I have a sequence of buttons (8 in total) relating to various address fields. I want to be able to push any given button (in any order) and fill in a blank...

hello all, is it possible to have a query present a drop down type of list? The list would be for example a list of current customers (already defined in a...

Hi everyone, Im newbie with access, how do I create a query that only report the records in a specific month? BTW the table that i have records have a field...

From my form: DoCmd.OpenQuery "Quotation-to-Invoice Query", , acAdd Works fine but I cannot get error code. CurrentDb.Execute...

I am designing an append query that will read data from one table and append to the other. That will be triggered from within the form so, I want to use the...

I setup the office outlook as the default e-mail program, but when I want to go back to outook express for my old e-mail messages, the office outlook...

I am wanting to create a query in which the operator is prompted for a numeric value range. In my table I have a field called "MainPair". I want to create a...

Hello: I don't know what's wrong with me today. I meant to post this question in the Queries forum and inadvertently posted it to the Forms Coding forum. I...

Hey people, I need help !!! I'm making a database which has 4 fields: project number(STRING), project type(STRING), proyect start(DATE), project end(DATE)....

I need the SQL sequence for the following update query for Access 200 2 tables named Contacts and Update Both tables have the same Unique ID I need the...

Hi, I have a table that has two fields; transect and forb height. Each transect has 5 frames for which forb height is measured, so there are 5 records for...

HI, I have data in a table that is structured like the one below. Site Transect Species Cover Density A 1 AGSM 1 1 A 1 ARTRW 1 1 ...

I have a form that is the result of 2 or more select queries. When I display this form I can not edit any values of any fields. It seems like I can edit...

I have a form with a subform inside which both manipulate 2 tables: Quotations and QuotationDetails (One-to-many rs). I have a button which when pressed will...

How can I delete duplicate rows from the same table making sure that the newest row is left, by only using a query? By using an Append Query? By using a...

Short Question: I need to run a query that identifies individuals who haven't been registered in our emergency department and then can directly click onto a...

Hello, I have a very simple database in a shared drive. Some users have read only access to this shared drive and cannot open the database ('could not lock...

Trying to "clean up" inherited database. In past data entry folk put extraneous characters at the end of many people's Last Names, as in: Smith,...

Trying to look at data by item in date order with demands by date. Example of column headers and as U can see they are not in order for the dates. ...

I am trying to figure out how many days there have been so far in 2007. I've attempted to do this using the DateDiff Function. I keep getting error...