Search results

check I've got the table and field names right...

could you not just set the report's record source to be the same as the form's record source??

Try this, and let me know if it works? Hoping I've picked up your field names etc properly... Private Sub PO_No_BeforeUpdate(Cancel As Integer) Dim CheckPO As Variant CheckPO = DLookup("[Purchase Order Number]", "Orders", "[Purchase Order Number] = '" & Me.PO_No & "'") If Not...

it's always the obvious thing that is the most difficult to spot... glad to be of service!

Just to check : what is the field type? It IS Date/Time, isn't it? If it is, then this should work: If Me.DOM.Value > Date Then MsgBox "Please enter a Valid DOM", vbInformation, "Check again !!" Cancel = True End If

I also remember 4-digit phone numbers :) My mum and dad's was 3210.... our local GP was 3120.... it was a cool number to have but we changed it after getting a large number of misdials at all times of day and night, and a large number of calls from toddlers!!

erm.... what is the match? I think your sample data needs looking at! - Your ProductLocalName in table one is ProductLocalName1, ProductLocalName2 - Your Product in Table2 is Supa1, Supa2, Supa3... etc and in Table 2, you've got more than one Supa2 against Europe as the market - how is it...

In the control on the report, try using =Division & " " & "Division" or =Division & " Division" but make sure the controlname on the report isn't Division or it won't work! Just rename the control to something else, eg txtDivision

The fields must be of the same type - both numbers, or both text - or you can't link them. What most people would do is add an ID field to the therapist table and then link the TherapistID (PK) from the therapist table to another TherapistID (FK) field in the appointments table - in other...

:) but I'm not a man, lol..... well, not the last time I looked, anyway!!

I found this... Remove illegal characters from filename (#filenames) Remove illegal characters from filename (#filenames) Function ReplaceIllegalChars(Filename As String) As String 'leo.heuser@get2net.dk, 5. August 2001, programming Dim Illegal As Variant Dim Counter As Long Illegal =...

marvellous, thank you :)

Simple one, really.... I know the Round function exists in MSAccess, but what I need is one that will always round up, and never round down! Easy enough in Excel, but I can't find one in Access?

ok, will have a root around and see what I can find.... ty

the sort should be specified within the query / select statement of the subform's Record Source.... well, that's how it works on mine, anyway! Make sure you hove removed any other sorts on the subform

!! WARNING - LONG POST!! I'm having a few issues with a database I've set up.... Each week I receive downloaded data in Excel - this is supplied to us in a pre-defined format from our client(s) (the data is actually timesheet information for Contractors) When we receive the data, it...

Setting record selectors to no should get rid of the grey panel Set Allow Additions back to Yes is you want to be able to add records using the form

quick question: what is the Add Record button supposed to do? - add a new record or - update an existing record or - save the record you've just entered as a new record And likewise, what should happen when you click refresh?

Even Simpler then SELECT Count(mytable.somefieldorother) AS NewRecords, Min(mytable.timestamp) AS Start, Now() AS [End], ([End]-[Start])*24 AS Hours, Count([somefieldorother])/[Hours] AS [Per Hour] FROM mytable; OR SELECT Count(mytable.somefieldorother) AS NewRecords...

ok, so to clarify: are you looking at ALL the records in the table 'ever', or just the ones between a certain start and end time?