Search results

I have a command button that basically saves the record that i just finished entering. here's the code: honestly i dont know what it is doing exactly... i copied and pasted from the internet somewhere. what i'd like to do now is add a second function that will make all the controls on the...

Thanks for the help lagbolt!! with a little experimentation with the info you gave me i ended up using this on the command button's onclick event:

I want a command button to "Requery" a combobox. the combobox uses a query to determine the records listed (it lists incomplete records). after completing the record, i'd like to hit a command button that will "requery" the combobox so that the recently completed record is no longer listed. i...

Cool!! works as expected now, thanks so much guys! much appreciated!

sorry to bug you again, but im having a hard time with this (im not so good with VBA yet...) Environ("userprofile") & "\Documents\ can you explain the elements here and how it works? is environ something you used just for an example or is that a legit part of the code?

I see what you mean now!! :o I thought you were asking, not suggesting! My bad. Thanks for the great advice!!

They are text boxes. one is currency format the other is just text. on another note... I LOVE YOU! it worked! now i just have to figure out some other things. here's what i came up with so far (i substituted an 8 for me.hours just to make sure this part of the code works before i tackle how...

im not using a path name. i'm learning all this by google and trial and error. here's what im using now: its basically a copy paste from two different examples i found on the web that i meshed together and modified slightly.

question in title. can you use some code to bypass the save as prompt, and just save the file? i have a command button thats saving 8 reports as RTF. but when i run it, the save as prompt comes up for each report and i have to hit enter for each one. i would rather it just save automatically...

On a subform I have a Rate box and a Rate_Type box. both are already populated. Rate_type can be "day","session", or "hour" I have a Total Charges text box where i would like the... uh... total charges to be displayed. so i know if the type were "day" or "session" i would just mirror the...

Thanks so much Roku!! One more question for anyone out there - can i also use this button to "refresh" the subform? my subform is based on a query which uses some combo boxes found on the main form as criteria. so i'd like to make my button be both a "make visible" and "refresh" button. can...

sorry for the necro bump, but can someone explain what "in the code behind your command button" means? I'm trying to accomplish the same thing as the OP but im getting an error message saying Microsoft Office Access can't find the macro 'me.' i should probably throw this out there - i've...

sorry im not familiar with the terminology... is this what you mean?

No I don't believe so, I used the combo box wizard and pointed it directly to a text field.

I cannot figure this out as i've done it before the exact same way with my other database and it works just fine... I have a form (named frmAddSession) with a combo box (named Band_Name) and lets say i have it displaying the band "Band A" I have a query where the criteria is...

nevermind, i figured it out. it's funny how you can bang your head against a wall for hours trying to figure something out, then take a short walk come back and figure it out within 5 minutes....

I haven't used any lookup fields, I dont even know how to set that up. I used the wizard and it did add a combo box with a list of Band_Names but it's not working as I had hoped. now when i try to add a new record, it says "You cannot add or change a record because a related record is required...

Hey guys, I'm trying to create a Data Entry only form based on a small table called tblProject. It consist of the fields Project_ID, Artist_ID, Project_Name, and Project_Notes. I used the wizard to get me started and i know how to change the form to data entry only, but the problem is the...

brilliant! i've heard of junction tables before but never fully understood them. thanks SO much for the clear, well written, and to-the-point reply! :):):)

did a google on this and found something about "lookup fields" but didnt really understand what the writer was talking about. I have three fields in one table that need to be related to the PK of another table. tblProject - Engineer_ID, Producer_ID, and Project_Maner_ID tblEmployee -...