Search results
-
M
Can 1 form update 2 tables?
My requirement is: In the form, find a record in table A by SSN, display several fields on the form with data from table A. Have several other fields on the form that data is then keyed into. Add a new record to table B with all the fields from the form. Can this be done? Can there be more... -
M
Grouping Header - Changing value on last page of Report
I have a text box in my page header where I print the PHASE of the data I'm working on. PHASE is in the detail records that I'm summing. PHASE is a text field in the table. I sort, group and page break by PHASE in the report. When I do, the correct PHASE prints on the page header. The problem... -
M
Need to Sum 2 seperate columns
I'm trying to show how many people have taken 1 of two courses. If the person has taken "PDI" it has a 1 in the PDI column. If the person has talken "LDRN" it has a 1 in that column on the report. I need a caluculation that shows how many have taken either "PDI" OR "LDRN". So if 3 people in... -
M
Memory Message
I added a control button on a form in Access97 to printout the current record that is being displayed. When I click the button, the record does print, however I then receive the message " There isn't enough free memory to update the display. Close unneeded programs and try again." I don't... -
M
* is defaulting to a 1 in a report
My query asks which birth month to report on. The user can key in 1 thru 12 or an * for all months. On the associated report, I use the birth month field to display what the user keyed in. When a month is keyed, it displays it properly, but when * is keyed to run for all months, it is... -
M
Too many criteria selections needed
I have a query going against a Medical Survey table. I need to show anyone who is past due on any of 10 different date fields. My problem is the criteria selection box only has 9 lines for 'OR' selctions. Is there any way I can include the 10th field? Thanks for your help. Tom -
M
Undefined function 'Date' in expression
I am working on a database that has a Master database with 3 other databases, all with the same tables, linked to the Master. I was told this was done to combat contention problems. My problem is that on two of the linked databases, a query using the Date function is working (>Date()-880) yet...