Search results

I am using Access 2003. My database tracks how many energy discount applications are sent out to clients. Our clients are low income frail seniors and disabled adults. My staff either mailes the applications to clients or in some cases staff will make a home visit to assist the client in...

Access 2003 I created forms frmEARP & frmAppProcess frmEAPR (parent) pulls 3 fields from tblClientMain fields: ClientID, LastName, FirstName frmAppProcess (child) has 4 fields from tblAppProcess fields: AppID, Date, AppProcess(dropdown), ClientID frmAppProcess is a subform of frmEAPR...

I am using Access 2003. I am having trouble searching the internet for help on creating a backup and exit macro. Can someone help me? Thanks

Hello Access gurus I have attempted to look through the internet and this forum for help with my question. Although I have found part of my answer, am still puzzled. :confused: I have created a “Worker At Risk” hyperlink on my main “Client” form that takes me directly to a subform entitled...

Access 2003- I am using a Multi-Select Listbox to filter a Report. I select 3 rows on the list and click the Run Report. The following error pops up: "Syntax error (missing operator) in query expression '(CareOptionsID IN(Combative,Beginning Alzheimers,Dementia))' :eek: The expression...

I am working with Access 2003, I created a CmdButton that works off a query to select multiple parameters. This works well. My problem, the query I am using is a lookup list of 47 CareOptions. The end user will need a way to see what is available. I created a combo box with the drop down to...

I am using Access 2003. I created a pop up calendar. It works well but not perfectly. Each time I click on a date in the calendar that same date shows up for each record in the form. What can I do to correct this? Thanks in advance

I set my main form RecordSet property to Snapshot to prevent edits to the main form and still be able to make edits in my subform. I previously added a Command Button for a Record Find on the main form. My problem now is that my Record find does not work. I use Record Find to locate records in...

I have a tabbed control on my main form with 3 pages. Each page has a subform. Problem: Clicking on the individual pages, the subform seem to jump up or down. How do I set the properties for all three pages so the subforms are sized & positioned correctly on each page? Thanks for your advise...

I've created a form with 3 subforms. They are functioning well. However, the form looks quite busy. To clean up the form, I created command buttons to open the 3 forms used as subforms. Problem: When I click on the command button and choose a value from the form. That same value is shown...

My database has several tables. 2 tables are set up with a one to many relationship with a 3rd tble right now called tbljoin. Main table is a list of agencies with physical address, etc. the detail table is a list of 47 care options. So one agency can have many care options. I created a form...

I have created a database with help from Access Forum experts. The datbase has 6 tables. All tables have working relationships. When I try to create a query or form using 2 joined tables I get an error message " The wizard was unable to open your form ... query in form view or datasheet view...

I have asked this question before. BobLarson sent a great example but without coding or SQL query experience my attempts at getting values to appear in a form's text box did not work. I have attached an example of my form and the table of field values that I would like to see populate the form's...

Is there a way to make a query that can choose several values in a single field and find matching values in another field. Example: Field 1 is Care&Supervision with a list of 45 care choices. Field 2 is a list of Care Facilities that each have different care options. All care values are...