We have a tblEnquiry based on 'Contact Type' and 'Date' of contact. We have a report based on a query linking the two, and grouped by priority - Month, Contact...

I have a report that is the result of a cross_tab. The cross_tab contains all of the A/P detail (open invoices) for a group of vendors. In the cross_tab, I...

No Data access pages forum here so I'll post it here. I developed a complex application in Access (500 man/hours of work), Its Access 2k and uses Jet. Now...

If I have a table with an autonumber primary key and 100 records and I delete the last 50 records, the next record added would have a primary key of 101....

I inherited a database when I came on board here, and I am quite the rookie when it comes to Access. We have our signal inventory in a Table format, but it...

I have a from with a subform with the current record in it. How do I get that record to the printer.

Can you password protect just a form in a database? If so, how do you do it? I have one table/form that needs to be password protected. Thanks.

I have a database that has a one-to-many relationship between multiple tables, but I need to query of the "many" tables and only get the most recent entry of...

what would cause VB functions like (Trim(), ASC(), CHR(), etc) to cause intermittant error messages in my Access app. not all users experience this. i have...

I am about to create a new database and I want to make sure I create it properly at the outset so what I want to happen can actually happen. Here's what I'm...

How can i convert numbers to alpha numeric

I want to create a form that will have four different options to search for a particular record (the date, the record number, who submitted the original...

In the Form Issue (data base on the PR Table) there are 5 fields. 1.PRNO 2.CODENO 3.QUANTITY 4.LINEITEM 5.SUBTOTAL I want when I input prno,codono,quantity,...

I have users with Office 97 installed. I need to install Access 2003 runtime to use some of the databases I have developed. Last time I went down this path...

I'm making a fairly basic webpage for an agricultural marketing association, tha will display a list of farms who have a certain product (corn, etc) when...

I am using MS Access 2000. I've never used it before and so ain't got a clue, however if the below is possible, i'll get myself a book from the library to...

Hi, Kindly let me know what are the various possible ways to a)Filter recordset in subforms b)to filter the items listed in a second combo box I am using...

I made the mistake of loading 600 pictures directly to my database. It appears that in reading some of the threads, this was unwise. It seems there is a...

I downloaded the Time and Billing Access Database from MS Office Online templates. It is for Access 2000 and I have Access 2003. The forms work properly on a...

I have a report based on the following: SELECT * FROM tblContacts INNER JOIN tblOrganizations ON tblContacts.University=tblOrganizations.OrgID ORDER...