Hi Ahmed , maybe you do not see the use, but it is certainly not useless!! add the following 2 fields to the table: TimeClockID, autonumber TimeClockID_In,...
BlankHello all, I have access 2007. I need to make 3 tables relational and none of my Info qualify as the Primary/Foreign key entry. I have tried using the...
Hi Jill, in the main table, make a field: SomeID, autonumber where "Some" qualifies the ID such as CustomerID, PartID, etc... in the related tables, make: ...
Actually the software house refused to do any addition to the software :(, thats why i need to do it manually. here is the Table structure: ** *Field Name...
Hello, Yesterday, I made the biggest Access database I ever done. The file is 2.02 Go, it has one table with about 6,640,000 records. The table has 27 fields...
Hi, I just have uploaded an MDB (Alignment.zip)in our Assitance Needed directory. I have accomplished whatever I have wanted except from the cosmetics. Brief...
Dear John, Payment term is always number, and there no datas like "on receipt" or etc. Is the method I'm using is true? ... always be a ... rows has ... Term?...
Ahmed- You can build a query to "match" in and out records like this: SELECT T1.Code, T1.[Date] As DateIn, T1.[Time] As TimeIn, T2.[Date] As DateOut, T2.[Time]...
Your formula looks OK, but you'll get an empty result if either the [Delivery Date] or the [Payment Term] is Null. Are you sure [Delivery Date] contains...
Ozair- That's going to be almost impossible to do with MsgBox. I suggest you create an unbound list box in the bottom of the dialog form and fill it with the...
Hello, I have a question related to parent-child relationships. I am designing a system that will be used to keep track of released materials. I am working...
I tried entering records into the form as-is and it doesn't act right. It let me enter the employee information, but then the TDate "beeps." If I clear out the...
Tammy- Normally, you should have a separate form to enter employees. Then on this form use a combo box to pick an EmployeeID from the list of existing ...
How can I limit the number of records returned in an SQL statement without resorting to using a loop/counter? I have tried using the LIMIT clause but A2003...
How can I delete duplicates within an SQL statement (without resorting to a loop/counter)? It seems I could use a counter greater than 1 to delete but I don't...
Its pretty simple. Set up your spreadsheet where the first row will contain field names with the data below and save it. Then open Access and click on File,...
John - I bet you are exactly right! That's what is happening. I think I should go home and go to sleep!! Thanks for setting me straight. I'll go back to the...
Hi Ozair, how about something like this: '~~~~~~~~~~~~~~~~~~~~~~~~~ Private Sub cmdShowDatesList_Click() 'Variables declared Dim varDate As Date Dim intCounter...
Hi Chanell, "'released' before a requisition can be added to them." don't worry about that, it will be okay -- just don't fill ReqID until you have the...
Hi Crystal (I was hoping you would respond) The way the process works is that draftsman release a set of materials for a certain job. Another person then comes...
Mike Do you know about SELECT DISTINCT? It removes duplicates based on all the fields selected. SELECT DISTINCT CustID FROM ORDERS The above would only pull...
Hi Skrol You're really pushing Access's file limits! Maybe you could divide the fields into 2 tables and put each in its own database. You would need to do is...
Hi Channel, "I was hoping you would respond" thanks ... wish I had more time to spend with your db, it sounds very interesting ... I only have quick moments...
I completely understand about not knowing the rules for a system you are creating, as I have found with this system (and the one I created prior to it)...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
