Microsoft Access / VBA Forum

The next Access Europe User Group meeting will be on Wednesday 3 July 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome two presenters from Germany: Olaf Nöhring and André Minhorst. Olaf will demonstrate his improved version of the Enhanced Message Box which was originally...

When clients report issues or forum members ask questions, we often need to ask which version of Access/Windows/Office they are using. Unfortunately, MS doesn't provide all the info in an accessible form that can be exported to a text file or similar. I have created a utility that gets all the important info and displays it on a form:...

Access Announcements From time to time we (Access MVPs) get information from the Access Team at Microsoft about what is happening with Microsoft Access. Much of this we are not allowed to share publicly. This sticky thread is for that which we are allowed to share, and for other information we come across related to Access which may not have...

Remember that the people here helping you are not getting paid. They have no real incentive to help you beyond the desire to help others generally. So, if you make it difficult for them to help, there is a good chance they will just skip your thread and go on to the next one. So, how do you ask a good question? There are a few rules: ...

POSTING GUIDELINES Please follow these guidelines when posting questions Post your question in a relevant forum Do NOT PM questions to individual experts - This is not fair on them and we instruct our experts to ignore any such PMs completely Be sure to give the version of Access that you are working with and the Platform and OS if...

I am trying to check for duplicate address records in a table before running an append query to add the user-entered address on a form. I am defining a string to capture the street number, name, suffix and city and then using DLookup to search the table (tblLocation). The problem is that the code keeps returning a data type mismatch in criteria...

Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing something in the combo box on a form and it would auto complete. Now in windows 11 it starts to do it but stops after a couple of characters being typed in....

Hello from Pennsylvania, with my first posting. I am just getting back into Access after a long layoff. Now, my Combo Boxes ‘Autocomplete’ work perfectly until “Compact and Repair” or the app is closed and reopened (then “The text you entered isn’t an item in the list” appears). Does anyone know why?

My program searches through all drives on the computer looking for the _be.accdb database, this allows the user to put the database on a network drive. The program when compiled was working fine, but the last time I compiled it and ran it using Access runtime it didn't find the database, however if I run the .accdb program it works fine. What...

Hi does anyone have a simple sure-fire way (as well as slick and seemless) to keep the front-end version for large numbers of desktop users up-to-date?

I'm trying to create a project that will display the charts data based on the selected month in my combo box, how can I do that ?

The next Access Europe meeting will be on Wednesday 5 June 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by about 19:30 (7.30PM) The start time is equivalent to 19:00 (7PM) in Central Europe and 10AM in Seattle / PST Please note that the UK is now on Summer Time (UTC+1). For local times, please check World Time Buddy In this...

Hello experts! So, I have a report called Ledger attached herewith. https://bytes.com/attachment.php?attachmentid=10632&stc=1&d=1717484933 My problem is that I want to calculate balance by subtracting or adding (according to the stituation) with previous record on each row like in first row (if you peruse the attachment), balance is (5,500)...

I inadvertently opened an Access ldb file with Notepad and now the file type icon changed from Access to Notepad. How can I restore the correct one?

I have a form with an unbound combobox. This combobox serves as the criteria for a Query that then feeds a Report. It is simple, efficient, and works very well. I am also using a vba codefor this purpose. I would like for this combobox to allow for multiple selections so that when the report is produced more than one selection would show on the...

We are using the treeview common control in an MS Access form. I've encountered a situation with a user where when he clicks a node in the tree, the nodeclick() event does not fire, yet the tree is still fully navigable. He can open and close all the branches, but the background code that picks up the nodeclick() just doesn't fire. However we have...

Can anyone tell me if there is any simple way in Access SQL of deleting all records in tblA that are specified by having a matching record in tblB? In other words, I want something like DELETE tblA.* FROM tblA WHERE tblA. = tblB. - except that that doesn't comply with the syntax for a DELETE statement. I tried the obvious method - creating...

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...

The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art and the report Picture properties would fill the bill, but not so much. An image added like that is a background to the report, so text in the report...

So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Navigate "whatsapp://send?phone=" & Me.Mobile & "&text=" & "Welcome! Admission of " & " " & Me.StudentName & " " & Me.Prefix & " "...

The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back (by popular demand) Thomas Moeller who will be discussing Better Access Charts – The Next Generation ...

Hi, I need some help. The routine below runs when a command button is clicked. A prompt appears to enter the directory path to the folder containing delimited text files to be imported into an Access 97 table. The test folder contains 9 files. The problem is that the 1st file is imported 9 times into the table. How do I correct the routine so...

Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the hyperlink so it uses it to find the correct record? This is the line of code with the hyperlink: Application.FollowHyperlink...

The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE add-in MZ-Tools, Carlos Quintero, will be leading a presentation called Top 10 advanced features of MZ-Tools For more details about the topic and...

So, I had this bright idea today that didn't quite work out. Or maybe it is working out but requires me to change a habit. I'm working on a form that will be a sub-form of another form. During initial development, I find it easier or better to work on the form as stand-alone entity rather than a sub-form. One reason is that I can edit the form...

The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In this month's session, Ramachandran (APR) Pillai will be leading a presentation called Streamline Form Module Code in the standalone Class Module. For...

Hello Everybody, There is SQL Server 2008 R2 database with MS Access front-end (linked ODBC tables). I can see all linked tables in MS Access and can add new rows. However, when trying to update or delete existing data, I got error: Process is stopped by Microsoft Jet because multiple users are trying to edit the same data simultaneously....

The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike Wolfe (MVP) will be leading a presentation called Streamline Your Import/Export Spec Workflow with VBA Classes. For more details about the topic and...

Hi All, I'm trying to create a single code (run off a button that calls the Private Sub) for our parts list report that will allow the user to filter by either/both PartVendor and PartType. On the microsoft forum I found multiple examples of code from HansV and simliar code from NeoPa here that I am trying to understand and adapt. The...

Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other small businesses, but I want it to be independent from Access. From my own research it seems like I need to learn many different languages such as SQL...