Recent content by Newbie2012

Hello, I'm having a problem trying to add my two fields, WTime1 and WTime2 to calculate a total SumTime: The expressions I'm using are: WTime1: Format([Start Depot]-1-[Depart Depot],"Short Time") WTime2: Format([Arrive Job]-1-[Depart Job],"Short Time") Also: It needs to calculate past...

I solved my problem. I went to Sort & filter > Advanced > Clear all Filters :)

Also, - Form (frm Company) > Property Sheet > Data > Filter = [ID] = 32 (generated record no. but still shows empty record)

My form used to work and as I kept adding event scripts now when I click on the ID text field, it doesn't open the linked record, but a blank record with 'Filtered' showing on the bottom navigation. I guess a question I have is, is there an order on which the procedure scripts run do they all...

No sorry it doesn't work because now I can't manually select anything from the combobox as the inserted data is just being placed there and not saved :(

I've used: ================================ =[Forms]![frm Company]![Company] as the control source for the combobox for Form 2 ================================ and also have this VBA code for Form 2: ================================ Private Sub CompanyID_GotFocus() Forms![tbl...

I'm not sure if this is exactly what I should do... ========================== Sub OpenToCallahan() DoCmd.OpenForm "Employees", acNormal, , , acReadOnly, _ , "Callahan" End Sub =============================== I'm not specifically looking for "Callahan" but any value which may be...

How do I go about getting data from a: Text field in Form 1 Clicking a button to run VBA code, and Automatically inserting it into a refreshed combo box in Form 2 I hope this is enough information. I've also attached a pic. Thank you *Also, I'm using Access 2007...

So sorry, I am referencing the wrong fields...duh Problem solved, light is on...:p

Sorry, I meant 8:50AM minus 8:45AM = 15...(am trying to get the result of 5 minutes...) I've used a few example formulas including this last one: OnSiteTimeMins: (60*Format([Depart Job]-[Arrive Job],"h")+(Format([Depart Job]-[Arrive Job],"nn"))) And it keeps returning with 15?? or 00:15? The...

Thank you very much. It is working correctly :)

I've gone to your databasemakers.com website and made payment for your assistance provided at Forum Thread http://www.access-programmers.co.uk/forums/showthread.php?p=1210968&posted=1#post1210968... Paypal ref. details are (Unique Transaction ID #1MR18097G6658772V). Thanks again.

Do you mean this criteria is supposed to go somewhere in a query window or the VBA editor?

Hi Severin, thanks for taking the time to have a look and making changes...however, the 2nd combo box is still not functioning correctly - it will allow 1st combo box (top of the value list) selection, and 2nd combo (value list) choices - it will save :)... ...but when 1st combo box, 2nd choice...

Thanks John...I realise I need to learn more to understand this coding thing. Is the programming language I need to learn VBA or are there any other coding languages involved? For Access (Office etc.) Is VBA the code language used for Access and also mainly seen in these forums? Am only...