Search results for query: *

In my spreadsheet, Row 1 has my headings for my columns, and I want Row 1 to automatically print out as my header on all sheets of my printout. How do I do that? thanks

I know a sting is different than a number...perhaps I stated it wrong, a 16 digit number in this case could be like a credit card number, in which case you do not need it for calculations, in that case changing it to text will eliminate the last number changing to a 0. If you wanted to then use...

Just change the cell's format to text, and if you need to use the number in a calculation, just take that cell and multiply it by 1. This will eliminate the last digit turning into a 0.

It is looking for the user to input data into a required field. Check the table to see what fields are required.

sillysod, true...but if the user hits "Tab" or clicks out of the textbox, then the On Exit event occurs...I want to call the event on the Enter key only

once again, Thanks RoyVidar now, do I put that in the textboxes After Update event?

I have a textbox, and I want it so that after the user hits the "Enter" key it calls an event. Any VB code for something like that. Thanks

I have a command button that I want to print out a PowerPoint Presentation on the On Click event. Any suggestions? Thanks

Is there any way to change the wording of the "Enter Parameter Value" message box? Meaning, instead of the message box saying, "[Forms]![frm_Main]![date]", I want it to say, "Please enter today's date". I know I can get around the message box, but I want it to pop up in this case. Thank you.

Once again RoyVidar, thank you I'll give it a shot

I have a command button on a form that time stamps the date in a field Private Sub Command297_Click() Me.Last_Updated_Date.Value = Date End Sub It works fine on my computer, but on someone elses it brings up an error as if it doesnt recognize the formula. Is there any other way to use the...

RoyVidar, excellent...actually your first thought was slightly off The formula for the query criteria needed to be... Between [Forms]![frm_2]![SUBFORMNAME]![TextDate1] And [Forms]![frm_2]![SUBFORMNAME]![TextDate2]

Roy-Vidar Thanks for the advice, but it didn't work It still asked for the parameter values

I have a query with a date criteria... Between [Forms]![frm_1]![TextDate1]! And [Forms]![frm_1]![TextDate2]! The user enters the dates in frm_1 and hits a command to run a report based off of the query above, and it works fine. However, if I make frm_1 a subform in frm_2, and hit the command...

randy700, I see what your saying, but what do I substitue "SomeField" with?

I have 5 comboboxes all with the same query as the rowsource. The user fills in all the comboboxes, but I want to prevent them from choosing the same list option in multiple comboboxes. I tried setting criteria in the query to something like this... <>[Forms]![frm_FORMNAME]![Combo1] then...

that worked guys Thanks you!

Is there a visual basic way to say... If Project Manager = "John Doe", Then Disable all Textboxes I have about 30 textboxes, so I want to avoid... If Me.Project_Manager.Value = "John Doe" Then Me.Textbox1.Enabled = False Me.Textbox2.Enabled = False 'etc... Any help or...

I understand subforms don't 'pop up', they just unhide, sorry for the confusion But the requery worked, thank you

I have a combobox in my main with project names to select from. (List is derived from a query of project names) After a project is selected from the combobox, I'll have a subform that'll pop up displaying that record. I have the query built so that... Project Name =...