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...
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...
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 ...
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...
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 ...
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...
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...
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...
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...
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...
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...
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...
John- Your Row Source for cmbCategory should be: SELECT CategoryKey, CategoryName FROM tblCategory The Row Source for cmbSubCategory should be: SELECT...
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: ...
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...
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...
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...
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...
Hi, My database has: A main form called frmPatient with tow fields- a textbox :PatientID and a combobox: cboRegimenID. Record source for frmPatient is...
Jesse- What happens if you have frmCreateEstimatePRO1 open and you run the query? You can also try, with frmCreateEstimatePRO1 open, going to the Immediate ...
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...
Shahab- You're not referencing the form inside the subform correctly. Try: Forms!frmPatient!frmShow.Form!DrugID = "SELECT DrugID FROM tblRegimenDrug WHERE...
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...
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...
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...
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...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
