Search results for query: *

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

Hi, Is it possible to add 10 NETWORKDAYS to a date to create a target date in Excel? Thanks, Trystan

Thanks for everyone's help & contribution but eventually I discovered the following command works fine. However the solution was a little bit easier for me because I can assume the presence of 'Outlook' and I don't have to attach a name to the recipient. CommandBars("Send To").Controls("Mail...

Hello there, I can email a worksheet from an excel workbook by choosing Send to - Mail Recipient which then gives you a choice of either sending the entire workbook or just the current sheet as the email body, which is fine, but how can I do this in code? Thank you for any assistance, T

Hi there -I've had a silmilar problem & the way round this was to use a hyperlink instead of a macro. There's no code required if your opening the same file every time and all you need to do is to look at the Properties of the command button & look for the hyperlink property & the rest is easy...

Hi hope someone can help me out here... I have a XL workbook which acts as a master for creating monthly reports. A sheet from a different spreadsheet is imported and manipulated to produce the monthly report. After producing the report I then manually move the report sheet into a new book and...