I am new to access and I am trying to find out if it is possible to set a field to default to the first answer entered, so that in the next repetition that...

Is there a maximum number of records a table can hold?

The previous post/answer by Allen Browne sounds like just what the doctor ordered for my current situation. An intermitent "Access encountered a problem...

I am trying to get my query to only show results for the most recent inventory of each item and I keep getting unfathomable errors. Any...

Hi i have a table as follows: Table1 Ref Code 123 1 123 4 123 5 123 6 321 1

I am trying to do a many-to-many join on Id's from two separate files. I like all Id's from both files to show in the query regardless of whether they have...

Is there a way to prevent the truncation of file names?

when i import data to access table from excel. tables are filled with " ". how can i remove this " " from my table. this is not aleading or trailing space.It...

I have a table of 400,000 records that I want to change the numbering based Model, Serial then Date Order Model Serial Date Number A 1 ...

I have a form that is filtering the information from a table (i.e., there's a criteria in the data property/filter field on the form). I can resize the form...

a new feature to windows vista is the movie maker no longer do you have to go out and purchase a program to create your slide shows windows vista comes with...

Often when we try to select an option from a drop down list of our Access client records to add the data to another record, the system locks up and gives us...

I have a start up menu with a command button linked to a form as “open form�. The form was created to open as “Datasheet view�. But, when I push the...

I'm trying to list records that appear in one table, but not the other. I'm using the Unmatched Records option and all is well, except it's adding records...

Hello there I kind of new of this so this is my problem my boss want's me to modify his access program so he is saying that everytime he changes the status in...

How do you turn off the unique identifier on the sales invoice programme of MS Accounting Professional 2008 Pro? We have been unable to enter invoices out of...

The code below ran in VB6 and the called Access DB was NOT visible. We've transferred the code to another Access DB..the code works fine, but the called...

I have created a Data Access Page from a table and my question is why doesn't the page display the current format of a field. Ex: Total Revenue field is...

I have opened an Access 2007 database and it opens to the main form. However I need to make some changes to the form and other objects. However the objects...