Search results

I have a form that is used to update some tables, and I have it located on a network drive. What I am trying to do is get around the form lock or table lock error I get when I am on a form and another user tries to get on that form, and they get an error stating they can not update, cause it is...

I have a form that is used to update some tables, and I have it located on a network drive. What I am trying to do is get around the form lock or table lock error I get when I am on a form and another user tries to get on that form, and they get an error stating they can not update, cause it is...

This will be easy for most probably... I have a button that calls 9 SP's in sequence, and I am wanting to display an image for the user while a sp is running and once it completes and the nest sp starts the image will go to invisible and the next image will become visible. I am doing the same...

This will be easy for most probably... I have a button that calls 9 SP's in sequence, and I am wanting to display an image for the user while a sp is running and once it completes and the nest sp starts the image will go to invisible and the next image will become visible. I am doing the same...

OK - this may be easy or may be hard - not too sure. I have a procedure that calls about 7 stored procedures in a row off the SQL server and once the last one returns it will pop up a form for the user. Problem - I am filtering through about 8 million records and it takes a minute or two. So...

I am having problems with this isloaded function. I am using it in my login routine and it keeps giving me "compile error sub or function not defined" Does anyone know what I need to do to get this function to work?? Here is the code I am using.. If Not isloaded("frmLogin") Then...

Ok - I am calling a stored procedure that runs anywhere from 30 seconds to 6 minutes depending on what parameter the user enters. My problem is that when ever it runs for anything more than 35 seconds I get a runtime error for timeout expired. Here is my code: Private Sub Command0_Click()...

This will be an easy one for you ACCESS guru's I am sure. I have built an application in ACCESS2000 and a backend in SQL 2000. I have a main form with many subforms that I am asking for user input with. When they enter the data it is stored in a few different tables in SQL. I then have a...

I am using ACCESS as the front end and SQL server as the backen. I am using ODBC to link about 20 tables through ACCESS. My question is: I want to run some sort of a script when you start the application to refresh the links to sql server. What and where would that code go? Thanks, BS

This will be an easy one for you ACCESS guru's I am sure. I have built an application in ACCESS2000 and a backend in SQL 2000. I have a main form with many subforms that I am asking for user input with. When they enter the data it is stored in a few different tables in SQL. I then have a...