Recent content by dgirl1010

I have a module of code that runs several make-table queries consecutively. They are querying from a very large database (several million records) that is linked to the Access db, and is located in another state. So I need to insert a pause between each query to allow the table to finish...

Hmm, that gave me a type mis-macth error. But I did figure something else out that works, I just did a left join to include all the records from the table where I keep a list of the phase names. :P Love it when it's something simple like that! Thanks!

I'm working on a report that will show me the number of projects I have by phase. There are some phases that no projects are in, and I need to be able to display a zero count on the report for them. I've tried using Sum(IIf([ProjectStage],1,0)), but I still don't get any zero counts. Help!

My code for this is a little more simple than yours, but it might do the trick for you. I just set the field to the Environ("username"). Example: Forms!FormName!txtChangedBy = Environ("UserName")

Thanks Skip, I did a debug/compile and it didn't catch it. :?

[blush] Hmmm, weeeelll, that does work better...

I have a form to detect idle time and close a db after a certain amount of time has been reached. It is launched at startup and hidden from the user. In order to close the form the user must enter a password. If the user hits cancel on the password prompt, I want to close the password prompt...

Thanks that worked. :) I did have to change the format in the table from hyperlink to text though.

I have a really dumb question, please forgive me if I'm in the wrong forum. I have a table where I store a list of contacts, including their email addresses. I'd like to be able to just click on the address and have a new email open with that address in the TO line. Is this something I can...

That worked! Thanks!

Hi there, I'm having issues using the Count function in a report. I have two totals in the report footer, one for the total number of records, and one for the total number of a certain type of record (special requests) and also a percentage of the total number of records based on the two...

Ah! That makes sence! Thanks so much!

Please bear with me, I'm still learning VBA. :) I have a form that allows a user to select how they want to view a report (Open items, closed items, on-hold items etc). In the "Open" category there are several statuses that need to be included on the "Open Items" report. I'm using a select...

I got it! I knew it was something simple, and it was. I had to change the name of the form to ConfigDetailsSub_frm. I still had it as the default name (DOH!). Changed that and this works like a charm. Thanks for the help! :)

Just tried this too, with no luck: If (Eval("[Forms]![Config_frm]![ConfigDetailsSub_frm].Form!txtEffectiveDate Is Not Null")) Then