Recent content by rkapfer

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

The Access ODBC wizard doesn't work like the MS Query ODBC wizkid, wish it did. Access only lets you pick an exposed view of the data, MS Query ODBC wizard lets you pick not only the file but also the fields. The vendors' already said "we've never been asked that..." amongst other "we'll get to...

Old data base we're banging at it probably like no one else, the vendors tough to deal with. Probably an old Cobol data base converted huge records throughout. Access tables don't link to MS Query do they? I'll have to create a button to refresh Excel or move to Business Objects, this won't be...

I'm linking via ODBC I have no control over the DSN. When I link I'm seeing only 255 fields. I'm currently using Excel via MS Query to get fields 256-275 then linking an Access table to the spreadsheet. I'd like to eliminate Excel.

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?

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

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

Access 2000, it loses all formats for any field defined as yes/no.

Thanks Andy, but is there a switch, flag or control that'll prevent this?

I noticed this also ocurrs as a result of a Make Table Query. The resulting table does have as you said has the 0's an -1's (instead of neat check box's). The resulting table's definition has Yes/No specified but the data still appears as 0/-1 in any query. Is there any flag, option or control...

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

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

No, if my form name is [Inquiries Group] but you made me think, what if I remove the form name and went with just [pLName]? That worked. For some reason if I used [Inquires Group]![pLName] and save the form, the RecordSource is getting changed to [Inquires Group]!pLName=. That didn't work but...

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