Search results for query: *

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

I caught that too (typo, sorry). I actually have it as that already and no luck. :( This is the line that is highlighted when I debug: If (Eval("[Forms]![Config_frm]![ConfigDetailsSub_frm].txtEffectiveDate Is Not Null")) Then I've also tried pulling out the [Config_frm] portion and just...

I posted this late Friday, hoping someone can help me today. Thanks!

I have a calendar button that the user can select to choose a date on several of my forms. I'm using VBA to tell the calendar form which date to default to, as well as whcih field to send the selected date to. It works perfectly in all spots except one, where the button is on a subform. I...

Wahoo! The NewRecord idea worked! Here's what I did: Dim intnewrec As Integer intnewrec = Me.NewRecord If intnewrec = True Then Forms!ProjectDetails!cmdCommit.Enabled = True End If Rock on! Thanks so much!

I'm fairly new to VBA, and I'm trying to do an If Then statement that will allow a button on my form to becaome enabled only when the form is in data entry mode, acFormAdd, but it doesn't seem to like what I'm doing. Is this even possible? Here's what I've tried: If...