Search results for query: *

When I setup an ODBC connection on a client machine and I get to the question "Which SQL server do you want to connect to?" I have two servers with the same name to choose from but neither of them work right now. I know that we used to have SQL 7.0 but I was not involve with the upgrade so I was...

Thanks CMP! I appreciate the suggestions and completely understand all that you have said here. My problem here is that I need to record the user ID as part of the temp table and have that as part of the key. Unfortunately, there is nothing to join that field to in the order table which is...

I'm hoping someone can throw some suggestions my way. Here's my problem: I have an access subform with text boxes bound to fields returned in a query based on an order detail table. The Subform is being populated based on choices the user selects from 3 separate list boxes (as each list box...

Okay, strangely enough, when I removed the reference to Microsoft DAO 3.6 Object Library and re-added it, everything started to work fine. Can references become "corrupt" like that? I've never had that happen before.

I had already checked the references because that was my first thought as well. All of the references are identical and none are missing. Maybe I will try to remove all and then add them all back again. The program also compiles fine and the error still occurs. Any other suggestions? Thanks!

I'm hoping that someone has some ideas as to what is going on with my text box. I have an app that has several screens with text boxes that display date data. The value in the Default Value Property is: =DateAdd("d", 1, Date()) This has been fine for the longest time and is currently...

Problem solved by referring to the full server and path name rather than the mapped drive. sorry for the post.

I'm hoping that someone can help me out. I have a DTS package that runs fine as a package but fails once scheduled. The package uses a Transform Data Task to move data from a table into a text file on a mapped drive. The drive is mapped as the U: Drive. When I manually run the package, it...

I'm hoping someone can point me in the correct direction. I need to move the primary transaction log file for each of several databases from one drive to another (basically from the E: drive to the D: drive). What are each of the steps that I need to go through to do this successfully without...

I was actually able to get the Active X script to do this working. I am both checking for file existence and if the file exists, checking to see if the file is empty with the following code: Function Main() Dim objFSO Dim cFilePath Dim cFileName Dim cFileData Dim cFile Const ForReading...

I have a DTS package that I am creating that will be running every 10 minutes to dump data into a file that will then be picked up by another application. This other application needs to look for the exact same file name each time it does its import. Once the other application accesses this...

I am hoping someone can possibly help me out. I have a linked server created that uses a Transoft ODBC Driver. I am able to run a select query against this linked server via Query Analyzer. However, when I attempt to run the following update query: Update OPENQUERY(Unibol, 'Select * From...

I have a text box that is bound to a date value in a table. The field within the table is set to not except null values. The field is used to record the start time of a process. The default value in this field is 1/1/1900 12:00 PM. This indicates that the process has not yet begun. When...

But that creates a new instance of the form - it doesn't give me access to the controls that are currently open on the form that I am trying to access. The code runs, but does not update the actual grid. I tried to create a shared method within the first form (where the grid resides) to call...

I am trying to update a grid control (refresh with a new data source) on one form after saving some values to the database via another form. The main form that contains the grid control remains open while the second form is opened, data is entered and saved to the database. Once the data is...