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 derfloh 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. longhair

    count based upon a field

    thanks, dhookom. i understand your concern. so here is an example: p/t created p-key pick count abc1 12/27/1983 0000001 5 <null> abc2 12/27/1983 0000001 50 <null> abc3 12/27/1983 0000001 75 <null> abc4 12/28/1983 0000002 500 <null>...
  2. longhair

    count based upon a field

    good afternoon all, have been banging my head against the wall on this and cannot figure out how to do it in access. any suggestions are greatly appreciated. i have a table. 5 fields. data was inserted with an order by of field 3 and field 2. so, it is in a correct working order. what i...
  3. longhair

    array field in a query

    afternoon all, any suggestions would be greatly appreciated! i'm not sure this is possible and a search of the forum and faqs has not given me a what i think is a solution. given the following: table1 text1 text2 text3 double1 table2 text1 text2 text3 double1 tables are related by text1 and...
  4. longhair

    top 10 issue

    dhookom, yes i did search the forum first. and the link to the thread where you posted the sql code is where i got the idea for my first example. had a typo in what i am trying to accomplish, it is the first 10 confirmeddate not the first 20. however, as i said, the first example returns more...
  5. longhair

    top 10 issue

    afternoon all, having a slight issue with a top 10. have the following code: SELECT [CustCode], [SKU], [ConfirmedDate], [pick-ticket-num] FROM [Table1] WHERE [ConfirmedDate] IN (SELECT TOP 10 a.[ConfirmedDate] FROM [Table1] a WHERE (Table1.[pick-ticket-num] = a.[pick-ticket-num]) AND...
  6. longhair

    does anyone know if there is a transaction set...

    from the customer that returns stole level retail pricing? have not been able to locate a specific doc. i assume it could be part of an 852, logically, but wanted to know if there was a specific document. thanks in advance. regards, longhair
  7. longhair

    snapshottopdf

    roy, thanks. will check out the news groups. regards, longhair
  8. longhair

    Labelview: combine two fields into one barcode?

    tjit, not sure, don't use labelview 8.10. can u script it with vbs or a .bat file to create a file then use that? regards, longhair
  9. longhair

    snapshottopdf

    hsve been testing snapshottopdf from stephen lebans (www.lebans.com). appears to work but one, small, issue: after the first pdf is done... Faulting application msaccess.exe, version 10.0.6771.0, faulting module vbe6.dll, version 6.5.10.24, fault address 0x0004fb2e. it blows up the entire db...
  10. longhair

    operation must use an updateable query

    looks like the issue has to be with table b being an odbc linked table. i just grabbed the few fields i needed from it and wrote them to another temp table and will do my update from that one. thanks. regards, longhair
  11. longhair

    operation must use an updateable query

    i've run accross this issue in the past but always with much harder queries. trying to update field 5 in table a from field in odbc linked table b. UPDATE tbla INNER JOIN [tblb] ON tbla.[field1] = [tblb].[field2] SET tbla.[field5] = [tblb]![field12]; local tables are created on the fly and...
  12. longhair

    ambiguous name in query expression

    thanks phv. but no dice. i did, however, discover the issue. yearcalc is a public function in the vba module. i'm working on another module and did not remember to change the public function name in the new module. hence, access did not know which public function to use, even though they...
  13. longhair

    ambiguous name in query expression

    afternoon all, receiving the following: runtime error '-2147217900 (80040e14)' ambiguous name in query expression 'yearcalc([tblshiptmephdr]![confirmed-date-time])'. the query is in a module that has worked for years and none of the syntax or tables / fields have changed. cmd.CommandText =...
  14. longhair

    help with batch file

    just remember that this is a plain text file and your user name and password will not be encrypted. regards, longhair
  15. longhair

    DLookup not working properly

    NFI, STR is the name of the field and Job_M is the name of the table? regards, longhair
  16. longhair

    Run make table query and create new database

    tnguyen315, why not just restrict the user rights to the folder / db? only allow admins the ability to delete. regards, longhair
  17. longhair

    computer locked screen

    jerryreeve, you checked start, settings, control panel, power options? look at the advanced tab. is 'prompt for password when computer resumes from standby' checked? regards, longhair
  18. longhair

    computer locked screen

    jerryreeve, hibernate or standby? regards, longhair
  19. longhair

    computer locked screen

    jerryreeve, right click on the desktop, properties. choose the screen saver tab - is the 'on resume, password protect' radio button clicked? regards, longhair
  20. longhair

    Declare multiple variables

    sn0rg, what about using an array and then a loop to populate it? regards, longhair

Part and Inventory Search

Back
Top