Search results

smart, it REALLY help!!!! thanks man.

how can i control a field to show/not show at the query level? let's say i have a query (from a table) like this [regularPrice] [isOnSale] [onSalePrice] where [isOnSale] is checkbox. if it's checked, [onSalePrice] will show [price]*0.9; if it's not checked, [onSalePrice] show nothing. i've...

how? there's no fixed filter, so there's no "FilterName" ... and "WhereCondition" is also not fixed ...

this only print the one record that is selecting... suppose my db has 1000 record. after a user apply some filters, the form will show "1 of 120 (filtered)." and i want the report to print out that 120 records, not 1000, not 1...

ruralguy, it's doesn't seems work on me. can you give me a example, my code looks like this now... ********** Private Sub Command76_Click() On Error GoTo Err_Command76_Click Dim stDocName As String stDocName = "rp Order 2005" DoCmd.OpenReport stDocName, acPreview...

quick question... i have a form with a "Save" button. i wanna disable/grey all the fields when user push the button, so they will not be able to make change... please help.

i've created a form base on a query, and other users will work on it (mainly filter). then i created a report base on the same query... what i want is a "print" button on the form which will print the report, not all records, but only the filtered records after user applied their filters...

pat, B2 is the user name, ie. to indicate who added the record. since some employee are leaving the company, there's no reason to keep the old employee name in the list and make all old added record to belong to the new employee...

thks pat, i did exactly what u suggested. and i solve my first problem by "limit list" on the combo box, B1. so user can only pick values from the drop down list. but i'm still stuck on my second "bigger" problem...

if i keep B2-B4 in table1 too, how can i set the auto fill then?

hi there, i'm new to the board and access... got this question, donno how to fix it. anyone, pls help. i create this db pretty much using wizards and following books... i have 2 table: tb1 and tb2 tb1 has fields A, B1, C, D; where A is the key and B1 is a combo box that select value from tb2...