Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ronh42

    OpenDatabase problem

    Thanks for your help everybody.
  2. ronh42

    OpenDatabase problem

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

    OpenDatabase problem

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

    OpenDatabase problem

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

    Can I create a variable in SQL?

    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 =...
  6. ronh42

    access executable

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

    Can I pass a string to a query

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

    Can I pass a string to a query

    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?
  9. ronh42

    Default ot upper case

    Thanks, I can make it work.
  10. ronh42

    Default ot upper case

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

Part and Inventory Search

Back
Top