Search results

If you right-click on the query in the database window, there is a menu option to export it to whatever format you like. So you can easily get the query result into an Excel sheet.

Also If you changed the border style to "Dialog" it will keep the size that you set in design view.

Try importing from within Access: File-> Get External Data->Import There is a wizard that will take you throug the process, enabling you to choose which fields you want to import and which you want to discard. It even allows you to discard the first row if it has the headings, and to set the...

Where is it?!

Sure no problem. I am jobless for now and I do have some time :0)

Another option is to use the VB capabilities in Access to open the file and read it record by record as in the following samples Open filename.prn For Input As #1 Do Until EOF(1) table.AddNew table!filed1 = Input(lenght1, #1) table!field2 = Input(lenght2, #1) . . ...

Ah I got what you mean finally! Search in help under "Autolookup" Autolookup queries is a feature in access that fills some field for you automatically. But you have to have a primary key in the lookup table so that whenever you choose a value in the other table, there will be one unique set of...

You misunderstood the function of lookup field. A lookup field simply helps you "choose" between a set of options instead of having to key them in. For example you can careat a table called "State/Province" and then enter "ON,AB,BC,......etc" Now when you come to a customer table and create a...

Probably the first table is empty because of the primary key issue. If you resolve it, you have half the problem solved. Now I understand that you have a field in a new table that looks up data in the imported table. If the imported table has data in it, the combobox for the lookup field should...

I suggest that you check the "column count" and the "bound column" properties of the combobox. if you have a combobox that displays NAME and ID and you want the output of it to be ID then you should set the "bound column" =2 . If you want the output be NAME then set "bound column" to 1. I am...

The first problem is usually caused by an empty cell being imported to a field which the import wizard considers to be a primary key (row identifier). Try filling this field with data before importing if possible or choose another field to be the primary key during the import process or skip...

Glad I could help!

I can really describe it in words, but if you look at the pic you will get it! remeber to remove the double quotes if your datatype is numeric.

Set the default value to: =IIf(Time()>#9:00:00 AM#,Date(),DateAdd("d",-1,Date()))

I am not sure if it depends on the version but on mine (2002) it is accessible through Tools->Database Utilities -> Switchboard Manager.

Why do you need to run the database from the CD? I mean why cant you copy it to any Hard Disk and remove the read only flag?

Of course you can!! I will give you the starting point and you will have to read the help to reach your desired result. Here is a sample code from one of my projects. DoCmd.TransferText acImportFixed, "File import Specification", _ "Inventory", "File.txt" where "Inventory" is the name of...

This can be achieved easily using an aggregate query choosing the "group by" field to be the foreign key and then choose max of [ID] that way for every foreign key you get the last transaction.

Regarding the null values, you can always filter null values out, or search for them by using the 2 access functions IsNull() and NotNull(), if you place them as a query parameter in the query grid, you get the desired result.

Yes I have worked with several databases over 6 years, some of them I designed myself and developed ones designed by others. The idea of having lookup tables is fundamental to database desing. You will always need to have lookup tables for Categories, Cities, Areas, Payment methods...