Search results

I recently put together something similar to what I think you are describing. In my case, we needed a database to track work associated with upcoming and present products, by the different departments at our company. So I ended up with a Company table, a Product table, a WorkType table, a User...

Additional info, the textbox named "Password" is bound to the User table "UserT", Password field (a text field with a password input mask). Further research reveals that the Password field is not getting updated. What am I missing? Further info: After adding a UserID (PK) textbox to my login...

I created a small database with a user login form, along with a password reset form. Running it in my sandbox as an accdr file, the password value resets just fine, but on my test machine with the Access 2010 runtime installed, the password reset form doesn't reset the password. I will try to...

I got sidetracked during my lessons by a discussion of a login form. So I built one along with a user table, and lo and behold it works. I got to thinking about how a user might change their password without help from an admin or someone else getting into the table and changing it for them. I...

Yes CJ London's eloquent suggestion did the trick. The search form has a label that prompts the user to use mm/dd/yy format or to use the date picker tool. That said, Access is smart enough to handle most ways folks might enter the date values.

Okay so basically this expression says if start date is null then it's "Date Zero" which for Office applications is December 30, 1899, and if end date is null make it Dec 31, 9999?

CJ_London, I can't believe I missed this in the thread. It works perfectly. So in this case adding the nz function is like saying either use the value entered or null? From the MS Office Access Help web pages on Nz After reading a bit about it, there appears to be a lot more to this function...

I'm going to dig into that discussion and attempt to understand it for sure. By the way, from your signature, I see the suggestion to add to a user's reputation by clicking on the scale icon. I don't see that option. Is this something new users don't see?

Thanks for all the advice. So using the Is Null option works if the user leaves both the start and end dates empty. Now I'm pushing it to try and get it to work if the user enters a start date or an end date only. As a bit of background on this project, I'm early on in my learning curve with...

Within the query itself

I have built a search form to feed information to a query. The form uses combo boxes tied to table values, and all have wild cards built into them so if the user leaves the combo box they get all the records. I also have to text boxes representing start date and end date. I would like to allow...