Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

jerryreeve, hibernate or standby? regards, longhair

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

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