Recent content by neilmcmor

Can anyone help?

Thanks Pete. How do I declare the other sheet at the start on the module?

Can anyone help with this little bit of code. I have a module that exports data from Access to Excel. The following line is causing me problems. I am trying to divide a value on one sheet on the Excel book with a value on another sheet of the same workbook. oSheet.Cells(intRow, 2).Formula =...

I am looking to sort on the Surname field. However it always defaults to sort on the RegNo field which is a number field. The underlting query only sorts on the Surname field. the user can select to sort either field to sort on when viewing the form howevere the report always sorts on RegNo when...

I am printing a report form a button on a form using:- DoCmd.OpenReport stDocName, acNormal However I cannot get the sort order right. i have tried setting the sort order in the reports properties and also the underlying query but to no avail. How can I force the sort order from the print...

I am printing a report form a button on a form using:- DoCmd.OpenReport stDocName, acNormal However I cannot get the sort order right. i have tried setting the sort order in the reports properties and also the underlying query but to no avail. How can I force the sort order from the print...

Anyone able to help. Can a command button be coded to open either a Word or PDF file at a specific page number? Any help really appreciated.

Some advice would be appreciated. There seems to be a minefiled of papers, some conflicting, on Access security. I have a standalone access database which I need to protect. I do not want users getting access to anything other than whats on the switchboard. I have disabled the shift key bypass...

It appears to work well now. Just sort of righted itself. Thanks anyway

The code to disable shift keys at start up that has been posted here numeroous times is causing me problems. I am a complete novice with vba. but i cannot seem to get it to work and there seems to be a problem with the following line of code:- db.Properties(strPropName) = varPropValue Can...

there is no relationship as tbl1 is a temp table used for importing excel data

I am trying to run the following sql but where there should be 54 records for deleting I keep getting 0 records will be deleted. I used an findunmatch query to establish tat there where 54 records unmatched. Can somen tell me whether the sql below is correct. I am Very new at this DELETE * FROM...

I have 2 dates in a form, (First date & Last date already there when form opens), from which I want to display the difference in years, months & days. I have found several completely different methods for this on the net however I am still not getting it correct. The best I could find was some...

The code attached below is used to run 2 append queries from a form when a button is clicked. I have switched the warnings off and provided the user the chance to cancel the append after the button is clicked. However I would like to inform the user whether the record to be appended has infact...

Had to place another set of brackets round Ken but thanks for your help as it works fine now. Hours_Lost: ((DatePart("n", Hours) / 60) + DatePart("H", Hours))*(me.[People])