Search results

If you want a "REPORT", send some records (your table), and tell us what is a look of "Report", (draw the report).

Ok Uncle Gizmo. He can adapt it as he want.

Look at "DemoSumA20022003.mdb (attachment, zip). Look at TAble1, Form1 (VBA). Open form and try.

I think it can be done via Module (function). Look at "DemoTVqueryA20022003.mdb (attachment, zip). Look at Table1 (I added 2 records T1850), look at Query1 (Column Xp1), look at Module1. Run Query1 and see.

I suggest to do it via OUTPUTTO function. Look at "DemoQueryExcelA2000.mdb (attachmnet, zip). Open Form and try. Adapt it as you need.

Try this: In the Table (for this field) put: Data Type = Number, Format = #.### In the Form (for this field) put: Format = #.###

Yes, short example of your application, with fictitious data.

Look at "DemoDateBetweenA2000.mdb" (attachment, zip). Open form and try.

Send a short example of your MDB, (access2000 or 2002-2003).

Put "0" in the table, (without quotation marks).

As I can understand you, you need 2 tables and 2 forms for this. Table1: f1ID, (Number, Primary key), f2Fn (txt, first name), f3Sn (txt, second name), f4P (txt, profession), f5.......... Table2: f1ID2 (autonumber, Primary key), f2Fk (number, foreign key) f3P1 (txt, next porfession), f4P2 (txt...

Send a short example of your MDB, (Access2000 or 2002-2003). Yes, maybe "Nz" solve the problem if any of your variable is null. It must be 0 or > 0.

Try this: Total: [w]+[b]+[O]+[NA]

Send a short example of your MDB, (Access2000 or 2002-2003).

Try this; Round([Price1]*1.35;0)

I think it is not a txt file, I don't know.

You don't need 3 combo boxes. Put a combo box on the EID field. Look at "DemoComboBoxA2000.mdb" (attachment, zip). First column in combo is column 0.

You have to know how many records you look forward, and therefore to adapt VBA (Right and Format). Look at "DemoNewIDA2003.mdb" (attachment, zip). Open Form and try.

1) You have to arrange a layout of TXT file with th sender. It mus be the same all the time. 2) When you have a TXT file on your PC, put it in the same Directory wiht your MDB. 3) In your MDB link this TXT file (click on FILE, GET EXTERNAL DATA, LINK TABLES). In the form "LINK", select a...

Try to do it via DLookUp function.