Search results

I'm trialling the 2007 beta of Access, will be changing all my company databases to it from Access 2003 upon release. Problem is the ribbon. I see you can minimise it but you can't disable it or permanently minimise it. I find this crazy - there's options on the ribbon for creating new tables...

I have a main form with a subform. I need to update values in the subform when a field on the main form is updated using afterupdate on that control. Example: main form name: mainform control name: gst (on main form) subform name: subform records displayed as datasheet. records field to...

I have a company database written in Access 2003. Recently every time I try to program something or change something in it I get: The report name "MonthlyStock" you entered in either the property sheet or macro is misspelled or refers to a report that doesn't exist. I had a report named...

I've got 5 time zones showing on the main screen of my db, just by doing date() and subtracting number of hours for each time zone. Only problem is need a refresh button on it for people to click. Can you get a realtime clock ticking away on an access form?

Currently have several access databases (with SQL backend) in use in our company - certain people see all of them, certain people can only see some of them. This is just basically controlled by putting certain ones on their desktops and not others. Looking to get a complete security lockdown on...

Hi I have a few forms where I don't want users to be able to delete the records. How do I disable "Delete Record" that's in the File menu. Thanks

This has obviously been a problem for years (since I first started using Access). When you have an access report and convert it to RTF any graphics / lines / boxes are removed. We email a lot of our Access reports and the only way everyone can open them is if we convert to RTF. Snapshot is great...

I have a report that everyone is allowed to view on screen, but only certain people are allowed to print. How would I go about programming this? Thanks

I have a macro run from an autokey (F12) that uses SendTo to send the current report that's on screen to an email as an attachment. This has been working perfectly for years and all of a sudden when I hit the F12 key I get: The Object Type argument for the action or method is blank or invalid...

I know there's a ctrl or alt key combination that allows you to see all the info in a query field without having to scroll - ie it pops it up in a new box so you can see everything, can someone remind me how to do this? Thanks

I'm trying to attach a report to an email - it can be any report on screen, the user hits F12 key and the report is attached. The following code has been working fine for years and now all of a sudden it returns the error 2487 "The object type argument for the action or method is blank or...

I have a table called received values, eg: Date - No. - weight 21Feb05 - X1 - 1500 21Feb05 - X2 - 200 22Feb - X3 - 500 etc I have a table called despatched values, eg Total Weight 1300 I want a report which shows me Total Received less Total Despatched, but I want this figure to show as...