I am importing data from a SAP system into Excel XP and
then altering a dog's dinner of a layout into 5 neat
columns. I then import the columns into Access XP table.
I've automated it and it works fine apart the middle

I have a database I have working perfactly on one computer but when I zipped
it and transfered to another computer it shows the records but when I click
to enter new data it sends me to the visual basic editor. It is located in
the same folder on both computers. I clickled on the ...

Is there a way to choose an item from a drop down box and have Access auto
fill in other fields?
Ex:  Choose a job number from the drop down box and have Access
automatically fill in 2 separate fields with the start time and end time.

must one have an access to run the application..or if without access can any
user used the application?

just a quick question.
is it possible to wrap text in a list box?
Thanks
Lee-Anne

I have a main form named "Manage Accounts".  Form "MC MAN" is a subform on
"Manage Accounts".  "MC MAN" has 2 textbox controls.  The DefaultView is
Datasheet.  Form "MC AN" is a subform on "MC MAN".  It has 3 textbox
controls, actno, actname and acttype.  The DefaultView is ...

I am a novice Access user and I've created a database of our equipment.  I
want to copy the data to Excel and to also copy the Database to our network.  
I don't get an option to "save as" when I save the database.  

I am running windows xp home. When I try to access Microsoft Access 97 I
recieve a message out of memory. I have adjusted my virtual memory. I have
1024 Megs of ram. Can anyone help me troubleshoot this problem?

I've got a database with a field of id numbers.  I want to see all id
numbers that don't end in 01,02,03,04,05,06,07,08,09 ...
for example
55501

Hi I have a date input mask and I get an error message
saying that the format is wrong if for example one number
is left out of the year etc..
please could you tell me how to trap this error to

I have a report that is working pretty well, it does sums
of various fields, but I need to do some tweaking, and I
am not sure how.  One question is this...I have the
report doing a sum of different counties, so if the field

I've set up a macro that sends out a report to all the BoardMember of the
corporation I work for, How do I create a Batchscript or Job that would
execute this macro daily at about 7:00AM every day, so that when these
members login, they have their report ready before 8:00 AM? can ...

With the help of Rick Brandt, Dan Artuso, and John Vinson through a previous
post I wrote this function to loop through a table... But I am getting an
error message that my table name is spelled incorrectly and cannot be found.  
I may have trouble because all the table names in ...

I have 2 combo boxes and 5 text boxes. I want the second combo box only to
display the items that are linked to my selection in combo box 1. Then when I
select the appropriate text from combo 2, I want the 5 text boxes to display
the text that is linked to my cvombo 2 choice in ...

Thanks in advance!
I want to use expression to calculate the total value in
a "control A" on "form A" which is based on a "Table A".
But the calulated value does not update its value to the