Search results for query: *

Form has only 3 fields in the detail - type, date & amount. It's used as a sub-form on another form, to record account transactions for various funds. The sub-form is set to display in datasheet view, so on the main form they can add as many lines as needed, & always see the previous...

Okay - form is based on a table & sub-table. Main table has the account starting & current balances. Sub table has the update records. Main table is for funding sources that have money coming in & going out, so I created the sub-table to record the transactions. I did an auto-form, so that...

Okay, sorry to bug y'all with this one, but my "cheat sheets" are on a CD at work, & I'm at home! Simple question: On a form, once the data is entered, users need to choose between "Done" (okay, I can handle that one!) and "Add Another Item". On the add another - I need the code for saving the...

Simple idea: use a combo box on the form header to list all records in a table; select the record you want, & it displays the rest of the data for that record in the form detail. Should be easy, right? Why do I always get stuck on the obvious ones!!!!! Okay - here is the code as I used it from...

I want to apply some text formatting on unbound text boxes, but it's not working. I think I've narrowed down the problem - has something to do with the control source being an IIF statement. I say this because the conditional formatting works fine on other unbound text boxes on the report...

I need to count records in a query 2 ways. 1) All records in the query that have a review date after 7/1/06 - not a problem, I got that DCount formula in & working. 2) Those records from the query where the review date is between 2 dates, & those 2 dates are found on a form (the form that...

I have a report that has 2 footers for the same "field" (Agency). I want a separate footer for each, because I need to add logos/other agency-specific, non-Db info for each of them. I have a "main" query that is pulling the data records, & I have all of my formulas in place for the appropriate...

Simple report on file review results - the detail contains 8 sub-reports, 1 for each outcome measure; each sub-report contains the results info for the individual records by question & then a summary field for the total of all Yes & answers & all NA answers. There is a footer by review number...

Okay, this should be so easy, but I'm stuck! I have a table - tblFaceSheet - stores the values that pull to a form. I also created qryFaceSheet for the data in the table. I have a form for users to select which review they wish to edit - simple combo box (cboSelectCase) that has the review #...

I am creating a table to capture donated items; each item will need a unique ID for tracking - an autonumber, obviously. I want to take that ID & make it into a barcode number - is there anyway to set the properties of an autonumber to start be 10 digits instead of 1? I only see where I can...

I'm using MS Access 2002; when I go from design to view I'm getting runtime error 2247: There is an invalid use of the . (dot) or ! operate or invalid parenthesis. Code is: Private Sub Form_Load() If fldCase_Type2.Value = 2 Then (this row is highlighted on debug) frmS1_I2_1.Value...

Okay, forgive me, but I'm missing something obvious! I have a field on a form to capture a birthdate (field name = Ch1_DOB). I need to convert that date to the child's age. I found a function, but I'm just not getting how to use it! I know my field name should go in there somewhere, but I'm...

I have a large report for which I want a specific page footer for the details section records; however, when I get to the 4 different group footers, I don't want the page footer info to display. I can only find out how to not display the page footer in the report header/footer, not in specific...

I have a report based on a large table, so I have to pull the data in via subreports (can't have more than 255 data fields on a report). The subreports work fine when opened on their own - I get the correct totals. However, when I place the subreports into the main report's Detail (or any!)...

I have a report based on a large table, so I have to pull the data in via subreports (can't have more than 255 data fields on a report). The subreports work fine when opened on their own - I get the correct totals. However, when I place them into the main report's detail (or any!) section, &...

I'm having a problem - I can't get data from a subreport to the main report. I'm wondering if there is a way to get the Control Source of a report to pull from more than one query? If so, then all the fields I need would be available for summing/etc on my main report. Or is there just a simple...

Report is on a table of review items - each item can have a value of 1 (yes), 2 (no) or 3 (na). Each item will be listed several times - one time for each completed review. I need to get the sum of all the 1s to then do an average based on the number of reviews completed. It looks like distint...

I have a field in a table that is a data type Number, Field Size is Integer (is there a better choice?), Format is Percent & Decimal Places = 2 When I enter a number into the table it is automatically rounded & multiplied by 1000!! What am I missing here? For example: I type in 94.8 & get...

I am creating a report based on a table that has the following fields: Item Number (text field as some items include a letter, ie 120a) CWICARef1 (text field - as some items include a letter, ie 120a) CWIQARef2 (text field - as some items include a letter, ie 120a) PMRef1 (Number field -...

I am creating a Db to store the data on reviews completed on case files for an agency. There are about 174 questions, each of which can be answered Yes, No or NA. I know how to make a data type be Yes/No, but how do I add in NA? I'm thinking that on the input form I'll want to use an option...