Search results

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?

Honestly, I thought I had it pretty normalized. But I am self-taught and maybe I didn't understand the documentation I read on normalization. I'm using Access 2003 SP3. I've attached a copy of the db. Currently everything resides on the Assets table. I put the brokedown tables I want to...

I have an asset tracking database that I've made and it works wonderfully now. Currently I have one form that has all fields for a workstation (pc, monitors, printers, etc.) and it's all tied to a user on the Users table. This is fine but as I got to thinking about it, it would be a better...

lol I found this whole thread hilarious. I have to say, even though I am new here, I agree with c_smithwick. I pride myself on being articulate and the few questions I have posted, I made a deliberate effort to clearly enunciate my questions. Also, I had already spent more-than-likely hours...

Well, I've actually been a member here for about a week now and saw this thread so thought I should post something. I'm a Jack of All Trades and done everything from Technical Writing to a little Web Dev. Currently I'm a Support Engineer for a Title Company. I've been working with Access...

Awesome. That worked beautifully and now my database is more normalized. Thanks! I love it when stuff works. :D