Search results

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])

I am pretty sure that will only multiply the hours and not the minutes. Lose a lot of money if I did that. 40 people with 45 mins each. What I have to do is multiply the whole time.

I have a query with 2 fields I wish to multiply together to get a value for a feild, [Hours_Lost]. One is a short time field and one is a number field. The short time field is [Hours] and the number field is [people] I have been trying the following but no luck. Abnyone any ideas? Hours_Lost...

Excellent. I spent ages trolling the net but I was giving up hope as all I could find on this problem led me to believe it could not be overcome when using Dates with VBA. Thanks Bob

I am using the following code to open the form which is obviously having the effect of access looking at american format. Can it be changed? DoCmd.OpenForm stDocName, , , "[Class_Date]=#" & Me!Class_Date & "#

I have a date field in a table that I store dates in UK format, (DD,MM,YYYY). I have aform with a command buttong that is supposed to open another form at a particualr record based on the date field. However if the day part of the date field is over 12 then no record is returned. For example...