Search results

After upsizing a linked database to SQL Server, one of the bound forms in the front-end A97 database reports an error when I try to set the filter (DoCmd.Applyfilter) in different form events. This form worked fine when the database was in A97. Any suggestions? Thanks.

Hi Everyone, I have a form with bound controls where I dynamically change the recordsource via an SQL query based upon the user's input. One of the bound fields on the form is a memo data type field which is now cutting off the data at 255 characters within the field. Any suggestions? Is...

I have a system where the users switch back & forth between maximized open forms. When going to a new form, the switch is invisible, only the forms changes. But, when closing the form and returning to the other open form, the screen bounces or flickers a few lines before displaying the...

When switching betweeen open forms, they seem to bounce or jump up and down a few lines, then reset, each time I switch between the forms. Can this be caused by the toolbars or menubars? Thanks, Howard

First, I have a form which prompts the user for some report criteria. Then I open the report and build the SQL recordsource of the report based on the selections from the user prompt form. All of this works fine. Lastly, after the report prints, I need to update a certain field's value based...

I am finishing up a large project and have come to the point where I have to decide whether to generate some form letters by making templates in MS WORD, or by designing the form letter as an access report. I'm sure there are pro's and con's to both, but I would love to have some feedback from...

I have a form with 5 text boxes, named txtpayee1...txtpayee5. I want to populate these with data pulled from a table, and give the operator edit capabilities on the form with these text boxes. However, I would like to access these text box names as follows: me!txtpayee(x).value where (x) is an...

I am designing a form that prompts the user for an account number, then sets up a filter condition to bring only that one record to the form for editing. Some fields on the main table link to other tables, using combo boxes. The SQL source for the form includes linking the main table with the...