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

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

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

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

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

Show calculated query field into text control on form? I have a query which has a new calculated field to concatenate different fields from the tables because I want to create a document code. I would like this code field to show on a form from the same main table (which has most of the fields...

I've created a query pulling fields from about 5 tables. My form sources from 1 table which in a lookup about way, links to the 5 tables also. I created the query because I wanted to concatenate various fields as a string from selected tables but use it as a combo box lookup (or find record)...

Cannot enter data in fields on my form... I'm not sure how to explain because I'm a newbie...but any prompting will be appreciated to get some help. I have quite a few fields which are lookups to other tables and then there are a few queries as well I can't change or edit any fields on this...

:banghead:I love Access and its potential, however I'm still a newbie and haven't really got past that stage yet lol. But hello, from New Zealand. I like business, am a tech junkie, a software shopper, multi musician by job & trade (which is my product) but business is my passion. My behavior...