Search results

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...

Thanks for your reply...its not a continuous form so will what you say still apply? Will try to explain a bit more: The Main form data is from the main query The text boxes also come from the main query (being calculated in a query field) The 1st combo box control source is from main query +...

No I've got excited too quickly... It has fixed the first combo box but now the second combo box is repeating...:confused: 1st Combo: Private Sub cboCategories_AfterUpdate() Me.cboProducts.RowSource = "SELECT ProductName FROM" & _ " Products WHERE CategoryID = " &...

:):):) Being up all night after 9hrs and for some reason, I got it to work by binding the first combo... I followed instructions from a combo box db sample but they said to insert the combo's unbound...

Here are some pics...if this helps. Thanks for any assistance

My combo boxes are repeating data through every record and I think its because the main form is running off a query so calculation fields can work. I don't know how to make this work and am :banghead: If someone could have a look please