Search results

Hey DC, Thanks for the idea. I considered having a some sort of a running timer, but my confusion results from my need (as directed by the boss) to only count full business days. So I would somehow need Access to record the very first starting date. Then it would need to calculate how many...

My "solution" thus far has been to open the database, fire both the hide and unhide code, and then close the db. After 5 or 6 times of this exact same action it usually works. :) Hmmm...I suppose admissions like that indicate that I will never be allowed to be a proper db developer. Or even...

Haha. Not that I want your computer to break, but I'm glad that the problem is at least replicating itself for you so people don't think I'm crazy! Thanks again for taking a look at this. I'll see if I can come up with some code that only messes with the menus that would have been open...

Hi All, I have a database that tracks work flow. The flow is as follows: 1) employee receives work request 2) employee performs some tasks related to that request 3) employee needs additional information, and pauses work while wait for that info 4) employee receives additional information and...

Good catch. I copied the loop that hides the menus and told it to unhide them and put it to run as the user is exiting the database. Actually, I don't fully understand what that does. I assumed it was just the bit that brought the database window up. It was some code that I copied in an...

Hey Sam. Thanks for taking another look at this. My opening code to hide the menus runs in the Open event for my switchboard. The closing code runs behind the button users must click to save and exit the database. I'm not really familiar with hiding and unhiding menus, so its entirely...

****bump****

There aren't any loops running. Also, as I mentioned, the problem occurs in different databases containing all sorts of different tables, forms, and code. It also only occurs on my computer. These same databases work just fine on for my co-workers, so this leads me to conclude that it might...

Sorry to bring this back up, but the problem is happening again. I've tried importing everything into a new database, but that didn't resolve the problem. Also I tried opening my database on a different computer, and there was no problem, so it appears that the issue is my computer and not the...

This is all excellent, everyone. Thank you so much for your responses! I think I'll be able to get a working model up and running from this. Rep points for all. -CF

This forum is so incredibly helpful! Here is my newest question: Is it possible to check if a given user is opening the db for the first time? What I would like to do is have a message box distributed with my updates that details what the changes are. So the first time each unique users...

Thanks for the responses, guys. Dennisk - I have not tried importing my database to a new one, but I did try creating a new database and had the same results. This problem also occurs when opening other databases on different servers. Mstef - There are no scroll bars to move. Simply a blank...

Hi, I was testing out some code I found on this website and other MVP locations to hide all the menus and disable the Access close button. It would then make sure to reverse before closing the database. I also created a button to bring everything back. This worked like a charm for about an...

Worked like a charm! Thanks!

Hi, I created a continuous form that shows a a series of records in my database so the users can quickly scroll through and select the one they want. Each record is either keeping track of a business or an individual person. These names are stored in a table in three fields - the individual...

Hi Rich, thanks for the reply. I'm intending to use the grouping feature of reports, but I can't figure out how to get it to roll up correctly. As it stands now, I have grouped by the Group that I have, but its producing seperate lines for every entry. So I get Group Name Risk Code 1-9...

This isn't specifically a help to you, Charlie, but just thought I'd add that the problem is not unique to Access or something you've done in your report. Printing to PDF from Word or Excel also fails to yield usable hyperlinks. Perhaps there is some VBA work-around, but at least you should...

Hello, Having a conceptualization problem here. In my database, every entry has a risk code from 1 to 100. For reporting purposes, management would like those grouped into ten catagories. As it stands now, I have three tables - one that holds the entire entry's information including the...

Thanks for the tip, Pat.

Problem solved: I was setting db=nothing inside my if statement and then trying to use it later on. My bad.