Hi Tammy, You need to do 3 things: 1) Fix the Form's On Current Event--Open the frmEntry Form in Design View. Right-Click on the little Form box in the upper...
65910
Myra Symons-Kazanci
myrafly
Oct 1, 2008 5:15 pm
John, I just aced an open book access test. Guess which book I had open next to me. Your index proved invaluable. I'm worth more to a potential employer...
65909
cellamedina
Oct 1, 2008 5:03 pm
I see that I had commented out the Me.SU = intS, etc., etc. Now that I've fixed that, it seems to be working. Wouldn't you know it? Once I asked for help I...
65908
cellamedina
Oct 1, 2008 4:56 pm
Yes, I only put boxes for the first group so far. In my other database, the totals appear in the boxes as you click the group selections. I must've changed or...
65907
Jesse Melton
irritable_ba...
Oct 1, 2008 4:56 pm
John and Pat, There was an unneeded table and join in my query. When I removed it everything seems to work correctly. Thanks for the info! Jesse ... [Non-text...
65906
John Viescas
jlviescas
Oct 1, 2008 4:50 pm
Shahab- You're not referencing the form inside the subform correctly. Try: Forms!frmPatient!frmShow.Form!DrugID = "SELECT DrugID FROM tblRegimenDrug WHERE...
65905
Patrick Wood
hunterpaw
Oct 1, 2008 4:46 pm
Hi Jesse, The error message is indicating there is a problem with this part of your query: INNER JOIN tblExpenses ON tblJobs.JobID = tblExpenses.Job If Job is...
65904
John Viescas
jlviescas
Oct 1, 2008 4:42 pm
Jesse- What happens if you have frmCreateEstimatePRO1 open and you run the query? You can also try, with frmCreateEstimatePRO1 open, going to the Immediate ...
65903
Patrick Wood
hunterpaw
Oct 1, 2008 4:29 pm
Hi Tammy, Is the problem with the totals the Material Tools & Equipment Totals in the Footer? Best Regards, Pat http://gainingaccess.net ...
65902
uruba1971
Oct 1, 2008 4:13 pm
Hi, My database has: A main form called frmPatient with tow fields- a textbox :PatientID and a combobox: cboRegimenID. Record source for frmPatient is...
65901
irritable_badger
irritable_ba...
Oct 1, 2008 3:57 pm
Hi Everyone, I'm not sure what's happening with my query (at least I think it's my query causing the problem)... I've got two forms: the first...
65900
Patrick Wood
hunterpaw
Oct 1, 2008 3:07 pm
Hi johnlond1, I should have read your post more carefully--but I am drinking my first cup of coffee now so I am now more awake <smile>. CatagoryKey should be...
65899
cellamedina
Oct 1, 2008 2:54 pm
I am uploading my new Compliance Audits database for help. I used my Safety Audits database to design it by, but the option groups are not totaling up. John...
65898
John Viescas
jlviescas
Oct 1, 2008 2:51 pm
mlmurrah- For this to work, there must be a control named "Application" on the form. Don't know if you missed the recent discussion about Me, but you should be...
65897
Bill Mosca
wrmosca
Oct 1, 2008 2:45 pm
First, Application is a reserved word. That's what is causing that one to blow up. Change it to maybe Appln. Next, although it shouldn't matter as far as I...
65896
John Viescas
jlviescas
Oct 1, 2008 2:32 pm
Valentin- If you need "date from" and "date to," I would think you need just a normal date/time field that contains the day. Your update might look like: ...
65895
John Viescas
jlviescas
Oct 1, 2008 2:27 pm
John- Your Row Source for cmbCategory should be: SELECT CategoryKey, CategoryName FROM tblCategory The Row Source for cmbSubCategory should be: SELECT...
65894
mlmurrah
Oct 1, 2008 2:24 pm
I have a table with several Yes/No fields set up to display as check boxes. On a form displaying the values of the fields, I have two buttons, one to lock the...
65893
Patrick Wood
hunterpaw
Oct 1, 2008 2:18 pm
Hi johnlond1, The easiest solution would be to use Subcatagory as a SubForm on the Category Form. You would not have to write any code for that. You would use...
65892
sonotronic sonotronic
vplayas
Oct 1, 2008 1:25 pm
Hello, I have use a table that I'm not sure which should be the good design. It has the following columns: DateFrom DateTo Reason Value Using that table I need...
65891
johnlond1
Oct 1, 2008 1:20 pm
I am having problems writing the code to fill a combo box in a recipe application I am building. The application's main table is called tblRecipe. It is...
65890
Sigurd Andersen
sigurd1999
Oct 1, 2008 1:13 pm
Would a tabbed control give you more room on the crowded form? I've found this a quite useful method of putting lots of info on one form. Sigurd Andersen...
65889
John Viescas
jlviescas
Oct 1, 2008 12:01 pm
Surely there's a better way to do this. It sounds like you don't really need the report - just some data that gets calculated on it. What is the Record...
65888
istari_6
Oct 1, 2008 11:49 am
Hi Crystal The controls I'd like to copy are in the report footer. the form I have open is completely unrelated to the data in the report and the value I'm...
65887
John Viescas
jlviescas
Oct 1, 2008 9:12 am
Jonus- The trick is to NOT select export formatted in the Export - Text File dialog box. When you click OK, Access should start the Export Text Wizard. You ...
65886
John Viescas
jlviescas
Oct 1, 2008 8:50 am
Shane- You have several options. You can use DCount or DLookup *before* you open frmManyThings and prompt the user if that's zero. You can check...
65885
Crystal
strive4peace...
Oct 1, 2008 8:47 am
In what section is the control on the report? You would have better success writing the value to the form from the code behind the report -- but why can you...
65884
istari_6
Oct 1, 2008 8:28 am
Hi all I have a form open and on this form I need to populate an unbound control with the value taken from an open report. Something along the lines of ...
65883
bty467549
Oct 1, 2008 8:05 am
Hi Bill, Thanks for the reply. I'm sure I fully understand the bit about VBA etc but When you say start a manual export, where exactly is that option? This may...
65882
Shane Herring
shane_herring
Oct 1, 2008 7:10 am
Follow-up: Would using a DCount prior to the DoCmd.Openform be a reasonable solution? I working on that now. Tks ... Hi. I have a form (frmMain) where main...
