Search results

I'm a newbie to Ms Access and I have tried to follow a lot of content on this subject title but I wasn't successful. Can someone demonstrate for me on the attached sample database.

I want to create a query (Resultant Query) which concatenates records from another query (Source Query). For example: Source Query A 10 B 15 A 6 C 4 C 5 Resultant Query A 16 B 15 C 9

I want to query figures from a table into my query using date criteria but when I run the query I get only blanks. The expression I'm using in the expression builder is as follows. See also attached images. XE: DLookUp("EXCRate","ExchangeRates","EXCDate=#" & [DateEntered] & "#")

I have a split database and I have duplicated front-end file to make multiple copies for different users. Every-time a change is made on one front-end form, I want the other forms in other front-ends to always drop changes. How can I trap this write conflict to always drop changes maybe through...

I am a newbie to MS Access VBA. I want to lock fields on a form (PaymentRequest) "Payment Request 1" using a checkbox such that if I go to the next form (PaymentRequest) "Payment Request 2" the fields will be editable until I also lock them with a checkbox on that particular form. I have tried...

Hie I have created a tabular form and I inserted second column with combo boxes which are dependent on combo boxes in the first column. However when I select a combo-box value in the next row of the first column, instead of updating just the combo-box of that very row in the second column, it is...

Hi I am new to Microsoft Access. Creating and using automated systems is my hobby. I have been using Excel workbook functions for a long time now and Excel VBA macros for the past few months. Now I want to get into more sophisticated platforms and so here I am