Search results

I have a form and it works fine...so far, but i have a variable that i would like to write into a table in the database. since i have no idea how to do this i was hoping someone could help me out!! ex: strName=me.txtName.text my table contains an autonumber ID and name field. How do i write...

Again Kevin, your a life saver, thanks so much!

that is sort of the problem i am having. I guess i should explain myself much better. the combo box is loading from a query and then filling in the rest of the form based on the information in the combo box. the information in the combo box is to appear in alphabetical order (last names) and...

thank you...worked fine!!

i would like the record to be deleted. i have integrated the UNDO code with the exit button code (it works!), but now i get an error if i go into the form and then exit without any entries being made. another thing...i guess i would like to know how to do the code by using unbound textboxes...

another question.... in my form i have set up tab stops at all textboxes and then they go to the 'update' button, then the 'exit' button, if i tab past the exit button, the record gets added. is there anyway to stop this from occuring, kind of a pain to test when the form keeps clearing.

Any idea on how to show the first item in a combobox without clicking. Right now the combobox loads into the form with the textarea blank, I would like that to show the first value instead.

Thanks, I guess the biggest obstacle for me is that I don't really feel that comfortable with VBA, even though I feel very comfortable with VB and VBScript. It just seems the wizards like to create code that I get, but wouldnt write that way..I guess!! Any way, if anyone knows a good place or...

I currently have a form that is supposed to write new records into a single table. I have some validation set up so that if you click the 'ADD' button, you get a msgbox that notifies you if any information is missing. but if the user enters a few pieces of information into the form and then...

THANK YOU!!!!!!!!!!!!!!!!!

I still cannot get it working, someone please HELP!! :D

I have tried that and now I get a bunch of #Error all over the report where the first name is. I also tried various combinations of that as well.

I am currently creating a report that shows the last name and first name of fishermen. In the table the fields are LastName and FirstName. On the report I would like to show the name kind of like this: Otis, Thehumble. Right now they just show up with the last name, a big space, and then...

Thank you!!

I have looked almost everywhere on input masks for this one, but my access book doesnt tell me much on the subject. I have a textbox that names get entered into. I would like the first letter to be uppercase, regardless of the user entering it uppercase or not. Is there anyway this can be...

Thank you Kevin, again you have rescued me :)

I am creating some reports that are based on an inner join with two tables. I have "Hide Duplicates" set to "yes" for those items that I don't want showing. When my reports print, there is a blank space on the row that is hidden. Any idea on how i can get rid of that extra space. Other than...

Thanks Kevin that helped, I also had to take the PK out of the Year table, didnt matter much since I only used the table for this one form..and hopefully others !!!

A good idea! but still will not work. The combo boxes are used as a filter to create the reports. For example a user chooses the waterbody, this combo box is filled with a waterbody table. Then a fisherman table is accessed to get the information about that waterbody. I would also like to...

I have a form that has 2 combo boxes on it, one is named Waters and the other is named Year. I have also created a report from a query that shows fishermen, their licences and their company names. The query is a select query that asks for the Waters and the Year. My question is...how do I get...