Search results

Hi All. I have the below code which generates an automatic email based on information from a query called QueryHiresOverdue. The correct amount of emails are being generated, however the To and CC for each email is the same. I am using a DLookup to find the To and CC for the email. Depending...

Hi all, I have a command button that I want to look at the table 'ImportEquipment' and find out whether [CodeNo] from the table 'PoolBookings' exists in both. If this CodeNo exists, then I want to change the [Location] field in the 'ImportEquipment' table to Me.DepartmentBookingOut At the...

Hi All. The code I have below is meant to run for the amount of records found in the 'QueryBarcodeScannerReturns'. At the moment I have ten records in the query and the code is looping ten times on the same record, but not moving to the next record. I am sure something simple just needs to be...

Hi All. In our workplace we used to use barcode scanners to perform a yearly audit of stock. We used a Symbol barcode scanner which stores the data until the user decides to download the data from it. To download the data from the scanner and input it into MS Access, we used to use a software...

Hi All. I have the below code to look at a query and create an automatic email containing data from the query. There are currently only two records in the query. When I click on the command button, my message box works OK and tells me that it has found two records, from the Rec.RecordCount...

Hi All. I have the below query which selects data and then counts the number of records that fits the criteria. The criteria is that the Equipment's Owner Department is 'Equipment Pool' and location is 'Equipment Pool'. Working query I now want to be able to count the records where the...

Hi All. I am creating a new equipment library database. The user will log when they are taking a piece of equipment from the library using a booking out form called 'PoolBookings'. This saves a record of the equipment's asset number, their name and department, and the current date and time. It...

Hi All. I have a table called PPMTarget that stores our planned preventative maintenance performance targets, when a command button is clicked. A click of the command button stores the below information: TargetID Date LifeSupportTarget LifeSupportSpread AcuteSupportTarget AcuteSupportSpread...

Hi All. Just in the past week on my database I have found that I cannot use the * filter in a numbers field. I get an invalid syntax message when trying to do so. I have used the * filter in a numbers field for years and have not changed anything in the database. I have changed the field to a...

Hi All. I have copied a table in my database with the structure of it staying the same. I have then appended data from another table in to this new table. Now when trying to add a new record I receive a message that this would create duplicate values in the index key. If I was to create a new...

Hello All I have a continuous subform called ContractsReadSubform, that is based on a query called QueryContractsSubform. One of the fields in the query is called CodeNo, which relates to the unique equipment number of a device. Every CodeNo has a serial number which is stored in the...

Hi All. I have a query that is ordered to order the [Date Out] field in descending order. The [Date Out] field is the last to be completed on a record. So until a record (job in this case) is completed, the date out has a null value, which means it shows at the bottom of the records. I have...

Hello All, At the end of every financial year, a copy of our front end and back end are stored in an archive folder. Up until 2020, they were all in .mdb and .mde format. The old database used a System file for user login and security. Since upgrading to Office 365 in mid 2020, all of our...

Hello All, I have created a command button on my form to create a report and save this as a PDF, which works perfectly using the code below: Dim FolderPath As String, FileName As String 'Exports report as PDF to Folder Path with Code Number as the file name FolderPath =...

Hello All. Our IT Department has blocked us from using the cmd shell meaning that we can no longer open .exe using the code we used to below: Dim stAppName As String Dim stHomepath As String Dim myPath As String myPath = "H:\QA90PRO32\QA90PRO.exe" Call Shell(myPath, 1)...

Hello All. My database used to automatically update itself using a .bat installation batch file. However our IT team now block us from using this method. Currently users have to go to the shared drive and copy the front end file and paste it on to their C:Drive to overwrite it. As the database...

Hello All. The database I have taken over has two tables called LookupSupplier and LookupManufacturer. Having been in charge of the database for a year or so, I can't see any instance why there needs to be two different tables, when a lot of the data is the same. I have created a new table...

Hello All. I have a form called AssignmentLedgerRead2, that has around 110 thousand records in its record source. Therefore I have a filter on the form's On Open event, which filters only by the staff's non-completed assignments. I currently have the following code to open the Assignments form...

Hello All. I am creating a command button to add a new record to another table. I am able to add text to the new record, and also values from the form to the table, however I want to add both text and a field's value. On my form I have a field called [Date Sent]. Say for example it is today's...

Hello All. Our database allows a user to duplicate a record using the following code: Private Sub CommandDuplicate_Click() On Error GoTo Err_CommandDuplicate_Click DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 2, , acMenuVer70...