Search results for query: *

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

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

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

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

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

morning all, have the following sql from a crosstab query: TRANSFORM Sum([PCS]/Right$(tblMasterCartons![um-code],2)) AS Expr1 SELECT tbl2009Shipping1.SKU FROM tbl2009Shipping1 INNER JOIN tblMasterCartons ON tbl2009Shipping1.SKU = tblMasterCartons.[product] GROUP BY tbl2009Shipping1.SKU PIVOT...

afternoon all, most likely a simple question but I have been unable to crack it. have 1 table: item - desc - custitem - retail - countofretail what i need is the 5 above fields grouped by item and the max of countofretail what i have so far: SELECT [item], First([Desc) AS FirstOfDesc...

afternoon all, receive a 450 error (wrong # of arguments or invalid property assignment with the following): Set cmdPOin = New ADODB.Command cmdPOin.ActiveConnection = CurrentProject.Connection cmdPOin.CommandType = adCmdText cmdPOin.CommandText "UPDATE tblOrderPO SET PONumber = " & strPO & "...

afternoon all, sorry, but my sql is not up to par at the moment so i was wondering if someone could take a look at the below and offer some advice. UPDATE tbl1 INNER JOIN (tbl2 INNER JOIN tbl3 ON tbl2.[field1] = tbl3.[field1]) ON tbl1.field2 = tbl2.[field2] SET tbl1.field3 =...

morning all, is there a way to call an access vba module from vbs? the idea here is to write a vbs script and make it a scheduled task. at the appropriate time it would run the access vba code. thanks in advance. regards, longhair

good morning all, not being familar with ntbackup i have a quick question. pc running windows xp with a lto drive for the backup device - backup is scheduled incrementally durring the week with a full on friday. i went and inserted today's tape and then drilled down to erase it but all...

good morning. a newebie at sms (the network admin usually handles but is out of the office). i have a pc on the 172.x.x.x network and we are on the 192.x.x.x network. sms is installed on the client while it was on the 192 network. in network discovery properties is see that the 172 network is...

good morning all, having a bit of an issue with some logic in an HPUX 11 script. any help would be appreciated. ... cat /files/dsdcwhd3.txt | while read off tty tm1 tm2 tm3 tm4 do if [[[$tm2 = "minutes" && $tm1 > "15"] || $tm2 = "hour"]] then print $off $tty $tm1 $tm2 >>...

afternoon all, hpux11 based on the following: cat /files/dsdcwhd.txt | while read dcoff dctty dcmnth dcday dctime do finger -i |grep $dctty >> /files/dsdcwhd1.txt done is there a graceful way to not process a line? within dsdcwhd.txt i do not want to process the last line, it does not...

probably simple but it escapes me now. hpux 11. need to remove a character from a variable in a script, don't have access to sed or awk. basically: cat /files/dsdcwhd.txt | while read dcoff dctty dcmnth dcday dctime do finger -i |grep $dcoff >> /files/dsdcwhd1.txt done but i need to add dctty...

morning all, simple issue that escapes me at the moment... Dim counter As Integer Do Until counter = 20 counter = counter + 1 astring = ActiveCell.Value bstring = "" If astring Like ("*B1M") Or astring Like ("*B5M") Then _ bstring = Mid(astring, 1, (Len(astring) - 4)) If astring Like...

Afternoon all, have an end user who is putting a hyperlink into an outlook mail. when it is sent the receiver can open it fine, but if the sender attempts to open the link before sending (to verify that it works) it does not chow as a hyperlink. all ready tried a compact and repair. any other...

afternoon all, looking for suggestions on the best way to do something and perhaps a little bit of code help. what i'd like to do is display a list of files in a directory so that my use can choose one. (i'll be holding the file name in a var for later use). i can get the files from the...