Search results

Greetings, I have a form(frmMainContacts) that has a field "notes". The form is attached to a table(tblMainContacts). I have tabs that have subforms,frmCalls set up in datasheet view. When the "notes" field is updated on the main form, I want it to send the note to the subform on a new line...

Greetings, I search this forum for a search feature for subforms. I found one and attempted to copy the code and apply to my database. I getting two error messages and stumped on how to fix. I want to be able to search by a Participant Name, SSN or Request ID. The request ID is in the subform...

I have a database with several tabs named "Participant" and "Participant calls". The tab named Participant is the main form, on the form is a field "Participant Notes". Heres the fun part...my senior executive explain this in a presentation to the users but I have not idea how to build it. But...

I'm building a db and have questions on the approach/designs. I have a form, user inputs a SSN, it runs a query that returns several lines of information. I want to be able to select ONE record, have it write to a table named "groups" that is a sub form. Any suggestions on how to select the one...

Does anyone know of a way of having an "Audit" trail for changes made to a database?

I have a database with a field named "results" with 3 options of closed, open or pending. I also have a field name "closed reasons" which are toggle buttons with 5 options. I want to be able to update the "results" field to closed when one of the closed options is selected. Also, if the results...

I'm want to create a field in a table based off of another field and add 14 days. Some of the records are blank. I tried to put the following syntax in the default value field of the calculated field. [DateMailed]+14 this didnt work I also tried an if statment Iff ([DateMailed]not null...

YOU ROCK! Sorrry for the stupidity. This is a major breakthrough for this novice. Thank you so much!

=Form!frmInputPolNumFA2.Text34. Text34 is the field on the form. this is in the control source of the textbox on the report. Thank you so much for your help, this is very trying.

I put it in the control source of the text box. The form is open and has a button to run the Macro/query which generates the report. When the prompt comes up "form" if you select ok, the report generates and #NAME? is in the field.

I do this in the control source property of the report correct? I did this and it is giving me a prompt for FORM?

I have a form with three fields on it, Two of the field are used to match fields on a query to pull information from a datawarehouse then run a report. The third field is a field I want to populate on the report but is not in the Datawarehouse. How do you put a field on a query that does not...

I want the queary to select a PLAN CODE of "Select1" and calclulate from the ISSUE_DATE elapsed time of 11 months and return the POLICY NUMBER. If the PLAN CODE is "Select2" calculate frome the ISSUE_DATE elapsed time of 23 months and return the POLICY NUMBER. I hope this is more clear, sorry...

I'm tring to build a queary based on a field called "PLAN_CODE" and a policy issue date field. There are 3 plan codes ...select1, select 2 and select 3. I want to pull information as follows Select1 has an issue date 11 months ago (day the queary is ran) select2 has an issue date 23 months ago...

I does not remain open. I think our IT department created a way to disconnect ALL of the ACCESS db utilizing Datawarehouse. They are in the middle of converting to a reporting software and will be disabling business users to utilize the datawarehouse tables. A programmer here told me to look at...

I have a DB with Linked Tables to a Datawarehouse. Each day I have to re link the tables for some reason. (IT may have implemented something). Does anyone know of a method/object that would keep the tables linked?

I have a DB that runs an update, delete and append queries and turned off the Confirm prompts under the edit options. The problem is this turns off the confirms for ALL Access applications. Does anyone know how to turn off the confirms only in one specific db rather than the entire access?

Works like a charm! Thanks

After the user input the information a button is pushed to extract additional information (based policy number)from a linked table to a datawarehouse. The infomation put into the form and the DW information creates a report that gets e-mailed.

Does anyone know how to have the information input into a form written to the table once a specific field is updated? Rather than once a new record is input?