Search results

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...

Hi All. I have taken over a database and I have come across an issue with one table and its primary key that I don't understand. We have a table called [Import Equipment] that stores information about all of the equipment that we own. Each piece of equipment is given a unique [Code No], and we...

Hi All. I have a database for equipment, the majority of which, requires a yearly service. When equipment is being serviced, a job is created and service details are completed for the equipment. I want to be able to automatically create a job (record) when the equipment is within 28 days of...

Hi All, I've got a command button that was working OK in Access 2010, but since upgrading to Access 365, I've been received a 'No Current Record' message. The full code behind this command button is included at the bottom. I have done some process of elimination with the code an found that the...

Hi All. I've updated my DB from Office 2010 to 365 and the accmddeleterecord is no longer working. When a user creates a record for a device, code runs to check whether there is already an outstanding record for the same device. If there is an outstanding job, the user is then prompted...

Hi All. I have a subform called ContractsEditSubform that is based on a query called QueryContractsSubform. It had always worked completely in my .mdb used in Office 2010. Due to an IT update to Office 365, I imported the database in to a new 64bit .accdb. Since doing so, it says that my...

Hello All. My database has the following table called NSRSubform. It is a table that stores orders. We have been entering the details of the part that we want to order in the Description field but I have just added a PartNumber field, to separate the description from the part number. After...

Hi All. I am hosting a quiz and was hoping to have a live scoreboard to make things a bit more interesting. So far I've added a spin button to add and subtract from the scoreboard. I was hoping to have a scoreboard that automatically updates and sorts the scores from highest to lowest. Is this...