I am trying to open up a form based on a table and restricting the records to a field on the main form.
Ex. main form has a drop down combo box based on company names in company table, once you choose the company the company form opens up filtered or restricted to just the ...

Please, help me with this issue: I got a file which is an extract from
Oracle database, and I want this file to be programmatically imported into
MS Access table.
This is an example of what kind of data this file contains:

Ok....I know this may be something simple but I just don't have the time anymore to mess with it....Does anyone know how to have all the windows open maximized and stay maximized when closing or switching screens? Any input would be greatly appreciated.
Thanks,
Randy

Easy VBA question for somebody who knows what they are doing (unlik
me).
I would like to put a command button on a form that will export th
data of a query to an excel file and possible ask the user for the fil

using 97. and trying to do a condition in a macro, but
cant' seem to get it to work.
If there is no data in my query, then I want to display
message that NO Data and stop macro. So I test with data:

I am trying to set a value to a field based on a contion that the date given is between two given dates.... is it possible and please how???

Howdy
I have a question about filling in a field's value.  I am actually modifying the sample "Time and Billing" database in Access 2003, and I have a question about filling in values in a field based on values in another field.  I have seen this done with a macro, but ...

I have built a macro running several reports every day.  
there is one specific report in the macro I only want to
run on thursday

Is there a way to test for the existence of a form (a built in function or
some such as opposed to knocking something up in VB) before I attempt to
delete it in a macro, or alternatively is there a way to suppress the error
message so that it continues with the rest of the macro ...

I have an access table with multiple columns. What I would
like to do is tranpose the data.  Column 1 has id  Column
2 through 20 different headings.  I would like to take
column 1 as one field column 2-20 as a field column 3 as

I have a macro which imports 8 text files to update my
database. currently i have to manually copy the text
files from their folders to my "update folder" and then
run the macro. is there a way to get access to copy the

I have a problem and I do not know why.
I have a table called "Outside" with the field name "Field1","Field2"
... "Field10".  The datatype for "Field5" is Date/Time.  Some record
have this field blank, while other records have "00/00/00".  Then ther

I am using an OutputTo command within a macro to export a query to an excel spreadsheet. Unfortunately, the field description is making its way to the spreadsheet as a column heading. I only want to data, not a heading
Is there a way to prevent this? Maybe I'm using the wrong ...

I would like to use the transfer spreadsheet macro, and
have it allow the user browse for the excel file to
open.  Is there a way to do this without using VB?

All,
We have an Access XP database that e-mails query output to assorted
recipients using the SendObject command in an Access macro.
We need to modify the process so that certain e-mails are sent from