Search results

Hello all, Here's my issue. I have a form with the data source being a query composed of data from 3 different tables. When I go to enter data in the form I get the default "ding" noise and I cannot enter any data. All of the fields I'm trying to enter the data in are unlocked and the form...

Hopefully this should be pretty simple, but I'd like to get some feedback from you pros. I've created a DB in 2003 that will be placed on a network share for the 5-6 users who will be using it. Basically there are two user groups that will be using the DB, so I'm creating Group1 and Group2 and...

You the man....it works!

Here you go...

I've tried to upload for you several times but I keep getting an error message from the site. The sample DB isn't larger than the maximum allowable, so that's not the problem. I'll try later.

Yes, I'm opening it from the form. I meant to say it looks like the report tries to open. I've added the additional quotes as you suggested, but still no dice. When I try to run the report directly I get a compile error: Invalid use of property and it highlights the following: ![Control...

Okay, I took a shot at it, well several actually, and I still can't quite get it. I made some adjustments after referencing the article at the link you provided. The onclick button code now looks like this (I did not include the sub call or end statements): stDocName = "rptUpdated Control"...

Okay, I have an interesting one and I'm not sure if what I'm trying to do is possible. I have a form (frmUpdate Ctrl) that allows users to update data as needed. On that form is a button that passes the record number to a report, opens the report with the single record, and then emails the...

I'm wondering if anyone knows if this is a bug or I went about something the wrong way which is now causing me some grief. I built my tables, queries, and forms and then realized that I hadn't named them to make them easily identifiable, i.e., tblCycle, tblProcess, qryTesting and so on. I went...

Rabbie, Unfortunately I can't split them out. That would have been ideal, but I can't do it. Drake, Thanks...that's pretty simple and qualifies me for the "duh" award. Perfect example of trying to over complicate things... Thanks both for your assistance

I have a sorting issue and I'm sure it'll take some code to straighten out, but I'm not a code guy. I have a test field in my table called "Control Number". The control numbers consist of COMP1, COMP2 and so forth up to COMP14. This repeats for several other control numbers, ie ENT, CTB, TAX...