Search results

I just don't get how to write that piece of code given my situation.

Hi, I've attached two photos to make this explination a bit easier. On my main form (when the database opens) allows the user to search by Fed ID using a textbox and a button with code which will return all records that match that FED ID and fall within a year from Today's date. Photo 1...

i just put the lookup value in the beforeupdate of the category field on my input form. works like a charm.

I guess I could add another field to the table and form and just copy what is generated into this new field as a workable fix? Or is there code that I can write for this to happen?

Because I want to search by the item number and not a counter number... Oh and also, I need to upload the item info to the web so im going to create a report that has all the data laid out in the appropriate format so i can just copy and paste the lines i need.

I just don't understand how to search by generateditemnumber in a query when the field I'm looking for is concatenated by 2 fields (categoryabbr + my number)?? I.E the 5th item to be added to the database (a computer) would be cpu5 using the 2nd column of the category table along with the Dmax...

mynumber field

Hello All, Access 2003. Edit: These fields are on my input form. I have a field called "GeneratedItemNumber" in my table "tblMain". This field uses a number field "MyNumber" and a category field "Category" and combines these values using this code in the generateditemnumber control source...

Thanks Chris, You example was great and it makes more sense. Thank you too Bob. Works great!

Here's the thing, I need to know what the item number is/will be (with the category abbreviation and unique number) at the input screen based on my duties regarding this information. Since creating databases..and i am no expert, but all of my tables use autonumbers and ive never had the...

Well, I looked around, I am close with this My new generated item number field has this as the control source: =[Category] & [itemnumber] The thing is I have the Category combo field showing the first column of the table and then next to it I have Category combo field showing the 2nd column...

Hi All, Access 2003. I have an online web shop where I need to create a database to store my items. I need to generate item numbers combining my autonumber field and my category abbreviation field. For example, the second item to be added into my database is a computer. I select computer...

Re: I have set a password with "on click", how do I show "*" when entering it I got it. Never had to do something like that. Awesome Bob!!

Re: I have set a password with "on click", how do I show "*" when entering it What is standard module?

Re: I have set a password with "on click", how do I show "*" when entering it Am i suppose to copy all that code and replace it with mine, or do I just need a piece of it?

Re: I have set a password with "on click", how do I show "*" when entering it http://bytes.com/topic/access/answers/888494-vb-input-box-password-help Does this make sense to you?

Re: I have set a password with "on click", how do I show "*" when entering it Well that code didn't do anything. Some part of the code will need a "*" to let it know thats what you want to type as a replacement for the characters. I could use a text box and have it work with the command...

Re: I have set a password with "on click", how do I show "*" when entering it Check this out first: http://www.databasedev.co.uk/button_security.html That is the form popping up...

Re: I have set a password with "on click", how do I show "*" when entering it Access has a "restricted form" dialog box that pops up when I hit the button to enter the password. I dont believe i have access to the properties for that Access Dialog Box. I think I would have to add something to...

I have set a password with "on click", how do I show "*" when entering it Hi All, I created a password "josh" on one of my form buttons on click property. How do I encrpyt it (I hope im using the right terminology) when someone clicks the button and begins typing the password. In other...