Search results

I tried to mirror your Multi-Select form example and copied/pasted the event procedure to my command button (onClick) property. I then made the necessary substitutions where needed. I don't know if the syntax error I receive when clicking on the Run Report button has something to do with my...

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...

Thanks for the advice. My popup calendar works fine now.

Many thanks I will make that correction.

The field is unbound.

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

Yes. I changed the RecordSet Type back to Dynaset to make my updates to the subform. If there is a way to protect the main form but allow updates to the subform? Thanks for your help Orson9750

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...

Thanks for responding so quickly. I figured out I need put a little more effort into it. No magic fix. Orson9750

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...

Thanks Rural Guy. Great tip. The tabbed control did the trick.

I am attempting to use a Open Form command button to open my subform instead of having the subform displayed on my main form. The command button looks better. The command button opens my subform ok but now the subform does not work. Using the open form command button for this subform -- well...

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...

Your advise did the trick. Thanks much

Thanks for your quick response. I will make the changes.

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...

Thanks. I finally figured it out. My joined fields were not the same data types. Once I made the change the query and form worked. I appreciate your example which I am sure will be helpful in the future.

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...