Search results

Use Format() function, either while importing data or update your field after import: Format([MyField],"00000000")

Use "Query Wizard" from ribbon, then "Find Unmatched Query Wizard" and follow it, result of this is what you'll want to append.

Arnel wins. Referencing to the control name works, result is 0.126 now. But why?

Changing names didn't change the result at all, also changing form sizes didn't matter. My result is still 9.70872. I'm curious why is it different than OP's though.

This is strange indeed, I made a query and a form based on table, entered your values and expression and... In query it works perfectly but on form I got result 9.70872.

Hmm... Your fields are: Height Weight Length Quantity But in calculation its: Height Width Length Quantity Weight....Width...

Why not show them continuous form, or split form even, where you could easily use any calculations you want? What is the reason to give users access to raw data in table? I'm not an Access pro by any measure but it's wrong IMHO. It's reasonable, but not using calculated fields in table. You...

Why would customer/user ever want to see a table? Also, data in calculated field is not updated "live", so using functions like Now() or Date() wouldn't make sense; results would usually be wrong.

In design mode, select Q_1 textbox control and look at "Preferences" window (if not visible - right click on this textbox and select preferences) and select "Event" tab. Find "After Update" and click on three dots, and if asked select "Event procedure", then paste this code there in VBA editor...

That bit is for form controls. "Me" is reference to current form. Me.Q_1 means control named Q_1 on current form. But to make it work you need to hook this code to some event (like button click, or After Update of those text boxes. All depends when and how would you like it to work.

Incredibly easy too: Me.Q_4=Me.Q_1 & "-" & Me.Q_2 & "-" & Me.Q_3

Select all fields, right click, Layout->Remove Layout

Or, if you want to keep table as record source, set Order By property of form to your alphanumeric field and set Order By On Load to Yes.

This link in my first post. Most thorough and detailed resource about ribbons I think.

Ah yes, File tab stays no matter what, but it contains only Privacy options and Exit button.

Sorry, but that's misleading. It's absolutely possible to hide Home tab if you create a custom ribbon. Like:

Best site imho about ribbons is here. My guess is there's a custom ribbon created that's set up to show only Home tab. You may need to modify it to hide that tab as well.

driving under influence

I agree with Minty, function will work better in this case. Put this in standard module: Public Function GivePoints(sJobType As String, nHours As Integer) As Long Dim vPoints As Long Select Case sJobType Case "job_a" Select Case nHours Case 1 To 3...

Ah yes, that too, but I thought it was obvious.