Search results for query: *

My spreadsheet is about 250 rows. If I use the TransferSpreadsheet command and the Excel file has headers the data is added but the last row is missing. I use a work-around by adding the last row twice at the bottom and it works fine but is difficult to get a user to know how to do this. Is...

I may have stumbled onto something. The slowness is because some of the linked tables do not contain data. Is there a way to exclude those tables so they don't jam up the ODBC link?

Thanks guys, both methods seemed to do exactly what I wanted in two different ways. All of this has revealed a rather nasty slow ODBC link in my source database and it is sooooo slow that both methods time-out while trying to read the tables. No problem with your coding though. Thanks

I have a linked database that has 500 tables all with various names and fields. Is there a way to programmatically read each table name and create local tables in a new (& separate) database with definitions and data matching the linked table? I am trying to create a new local database (not...

Greetings, I need to be able to delete the Temporary Internet Files for ALL users on a machine. I know I can do that with IE but when many users login and use the pc, they each create Temporary Internet Files and I have to delete each one manually or log into the machine as each user to delete...

Since I haven't been able to get the Monitor screen to display, is there a command to start just the CONNECTION INFORMATION item on the MONITOR menu? Thanks

Thanks, I thought that was correct. And it seems to load correctly however, the monitor screen is black which is why I questioned my attempt at remembering the correct command. Must be another issue. Thanks for the fast reply

Greetings, It has been many years since dealing with Netware and now I have been asked to disconnect a user via RCONSOLE. As I remember, there should be a connection manager in RCONSOLE but I can't seem to see it. Is there a command to start the Connection manager to see all the users in the...

I'm not sure how much help this will be but I use ScreenPrint32 to capture pages and save to the clipboard. From there you can paste into most applications. However this only does one page at a time. Another option you may want to play with is to export the report into the SNAP format. This...

I have a report that uses 20+ queries to get the desired reports. Each time the report runs I use code to assign a different query as the record source and print the report. I found I could also use embedded SQL statements in the code and branch with IF-Then statements to accomplish the same...

I have a W2K3 setup with and extra NIC. I can browse the internet from the server just fine. When I try to browse from the client computers I can never get a page to show. I can not ping the router nor any external IP address like I can on the server. WWW.<names.com> will resolve the name to...

I saw this on a news group. Perhaps it is what you are seeking? <Greg.Pigott@PSS.boeing.com> wrote: > I am having a problem when I try to export (send to) a report that contains >a graph OLE object. When I export it, all I get are the text portions of my >report in my RTF file. I've tried...

Perfect. Both examples changed the table names. The one by raskew changed the prefix including the &quot;_&quot; (underline) character while the one by tunsarod changed the prefix but left the underline. I'm sure with a little tweaking, that could also be resolved. Thanks for the quick response.

I have a database with 100+ tables. Each table was imported with &quot;TABLE_&quot; as a prefix and the actual table description follows that. Is there a simple code to cycle through each table in the database and remove the prefix from the name? (i.e. if the table name is...

Guess I just needed a little breather to start thinking straight. I figured out how to accomplish this. Seems so DUH!!! now. All I needed to do was to IMPORT the data files into a new database instead of LINK. Then I can see all the data and it stays with the Laptop even when not connected...

Can anyone tell me how to see ODBC linked tables when not connected to the server? (I am using MS Access.) I have a rather large database that I would like to be able to view from home and not at the office (server). This server is not connected in anyway to the internet or a dialup...

Can anyone tell me how to see ODBC linked tables when not connected to the server? I have a rather large database that I would like to be able to view from home and not at the office (server). This server is not connected in anyway to the internet or a dialup connection. The fact that the...

I hope this is not too much of a newbie question. I saw in some examples in this forum the useage of the: sqlString = &quot;SELECT *&quot; Could someone explain (or refer me to a URL) what that is and how it works? Is it a wild card for using the SQL statement or something else? Thanks

I have a tab control that has sevral tabs. Each tab has the same subform and uses the same query as the source. I need to change the source when the tab is viewed so that different information is displayed. (i.e. one field changed to filter on that criteria) Is there a way to have these tabs...

That may work for some forms but the main form in this case does not get it's source from that query and is unbound. I guess what I am asking is if there is a way to use the same query/subform on each of the tab sheets. It seems like it should be easy but so far, nothing I've tried seems to...