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

    diplaying a URL in CF from an Access DB

    yep, it worked. Thanks. funny that it wasn't a problem before, but now i know!
  2. elektra12

    diplaying a URL in CF from an Access DB

    this must be a common problem, but I the solution i've used in the past is now not working. i'm trying to display a url from a db created in Access 2000. For ages, the following code has worked, but now in the past few weeks, I get an error message on my site, along these lines...
  3. elektra12

    simple update query question with a nested if statement

    IT WORKS! Thanks for the helpful suggestion. The only change I had to make was to change <> to = for the purposes of what I was trying to accomplish, but it does everything that I need it to do, even in the rare case that I described before. I knew it had to be simple! Thanks again for your...
  4. elektra12

    simple update query question with a nested if statement

    Thank you for your post. I tried it, but it said I had the wrong number of arguments. This was after I deleted one extra parenthesis you had which brought up an error msg.As for the nested query, and your suggestion, I think that if I need a second result to the if statement (the optional one...
  5. elektra12

    simple update query question with a nested if statement

    yikes, somehow in my post, the minus (-) got deleted in my code. We're dealing with True/False. Sorry for the typo...
  6. elektra12

    simple update query question with a nested if statement

    i'm new at sql statements in access, particularly nested ones. One trying to run an append query based upon a checkbox value. Here's what I want to accomplish. If the box is NOT checked, then I want to enter the value for CustID (from TblTransactions) into a certain field &quot;Owner&quot...
  7. elektra12

    using forms to enter new data based upon present data

    This may be more of a query problem, because I'm still getting used to using forms to update data and in Access I am only accustomed to the select queries, but less used to building insert/append queries in Access. What I want to do is this: while entering a new customer in the DB, I have a...
  8. elektra12

    db design question

    i'm somewhat new at access and have been using a particular db for awhile. the basic design is three tables: tblCustomers (includes contact info, etc) tblTransactions (links Customers to info on homes bought or sold by customer...a one-to-many relationship) tblAddresses (links the...

Part and Inventory Search

Back
Top