473,856 Members | 1,475 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Microsoft Access / VBA Forum

Microsoft Office Access database and VBA - Ask questions about microsoft access queries, reports, forms, macros, modules, security, automation, functions, records, mining, visual basic for applications and more.
1
88
isladogs
thread by: isladogs | last post 1 Week Ago by: isladogs
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...
3
939
isladogs
thread by: isladogs | last post Apr 25 '23 by: NeoPa
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:...
15
23,809
NeoPa
thread by: NeoPa | last post Feb 7 '22 by: isladogs
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...
1
36,221
NeoPa
thread by: NeoPa | last post May 8 '16 by: NeoPa
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: ...
1
54,567
PEB
thread by: PEB | last post Jan 21 '07 by: MMcCarthy
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...
3
85
thread by: JWS0823 | last post 1 Week Ago by: NeoPa
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...
6
138
thread by: CD Tom | last post 2 Weeks Ago by: NeoPa
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...
13
171
thread by: W4NMP3 | last post 1 Week Ago by: W4NMP3
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?
3
114
thread by: BrainstormUK | last post 3 Weeks Ago by: NeoPa
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?
1
151
thread by: mendozajanine | last post Jun 8 '24 by: NeoPa
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 ?
1
139
thread by: Aftab Ahmad | last post Jun 4 '24 by: NeoPa
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)...
2
186
isladogs
thread by: isladogs | last post Jun 7 '24 by: isladogs
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...
3
189
thread by: marvin99 | last post May 31 '24 by: jimatqsi
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?
6
266
thread by: mshakeelattari | last post May 29 '24 by: MrXmas
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...
8
294
thread by: Petrol | last post May 16 '24 by: NeoPa
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...
1
7,934
isladogs
thread by: isladogs | last post May 5 '24 by: isladogs
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...
1
15,749
isladogs
thread by: isladogs | last post Mar 8 '24 by: isladogs
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 ...
1
21,046
thread by: Aftab Ahmad | last post Mar 28 '24 by: NeoPa
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 & " "...
1
19,721
thread by: davi5007 | last post Feb 16 '24 by: cactusdata
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...
2
27,664
isladogs
thread by: isladogs | last post Feb 10 '24 by: isladogs
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...
4
43,204
thread by: jimatqsi | last post Apr 11 '24 by: coldbluts
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...
3
27,205
thread by: jimatqsi | last post Jan 16 '24 by: NeoPa
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...
3
31,816
isladogs
thread by: isladogs | last post Jan 12 '24 by: isladogs
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...
3
26,864
thread by: efe2023 | last post Dec 26 '23 by: jimatqsi
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....
3
30,322
SueHopson
thread by: SueHopson | last post Dec 8 '23 by: NeoPa
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...
4
35,624
thread by: GKJR | last post Dec 5 '23 by: NeoPa
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...
1
36,142
isladogs
thread by: isladogs | last post Dec 13 '23 by: isladogs
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...
0
31,184
NeoPa
thread by: NeoPa | last post Nov 6 '23 by: NeoPa
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it then makes that (calling) Form visible again. This article is released as a companion to the VBA Class Basics one that focuses on opening Forms. ...
3
24,428
thread by: nia12 | last post Nov 1 '23 by: NeoPa
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of forms they will fill in. One of my forms relates to a goal based measure that the employee will fill in each time they meet with the patient (each...
0
19,356
isladogs
thread by: isladogs | last post Oct 28 '23 by: isladogs
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on Sunday 29 Oct, whilst the USA remains on Daylight Savings until mid November. The start time for this meeting is equivalent to 19:00 (7PM) in...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.