Search results

Sorry to hear you got "flashed" The guys at work swear by TomTom. Apparently there is a free add-on for camera locations. You can even get a version that loads onto a PDA. BTW, the dash scanner only works for radar/laser guns - not cameras. If they scan you directly, you don't have much chance...

Hi Katie You are on the right track! Put the =Now() as the default value in the field property. That will only update the field with the current date and time when a new record is opened. It might be worth setting the Enabled or Visible property to False to stop the users changing it as...

Macro solution Hi Matt This macro will add spaces to either end of the cell contents to balance the number of characters either side of the "-" mark - effectively centering the "-" sign in every cell selected before the macro is run. However, you will have to us a non-proportional (TruType)...

RACData I think this is what you were after... =Right(Date(),2) & Right(NZ(DMax("[EventNo]","[tbl_EmgCalls]","Left([EventNo],2)='" & Right(Date(),2) & "'"),"9900000")+1,5) -What this does is takes the last two digits of the current year (Right(Date(),2) ) and appends the last 5 digits of the...

This SQL might be your solution Hi Bess I have had a look at what I think you want to do and have come up with the following SQL statement... SELECT [tbl STUDENT DATA - ACTIVE].SchoolDistrict, [tbl STUDENT DATA - ACTIVE].Grade, [tbl STUDENT DATA - ACTIVE].First, [tbl STUDENT DATA -...

Hi Durien The closest that I have come to this is by using conditional formatting. The drawback being that you can only apply the formatting to an individual field. So, if you wanted to highlight the whole record, you would have to set the conditional formatting for every field - not an...

Hi Rob As you are looking up a string value, the variable needs to be enclosed within single quotes. Try changing the Dlookup statement to : qryAmount = DLookup("Amount", "querypayment", "[Number]='" & Me.txtchqstring.Value & "'") If this works, then you will need to change the others as well...

Read Only (Slightly Off topic) Kassy I get the "read only" status on every sample DB that is posted as a Zip file and is opened without extracting it to my hard drive first. This is down to how Zip works - it creates a temp file, which Access cannot use as the names are all "wrong". To get...

Hi Kyriakos In my opinion, you will need to have an extra text field to hold the currency type. This is because once you leave the record, there will be no way of knowing what was set when you come to edit it later, or use in a report. You can use this text field to format the value field as...

Hi Rob You could use: ctrlComboBox.RowSource = "" Although earlier versions of Access VBA did not support this function. I use Access 2002 and this works fine for me. HTH Rgds Rod

I think your problem lies elsewhere Hi Kev Is the data Linked to the Excel spreadsheet? - If so, only 255 chars will be "transferred" across. If your tables are populated via an export/import... if the data in the first 25 rows have less than 255 chars, then the field will be treated as text...

Thinking this through - If you do not save the option group result to a table, the info will be captured, but you will not be able to access the data using the form unless the user knows what option to select to display it again. If you are happy to store this in the table, you should copy the...

Very possible! Hi VanGough What you propose is quite possible, but without knowing the layout of your forms and the number of fields that are in each of the scenario's, it is difficult to advise which is the best method to implement. Either way, this can best be achieved using code - How are...

Of course they will change! This has nothing to do with formatting! The calculation in row 24 (kg DM/ha/day Supply) adds up the values in rows 27, 28, 29 and 30.=Sum(B27..B30) Row 25 is dependant on row 24 =B24*B13 and row 26 is dependant on row 25 =B23-B25 ...by adding or changing a value...

NULL is an odd one... Hi Tim Have a look at this link http://allenbrowne.com/casu-12.html which will tell you all about using NULL. Essentially NULL does not mean empty, it means Unknown. You need to look at functions like NZ (which gives Nulls a value) and IsEmpty or simply = "" to test for...

Hi Dante I suspect that your field will always be blue... You need to change your code to the following to get it to work. Private Sub prova_AfterUpdate() If prova > StartDate AND prova < EndDate Then prova.BackColor = vbBlue Else prova.BackColor = vbWhite End If End Sub If the...

Here is a link... An almost identical request was posted recently from a member in China... http://www.access-programmers.co.uk/forums/showthread.php?t=104972 You should find a lot in here that will help. Regards Rod

I'm pleased you got it working and that you are happy with the result. Glad to have been able to help. Regards Rod

Nearly there... Hi Surfette Attached is a word doc that shows all the changes you need to make. I haven't had time to make the document "pretty", just tells you what you need to do - If you make the suggested changes, the VB errors and field #Error's will be resolved ... Regards Rod

Hi Spock I would suggest that you change your formula from... to int2=dcount("[payroll number]","staff","[payroll number]=" & forms!control![payroll]) I assume control! is your form name - if not, change it to be the form name. Remember that if the form name has spaces in it, it will have to...