Search results

Hi MarkK, I am trying to add the DCount code to locate a work order that is currently in the table and respond with a message if found. I am using the following code, but I receive an Syntax error. What am I missing? Code: If DCount("*", "tbl_WorkOrder", "WorkOrd_Number = " & Me.Cbowonum) >...

Hi MarkK, I need for the function to perform a search to see if there are a work order number in the table before displaying the message. Where can I find the MsgBox() function?

Hello, How can I create an alert message to tell the user that there are an existing work order number in the table? I don't want it to restrict the entry, just inform the user that there is an existing work order number, do they want to continue. Btw, the code will be attached to a combo...

Hi, I need help on this error message I am getting when I click on my Duplicate Record button (created through the wizard). I have two combo boxes on the main form that populates data when the user makes a selection from the combo box. First combo box populates project data and the second...

Hey, thanks DenMiller! I apprecaite your time and assistance.

Hi, I desperately need help on a time issue. I have an Access query that exports data to an Excel spreadsheet (so far so good). Unfortunately, the data is exported incorrectly. Here is the problem… I need the data to export for shifts “B” and “C” between particular times. Example: Shift B...

Hello, I am exporting data from Access (2000) to Excel using a criteria form. I would like to append data to the Excel sheet without clearing the current data. How can I perform this function? Here is part of my code: <BEGIN CODE> Set myXL = CreateObject("Excel.Application") Set myWB =...

Thanks to the both of you for responding to my problem. Holger, your formula worked. I appreciate your time. :D

Hello, Can someone tell me what I am doing wrong with this formula? =IF(J1487="","",(K1487-J1487())) I am trying to remove the "0" number in a blank cell. I am calculating the number of days a workorder was open. I subtract the close date from the open date (K1487-J1487) which works fine...

Hello All, I am exporting data from Access (2000) to Excel using a criteria form. I would like to append data to the Excel sheet without clearing the current data. How can I perform this function? Here is part of my code: <BEGIN CODE> Set myXL = CreateObject("Excel.Application") Set myWB =...