Search results

I found the follwing in another post and was wondering if anyone could expand on this. What would the code be for the buttons to select Edit or Add on the form? My form opens in Add mode but I'd like the user to have the option of toggeling to Edit or Add. Thanks -Phil

What would the code be to have a button on a form that closes the current form, and opens another form with one click? I can get the button to do one or the other, but not both.

I've got a search form based on the following code. After much help from Mile-O-Phile I've been able to get it so that when the user enters an age in an unbound txtbox, a range of +/- 5 years of the date of birth populates 11 unbound txtboxes (each holds a different year.) The below searh...

what would the code be to have a user enter an age in a text box and have the db calculate and display year of birth +/- 5 years in a different textbox? Basically the reverse of this and +/- 5 years: ())+(Date()<DateSerial(Year(Date()),Month([DOB]),Day([DOB]))) Thanks.

Can anyone help me with (or point me to an example) creating a search page with unbound textboxs. What I need to be able to do is select a checkbox to include or not to include the textbox in the search. For example: I have physical descriptors in my table such as "Race", "Age", ect. I need...

I have a textbox sized to 4 lines of text on the screen. How do I limit the textbox to only allow those 4 lines to be entered? The problem I'm having is that once the 4 lines are filled, the box continues to allow data to be entered. It is not allowed to shrink or grow and enter is used to go...

Syntax error (missing operator) in query expression. Where is it missing? DoCmd.OpenReport stDocName, acPreview, , "[ID]=forms!Booking Sheet[ID] & [Car Number]=forms!Test![Test]![Car Number]" Thanks.

I'm having trouble defining the proper relationships between tables so that fields in a form and subform will function properly. I have a field named Record Number in my main form. I can get Record Number to display in the subform. What I'm having trouble with is also a field named ID that is...

I'd like to thank Wayne for his previous help, but I think I need to better explain my problem. I have a form with a subform. I need to design a query to open a report that will display only the current form and subform. I've been able to display the current form, but all subforms are...

How do I get a report to display only the current form and subform displayed on the screen?

help with code I've created a search form where the user presses a command button and the possible matches are displayed in a list box. The user should then be able to click on the correct response in the list box to bring up the correct record in a form. I've used the following code posted...

My apologies for asking a question that has been asked many times before on this site. I've tried the codes and downloaded examples, however I'm still just not getting it. I have a form named Booking Sheet with fields [Last] and [First] among others. I would like to make a separate form to...

I need help with printing the information in an open form as a report. I only want the current record to print as a report opposed to all of the records. I'd just print the form but the form takes up way more paper. I was also wondering how to get the gridlines in the report to print? Thanks...

I'm having trouble with what I know is a simple code. I have text controls: $1, $5, $10 etc in a form. The user is to input the quantity of each bill in possession. I then need the form to display the total dollar amount. What should I type in the Control Source property? Example: He has...

I'm using the expresstion =[Money1]+[Money2] to sum two fields. However, I also need the expresstion to over rule the addition and make the total display 0 if a checkbox named "no bond" is checked. Any help would be great. Thanks.

How do I make the -1's and 0's in my table created by unbound option groups, display the words "yes" or "no" respectively? Thanks for the help.