Search results

My datebase is tracking employee training, Each employee is required to complete the training every 12 months (for example) The database tracks all of the info about the employee and I have a table that keeps the records of all training completed dates for all employees for all SOP numbers...

I have a form that allows the user to select a date range, then click a button to open a report that shows the results based on the user input. I need to add VBA to check for no results in the query/report and give a message box telling there are no records available. I tried adding code to...

I am using the following function found on the web to open a browser window to allow the user to select the location for a download of an excel file. All is working correctly EXCEPT if the user clicks the cancel button on the browser window the code that follows runs anyway. How can I cancel...

I have been searching for a solution to add a command button to a report that will export the report (or underlying query which ever is better) to an excel file. I have found the following which is supposed to save the file with the date added to the name. I get the message box that the file is...

My form displays the Employee Number correctly as 0049, yet when I refer to that field in my code it changes it to 49. I need the code results to show the full number with the proceeding zeros. I tried to format the declared value but this did not work. Any suggestions? strEmpNumber =...

I need to reset a combo box to display as blank from VBA If I use Me.[EmployeeNumber] = Null I get the error code 3162. What is the correct code to reset a combo box? Thanks

I have a form that has the following controls: SOPNumber EmployeeName DateCompleted TimeCompleted The form is bound to a table. When a record is saved to a table normally the form is cleared. If the training session was completed by more than one employee it would be best to return to the...

I am creating an append query based on a form. I have all of the info entered correctly but for some reason 2 of the fields will not show any value in the query results. The fields are a date field and a number field. Please I want to keep this as simple as possible without getting into a...

I am creating an append query based on a form. I have results in 3 of the fields but for DateCompleted and Completion Time the fields are blank when I view the query. I am totally stumped as to why this is happening. Has anyone had this experience and can you point me to what might be causing...

Can anyone please tell me where my syntax error is in this code? The error message states syntax error in date in query expression but I am using a similar code elsewhere and I don't get this error. I am sure it is something simple that I am missing - so any assistance as always greatly...

My table has a field that is a number (long integer) and I am trying to update the field from a form. On the form I have my text box set as Format:General Number. What I am missing here because I get an error message 3464 Data Mismatch? What should have the form control set to to clear this...

I am setting up a table to keep track of the time it takes to complete a training course. One of the fields needs to be the time it took to complete the course in minutes. What is suggested as the best field type for this? Number, text....? The field will be used in the future to produce...

I have a form with a subform. A change on the main form requires a field on the subform be updated. I am using this to close and reopen the form which forces the update as needed but this opens the form to the first record. I need to reopen to the same record that I was one when closed. I...

I have a form with a sub form that is used to enter information about job training. The main form is used to enter info into the training table that includes fields for the training number, type, description, expiration, if it is obsolete and if it is mandatory. The subform is linked to the...

I have a yes/no field on a report and it is working fine except I would like only the yeses to appear- not the nos. So if the record in the report is no, the space for the field is left blank. Thanks

I have a report that displays training completed for an employee. Some of these classes have expiration dates and others do not. The query that this is based on has fields that are DateCompleted- the date the training was completed, Expiration - the number of months that the training is good...

It has been a while since I worked in Access so I am definitely rusty!. I need to add a field to a query that takes a date field (CompletedDate) and adds the number of months listed in another field (Expiration). The original fields are in different tables but are combined within this query...

I am updating an existing database with a front and backend. I need to add a calculated field to an existing table in the backend. I have searched but can't find any info on how to do this. Anyone have any idea of how to accomplish this? As always, thanks Sue

My programmer wishes to be able to post to the forum. He has tried to sign up but has somehow gotten locked out. Every time he tries to log in he gets a yellow message telling that the account has not been confirmed. He clicks to get an email but it never comes. He has checked his spam folder...

We need to replicate an Access report we have in Microsoft Word. The report has a fixed, small image in the header and so we embedded it in the report (it is not in an external file). To put this image in the Word document the only way we’ve come up with is shown in the code below. Dim apWord...