Please help: I am trying to manage land and properties in a small town. I have 2 tables: Owners and Property One owner may have one property or own several...

I would like to be able to pass variable data (product name) from a Textbox on a form to query data in a Table and then have that query return the (price)...

How about the following? DCOUNT("*","Clients","Therapy1='1' and Active='1'") + DCOUNT("*","Clients","Therapy2='1' and Active='1'") + ... Depending on your...

A subform which I use on a form and a report have recently stopped working for users of Access 2003. This is a continuous form and sometimes the information ...

I have INSERT SQL code that I run. I'm not quite sure how to do this. I need to search for duplicates either before or after the code is run. All of the info...

Hi, I have 2 access databases where one holds all of my underlying data (several million rows) and the second holds all of the calculated info I need from...

I have a large set of questions in my form and I want all these questions to appear in my form, but because of the number of controls, only some of them appear...

Hi I run Win2000 with Access 2000. I have created a table & form which has an entry of a "First Name" and an entry of a "Surname". I would like to have...

What is the syntax, please, to insert into the Private Sub Form_Current() event of a parent form in order to refresh a subform contained within that parent...

I'm trying to track payroll data that will be update annually.Should this be done with a data base for each year or should a copy the 14 tables planned for...

What causes data to "corrupt"?

Hi all A report contains a box (terminology?) in the report footer that contains the formula "=Count(*)" This works fine with the exception that it returns...

I am new to Access & trying to create a field that will calculate the "balance due", by taking the "TotalTripCost" and subtracting all the "PaymentAmount"s. I...

I have an output field in my db that lists however, when performing a later function it turns out that if this field is blank I get a blank result. The...

is there a way to write in a text box more than one answer?

I have a need to have both A2000 and A2003 running on the same PC in order to support my customers. Are there any compatibility issues with running both A2000...

Hi all, Access 97 Nearly there. I now have two tables T_Clients and T_Tasks containing autonumber primary keys ID_Clients and ID_Tasks. ID_Clients is...

In the On current event of the parent form I tried the effect of typing "me." without the quotes, on a new line within the Private Sub...

I am having trouble with filtering a query. I would like to do a "invoice filter" like in the northwind sample database where it only prints one record at a...

I am using =DatePart("yyyy", ) to pull through the month displayed as mmmm format, from a field containing a date in ddd d-mmm-yy format. I am getting an...