Recent content by jsparks

basically what i have is an access.mdb with say, 50 tables in it. i need to create another database with say 23 of the tables from the original database. i'm attempting to do this via ASP... so far, i have created a page that first renames the current database with the current date to be kept...

I'm new to VB, so please bear with me. I have a text box that the user types a page number into. When the user presses enter, a connection is made to an Access2000 database and a recordset is built with all of the fields for each record that match the page number the user typed into the text...

EXCELLENT! As it turns out, I did have locktype set to readonly, but i had the cursor type set to forwardonly...changing it to STATIC populated my MSHFlexGrid perfectly, thank you very much!

Just some more information... I have verified that my database connection and my recordset are working. If the user types in a catalog page number, the text for a combo box is changed to &quot;page <number>&quot; and the combo box is filled with the product numbers from the correct page...

I have an MSHFlexGrid Control on my form. The user types in a page number. on the return keypress, a connection to the database is made and a select statement is executed. the results from the select statement are to appear in the MSHFlexGrid control. (MSHFlexGrid1.DataSource = RS) The first...

i have looked at and used loadpicture, but am having difficulty writing it to use the stylenumber field as the first part of the image file name and _D.JPG as the last part of the image file name.

I am using the ADO Data Control to retrieve information about a retail catalog from a database. When the user looks up a record, the details of the record are shown along with the matching image. In my HTML/ASP version of this project I specify the path in an image tag, and then insert the...

I have a system DSN setup on an NT server on my LAN. It uses the Microsoft Access Driver, and points to an Access2000 .MDB file on the server. I am writing a visual basic application that needs to use this datasource from whatever workstation the app is being run on. All I can find are...

I'm new to VB6, have been into it for a few weeks now working from training guides and reference materials. I've got the basics down and have designed an interface for what I need to do, now I am coding the functionality. I have used the ADO Data Controls in several examples, but all have been...

Michael : I am using Crystal Reports 8 to develop reports based on the tables in this Access database. I'm not sure if you are familiar with CR8, but I run into 2 different problems there. First, if I try to specify my database as the datasource for the report by choosing the system DSN from...

I'm reading in Wrox &quot;Beginning Access 2000 VBA&quot; about the Transferdatabase and Transfertext commands. However, both of these examples suggest you put a button on a form in the database and use the onclick event to run the VBA code with the Transfertext command in it. That looks like...

I have an Access 2000 database on an NT4 server, and I have data that I need on a UNIX server. I have the UNIX server setup to create 3 .CSV flat files automatically every day. The NT4 server copies those files from the UNIX server, every day. Currently I have those 3 .CSV files linked as...

I have 3 .CSV files that are created on a UNIX server at 5:00PM every day. Those 3 .CSV files are copied to the NT server running our Intranet at 5:15PM every day. In my Microsoft Access database, I have 3 tables that are linked to those .CSV files. This method of getting new data every day...

I have a task to complete here, and I'm having a hard time finding information on it. I have an HP-UX server that keeps all of the data that I can use. I have a routine setup that creates 3 flat files with the information I need. 2 of those flat files are used to fill data to one access table...