Search results for query: *

Hey everyone, I am creating this Expense Log Form for entering all expenses for vehicles that is owned by my company. I have an unbound combo box, which pulls the vin # from the tblVehicleInfo, and when a particular vin # is selected, it populates a list box with a history of expenses on that...

Actually, let me see if i have this correct. I can make my date field a Text Data Type, and in the format property for the field I am going to enter YYYYMM? Is that how it is going to work? But if i make it a text field, I am going to have to put in some sort of validation for the month?????

Thank you guys very much for your help. Now that I know this, it seems simple enough. Salisha

Hey all, I have this date field and I need to put an input mask on it in the format of YYYYMM. I do not need the day part of the date. > >My question is, in the design view for the table for the data type can I still use date/time as the datatype even though I am not using the format of short...

hey foolio12, thank you so much for your help!

Hey Nick, You are a Lifesaver!!!!!!!!!!! Thank you so much... It worked like a charm. Thank you, thank you,thank you! salisha

I am creating this Parameter query and I need a little help. I have a couple fields such as lastname, firstname, address etc. In the query design mode, I am setting the criteria where the user will be prompted for a first name and last name and get that particular name. For the lastname field...

I am creating this Parameter query and I need a little help. I have a couple fields such as lastname, firstname, address etc. In the query design mode, I am setting the criteria where the user will be prompted for a first name and last name and get that particular name. For the lastname field...

UNIFEX,,,,,,, thank you so much....you are the best. it worked!!!!! that's exactly what I was looking for. thanks. i appreciate it greatly...

..

actually, can I add some sort of code in there where the msgbox will not pop up for a customer that has never been entered in the database before. so like when I am entering a new person and then i TAB over to the next field, I will get no msgbox. I only get the msgbox why someone is in the...

hey unifex, THANK YOU SO MUCH!!!!!!! IT TOTALLY WORKED. YOU ARE A LIFE SAVER. THANKS! I TOTALLY APPRECIATE IT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

PLEASE HELP!!!!!!!!!!!!!!!!!!!!

I am entering data into a database concerning complaints, and I need to use some sort of "red flag" or "early warning signal", to identify if this person has submitted complaints before.. This is the code, I have so far. It only works by identifying the first record in the...

thank you elisabeth. It worked. Thank You So mUch!

HELP!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

I have two combo boxes. Depending on the Value I chose in Combo1, I need it to populate Combo2. This is how my code looks, but i keep getting a "Data Type Mismatch in Criteria Expression" when I click on combo2. What am i doing wrong???? Private Sub cboIssuance_AfterUpdate() Dim dbs...

I came up with this code. It works fine for MS Access 97 but not for MS access 2000. What am i doing wrong??? Dim frmCal As Form ' calendar form Dim ctlD As Control ' date control on this form Set ctlD = Me!DoB DoCmd.OpenForm...

I need to add a calendar control to a MS ACCESS 2000 Form. I need to be able to click on a button and the calendar will pop up. After I click on the date I wanted from teh calendar, I need to add that date tothe date field. How would I do that?

I am placing a Find command Button on a Form to allow users to Search Any Field in the DAtabase that they would like to. The code I have used behind the button is (Name of Button is cmdFind) Private Sub cmdFind_Click() DoCmd.RunCommand (acCmdFind) End Sub This code works fine in MS ACCess...