Search results

  1. R

    SHELL LPR

    All of sudden lpr has stopped working code: cm = "cmd /c lpr -S " & IP & " -P Port0 " & FileName x = Shell(cm,1) The dos window shows Error: host 192.168.1.126 not found I created .bat file lpr -S 192.168.1.126 -P Port0 %USERNAME%.ZPL This works fine off a desktop shortcut What would stop...
  2. R

    linking access and sql server

    Greetings, I've got an sql server that I can see and link/import data from but a few of the files are large meaning greater that 255 fields. So I create a link to that file and do see the first 255 fields in my linked table but! How do I get to see fields 256 thru 275?
  3. R

    Eliminating Duplicates

    I've got a query that needs to make a table containing all fields from the source table for only unique phone numbers (multiple records contain the same phone number). Can I do this in one query? SELECT DISTINCT [Student Info Table].[Parent 1 home phone], * INTO TABLE1 FROM [Student Info Table]...
  4. R

    Eliminating Duplicates

    I've got a query that needs to make a table containing all fields from the source table for only unique phone numbers (multiple records contain the same phone number). Can I do this in one query? SELECT DISTINCT [Student Info Table].[Parent 1 home phone], * INTO TABLE1 FROM [Student Info Table]...
  5. R

    losing yes/no data

    I noticed that I'm losing data (luckly it's test data) whenever I import or export! If I export a table from one database to another the resulting databases table has lost any yes/no fields. In datasheet view the resulting table has zero's (0) or -1. I find the same thing happening if I export...
  6. R

    losing yes/no data

    I noticed that I'm losing data (luckly it's test data) whenever I import or export! If I export a table from one database to another the resulting databases table has lost any yes/no fields. In datasheet view the resulting table has zero's (0) or -1. I find the same thing happening if I export...
  7. R

    Multiple OR's in Select

    I’m trying to conjugate a SELECT using a multiple OR’s in my WHERE clause, with little success. SELECT [Student Info Table].[StuID], ([Student Info Table].[First Name] & " " & [Student Info Table].[Last Name]) FROM [Student Info Table] WHERE [Forms]!pLName=[Student Info Table].[Parent 1A Last]...
Back
Top Bottom