Quick Question

Results 1 to 4 of 4

Thread: Quick Question

  1. #1
    Kristen Guest

    Default Quick Question

    How can I access a query in a database when the query&#039s name has a space in it? Doing it this way gives me errors:<BR> objRec.Open "My Query"<BR>Thanks!

  2. #2
    Join Date
    Dec 1969

    Default RE: Quick Question

    I know this probably doesn&#039t sound very helpful, but spaces in fieldnames, tablenames, queries, etc.. is very bad programming practice, I would suggest you change your naming convention.

  3. #3
    Kristen Guest

    Default RE: Quick Question

    Yes you&#039re right but unfortunately, this particular database is absolutely huge with table links all over the place and I&#039m too lazy to go through the whole thing and change the query name where ever it&#039s referenced...

  4. #4
    Kristen Guest

    Default RE: Quick Question

    Oh nevermind, I surrounded the thing with brackets and it worked. Thanks for nothing everybody!! woohoo!! Just kidding, I love you all.<BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts