Recent content by eburgtech

Wanted to say that I did figure out a way to do this. I created a report with 3 sub-reports. This way, I was able to create 3 separate queries for 3 separate reports but put them all on one visually stunning report. :o) I was also able to create a selection form where the manager could select a...

I am running Outlook. Thanks Bob, but that wasn't very useful. I know how to make it so that the same thing appears on every email (i.e. "This shows up on every email sent." - type of thing). What I am looking for is code that will create a Subject Line string pulling from 3 fields on the...

Greetings, I have a form that has all of our file information. There are various parts to our files and each piece is ordered from a client by our analysts. I want to create an email button that automatically puts the Order Number, Client Name and Client Number in the subject line of the...

Re: I have set a password with "on click", how do I show "*" when entering it Nevermind. Figured it out. I had to call the function. Derrr. lol

Re: I have set a password with "on click", how do I show "*" when entering it I tried using this but my button errors out every time, bringing up the debugger and stopping on the button name in the VBA code and highlights the InputBoxDK in the code. Any ideas?

While I completely concur withe the normalization issues...unfortunately, I inherited this database from my boss. :( I do know that there is no possibility of me being authorized to restructure the core of the database. Is there a work-around for crappy situations like this? Also, the...

Ok, so, we have one major "Files" table where most of the data resides. There are fields on this table to identify which user has processed what piece of each file. Currently, there are separate reports to track who has processed how many of each piece of the files. A manager wants a report...

I like the DLookup option. However, I already have an On-Click Event Procedure for the button which launches the form. Is it possible to have a lookup and a DoCmd.OpenForm on the same click?

@vbaInet - No, there's no security on the database at all. And really, I don't want to have to place security on the whole database if at all possible. Just either the form or the report or the query. Any of those pieces would be sufficient. @Simon - lol I totally agree since the reason...

I have a Form that runs a query prior to launching a report that tracks statistics of employee performance in the database. The manager wants only this Form/Report to have security so that it requires a password. I only know of Database-wide security. Is there a way to slap some VB code or...

Thanks everyone. Interestingly the problem we've had isn't the content the users are going to, it's the duration of their time spent on the web. Basically, taking half hour to hour breaks instead of 10-15 minute breaks. (Personally, that's a management issue but not up to me:confused:) So...

Greetings All: Well, I'm not a member of any other online forums so I thought I'd ask here since you've all been so helpful. I'm a site administrator for a business and they've had me setup a pc with wireless for people to connect to the internet on their breaks. As expected, the privilege...

Not sure if this is the area to ask the question, but what is the best or recommended Certification to pursue for MS Access so that I can add credibility to my work and improve my skills? Thanks!

Thanks Bob. I'm working on normalizing my database. I've saved a copy of what I have so I don't have to reinvent the wheel. I'm making a new database with new tables and once I get it functioning the way I want it, I'm going to import the data from from my saved original. Thanks again. :o)

Bob, that's confusing. Don't make a single table and don't make multiple tables...then what would I make?