I tried posting something like this already but am still flummoxed. I got most of the following code from this forum but it doesn't work for me. I have an...

This is something of a repost, but I could not figure out how to implement the suggestions received at the time, or they did not work. I have been working on...

How do you convert a ms Word document into pdf format without using special software?

I am learning Access by converting a flat-file database and am having a problem using a filtered lookup query as a row source for a combo box field in the...

Hi, Does anyone has a good calculation to get the first and last day of current year? I want to use this in the criteria of a query. Thnx

I have a table with the following fields ShipID = PK Sku = Product ID Date = Products Trans Date ShippedToDate ShipID Sku Date ShippedToDate 1 AC 10/1/2004 ...

I down load a new mdb file everyday with no queries in it. I have queries in the present mdb file, but the file overwrites this file. How can I reuse the same...

In Access 2002, I have a one-to many query that displays several records for each id value (each record with a field for a numerical (dollar value) and each...

Hello, I would like to use the like statement to look up a date. i know that like '*' is used for a text search. How would i use it for a date/time...

I am updating tables from a server through a data extract process. I would like to delete records to the primary table (that don't match the primary...

I have 3 tables - Resin, Criteria, and Application. Criteria and Application only have an ID number and a list of criteria or applications. These tables are...

I am creating a query with 10 different fields named categ_1 to caetg_10. I need to know if any of the records in any of the ten fields equal step up or step...

Receive a message when running a delete query as follows: Can't delete 0 records in the delete query due to key violations and 1 record due to lock violations....

there's a form that has 16 union statements in it. It is used to show the user the forms they can access after logging in. I've tried to add one more form to...

How would I separate a text field in an Access 97 database, entered like this: A695 Item1/Item2/Item3/Item4 (say up to Item 10) A696 Item1/Item2 to separate...

I have a database of club members and each year members who left are taken off and new members add to bottom on list and the table must than be renumbered...

I don't normally right code this is just a small project for a rather large home office. So I am in way over my head...but willing to learn. Any help...

I have the following crosstab query. Can any one tell me how to get 0 for Daval when their is no value for that Value field. PARAMETERS ...

HI, I was trying to use Table Analyzer to split a table, and got this message: File sharing lock count exceeded. Increase MaxLocksPerFile registry entry. I...

Hi, Could someone please help me? I have a make table query based on three different tables. In one of these tables there is the purchase date field. I would...