Search results

Hi: I don't know why I can't get my subform data to show? The unbound subform is on a Pop-up form that gets opened when the user clicks on any patient record in the MainForm. The subform on the Pop-up is supposed to show all the patient visits for that patient. When I view the subform on its...

Hi there: I have a fairly wide form (more fields than will fit into the screen width), so you have to scroll over to the right to see the righthand fields. If I scroll over to the right, based on the value in those fields, I see a range of records I want to select (and I want to do the selection...

Hi: I am creating a temp table in an Access 2000 database (from a pass-through SQL query). Its all working groovy, except that all my text fields are 255 characters. Is there a way to specify the length for various Text fields created with the 'Select into' statement (without having to go...

At least I think it should be easy, but I can't find an answer in books or on the web. The purpose of the query is to create a temporary local Access table using a passthrough to a SQL database. (based on user login). #1: My application first creates a SQL pass-through, then a make-table...

Hi: I have built an Access 2000 front end that displays data from a backend SQL database. The recordset is returned via a vba pass-through query, and since I send over all the criteria to the server (in a parsed 'Where' statement) the data is returned with very good performance. My problem...