Færdiggjort

Updates to an existing Access Database

iTAG100 DATABASE Project

Background

We have an Access database with an SQL Server backend which we would like to extend.

Scope

The develop the current iTAG database to include the following

• New Table for Version with the following fields

o ID (INT)

o Version Number (INT)

o Version Specifics ( MEMO)

o Default (BIT) (Only One item will be default at a time)

• The new Table will be linked to the TagSerial Table and the Tag Service table such that we have one version per Tag Serial and One Version Per Tag Service record.

• There will be a new form to edit the version numbers

• The Current “New Tag” and “Service forms” will have an additional combo box menu to select the version number (Compulsory). It will always default to the default version from The revision Table.

• When the new tags / services are added the version number will be included into the relevant table (possible new fields required)

• A Reprint option will be added to New Tags / Service forms which repeats the movement of the file See Appendix 1, Also ask the question if there are more than 30 MACS to print.

• Add a report(s) to show details about a MAC address showing its manufacturing detail and any services which have taken place. Filters by MAC address Customer, Version, Partnumber, Date

• Add a report to show the COUNT specific versions in the field. Add filters by customer and Part number Considering the current version (i.e the latest Service always takes president)

• Add a form “Version Query” , which has a single mac address field which when it looses focus displays the Version number on the form. Then resets back to waiting for a new MAC address

• Add all above options as menu item to access the forms and reports

Appendix 1

Code for moving files to print labels

' Check to see if if the print check box is ticked and if it is how many records we have to prompt if they want to print so many

If [login to view URL] = True Then

' Now check how many records as we just print it if ts less than 30, more than 30 prompt and ask

If NumberOfRecords > 30 Then

If MsgBox("There are " + Str(NumberOfRecords) + " records. Do you wish to Print these labels?", vbYesNo, "Print Label Check") = vbYes Then

PrintCheck = True

Else

PrintCheck = False

End If

End If

If PrintCheck = True Then

' Print the labels (this just copied a pre-formatted file to the destination folder)

Dim PathForLabels As String

Dim FileForLabels As String

PathForLabels = DLookup("PathForPrintLabels", "dbo_tblGlobals", "GlobalsPK = 1")

' Check if the Label path has a "/" at the end

'If Right(PathForLabels, 1) <> "/" Then

' PathForLabels = PathForLabels + "/"

'End If

' Updated to have source and destination

FileForLabels = DLookup("FileForPrintLabels", "dbo_tblGlobals", "GlobalsPK = 1")

FileCopy FileForLabels, PathForLabels

End If

Evner: Programmering af database, Microsoft Access, Microsoft SQL Server, SQL

Se mere: access update query examples, access update query from another table, access update query multiple criteria, update query access, update query access 2010, use a field in one table to update a field in another table access, how to create an update query in access 2016, access update table from form values, project mysql database access using odbc, project management database access, access project management database, modifying existing access database, project log database access, import excel sheet existing access table vb, create invoice existing access database, access 2010 database backend server, modify existing access database, edit existing access database, database existing access database, project workflow database access

Om arbejdsgiveren:
( 3 bedømmelser ) Middlewich, United Kingdom

Projekt ID: #17532089

Tildelt til:

alaeddindhahri

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, MS SQL and VBA. I have read your project description and I'd like to help you de Flere

£150 GBP in 3 dage
(68 bedømmelser)
5.8

17 freelancere byder i gennemsnit £185 på dette job

fabest

Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As Flere

£122 GBP in 3 dage
(81 bedømmelser)
7.3
expertcoder1vw

Hello, I'm an expert MS-Access / VBA / SQL Server / ODBC developer with over *20 years* experience in MS Access /database application programming. Please see my Freelancer profile for past history. I can do the job fo Flere

£200 GBP in 5 dage
(55 bedømmelser)
6.0
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll update your current Ms Acc Flere

£250 GBP in 5 dage
(45 bedømmelser)
6.1
£250 GBP in 3 dage
(29 bedømmelser)
5.9
schoudhary1553

Hi there, Warm Greetings We came along with your request for Updates to an existing Access Database and we reviewed your project description. We'd like to help you with confidence and satisfying results. We ha Flere

£250 GBP in 3 dage
(14 bedømmelser)
5.4
royalcalif

Let me review the database. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy report to your requirements. Let me know the full specification of the pro Flere

£20 GBP på 1 dag
(58 bedømmelser)
5.6
£250 GBP in 9 dage
(16 bedømmelser)
5.0
Webxpert4u

I am ready to update your access DB with adding new fields. I am able to create/Improve online database so that multiple users can access into db and keep track. I have 7 years’ experience designing and developing Acce Flere

£250 GBP in 5 dage
(6 bedømmelser)
4.6
tangramua

Hello Our team would like to help you in updates to the Access Database. We have a lot of experience in database development and programming. In area of web development our main specialization is LAMP stack of t Flere

£186 GBP in 3 dage
(1 bedømmelse)
3.8
£250 GBP in 5 dage
(3 bedømmelser)
3.1
techmartsol

Making the suggested changes in access db.

£180 GBP in 2 dage
(6 bedømmelser)
3.7
rayyankabir

Hi, I have excellent depth over MS Access database and all other Office applications. I have 10+ years of experience in this field. I have developed for almost all kind of domains. Please see my portfolio on the below Flere

£200 GBP in 3 dage
(4 bedømmelser)
3.0
ITPyramid85

hello,how are you. i read your bid carefully. i am database expert and have full experience for 7 years. database is my top skill and my interested skill. I can provide most quality and high fast. if you want to su Flere

£150 GBP in 3 dage
(0 bedømmelser)
0.0
futun

Greetings, Going through with the requirements in project description, I would like to take your project on board. I am an independent and professional developer with 100% completion rate. Please knock me for a quick d Flere

£150 GBP in 5 dage
(0 bedømmelser)
0.0
Zesheng101

I would like to, first of all, thank you for the opportunity. I am confident that my skill set matches the proposed work and I am able to have it completed within the specified timeline. I am a new Freelancer and ha Flere

£150 GBP in 3 dage
(0 bedømmelser)
0.0
AnkitaDakre

Good knowledge of SSIS Good knowledge of SSRS Good knowledge of datawarehouse Good knowledge of SQL

£144 GBP in 7 dage
(0 bedømmelser)
0.0