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 Mike Lewis 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. biffer711

    Booting in MSDOS mode

    Thanks Spyderix, this did the trick. Biff
  2. biffer711

    Booting in MSDOS mode

    Wondering how to reboot the machine in MSDOS mode. I'm trying to restore the WSOCK32.dll file and am having problems in "Safe Mode". Any help would be appreciated. Thanks, Biff
  3. biffer711

    Multiple COUNTs with a WHERE clause?

    Thanks Crystallized! Exactly what I was looking for! Thanks a lot, Biff
  4. biffer711

    Multiple COUNTs with a WHERE clause?

    Thanks, Terry! Not as pretty as I'd like, but it gives me what I need.
  5. biffer711

    Multiple COUNTs with a WHERE clause?

    I'm trying to create a query with multiple counts on a subset of a table. I've found: SELECT (SELECT COUNT(*)FROM Table WHERE Item = 1) AS Field1, (SELECT COUNT(*)FROM Table WHERE Item = 2) AS Field2 which does return the total count of Items = 1 and Items = 2 in Table. My problem...
  6. biffer711

    Recordset not updateable - Again

    That was an immediate fix! Once the Key field was set I was able to update. Thanks Allanon
  7. biffer711

    Recordset not updateable - Again

    I'm running Access 2000 and connecting to a database on SQL Server 7.0. I bring up the .adp file that I'm working on and open one of the tables. Whenever I try to update any of the data I get the "Recordset is not updateable" message. I brought this database over from the client...
  8. biffer711

    Posting a Value to a Combo Box

    I'm trying to load a saved record from a table into a form. All of the data comes in nicely except for my Combo Box, which doesn't seem to be able to accept the value the way I'm referencing it. I'm trying to use the assignment Combobox.value = "Bloom". "Bloom" is one of...

Part and Inventory Search

Back
Top