Search results

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

Thanks sonic8, I've added the following code and now it's working perfectly: Dim reportName As String Dim criteria As String Dim MSG As String Dim O As Outlook.Application Dim M As Outlook.MailItem Dim FolderPath As String, fileName As String DoCmd.Save...

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

Hi Moosak, I've given this a go and I'm not sure that I've copied the code to the correct places. I created a new module and copied the top section of code. I then copied OpenHyperlink "H:\QA90PRO32\QA90PRO.exe" in to the on click event of my command button. When clicking the command button...

Hi theDBguy, I used the following code: Dim myPath As String myPath = "H:\QA90PRO32\QA90PRO.exe" Application.FollowHyperlink myPath and got this message: When clicking OK I get this: When clicking debug the following is highlighted:

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

@isladogs Thanks for the tips, much appreciated. Does anybody know of any way to open a .exe using a similar method? Our IT department have blocked us using the following code: Rem On Error GoTo Err_CommandQA90Home_Click Dim stAppName As String Dim stHomepath As String...

Thanks all for your help. I have used the post from Isladogs that KitaYama suggested a couple of posts above. This works a treat. I am now going to have my front end open, and check the version number. If the version number is below the latest version, it will first close the user's front end...

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

Strangely there was a 1 week period where it worked fine with roaming profiles. Apart from this 1 week, it would corrupt multiple times a day.

Just an update on this issue which I solved a while ago now. My organisation used to store the front end on the user's PC in what was known as a Home folder. This Home folder was static and was specific to that PC, therefore if an employee went to another PC they wouldn't have access to the...

Hi Galaxiom. Both the old LookupSupplier and LookupManufacturer tables used the name rather than an ID for their primary key, so I continued this with the LookupCompany table. I have created a copy of the backend, and deleted all records in the Contracts table except for one, and I am now able...

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

Thanks Minty, that makes sense.

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

Hi arnel There is an order by, which orders it by a primary key. This means that the duplicated record will always have a higher autonumber primary key. I have tried removing the order by but it is still the same. Maybe I'll look to what moke suggested and change the way the record is...

Hi moke, We are currently using Access365. This code probably hasn't been updated since it was first created in Access 97. I will look in to this method as I'm not familiar with how to add a record by doing this. Thanks

Hi arnelgp, I have added this code to the end of the command button and it still switches back to the first record. I can't figure out why this is happening, very strange.

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