Search results for query: *

Here is the error message. My code also does of verify that the DB is there first. Unable to open \\vbarsefpc1\sqa_docs\Test|Dev\VS2013\BatchFileScanner\Database\SSNScanner.mdb Error #-21474672559 was generated by Microsoft OLE Provider for ODBC Drivers [Microsoft][ODBC Driver Manager] Data...

I am using VS2013 VB and have created several routines. The library project connects to Access (mdb and acceb) just fine. When I move the class to another project I get an error that it can not connect. Why? My code it: Public Function Open_Access(ByVal dbname As String, Optional ByVal...

Thanks. I am finding it complicated also. I have a combination of delete, add, update, and SQL statements. I am not sure how to handle them. They can happen at any of the three sites. I was thinking about creating a change table that will indicate the type of change, table, record id, and SQL...

I am using Access 200 as the database and VB6 as the application language that access the database. The links you provided are for general Access and for VBA not for what I want. I have tried looking the web for my answer but I have come up with nothing.

I am using VB6 and Access 2000. Due to network times I have to have a replicated Access database at the other two sites. Replication adds a lot to the size of the database. Is there a way to combine changes at the different sites the way that replication does? I am hoping that I can get away...

To both: I only replicate tables, I synchronize with a database in Chicago. I wish to make Tampa MDB the master. I do have office developer. How do I do this?

How do I set a replicate to master without Office Developer?

Move first then move last to get record count.

I need to know how to insert a row into an Excel spread sheet. I know how to open the sheet and get to the row belw where I want to Insert the row, but I can't seem to find that next step. I also need to know how to copy the row above the new row into it.

Thanks for the info. I will give it a try. I wish that the help files in VB were more detailed.

I know how to use OnTime and the Windows timers. I have a need to wake up a procedure in an Excel spread sheet every 1/2 hour and perform certain functions. The program that I am running into is that I have many Excel sheet open and when the timer expires and start my timer routine and the Excel...

I am sending emails to out people using their LanID to find them. We have found that this does not always work, in fact if sends it to the wrong person. I noticed that in Outlook there is a find feature that when I put in the LanID into the Alias it does return the correct person. How do I...

Thanks for the information. I guess that I should have been a little more detailed in what I am doing. I am bring data in from other workbooks into mine. From here I will be working the data. I have been accessing the combined data as Worksheets(name).cells(row,col).value. Is there a better way...

Does any one know how to read in an entire sheet into an array quickly?

Thanks for the help!

Thanks! That was a good reference. When running Visual Basic Studio and you click on 'Project' and 'Reference' you get a long list of libraries that can be included. I am looking for very basic information. For example, I have a very simple program and I was to open another form. The normal...

As I don't have MSDN library CD, I am at ends trying to figure out what libraries to includes during my development using VB 6.0. Most of time it is hit and mostly miss. Does anyone know where I can get a list of what each library contains?

Thanks!

I need to determine the full path name of the Access application when it is run so that I can find the local data assoicated with it. Any one know to get this information after the application has started?

Thanks!