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...

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!

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?

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...

I have a main form which displays data and the textbox from which users can type a keyword as a query. when the query is run, a datasheet is opened with the query results. since the main form already has all the fields, i want my query to display the results exactly in the same form where is...

I cant seem to make a text box as a source of my query. in the criteria, i entered forms![forms1]![textbox1]. am i missing something?

i am able to grey out(disable) a command button when textbox1 is empty. but how can i enable the command button once a user enters info in textbox1? this is the code i use: Private Sub Form_Current() If IsNull(Me.Text25) Then Command27.Enabled = False Else Command27.Enabled = True End If...

I have a query that prompts users for a parameter. the results of the query is outputted to a form. on this form, i have a command button to preview a report based on this query. the problem is whenever i run the report, the same dialog box prompts me for the parameter. how can i get rid of this...