I originally posted on the FORMs page...my bad. http://www.tek-tips.com/viewthread.cfm?qid=1244545
Some kind person pointed me toward Duane's super-duper Concatenate() code. Thanks.
I'm getting the dreaded data type missmatch in criteria.
Here is my SQL:
SELECT tn_p1.SONumber...
I'm starting with:
SONumber tn
00100211678 LABOR OUTSIDE OF CONTRACT
00100211678 SERIAL NUMBER REWORK ON 800 SERIES ENGINES AT CAT PLANT. INCLUDES NECESSARY TOOLS AND
00100211678 TIME TO REMOVE EXISTING NUMBERS, CLEAN, PREP AND RESTAMP NUMBERS PER
00100211678 INSTRUCTIONS OF MHI JAPANESE REP...
We think we want barcode. We are a engine parts distributor. We don't have any real examples in our industry to draw from. None of our managers have a "We used to do it this way and ..." Our accounting package is in UNIX. I can print 3of9 barcode on my forms with the use of escape codes...
We have both WiFi and wired phones. Could it be that we have too many access points? Or too few? We have QOS turned on but there is considerable arguement that QOS is not seeing all packets.
Thanks for the help.
When I create a static page with a reference to file:///server/share/file.pdf the page works as expected. When the page that references that same reference is served up by IIS (or Apache) the link doesn't work. Can you guys enlighten an HTML newbie?
We have a pretty standard warehouse as far as dirt is concerned. Can anyone recommend a scanner to quickly scan picking tickets to .PDF? I'm looking at the XP series from Visioneer. The XP 200 looks like it would do my job at the minimum and the XP 450 on the higher end. Duty would be 100...
We got a message from a Security Professional working on a system near us that said I see your network...We called the guy and said we know our WiFi is "unprotected" we use MAC filtering. I told my Boss at the time we said MAC was OK that NIC's can clone a MAC adddress but you would need to...
We need a method for people to get into our system. In the past they dialed up to our UNIX box. We've put in a new network with WiFi VOIP and the whole nine yards. We have Siemens routers. The IP guru says the heck with VPN, Siemens has a TS solution that works great. Our IP guru "wannabee"...
I'm a bit of a .db newbie, like you couldn't tell from my question. My companies accounting software is in AcuCobol. I've got ODBC drivers and a MySQL engine running on the Windows side. I would like to replicate the Cobol data on the MySQL box. Has anyone here done similar? Is there a WWW...
We attemped to install yet another router between our 2 sites. We tried an Adtran this time. Seamingly everything is ok. We're routing between 192.168.1.X and 192.168.2.x networks. When the 192.168.2.135 machine pings 192.168.1.9 everything is OK, when we change the IP to 192.168.2.160 the...
We had a SUS server running on a W2K3 server with compatability security mode. It worked great. That server crashed and I rebuilt a server with a different name. I insyalled SUS. I tweeked the admin template in AD to fix the name change but NO JOY. The clients don't talk to the new server...
Often I simply "link" to a .CSV or a .XLS file. This morning I went to refresh my linked tables and there wasn't anything in the Linked Tables Manager. I looked into my backup directories and those .MDB's are in the same shape....the links are gone. has anyone seen this?
Thanks for the help...
I have a Win2k Server with DHCP. My scope covers from 192.168.1.56 through 192.168.1.200. When the lease for 192.168.1.200 goes the DHCP server says I'm out of addresses even though I have gaps in my numbers. When I delete a lease, delete the DNS entry, force a renew of the client I still get...
I cannot figuare why v2.2.13 uses so much CPU power. When I had 2.2.8Aa installed I never saw the smbd daemon in my "CPU HOGS" screen. I always saw Apache or our enterprise software. I turned off symlink but no change. Any thoughts?
# cat /usr/local/bin/cpuhogs
ps -e -o "pcpu" -o "pid=" -o...
We got out first Rack mounted server (PE750) without rails. We're concerned there is too much cantilever load to support it with the standard flange. Will "RAILS" really help with the catelever load issue?
Thanks for the input.
Scott in Charlotte, NC
When I:
DoCmd.OutputTo acQuery, "Loc003WOcouldbuild", "MicrosoftExcelBiff8(*.xls)", "", True, "D:\Program Files\Microsoft Office\OFFICE11\XLSTART\Book.xlt", 0
it doesn't follow the rules I set up in Book.xlt like custom headers, repeat rows. etc. Even when I explicitly call out the location...
I cannot seem to be able to check for non-entry of a date field. I've tried:
is Null
= ""
= "__/__/____"
I have a "mask" to force correct date entry. Any help would be great. As you can tell from my question I don't do alot of coding.
Scott in Charlotte, NC
I need to loop through a table and create a new table. Basically it should check for True/False if True then create a record for each of Qty. If False then create 1 record with Qty of many. The manipulation works great. My issue is that the true/false test is only looking at the record in...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.