Search results for query: *

Thanks for your help everybody.

Here's the code. Set Db = OpenDatabase("d:\GSE_GEO_INFO.mdb") Set RsSt = Db.OpenRecordset("tblStateCodes", dbOpenSnapshot) Set RsMsa = Db.OpenRecordset("tblMsaSelect", dbOpenSnapshot) Do Until RsSt.EOF = True cboSelState.AddItem (RsSt.Fields("StName").Value) RsSt.MoveNext Loop...

Yes only when I read it. All I want to do is read it. There will be no updating or appending.

A quick question. I'm attempting to load a VB form with data from an Access DB. This works fina as long as my database is on my c: drive. If I try and open it from d: drive(CD) I get 3051 Run time error. Which basically says VB thinks the database is already in use exculsively by another user...

Can I or am I creating the Variable GSE correctly? The code follows. strSqlCd = "SELECT RPTYEAR , " strSqlCd = strSqlCd + "'FNMA' AS [GSE], " strSqlCd = strSqlCd + "STATE, " strSqlCd = strSqlCd + "NSERV AS [SERVED UNDERSERVED], " strSqlCd = strSqlCd + "FIRST AS [BUYER TYPE], " strSqlCd =...

Can you make an Access DB a stand alone executable file? It seems to me I read somewhere this could be done. Thanks in advance.

I can correct the table issue. But then I'm going to have to pass a number of strings for filters so the query does what I want. Anyway my tables will consist of company, state, msa, serv, tract, year as my filter and grouping fields. The rest of the fields will be summed, etc. My query will...

I fairly new to this. However here goes. What I'm trying to do is pass a string to a query. Let's say to point to the correct table for the query to use to update another table. Then execute the query. Is this possible?

Thanks, I can make it work.

How do I get a column to default to upper case?