Hello, I have a form (Invoices) with a subform (InvDetails) where the subform displays in datasheet view. Each line in the subform begins with an activity...

I'm a newby in need of assistance. I'm creating a form based on a query which includes two table-based combo boxes: one from an ID#, with a city name field ...

I have a form with several combo boxes and text boxes. I would like "NA" to be automatically entered for null values when the user tabs to the next box. My...

I want to display the number of records in a query where I set the field =. in the ControlSource property. It works fine except that when there are no...

My Num lock is disabled after an On Click Event macro runs. I converted the macro to vb to show the code: Function CancelProject() On Error GoTo...

I would like to generate a number automatically, but not use the autonumber function. I want to keep it in the format I need for the database. Basically,...

I am using the Lookup Wizard within table design view and it works great, however, when I finish it says it must save the relationship (fine), but it changes...

Currently I am using a subform to populate a table. When people come into the form, they need to go to the bottom of the data table (sub form) and enter...

I need an Employee Number text box in the format “0000�. The catch is, users are supposed to enter “0345�, but some will forget to enter the zero...

I need an Invoice Number text box in the format “0000-yy�. The catch is, users are supposed to enter “0345-yy�, but some will forget to enter the zero...

Hi, I want one of those number box thingeys - the ones that will have a default value of 0 with like 2 arrows (up and down) on the right and the user...

Does anybody know a formula to convert a numerical number (25) into its text number (twenty-five)?

I have unbound text boxes on a form for entry of time in HH:MM:SS format. Someone is the newsgroup helped me with the code to convert/save the time as HH only...

I am trying to print a form, but in print preview the total column is showing a number error. I have expanded the column and it is still showing number...

I have a form populated with number fields used to enter time spent meeting with a client. There are 31 fields representing the number of days in a given...

I am trying to get a number field to react as an autonumber. Through code. I have seen examoles of this but can't remember where?

On my forms if a field type is number, the field shows with a zero (before anything is typed in). Is there a way to prevent the zero from showing up? Thanks...

I have a field in my table named which should contain a 5 digit number. Some of these numbers begin with a zero, so to prevent the preceding zero from...

Hi Im trying to set the number formats in a listbox to "Standard" with no decimal places. Currently i can get it to display by: 5,000,000.00 by using: ...

Hi, how can I have a field to display the number such as 1234567 as 1-234567. It should show with this format as you type, meaning that as soon you type 1 it...