Search results

I have a form with an embedded subform. For each record in the mainform, I could have several subform records available to choose. When I print, I am unable to print the mainform record along with a single subform record. When I go to the print function, I'll select "selected record(s)", and it...

thanks for your help. will this also print the current order in my subform? the orders subform is in continous form view.

I have lost of records in my subform. how do i print the current record in my subform? Please help!

I have a form with the client's info and the subform contains the orders the current client have placed. On a click of a button, i want to be able to print an order form that has the client's info i.e. address and the current order details. is there any way?

Is it possible to sort the data in a continous form based on the header clicked by the user? thanks for any help.

what code do i need to put in my form's "on open" property so that my form goes to a new record everytime it opens. thanks.

please give me an example of this function. i cant get it to work. i have my "task description" field automatically updated based on whatever value was chosen in my "task ID". One task ID corresponds to a task description. do i use the dlookup function for this? and where do i put the code...

how do i get the value of the last record in my field? thanks in advance.

i have a combo box on my data entry form from which i based my query results. i want to display my results on a subform in my form. i couldnt make the results display on the subform. also, all choices i pick from my combo box gets added to my table and i dont want that to happen. what can i do...

i am learning how to verify userid and password entered by the users. it seems to be working except the part when the wrong userid or password is entered. here is my code: Dim db As Database Dim rst1 As Recordset Set db = CurrentDb Set rst1 = db.OpenRecordset("Select * From passwordtest Where...

how do i make my data entry form close without saving whatever i typed in it. i have a save button and a "close without saving" button. the second button seems not to work. the data i didnt want to save is in the table when i close the form by clicking on "close without saving" button. any...

I have the following criteria in my query: like "*" & forms![forms1]![searchbox] & "*". my problem is whenever i type "?" (excluding quotations) or "*", the database returns all records. is there any way i can make my query not show all records whenever the symbols ? or * are entered in the...

i want to count the number of records that my query found. i want to place this in a textbox. i know i'm supposed to use "dcount" but i couldnt get it right. will someone please hlep me? thanks in advance!

yes i am using a form to diplay my query....

i have a query in which user's are required to input a parameter. how do i create a message "no record found" when there are no hits found based on the parameter entered? thank you in advance for your help!

i want to declare variables in my database. where am i suppose to enter them? is it in "general" module?

mine was a general question and your response solved my problem. thanks a lot!

how do you assign a variable to a textbox?

how do i stop a parameter query to stop showing all records every time users leave the parameter blank? i am using a query to limit the records my users can view but all records are shown when they didnt enter any parameter! it defeats the whole purpose of my query being used as a security...

thanks for the advice. is there a way to print the results of the "filter by form" function?