Search results for query: *

Thank you both! Very helpful!

Hello... I have a parent table called Tickets (tech-support tickets) and a related child table named Tasks, related via TicketID. One ticket can be made up of one or more tasks. Each ticket has a status of open or closed. Each task has a status of completed, waiting, etc. I'm trying to...

Where you have [Last Name], shouldn't that be where you put the name of the table that [First Name] is located in? Do a separate DLookup for First Name and for Last Name in your subform.

Wow... I totally overlooked the validation rule property. Thanks for reminding me! :)

Hi. I have a form called RFP Entry. On it is a subform (RFP Expenses subform). In the continuous subform for a new expense record, I choose a doctor from a combo box (Doctor_ID), select an account from a combo box(Account), and fill in an amount of the expense in a text box (Amount). Each...

OK. I discovered that I had a macro running when the form opens that finds the first record with a certain value in a specific control. When I take the macro away from the form's OnOpen event, the scrollbars show up again. I'm using the FindRecord action in the macro with the FindFirst...

Hi. I have a form that does not display either the horizontal or vertical scroll bar. The Scrollbars property in the form's property sheet is set to both, so I was curious if there was something else I'm missing that would cause this. Not sure what other information to provide. The form is...

Terrific! You guys are amazing! Gazillion stars all around!!! :)

Working great now, except that when I have multiple records in the subform for Operations accounts (1, 4, 6), the box will print Operations for each time it sees each different number. For example, if I have 2 expense records for Account 1 (Operations), 2 account records for Account 2...

Thanks, PHV... With the code line you mentioned repositioned, the same syntax error appears, except with '[Account_ID]=1;' And, the same line is highlighted when I click Debug.

OK, made that correction. Now, upon opening the RFP Entry form I get "Run-time error '3075': Syntax error in query expression '[Account_ID]=0;' When I click Debug, it highlights the line: DLK = DLookup("[Account_Description]", "Accounts", Criteria) The Accounts combo box in the subform has...

Thanks again... I tried your suggestions. I activated and moved as high as I could the DAO 3.6. Also, I originally had your code placed in the code window for the RFP Entry form. (I didn't have a Module created on the Modules tab in the database window.) I have now created a module (named...

Thanks, AceMan! I tried what you suggested. I set the control source of the Account_To_Be_Charged and placed the code into the RFP form module. ("General" is in the code window's Object drop down list at the top.) I noticed in one place in your code that you left out an underscore (RFPNumber...

I have a combo box named Account on a subform named RFP Expenses subform. That subform is on a main form named RFP Entry. There is a text box on RFP Entry named Account_To_Be_Charged. The main form and subform are linked via a field named RFP_Number. For each record created in the subform, I...

Thanks for the suggestion. Could you provide a code example?

Hi... I have a field named RFP_Number in a table named RFP_General_Info. I would like to have something like a parameter query that can prompt a user to enter a range of new RFP numbers (e.g., from 5001 to 5500). I would then like those numbers used to create as many new records in the...

Fabulous...thank you! *star*

Hello! I have a Projects table with 11 project records. I have an Employees table with 25 records. Each project has an ID (Project ID) and each employee is assigned to work on one project (Project_ID Number). The tables are related from Project ID in Projects to Project_ID Number in...

I have 2 parameter fields that ask for dates and customer name when the report is refreshed. The dates will accept multiple values (discrete & range values). The customer name accepts multiple values as well using a drop down list on the parameter box. So, we're wanting to print in the header...

The right-click worked in the Field Explorer. Thanks! I can't believe I overlooked something that simple.