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 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 …
I am working on a query to delete from an existing linked table where the Batch Id is all the same. So my query is as following :
i am using an explicit parameter called BatchID and when i …
I had this query in access which gave output specifically only where an item went from no value to a value or either value changed
AbiCode minYM maxYM Tprev Tchange
I have a subform that displays a list of orders and/or quotes based on the parent form criteria selected. Many criteria on the parent form can be selected to query specific records. the SQL is …
I had a problem to export an Access (2010) table/query to Excel 2010 format.
I've tried with these two commands:
1. DoCmd.TransferSpreadsheet A_EXPORT, acSpreadsheetTypeExcel12, <tableName>, …
I had this question after viewing Printing to File then Sending File to an IP (https://www.experts-excha
I have some cells in a excel file , one of them contain xml string.
i have imported th file into access table .
the cell contains xml string imported into text field.
now, what i want is to…
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
27,032 points this week
Rey Obrero (Capricorn1)
Seattle, United States
13,100 points this week
Jim Dettman (Microsoft MVP/ EE MVE)
Syracuse, New York Area, United States
8,157 points this week
6,302 points this week
Los Angeles, California, United States
5,200 points this week