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

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

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

I have a tab control that has seven tabs (one for each day of the week). Each page has a subform that uses the same query as the source. The data in the query can be sorted to display only data for each day of the week by changing the criteria of the dayofweek record in the query. How can I...

In MS Word, I have a form that was computer generated and it has a numbered list (each paragraph is numbered) and they are numbered in a strange sequence with some paragraphs not in numerical sequence from top to bottom. When I copy and paste this information into another application it pastes...

I have several unbound text boxes (date1 - date 31) these have the date corresponding to each day of the month on the main form. I have 31 subforms (sfmData1 - sfmData31) that need to use the date in the appropriate date(1 -31) box as a filter for the data in each subform. When date(1-31)...

I have a project that I created in Excel 97. I usually run it in Excel 97 since that is what is on the pc that it was written for. I inadvertantly opened it in Excel 2000 and saved it. (also protected/locked) the vb code. Now when I try to unprotect it in Excel 97 it will not offer the...

In Excel is there a way to retrieve the previous contents of a changed cell without using the UNDO command? I guess Excel97 knows what the previous cell contained or it would not have an UNDO command but can I retrieve that value via VBA and without physically UNDOing the cell? Thanks

Is there a function or VBA method to retrieve the previous contents of a changed cell without using the UNDO command? I guess Excel97 knows what the previous cell contained or it would not have an UNDO command but can I retrieve that value via VBA and without physically UNDOing the cell? Thanks

Greetings, I use the macro 4.0 language and am just learning VBA. There is a function in the macro language that I use a lot and am having difficulty using in VBA. This is what I would use in the macro language...

Greetings, How can I programmically track changes in a workbook and also keep unauthorized users from editing it. It will be ok for them to view the workbook but not change it. I would like to start with a template that is not tracked but once saved as a different name will be saved and...

When you protect a sheet and then the user trys to change the cell a dialog box pops up telling them the sheet is protected. Is there a way to cause my custom dialog box to pop up instead? I would like to have a custom box come up and ask the user to enter their name before proceeding and...