I want to be able to run a macro from a command button that allows for a specific data set to be found and then appended to a seperate table. I have a central...

OLE Object fields can't be made primary keys. I have a table that houses many OLE Objects for one record and I want to make sure that one record can NOT be...

Hi: I want to Add a Field of short datatype using Alert Table sentence in the a2k, but always error, someone can tele me why. thank you. my SQL...

I am creating a database which will list various internal control processes for the various business cycles. There will only be about 7-10 cycles, but each...

How do I check through all the records in a query/table at run time when I go to the next/previous record in a form.

My Access97 database is linked to an Excel97 doc. How do I change field size in my linked table? Several records contain data bigger than 255 yet Access sets...

Hello, I am creating a database of names and telephone numbers etc. for my work and I can't seem to get one of my Validation rules to work. I am basically...

I have 2 tables with the same numbers of fields and same name Table 1 is the original data and Table 2 is the adjustments data, which needs to be kept...

I suddenly have this "Unread Mail" folder. New mail cannot be opened from the "Inbox" anymore, even though there's a blue # telling me how many mails are...

The memo field goes on forever. How can I set up word wrap for the memo field in Access 2000 such as in Excel?

I have this popup form that I'm inserting information from a table that is indexed by CTANumber. The CTANumber is located on my other popup forms so that the...

Is it possible to update a column on one table that is the result of a sum of another table's column? I have a table of accounts, which contain a balance at a...

Do you recommend SQL statements, in the RecordSource property, or a saved query? Any particular reason? Thanks.

Hello! i want to prevent entry in one field on a form unless another field has been filled in. Could someone please tell me how to do this! Thanks Derek

We have a problem with an Access 2000 table where the KeyID field was duplicated. When we look at the table and attempt to append a record to the bottom of...

I have a sets of questions I want to answer on different pieces of equipment and I am not able to figure out how to relate the tables to one another. I have...

how do i remove "is null" or "is not null" on filtering?

Hello, A little new to access programming (I'm a MySQL/PHP guy), and I was wondering if it's possible to change a Yes/No field to different values, besides...

Hello, I'm trying to combine two tables into one form, without using subforms. One table has 255 fields and the second table has about half of that. Is...

I have a report that will crash when a certain table doesn't have any data. This is hard to explain, so please bear with me. This is a monthly report that...