User Profile

Collapse

Profile Sidebar

Collapse
AXESMI59
AXESMI59
Last Activity: Mar 19 '09, 02:08 AM
Joined: Sep 25 '08
Location: Wisconsin
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • AXESMI59
    replied to Allow Duplicate Entries in a Combo Box
    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.
    See more | Go to post

    Leave a comment:


  • AXESMI59
    replied to Allow Duplicate Entries in a Combo Box
    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.
    See more | Go to post

    Leave a comment:


  • AXESMI59
    started a topic Allow Duplicate Entries in a Combo Box

    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...
    See more | Go to post

  • 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.
    See more | Go to post

    Leave a comment:


  • AXESMI59
    replied to Linking Excel to Access Query
    Error on line 25

    Code:
    # Set db = CurrentDb
    #   Set objXL = New Excel.Application
    #   Set rs = db.OpenRecordset("qryStaffPerformanceCalculator", dbOpenSnapshot)
    Most likely it is the code above line 25.
    You might try: Set db = CurrentDb()
    Also you could try Set objXL = Excel.Applicati on
    See more | Go to post

    Leave a comment:


  • AXESMI59
    replied to How do I use equal to or less then in VB
    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.

    Steve
    See more | Go to post

    Leave a comment:


  • AXESMI59
    replied to recordset invalid use of null
    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....
    See more | Go to post

    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[/]
    ...
    See more | Go to post
    Last edited by NeoPa; Jan 21 '09, 03:41 PM. Reason: Please use the [CODE] tags provided

    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.

    Steve
    See more | Go to post

    Leave a comment:


  • AXESMI59
    started a topic Error 3021 in SQL using multiple INNER JOINS.

    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...
    See more | Go to post
    Last edited by pbmods; Jan 21 '09, 01:08 AM. Reason: Added CODE tags.
No activity results to display
Show More
Working...