Recent content by trystanhuwwilliams1

Good Afternoon, Two columns in my flexi time worksheet represent the time that I began and finished my lunch. By deducting the cell in the second column from the cell in the first, I get the duration of my lunch break for that day. How can I (in code) calculate the average lunch time...

Ahh, I see. Thank you.

Sorry, how do I define 'myXL'?

Hi, Don't know if this is possible, but here goes.. I want to open password protected Excel Workbooks from an Access Form via the code below. strPath = "Dir\Path" & "\" & rs("file").Value Application.FollowHyperlink strPath, , True, False This works except that it won't allow a password to...

Aha, As long as you don't use an operator identifier, such as ! or . then Access will accept a variable as a substitute for the field name.

Thanks for you help Hap, but Access doesn't like the parenthesis around the variable name. I've also tried removing them without success. I may have to try a different approach. Trystan

Hi, This should be fairly easy to answer. This is my code: rs.MoveLast tot = rs.RecordCount For x = 1 To tot With rs .Edit !Credit_Date = Null .Update rs.MoveNext End With Next x Is it possible to replace the field Credit_Date with a variable? Thanks, Trystan

Hello there, I have a problem with a date field in a linked table. The table is linked to an Excel spreadsheet and one of the fields has a date format which sometimes contains null values. For example when a case has been completed I would put the completion date in this field, and it would...

Hi there, not sure if this can be done - but I've inherited a database (very old Dataflex) which is unfortunately still live. I've managed to set up a facility which exports the records to EXCEL. Once in EXCEL I need to perform some data conversion before I eventually export it to Access. To...

Thanks for your help Duane, but I need to COUNT the number of records where the value is greater than one, not SUM the values. Cheers, Tryst

Hi There, Can anyone tell me the formula to place in a control which will Count all the records in a report where the field value is greater than 0. Thank you, Tryst

Please can someone help me with this problem, didn't get much sleep last night and I can't seem to work it out. I've got a main table with 2 fields = POST + NAME I've got 3 other tables which hold details of qualifications, training & professional memberships. The tables are linked via the...

Thank you Ken, I think the first option will suit my needs best. Thanks for your help

Hi, I hope someone can help me here?? I've got a basic form which holds info on individuals - Name, Job Title. Then I have 3 command buttons and a frame for a subform. I want each command button to open a subform containing different types of information relating to the individual. Each group...

Good Morning, I have a button on a worksheet which sends the worksheet to a Mail Recipient as below: CommandBars("Send To").Controls("Mail Recipient").Execute There are 50 users who have this facility (to email their timesheet) and for most people this works fine. However it doesn't work for...