thread by: JWS0823 |
last post 2 Weeks 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...
|
thread by: DJRhino |
last post 2 Weeks Ago by: NeoPa
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....
|
| |
thread by: W4NMP3 |
last post 2 Weeks 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?
|
thread by: CD Tom |
last post 3 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...
|
thread by: BrainstormUK |
last post 4 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?
|
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 ?
|
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...
|
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)...
|
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?
|
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...
|
| |
thread by: argonautical |
last post May 29 '24 by: MrXmas
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...
|
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...
|
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...
|
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...
|
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 & " "...
|
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
...
|
thread by: gdaniels |
last post Feb 28 '24 by: cactusdata
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...
|
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...
|
| |
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...
|
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...
|
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...
|
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....
|
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...
|
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...
|
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...
|