Search results

I use this little pop-up calendar on most of my programs and it works like a charm for entry and reference. No Active-X controls needed.

Thanks for the explanation, Bob. For the life of me, I couldn't understand why he couldn't edit the query when I could.

I just downloaded it at work, went into the query - added an ORDER BY line and saved it. Go to the Database Window, right mouse click on the Query, then right click and select Design View, then right click and select SQL view. Make the changes (add the WHERE lines) and save it. There should...

I just checked and the attachment has been downloaded 2 times. So it is here. Please download it and use it as your example. It seems to me that you are not following the instructions that we have given you. I can't help you beyond what I've already done if that is the case. I don't mean to...

That's what I did in the attachment. My post should have an attachment that is about 57kb.

I just looked at the post and the attachment is there.

Sorry, I uploaded the old one - here is the new one using query2. If you add the WHERE statements that filter the form - like you did in the original post, it should work because that is the standard way to do it.

You're Welcome. Glad I could help.

The following would include the beginning and ending Date and any Date between the two. WHERE [YourTableFieldName] Between Forms!frmDownTimeGraph!begin And Forms!frmDownTimeGraph!end;

Thanks for posting your solution. That will help someone in the future with a similar problem. (well ... as long as they use the search feature) :)

I'm guessing that you have that field in the table set for text. Change that to number and then specify something like integer. Then when a non-number is entered in the box, a warning msgbox will be called.

For some reason, you had an actual query instead of a table for the subform. I changed that to a record based on your query2. Right now, it shows all of the records for the table. You still need to go in and change that query to mimic the one you had here so it will filter the records based...

What you can do is make a "stripped down" version that doesn't contain any personal data. Just enter some fake data (enough for it to work) and then the group here can have a look at it.

Sometimes (when the issue is complex) it's easier to upload an example of the database. Even with the best descriptions of an issue, there can be certain elements that are missing, making it nearly impossible to diagnose the problem without having "hands on" so to speak. With the database at...

Of course, that makes sense.

That's true, but I tend to bow to your expertise in Access. :)

I went about it a slightly different way, Bob. I added the public variable on the afterUpdate of the login then used that on the currentEvent of the form to put the name in the textbox. My method doesn't do a check for a match, it just mimics the name assigned to the combo then transfers it to...

You might want to have a Command Save button OnClick Event do a search for duplicates. Then, if it finds a dupe it will call a message to ask the user what they want to do. Something like ... (quasi code because it's early and I might not have this quite right :)) Private Sub...

Dim DB As DAO.Database, RS As DAO.Recordset Set DB = CurrentDb ' Open a Recordset and loop through it to fill the TreeView ' control. ' The Key value, RS!CustomerID, is naturally alphabetical Set RS = DB.OpenRecordset("Customers", dbOpenForwardOnly) Do Until...

This is the usual way to move through a recordset.