Search results

Ok here is the code the wizard does. Private Sub Command60_Click() On Error GoTo Err_Command60_Click DoCmd.PrintOut Exit_Command60_Click: Exit Sub Err_Command60_Click: MsgBox err.Description Resume Exit_Command60_Click End Sub I'm not sure how to apply your...

Hi there, I have a search form that returns all the records that match all criteria in a subform, which is set up so that the nav buttons take you from one record to the next. Sometimes more than one record matches the criteria, and I would like a command button to print just a single...

The types of summaries I need to do are things like 1. Totals of each type of incident for each location for each month. 2. Percentage of severe incidents against the whole 3. Percentage change from one mkonth to the next things like that They are mostly ad hoc but I'd like to build ones...

Oops, sorry I didn't reply to the thread, I kinda forgot, sorry. It was just that the "[Event Procedure]" in the cmd button properties was missing. Not sure where it went though :P -Z

How can I donate to this site?

Hi there, I have a large database that catalogues incidents, keeping track of data such as: -where the incident happened -who it happened to (visitor, employee, volunteer etc.) -what type of incident it was (2 fields, general and specific: ex: fall -> tripped) -when it happened...

Hi guys, I have a command button that no longer seems to work and I'm wondering what is going on. The button is in a subform linked to a search form, and it's purpose is to undo any changes that the user has made in the subform. Nothing happens when it is clicked, it used to work and...

Just an FYI that I have had this issue resolved (at least for now). The network admin created me a new profile and it seems to work now. He says that the cause of the problem had something to do with the code in a macro, he said that he had seen this problem before and in that case was able to...

Bump. I'm really stuck here. Are there any user settings or general access settings that I can play around with and see if that helps? -Z

Just a note: I seem to be able to open VBA editor in Excel just fine. -Z

Ok, IS dept. has finally gotten around to looking at this error, have installed the hotfix, given me a new machine, re-imaged my username and I STILL get the error in my database, as well as any access database when I try and open the vba editor. They can't seem to fix the issue for...

That is exactly the case, I had a hard time getting that into words!

Im not sure what you mean by apps. I have access to where all the files are stored etc. Same level of access that my colleague has that doesnt receive any of the crash errors at least. -Z

Yes, when I log into my colleague's workstation, I get same error.

Here's a bit of new info. When my colleague logs in to my workstation with his account, he has no trouble opening the code editor. Seems like the problem may be tied up in my user account? -Z

Thanks, I'll have my IS dept. check if that has already been added or install it now. Anything I can try in the meantime? -Z

I have tested a couple of sample DBs from the internet and I get the same error in all files. I am using access 2003 service pack 3. -Z

Recently I have been bothered by the error: "microsoft access has encountered a problem and needs to close. we are sorry for the inconvenience." This happens each time that I try and open the VBA window. Restarting doesn't seem to do anything and this problem occurs on all workstations. I...

Hmmm, my forms are both unbound, so I dont think the update event even fires until I hit a button. -Z

I have asked this question in other ways and havent yet gotten an answer. I have a search form that allows users to search for and edit records in the database. The main form has 3 command buttons 1. Search - Searches based on what user specifies 2. Clear - Clears search fields 3. Quit -...