Search results

My problem is that after I enter the first date range condition, it won't query any record. If I take out the second conditon, it work as expectation. On the other way around, the second condiion also can work independently. THis is quite strange. However, as I mentioned I would like to have 3...

I have created a simple query! And I would like to query the query sheet using conditions, with the following 2 type of practical query. a) date range -> between starting date and ending date under invoicedate field c) only working status -> status = "Y" under status field My problem is...

1) how to set odd number rows color different from even number rows?? 2) how to set the current row color which is different from all others?? Thanks a lot!!

I have created a query with sorting order specified. However, when I using subform to link that query, the sorting function disappeared under subform environment!! Any idea?? Thanks!!

No! I meant copy reaocrds from one table to another table!! Thanks!!

One master file and one transaction file. Then I create a query file mainly based on transaction file plus one field from the master file, the transaction total field. I also create a form with a sub form linked to this query. In the subform, a logic created in after action event procedure as...

Two same structure files! How to copy content from one to other on record by record basis. I only know field by field copy! Is there any easy way or statement to do it! ? Thanks!!

Where can I find this "Compact and Repair" option!!?? Thanks!!

I am using 2000 Access. My database keep on growing even though I have constantly deleted tranactions. Is there any way to restruture or organize the database so as to reduce the file size of the database?? Thanks!!

Thanks boblarson for your detalied explanation! I am now using 2007. But my colleagues should have to use 2000. Just want to know how he can also achieve the same purpose in 2000 to have transction header and transaction footer in his report. In not, then is there workaround solution to have the...

I can create a transaction header by clickiing the grouping/sorting option to display the order master record data. However, is there any way to create a so-called transaction footer to achieve similiar purpose in report layout?? Thanks!!

WHy in multi user environment, the simple query like this type won't work?? Then, is there any approach that can overcome this problem!!?? Thanks!!

In practice, the situation is a little bit complicated. Cause, some transactions have to be printed out immediately. As such, how about to put a flag in the record to indicate whether the transaction has been printed out. And then a query to filter out for those transsactions that still have not...

Nobody!!??

Just want to know is that the sample report only print out one blank line? Cause I suppose it will print out some records and then with some blank lines!!

Anybody?? Thanks!!

I would like to printout a 10 rows report even though I may got records less than 10 rows? Please advise how I can print some blank rows to achieve 10 rows per report? Thanks!

Sorry! I couldn't find any Picture row either. I am using Access 2007 indeed! I first clicked the detail section, no Picture item appeared, and then I clicked the fieldnames available in the detail section, and also no Picture item appeared!! I have thoroughly search all the optiones and menu...

Why I couldn't find any insert picture property box under the Format tab??

Yes! I understand that or may be I need to have that Chinese code set in the PC which use the English version! Anyway, i just don't understand why the table fieldname and when running the applcation, all query and forms can display correctly all the Chinese character but not the programming...