Search results for query: *

I am posting this here because it seems to be more of a VBA issue than SQL. I have a sp setup on a SQL Server that runs a job. I can call the sp from Query Analizer and it runs without a problem, but when I try calling the same sp from VBA, I get the following error: Run-time error...

Is it possible to edit an existing text file from VBA?? We receive a file daily from a vendor that contains informaiton that we pull into our database and then pass the file onto another company which uses it for processing. The problem is that occassionally, there is data missing from the...

I am setting up SQL Server ODBC connections on 5 machines and everything has gone fine until I came to the last machine. When I go to choose the server I want to connect to from the server drop down list, it isn't there. There other machines listed, but not the one that I want. The only...

I have setup a custom menu bar and am trying to add an option that I can't find. I don't know the proper name for it, but it is the option of how many pages you want to display on the screen when you are previewing a report (1, 2 or up to 6). I want to add this to my menu bar because it is...

I have converted my Access backend to a SQL Server 2000 backend and am in the processes of redoing the frontend to make it more efficient. The frontend is still Access. I posted this in Forum 705 also, but it was suggested that I try it here. I need to add a record to a SQL table through VBA...

I have converted my Access backend to a SQL Server 2000 backend and am in the processes of redoing the frontend to make it more efficient. I am not sure if this should be posted here or in the SQL forum, but am trying here since it is dealing with VBA. I need to add a record to a SQL table...

Is there a way to sort a table that is open in code? I need to be about to sort a table that I have open in code and am not sure how to do it. I am not looking to filter the table, just sort it. Thanks for your help.

Well, I messed up. I was cleaning up my system and deleted a user that had nothing saved under their login, so I chose to delete the files associated with the user. Well, now I have none of the files that were saved under my profile anymore either. Is there a way to get these back? I am...

I am working on writing code to import a spreadsheet that I created. I spreadsheet has 9 columns in it and each one has its own vaildation rules. I am getting the following error when I try importing the file through code: Run-time error '3709': The search key was not found in any record...

Can someone explain replication to me? I have searched the archives and FAQ's here and really didn't get a good understanding of it. I have also look at the help in Access and some other sites, but still don't really understand it. I am having a problem with a web site that is being developed...

I am trying to pull information from a table using criteria entered into a form. The following is the SQL of they query that I am trying to get to work. This is only the portion of the query that I can not get to work, there is more, but it is way too much to post. My problem is that if there...

Is their a way to pull data directly from a report and say put it into a table? I am trying to create another report that will pull the totals from another report. Not sure if this makes sense, but let me know. I could come up with the report another way, but it would take a lot more coding...

What I have currently is 2 different queries that pull the same information but with different criteria. I am trying to combine them into 1 query with an IIF statement for the criteria. The querie is run based on the RepNo that is input on a form. Once the user choose the RepNo from the...

I use the following code in an unbound form to add a new record to a table. I have just converted my Access back-end to SQL and this no longer works. So now I have an Access front-end with a SQL Server back-end. Can someone tell me what I need to change to make this work? I am assuming it...

I am new to SQL Server and have a question about converting an Access back-end database to SQL Server. How can I setup a field as yes/no like in Access? Does anyone have any other advice or warnings that I need to know while I am doing this? Thanks for your help.

Is there a way with VBA to combine 2 files? Currently I am doing it with a batch file which works great for .txt files, but if I format a file as a .rtf, it does not work. Here is what I have in my batch file: copy f:\pdoxdata\blotter.txt+f:\pdoxdata\temp.txt f:\pdoxdata\blotter.txt del...

I am trying to query a table through code and am getting an error message. Here is what I have: Private Sub Label7_Click() Dim CnCurrent As ADODB.Connection Set CnCurrent = CurrentProject.Connection Dim rsManualTds As ADODB.Recordset Set rsManualTds = New ADODB.Recordset Dim dtBegDate As...

I have to print about 20 different reports to 1 text file. When the reports are printed to the text file, they must look like the origional report from Access. What I envision is that I create the text file through code and then keep appending the results of the reports to it. But not sure...

I have an inputbox that comes up from code: strCode = InputBox("Enter the override code.", "Override Code") It is for an override of a transaction that only a few selected people know the override code for. I need the input to appear as *'s when the code is typed into the...

I know I have seen threads on this before, but can find them for some reason. I currently have Access XP installed and also need to have Access 2000 installed. What do I need to do to have both of them installed on my machine. I know I will have to install Access 2000 in a different...