Articles & Videos
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
I have a MS Access 2013 Search Form.
It queries data from one Table1 with 20+ columns.
I have 3 search criteria (combo boxes?)
Above 3 are …
I'm starting a project to integrate a third party add-in from SagePay to our in-house Access database and unsure on some of the basics. I've completed the following steps but not clear on where…
i have a multiuser (Databse not splitted yet as backend) database. Need to know if following additions can be done ?
1. Can i know How many users are logged into the system ?
2. Can a …
I develop in Access 2010.
My client has a few users for the access database which I develop and support for him. The users only use the database and do not need any development abilities.
I have a form that allows a user to enter data that goes into a existing table and at the bottom of the form, I have a "Save Record" button. The problem I'm running into is when a user only partially…
I have an Access Application that was created and compiled in Access 2010. It installs and runs correctly on a Windows 7 64 Bit PC with Access 2010 Runtime.
When I install it on a …
I want to create a delete query to remove records other than the max appended record which is based off an autonumber field "Current Post". I'm not to familiar with SQL or if it can be …
I have a rpt with a line in the detail section that i want to be visible only if me.PaymentYN = "Yes"
I have code on Load of the rpt
If me.PaymentMadeYN = "Yes" then
I need to sum with a where criteria.
I have the following but its wrong
=Sum([USD Equiv Rpmt] & [PaymentMadeYN]= "Yes")
The part after the & is not correct. The YN field is a value list with …
I have a Navigation form with 2 continuous sub forms.
PLU is the common key field
1 sub-form (sub_vendor_item) is for entering vendors, order numbers, and costs - with a corresponding table …
I have a problem that I could not figure it out. I have a combo box in a employer form, this combo box is list all the employers. on the employer table I have a field Status (A- for …
In your Expert Opinion,
how should I determine when to use a tabbed subform vs a navigation sub-form.
I am attempting unsuccessfully to format data in Excel as a table from Access. I was hoping someone could tell me what I'm doing wrong:
We have 2 Access databases where database A has all of the information stored and we need to append that information into a table in Database B. Currently we are importing the table into database B, …
I wonder if thats even possible. Is there a way to store via VBA a value in a Label control, and that value sticks, even after closing and open ms access without aid of a table?
Im about to implement a control on a form with the characteristic of a listbox that show to the user what record as been "updated", for this i need a listbox with row color, but for …
I've got some codes for showing progress bar in access form and is working fine on the sample form but not getting it worked with my form. Actually I'm not able to fit it at right place. …
this is a continuation of :Display <> "Yes" records (https://www.experts-excha
I need to add some fields from tblRepayment and …
I have 2 tables: tblDraws_Details1 and tblRepayment.
Joined on tblDraws_Details1.ID and tblRepayment.DrawIDrpmt (one to many)
Each record in tblRepayment is a repayment
after a …
Im trying to insert a new line in a memo richtext control, but the vbNewLine and vbCrLf dont work there. Is there a way to do this?
Thanks in advance for your suggestions
I have a table of thousands of documents, and when they get revised we need to track the relation between other applicable documents that reside in the same table.
If I input the first line below …
I have an ms access app that is created centrally and then put in a remote users dropbox. The app contains several linked dbase tables. These linked tables will be re-linked to the proper path when …
When I run my code, I'm getting the following errors:
Application-defined or object-defined error
Then if I click on OK, it continues through the code, but then …
How can I achieve the following please? I want the data shown in the first column to be summarised to only show one of the possible values in the Colour Column. Have a look below and it should make …
by Patrick G. Matthews Introduction: A common request in the various database zones at Experts Exchange involves returning a concatenated list of the various items in ColumnB for eac…
By Patrick G. Matthews Introduction In Microsoft Access, Switch is a very useful and powerful function that allows you to build conditional branching logic into your expressions i…
Stratford, CT, United States
30,632 points this week
Rey Obrero (Capricorn1)
Seattle, United States
15,100 points this week
Jim Dettman (Microsoft MVP/ EE MVE)
Syracuse, New York Area, United States
9,749 points this week
6,431 points this week
Scott McDaniel (Microsoft Access MVP - EE MVE )
North Augusta, South Carolina, United States
5,000 points this week