Hi I would like to create a custom data type (or whatever the terminology is) when I am designing my fields within design view. Can I create a data type using...

Hi All A database I created for a client some years ago has a macro which contains an append query. This macro repeats itself until a condition is met and...

this is a test

Hello, We have created a table and a form to track all of the clients informations coming into the business. Then, we categories the clients into five...

I created a data collection database that has been distributed to remote offices on rented PCs. The PC's have Access 2K. I built and maintain the db on...

You do not want to delete objects from MSysObjects! Fortunately, MS denies you permission to do that. If you are attempting to programmatically delete all...

In Access 2000 and later, you can create a relation between tables where related records can be automatically set to Null rather than deleted when the...

There's quite a bit to setting up a database like this. You need a Customer table seprate from your Quote table, becuase one customer can have several quotes...

Anyone have experience with how reliable JET 4 is with cascade-to-null relations? I have a scenario where cascade-to-null would be ideal: a child table has...

I'm working on a database for a huge amount of information that realistically is related ONLY by a person's ID number, unless I'm just not thinking of it...

I have two different ODBC tables and as a result of a make table query I'm trying to change the Data Type on both tables to read "text". One table already...

Issue: I have a linked table (ODBC) each time I run a query a pop- up box appears asking for my password for the other system. I then design a make table...

Is it possible to paste the content of a Word doc directly into a record in Access? I have designed the form and have a field where I'd like to be able to...

Using Access 2007, I will be developing a prospect call log and order entry system for my company. The products we sell are somewhat expensive so we get a...

Is it possible to have a table as the lookup record source, but when the record is not found, add a new record – but into a different table other than the...

I need to develop a sales order database that can allow a customer to have many phones, many addresses, and even many contacts. For example, we sell vehicle...

9PC PAISLEY DESIGN BROWN / BLUE COMFORTER SET W/ MATCHING PILLOWS, KING Price:$89.99 Image: http://bestdeallocator.info/image.php?id=B001KVUKUS Best deal:...

Hi Experts, Here again as usual. :-) I'd like to get opinions and/or pinters to achive the following: I would like to query an mdb's/mde's MSysObjects from...

Hi, How can I indicate the relation to be a 1to1 or 1-to-many or many-to-1 on my relationship diagram. It seems to have a mind of its own on deciding what it...

We've just updated from Access 2000 to 2007. We've recomplied the code and all is working normally. Our problem is our back-end database on the server is...