Search results for query: *

never-mind, figured it out, it needed some brackets around the table-name in the DROP statement. . . Thanks, Christy.

Hi, I want to create a procedure "EXISTDROP" that will drop a SQL Server table where the table name is passed from my VB app. Here is what I have but I'm getting the error message: "Incorrect syntax near @TABLENAME on line 5" CREATE PROCEDURE EXISTDROP @TABLENAME VARCHAR(75) AS IF EXISTS...

I just bought 2 great VBA for Word books: "Learning Word Programming" by Steven Roman "Word 2000 VBA" by Duncan Mackenzie both very helpful. They are hard to come by it seems, but I got lucky on Amazon.com. Thanks, CWarner.

hi! I'm very interested in making my forms all the same size and loading in the same position, top/width/height, everything. I haven't been able to find a way to set the top? I would love to see your module, or any code you have that would help me make my forms consistent. Thanks, Christy.

I also want to migrate my back-end to SQL Server, with an Access 2000 front-end. Do any of you have some Access code to link to SQL Server? I have developed some w/ the ADODB.connection object, and have successfully created & deleted tables on my SQL Server Developer version. Just looking...

Hi, Does anyone know the max db size of the SQL server 2000 Personal Edition? I know the max db size for the MSDE 2000 engine is only 2GB, I was hoping for more space in the personal edition. Also - what is the going purchase rate for the personal edition? Thanks, Christy.

I am an independent developer and have SQL SERVER 2000 Developer Addition, but this cannot be used for production deployment. My question is - what is the cheapest way for me to create a stand-alone Access front-end with SQL Server back-end that is completely re-distributable? I looked at the...

Hi All, I figured it out, and I thank you for your replies. Here is how I did it for those who would like to know. I created a Stored Procedure on the SQL Server side, calle EXISTDROP: CREATE PROCEDURE EXISTDROP AS IF EXISTS (SELECT name FROM sysobjects WHERE name ='NEWTABLE') DROP...

Hi, I have an Access front-end w/ SQL Server back-end. I have a stored procedure that checks to see if a SQL server file exists, and if so, it deletes it. The only problem is, once the file is delete, the stored proc gives me an error that the file doesn't exist. How do I suppress these...

I want to check the SQL server to see if a file exists; then if it does, I want to delete it. thanks!

hi, I have an Access front-end w/ an SQL Server back-end, and want to know how I can check to see if a file exists on the SQL server? My code gives me an error when the file doesn't exist: Dim rs As ADODB.Recordset Dim cn As ADODB.Connection Dim db As Database Dim cstring As String Set rs =...

the exact error message I'm receiving is: A first chance exception of type 'Microsoft.Data.Odbc.OdbcException' occurred in microsoft.data.odbc.dll Additional information: System error.

Hi, I'm trying to read a .csv file using a data adapter. I've tried several different connection strings, but no luck yet. Here is my latest string.... If ext.Text = "csv" Then 'Connection string for a Text File Dim connectionstring As String...

I'm trying to connect to a .csv file and input it into a dataset using the .fill dataadapter technique...here is my code, but I keep getting a system error: If ext.Text = "csv" Then str = "SELECT * FROM " & thefilename.Text conn2 = New...

I am new to VB, and have VB.Net 7.1. from Visual Studio Net. I wanted to know if VB.Net uses the same syntax as VB 6.0? The connection string proprerty seems different; here is what i have to use to connect to an Access DB: Public Sub ConnectToAccess() Dim conn As New...

I wanted to also mention that I just want to send the form results via email -- the form results just happen to be a person's email address. So I want the email to be generated from Brinkster.Com - not the user's email. Make sense? I've tried other code I"ve found online, but no luck...

Hi, I have a webpage created in FrontPage 2000, and I want my users to be able to type in their email address (fieldname=ADDRESS) so it goes in a "guest book" - either appended to a .txt file or as part of an email body sent to me at info@autoaudit.com (my website is autoaudit.com)...

Hi, One of my users on my Access2000 application, .mde, is seeing this error message for every button he clicks: "THE EXPRESSION ON CLICK YOU ENTERED AS THE EVENT PROPERTY SETTING PRODUCED THE FOLLOWING ERROR: CANNOT UPDATE DATABASE OR OBJECT IS READ ONLY" I zipped the file up and...

thank you everyone, your tips are helpful. I think to get around Excel version issues, I might force users to import their data via .csv file. Everything has to be automated, so I'm not sure how I would detect the Excel version up-front BEFORE the user imports it. The docmd.transferspreadsheet...

Hi, I have developed an app in Access 2002, 2000, & 97. Some of my users are having errors that I am not seeing on my computer and I think it's version compatibility issues. My questions to you are: 1) Do you think using Visual Basic instead of Access is a better solution to a stand-alone...