Search results for query: *

The set ansi_warnings off worked. That was exaclty what I was looking for. Thanks!

I am running a stored procedure from VBA code that creates a table using a group-by query. When I run the stored proc, I get following message: "Warning: Null value is eliminated by an aggregate or other SET operation." How do I disable this message, since it stops the code? I already have the...

Well, I figured out that my syntax was wrong in the code where I called the stored proc. Sorry.

I have an adp form that calls some stored procedures that contain update queries. Most of these work, but one only works when I run it in the SQL query analyzer, not when I call it from the adp form. I don't get any errors. Any ideas? Thanks in advance.

That makes sense. I now have it working. Thanks!

I created a new adp file, and after linking it to SQL 2000, I create a form. I made the form's record source one of the tables in the database. But after I switch from the form design view to Form view, all of the controls that I had created on the form disappear. What is going on here?

I have recently installed Visual Interdev 6.0 to windows 2000 computer. when I try to create a new project, and try to add an ASP page to the project, I get the following error message: "Error 1317. An error occured while attempting to create the directory D:\ProgramFiles." Can anyone...

Hello, I am trying to update a variable to the value of a field in row in a cursor. I know about the "Into" statement that allows you to line up the variables with the columns in the select statement, but what if I only have one variable, and it doesn't match up with the first...

How do you increase the time out property for queries in SQL? I keep getting the error: "Microsoft ODB SQL Server Driver Timeout Expired" on a large update query.

Is there a property in VBA code that identifies the database location? I want to query on a table in the same database, but I need to always change my connection string in the "open database" method based on where the database is, b/c it is on different computers.

I created an access file for an end user that has one form with a few command buttons on it. Each on of the On click events for these command buttons do not work when I put the file on the end user's machine, all though they work fine on mine. The error he gets when a command button is clicked...

Rod, Unfortunately, there will not be a limited number of tables that the user can reference. I work at an auditing firm, and I am trying to create a tool that will analyze tables from our clients that we are auditing. I want to be able to have the user select a table to analyze, and then...

I am trying to create a form that will be linked to different tables based on user's input. The form will have different number of check boxes in it based on how many fields are in the table. Not sure where to start. Anybody have any ideas?