User Profile
Collapse
-
My project has many tables. I did not initially design the table structure. They use a Primary Key and Foreign Key. I split the database for Multi User usage. -
I resolved the issue by creating a table to place those values in. We also went with just text boxes. If the user needs to view what they entered, I have a button that will load it into a ListView control. I found a great Function for populating a ListView Control. All you have to do is call it and send an SQL Statement to it. Real slick.
Thanks for your reply.Leave a comment:
-
Allow Duplicate Entries in a Combo Box
have a project in which I am entering Serial Numbers and Date codes into a Combo box. Serial numbers are all different. However, they could each have the same Date Code. Each Serial Number has a corresponding Date Code which I then write to a table using VBA. When I try to enter a duplicate date code, it automatically finds the duplicate and will not allow me to add it again to that combo box. How do I configure that combo box so I can enter the... -
Is this an Autonumber field? If not, just set it to 0 and increment as you add items. Is the Line Number field bound?
You could create a temp table and copy the data to that table. Dropping and Creating the table should reset it to 0.Leave a comment:
-
Error on line 25
Most likely it is the code above line 25.Code:# Set db = CurrentDb # Set objXL = New Excel.Application # Set rs = db.OpenRecordset("qryStaffPerformanceCalculator", dbOpenSnapshot)
You might try: Set db = CurrentDb()
Also you could try Set objXL = Excel.Applicati onLeave a comment:
-
In Line 4, do all of those conditions need to be true? PErhaps you need to break that up with an AND or an OR
Forms!frmOverTi me!YearsInRank > 1 AND/OR Forms!frmOverTi me!YearsInRank = 2 AND/OR Forms!frmOverTi me!YearsInRank < 3
Where AND/OR is either AND or OR. Just a thought.
SteveLeave a comment:
-
Look at your .Movenext. Is it possible that is is trying to move to a record that no longer exists or beyond the number of records. Say your Do Loop has 8 records. After the 8th record, it is still executing a .Movenext. Since you have already reached your 8th record, it is trying to go to a record that doesn't exist. You should test for that. Then if you have reached the last record, skip the .Movenext. I had that problem with a Do Loop I had....Leave a comment:
-
I found it. It was actually in my code.
Original:
...Code:Do Until a = iQty strErrSect = " [Fill_Record ME-Manufacturing Engineer D2] " BigLine = BigLine & "Serial #: " & !Part_serial_number & c5SP & "Date Code: " & !Date_code & cDCF MsgBox "BIGLINE [" & a & "]: " & BigLine, , strErrSect [B]a = a + 1[/]Leave a comment:
-
No, I used the same data in the VBA one that I had hardcoded in the Access Builder. I have a message box that shows the SQL for debugging and it is there. This has me puzzled.
SteveLeave a comment:
-
Error 3021 in SQL using multiple INNER JOINS.
I created a query in the Access Query Builder that I modified to use with VBA Code so I could reuse it for any record I choose. The one that I created with the Access Query builder works beautifully with the hardcoded criteria. The VBA version with my criteria being set by a variable returns Error 3021.
I am using a DAO Recordset and all I want to do is retrieve the data to place into a report.
The Original made in the Access...
No activity results to display
Show More
Leave a comment: