Good morning all:
   I want to set the default value of a textbox with the value entered in a
textbox on another form; a previous one. Right now, it is saving the ID
corresponding to the value entrered on the field, but what i want is the

I’m trying to create an Access formula that when I do a query it will only
show me effective dates until about two months in advance. Can anyone help me?

I have a field that stores the date and time from a GPS device in a single
field.  I want to use a query to split the single field into two separate
fields and then format the date and time fields.  See sample data below.
Date & Time Field, New Date, New Time

Not really an Access question but.... does anyone know the effect of running
a compact and repair on security permissions (folder security) for an MDB
file. I right clicked on my MDB file and chose Properties--Security and
printed the result. Then I did a compact and repair, then ...

Our company has a large staff list/offices in Outlook.  It is a request that
I use that information and create a few different printouts.  There was no
suggestion on what software I should use for this process.  I am certainly no
pro when it comes to Access but, I presumed that ...

Has anyone received the error message below:
"There isn't enough memory to perform this operation. Close unneeded
programs and try the operation again."
I'm trying to open a form and I keep getting this message.

I set my form to datasheet view.  However when I use the switchboard it
appears as single form.  Can this be changed?  Thanks.

On one of my forms called "story" I am getting a strange problem when I try
to tab to the next field.  When I press tab it highlights the text I just
typed.  I cannot select the next field with my mouse either.  
One stupid way around it is clicking (right away after opening it & ...

i have a set range of two columns, but now i need to narrow it twice instead
of once. I used countif for this equation the first time when i only had one
criteria but now i need to use two pieces of criteria to narrow the range.
Any help is appreciated. Thanks

When running a macro, I get the following error:
‘The query cannot be completed. Either the size of the query result is
larger than the maximum size of a database or there is not enough temporary
storage space on the disk to store the query result.’  

Does Access have the increment function like in Excel where you can enter
incrementing numbers in concecutive cells by dragging down, or across?

I have a field containing titles of books.  I want to exclude records that
contain the specific characters "AFE".  Help

I wish I could break this down, but I have been struggling for some reasons
and so I am going to post my entire challenge here instead of trying to
compartmentalize it.  
I have a database.  I have many tables and several forms.  Within one form,

I have a db that tracks applicant information for job hiring needs.  
Applicants are required to take pre-employment tests and those tests are good
for up to a year.  I have 4 tests that each have there own date taken field.  
How can I calculate from the current date if it has ...

It would be very useful for me to give each customer in my database a unique
customer ID based on several items including the first or first several
characters of different fields, perhaps brought together with a sequential
number at the end, including space holding zeros when ...