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.

If there's one thing I've learned from all this is to be patient. I have a whole new respect for programers.

Private Sub cmdSearch_Click() 'Set the Dimensions of the Module Dim strSQL As String, strOrder As String, strWhere As String Dim ctl As Control, boo As Boolean For Each ctl In Me.Controls If ctl.ControlType = acTextBox Or ctl.ControlType = acComboBox Then...

Works Great. I'm going to push my luck. How do I get a popup box to display if no search information is entered? Right now it starts prompting for BookingSheetNumber.

I know you've given me an inch, and I've taken many miles. I hate to even say this, but the search doesn't display anything now. I cut and pasted your code for the button. I guess I'm not doing something right. Any ideas? I know you can't make it much easier than that.

I know it's a normalization nightmare. This is my first project and I'd never even heard of normalization prior to reading about it on this site. I have every intention of making an updated version very soon. However I can't quit on this one because I've put so much time into it and my Chief...

Please Anyone? I know that's a lot of code, but this is the last problem I need to solve in order to finally be done with this thing. Thanks again. -Phil

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

Thanks As soon as I'm done with this project I'll have time to start working on my department's web. I can assure you that I will display your links proudly. It's certainly the least I can do. The amount of help I've received has been priceless. Thanks everyone.

It works great. Thanks. I'll name my first born after you (I'm not sure the wife will go for that though.)

Here's an example of what I have. Hopefully you can see what I'm doing wrong. Thanks for all the time you've given me.

I don't have a clue. I've cut and pasted and added txt to the name of YOB to give txtYOB. When I put an age in txtYear, nothing happens. Does it make a difference that neither box is bound?

Here's what I have. The user enters the age in the [txtYear] box. Dim intCounter As Integer, strList As String For intCounter = -5 To 5 Me.YOB = strList & (Year(Date) - [txtYear]) + intCounter & " " Next intCounter Me.YOB = Trim(strList) Where should the code go? I can't get it to...

I'd like the output to a txtbox called [yob]. I'm using it in a search form and I need the user to enter an age in one txtbox, have a range of years display in another box, and then search my table for records with a year matching one of calculated years. I think I've got the search down, it's...

I'm close, but how do I get it to calculate a range of +/- 5 years and to only display the years? Date() will show today's month, day, and year.

I get a #Name error.

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.

Does it work for you? When I type a name in it doesn't do anything on my main form. All it does is start a new record with the name. Help. -Phil

Everything else is working great now. My plan was to have a search form accesable from the Switchboard for a search. When the search is completed I wanted the names of the possible matches to come up. Then the user could click on the name and the booking sheet for that person would display...