Recent content by the_utmost

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.

Resolved This was an interesting one. I have my reports prewritten with a recordsource hardcoded into them. But the queries are dynamic and need to be linked (again) in my VBA code like so: Set qry = CurrentDb.QueryDefs("qrySharedPassThrough") qry.SQL = strSQL I have dynamically...

Where Clause When you open your report, it should look like this: Dim strWhere as String strWhere = "Company = Toyota" ' or whatever. Do not use SELECT, FROM ect. DoCmd.OpenReport (your report name), acViewNormal, strWhere

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

I am doing exactly this right now. What you might want to do is a 'replace' command that replaces the saved values with the ones on your form. Can you give us more info?

I ended up using a 2-dimensional array. My list is 6 items max so I just created an array of this size. Thanks anyhow.

This looks like a good idea. Now I need my collection to have public scope instead of private. Where do I make my declaration? I have a code module but this is where I am creating my collection.

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

First Problem First of all, your error handling is wrong. You should only have to state your error handling statement at the beginning unless you are doing something very complex. You are using "On Error Resume Next". That means that your code will continue no matter what the error is. Since...

Must be the Syntax I seem to be getting prompted for the values that the WHERE condition has in it. For instance: dim strWhereSQL as string strWhereSQL = "[MASTER_TYP_ID_ADMINCO] = 53" DoCmd.OpenReport rsRunningReports!report_name, acViewNormal, , strWhereSQL The report runs fine when I open...

This is how I see it. When I link my Access application object, that is when I get prompted for the DSN password. Dim AccessApp As Access.Application Set AccessApp = CreateObject("access.application") AccessApp.OpenCurrentDatabase (strPath) '* I get prompted for the user name & password here...

We are using an Oracle backend. There are system DSN's that are created on each computer. If I go to Control Panel - Admin Tools - Data Sources (ODBC) I have a list of connections to Oracle. There are System DSN's and my reports use one. It uses an Oracle ODBC driver and whenever we start it up...

Thanks Pat. I previously found this article on www.microsoft.com and I thought that it would fix my problem. The thing is, we are talking about 2 distinctly different things. There is a password protected *DNS* which is what I am dealing with and a password protected database which is what the...

I am a diehard Visual B programmer and I have only done about 2 years of Access. I am unfamiliar with some of the objects. I haven't used DAO since VB 5 and it is somewhat different here. My problem is that I have a DSN connection to a remote database. When I use DAO to open the report (which...

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