Search results

Hey Everyone, I am stuck trying to figure out this problem. I have a main form "frm_tirelog_600" which has 4 combo boxes "cboleg", "cbocar", "cbopos", "cboserial" on it. The first 3 combo boxes are used as criteria on 1 of 3 subforms that I have. The fourth combo box "cboserial" is used for...

Hey Everyone, I need help with a form that will pop-up based on a value that is in a field on my sub form. Basiclly what I have is 3 fields that I am working with. The first is the "mile" field which has the milage at the start, my second field is the "dismount_mile" which will have the...

Here is a visual, if it helps

Hey le888 thanks they I did not think I was explaining it right. Right now in my tbl_master I have a field called part_num with is the manufactures part number. I also put 3 fields in that table Grainger, Home Depot, McMaster which hold the vendors part number for that manufactures part number...

if you create the standard button and go into the properties of the button the third item on the all properties tab should be "picture" click on there and you will get a pop up that will allow you to selct an image or clcik on browes and you can navigate to your own bmp file and select it. Thats...

Re: Problem With Code For Login You are correct I had never tried it with a gif image. The code will not work with an image file type. About the only was I can see that we be quick and simple would be to convert your gif to a bmp and add the image to the button. It will fill the entire button...

The easiest way would be to have 3 fields in your query field 1 would be income, field 2 would be expenditure and the third field would be an expression Example: of the 3rd field would be: disposable:([income]-[expenditure]) which will give you a calcutated total. Hope that helps

Problem with Code For Login Here is a sample database with the code that I use to make my work.

Re: Standard Navigation Buttons Yes, all of the standard nav buttons all have vb code in the background. If you look at the properties of the nav button you will see a on click has a Event Procedure with it. Click on the 3 dots and you will see the VB code associated with it.

Hi All, I hope someone can help with this, I have 2 tables, 1 main table that holds all my part data ( ie part num, description, etc) and a second table with vendor info. On my Form I have all my fields that display the record. I placed a combo box on my form that I need the user to be able to...

Hi All. I have a query that is based on 1 table. I am using a form with a calendar control for the users to select the date range. In my table the date format is mm/dd/yyyy. My calendar control is pulling the date format mm/dd/yyyy I need my query to only look at the mm/dd part of the field. In...

Hi All. I have a query that is based on 1 table. I am using a form with a calendar control for the users to select the date range. In my table the date format is mm/dd/yyyy. My calendar control is pulling the date format mm/dd/yyyy I need my query to only look at the mm/dd part of the field...

Thanks Thanks Rural Guy.... I went back and checked my relationships and they appeared coorect but so when ahead and deleted my sub for and relationships and added them back and they appear to be working correctly now.:D

Hi All.... I have a database with 3 tables ( employee, topic & training ) and 2 forms. On my Main form ( training ) I have 2 combo boxes for the user to select the employee name which is based on the employee table. I have a sub form ( training sub ) based on the training table, which is a...

Hi All.... I have a database with 3 tables ( employee, topic & training ) and 2 forms. On my Main form ( training ) I have 2 combo boxes for the user to select the employee name which is based on the employee table. I have a sub form ( training sub ) based on the training table, which is a...

I have a form that has several fields on it and I have a group option box ( frame121 ) which I have to have them select one of the options before they can move to the next record. I tried to do a afterUpdate on the Option box but nothing is working. Any idea on how to do this, I am very new to...

Thanks Guys those oth worked great... ;)

I have a form with a text field and a command button. My code works for the password part but it is not checking for the 3 times and exit. If I take out the Else Msg box in the top section the 3 times works. But I dont get a message that I did a wrong password. If I leave the top msg in it never...

I beleive it is set at static, If I take the Else: MsgBox ("Please Renter Correct Password"), vbOKOnly, "Error!", 0, 0 out of the top then the lower part works and after 3 attempts it gives the message and exits. If I leave the top part in all it does it give the Msg box and never looks at the 3...

I have a form with a text field and a command button. My code works for the password part but it is not checking for the 3 times and exit code. I'm not real up oon coding and not sure what Im missing Any help would be appreciated: Private Sub cmdLogin_Click() If txtPassword = "Test" Then...