The situation I am in at the moment is that I have a database for a company who does work at different building sites. I have created a database so that it has the date the work was completed. With this company in particular the last possible dates of payment are 30 or 60 days after the work was completed, depending on the work. I would like to know how I would be able to create a calculated field that would display the first day that the payment is late.
Is their a way to highlight a feild. I am using the duplicate function but after the record is duplicated their are certain feilds that have to be changed, how can i highlight them somehow. ANy ideas??? The feild is Price???
I have have 2 feilds in my database, there can be the same value in one feild but not both.....for example say NAME and ADDRESS i can have the same NAME for more then one entery and i can have the same ADDRESS for more then one entery but i cant have the same NAME And the same ADDRESS....anyone know how to do this? :confused:
Im having a problem with controling duplicate records in a table
i want to allow duplicates in all feilds individually, but not if 3 feilds are the same in more than one record. (ei. if the entries in a1,b1,c1 are equal to entries in a2,b2,c2; prevent the second record from being entered)
so far, i've writen a macro to identify duplicates in an existing table, but i dont know how to delete records, or access values being entered in a form
Hi, I'm trying to create a table which needs some feilds to be automatically filled up when the control goes to it. Say my table has feilds, "size" and "result". In each row, the result cell should be filled up corresponding to the size value of that row. This needs to be looked up from an existing table.
I have been struggling with this and would appreciate any help. It sounds so simple!!! I have 4 fields (Unit Price 1, Unit Price 2, Unit Price 3, Unit Price 4) in a Orders table that I want to add together and store in a 5th field (Sub Total) in the same table using a form. I am having problems with the sum and I am unsure how to get it to show in the Sub Total box in the form as well as the table. Thanks for your help!!
I am trying to create a form to enter data in a table. I would like to make it pull in info from a switchboard. If the record already exists I would like it to find it and allow me to edit the info. If the record doesn't exist I would like to be able to add a new record with the data input. What is the best way to accomplish this?
I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.
a system for my company. I have been working with Access for a total of 3 days now, so bear with my inexperience.I have a table with State, Product Name, and so on as Column headers. I have repetition in both of those Columns (if that matters). I would like to figure out how to be able to pull up (Search, Sort, not sure how to word it) 1. By state) all products offered in that state and related info2. By Product) all states using the selected product and related infoWhich would be better for the above goals - Form or Page?I have looked into cascading combo boxes....it that the right direction?
I have a table of around 100,000 records all with a unique contract ID. However there are several entries holding different information on each line but with the same contract number. How can I assign each contract number with its own ID for example contract number 12345 has 6 different entries in the system which i need to keep but i want to assign that contract number with its own ID so i can provide a better contract count instead of it appearing 6 times.
I use office 2003, first I had to convert my database, then I did the database splitting then, remove all menus from running at startup, I tried to create an mde file but it didn’t work.
This is what I got:
This error is usually associated with compiling a large database into an MDE file. Due to the method used to compile the database, a considerable number of TableID references are created for each table. The Microsoft Jet database engine version 4.0 can only create a maximum of 2048 open TableIDs at one time. Exporting a database as an MDE potentially can exceed this limit if the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet database engine uses during the process of compiling a database as an MDE. However, each VBA module and each form uses one TableID, as a result, if the database has 500 forms, and each form's HasModule property is set to Yes, as many as 1,000 TableIDs are used.
So installed office XP and tried the same steps but still not working.
I have created access2K application with 4 clients (forms+query+macro+reports) residing on workstations and database on server. I have created MDE of 3 frontends but unable to do so on one computer. When I goto Tools->Database Utilities->Make MDE File... (Disabled) Its disabled I cannot continue so no error message. Any idea? Prodigy
I would like to create a new database from an existing data base with the same fields but I don't want the data. Can anyone give me a step-by step instruction. I also want to duplicate the form as well. I am currently using ACCESS 2000
I have two tables i would like to create a relationship with but the two fields that i want to join are not exactly the same e.g
Table 1 0000111111
Table 2 111111 ABC
The key piece of information that i would like to link together is the 111111, in SQL i would just type "WHERE Code LIKE '*111111*'" or something like that.
Is there anyway i can create a relationship based on the data above?
This has got to be a really easy one for you guys...!
I need to record the date/time a record was created - I've tried to use now() but obviously that updates and there appears to be no function for create date...
I setup my security (or lack there of, hehe) and split the database. I relinked the tables.
Now, Access gets hung up when I try to create an MDE of the FE to distribute. It starts the process, asking me to select a folder and file name, I do that, and it gets no further in the process. Access says (not responding).
Should I have created the MDE before I split it? Or does crashing of Access have nothing to do with whether i create the MDE before or after splitting?
Hi All. I have searched forums......honest!! But cannot find an answer.
I have the following code to make a directory....the directory name is as the ID_number....
--------------------------------------------------- Private Sub Command216_Click() Dim strDirectoryPath1 As String strDirectoryPath1 = "\server1Helpdesk_Calls" + CStr(Me.ID_Number)
If Len(Dir$(strDirectoryPath1 & ".", vbDirectory)) <> 0 Then MsgBox "The project folder already exists, the folder will now open"
Else MkDir (strDirectoryPath1) MsgBox "A folder has been created on the network at location \Server1Helpdesk_Calls" + CStr(Me.ID_Number) stAppName = "C:Windowsexplorer.exe \Server1Helpdesk_Calls" + CStr(Me.ID_Number) Call Shell(stAppName, 1)
End If
End Sub
------------------------------------------------
This works fine, and makes a directory on the network drive i.e
\server1helpdesk_calls123456
My question is, how do I also make it create directories under this one i.e
\server1helpdesk_calls123456Emails
It is the ID_number that is throwing me....have tried with numerous goes!!
relationships div and subdiv (1 to many) subdiv and issues (1 to many) issues and subIssue1 (1 to many) subIssue1 and subIssue2 (1 to many)
Now resolution table could have a one to many relationship with either issue table, subIssue1 table, or subIssue2 table. When I go to create any of those relationships, Access won't allow me. Tells me it can't create this relationship and enforce referential integrity.
Possibly I need to restructure my database to accomodate? I am not sure, any help would be appreciated.