Search results

Hi: I need to have a listview (or similar control) with several of the columns being a dropdown list. Does anybody know how I can do this? I have done this in Visual Basic 6.0 but not V.B.A.

Hi: I have a query that is the recordsource for a report. The query uses linked Oracle tables. I get the error: Error Number 3146: ODBC--call failed. [Oracle][ODBC][Ora]ORA-00936: missing expression (#936) whenever I use this command: DoCmd.OpenReport (my report name), acViewNormal I have...

Hi: I have a problem with saving two sets of data. The problem is that sometimes the corresponding value is not known until later. For instance Collection1 Collection2 Name1 Null Name2 Bob Name3...

Hi: I am opening up a remote database and I have a syntax problem. I know how to open up my report with DAO but I need to open it with ADO. I have code for both but I am still getting prompted for the DSN User Name and password. Here is my code. Dim AccessApp As Access.Application Set...

Hi: I am printing reports off in code. The first one prints fine. When I loop through it the second time, I get a 2486 error "Cannot perform this action at this time." From what I have read on the Internet, Access maybe repainting the form and causing the error. Therefore I took out my DoEvents...

Hi: I need to open up a remote database on the S: drive and it needs a password. I can get the required values but I don't know how to send them in. Here is my code so far: Dim AccessApp As Access.Application strPath = "S:\Common\Tri.mdb" '* Create a reference to...

Hi: I have to open a database that needs a user name and a password. We have a generic one that I can use but I don't know how to pass that information into Access as I remotely open the second database. Here is my code to open the db that needs the password: Dim Acc As...

Hi: I want to query a table on a network drive. The path, for instance would be S:\Common\Users\ARTest.mdb. I cannot change the CurrentDB since this is a read-only property. Do I need to link the tables to my current db or what?

Hi: I want to take a previously filled listview control and read the contents into variables, then use the variables in an INSERT query. The SQL I can handle, but I keep getting errors when I try to get the data from the control. The Intellisense does not work for this control and the code is a...

Hi: I need to have the first column of my list view control as a checkbox instead of a text field. I need to know how to set a checkbox to true or false.

Hi: I am creating an Access application that will automate the printing of 10 reports. Each of these reports requires that I enter in a Start_Date and and End_Date. I have written a function so that they generate the first and last date of any given month. I need to know how to pass in the...