Search results

Hi there I have 3 PC's on my Network accessing a back end which is sitting on the main PC. i.e. Main PC has Front End and Back End PC 2 has Front End and is linked to Main PC's Back End PC 3 has Front End and is linked to Main PC's Back End PC 2 and PC 3 take about 5 minutes to load the...

I have been trying to find out how to do this for ages...! Does anyone know how to open Outlook from Access when Outlook is closed. The main reason I need this is because my staff keep shutting Outlook down and so I do not get my automatic reports at the end of each day due to it...!! Then...

If I run the following code below on two PC's at the same time accessing the backend database, "zz_LockTest", one of them errors with the message Microsoft Jet Database engine stopped the process because you and another user are attempting to change the data at the same time. I thought that...

Anyone know how to search for a line of text and replace it with 2 lines? i.e. Search for: Set cnn = CurrentProject.Connection and replace it with: Set cnn = CurrentProject.Connection cnn.CursorLocation = adUseServer

I am doing some experimentation on locking and have noticed that when you open a record set and update to it lie this: cnn.CursorLocation = adUseClient rstTestLock.Open "zz_LockTest", cnn, adOpenStatic, adLockOptimistic, adCmdTable It processes a lot slower that if you do it like this...

I am getting the message "You do not have exclusive access to the database at this time" whenever I try to make changes to my forms. This problem only happens after I run the following statements and I get the message "Cannot access C:\SALON-NET\Data\Salon-Net_be.mdb; file already in use" Dim...

Is there a set variable or property that can tell you which Sub you are in? I want to use this to log errors. i.e pass the module and sub routine name to the error handler log file. The only way I can do this at the moment is to physically hard code the sub routine name into each error handler.

Anyone know how to get the computer ID or name unique to your computer? I want to be able to use it in a database to keep logs for each computer on the network. Any ideas?

Anyone know how to find the path of your backend database using VBA code? I am trying to determine whether the application is using a database via a network path.

I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network. The link works fine but the time formats are different. On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format However on PC...

I have an application with a backend db on PC 1, and the same application on PC 2 linked to the backend db on PC 1 via the network. The link works fine but the time formats are different. On PC 1 the time format is shortime and displays as it should i.e. in 24 hour clock format However on PC...

I have a main computer where my Access Application runs but I also want other computers with the application runnign on it but linked to the backend database on the main computer, however when linking to the tables they are only read only. How do you link to tables accross the network so you...

How can I allow a user to enter some text in a Textbox React to that text in the Afterupdate, or Lost Focus Event and then clear the text and keep the focus in the Textbox ready for the next input? Only not reacting to the text when the input is "" or NULL I have the following but it does not...

How can you stop people editing the data in the backend database from the linked table in the front end? The back end is passworded but you can still change data manually from the front end. Can this be stopped?

How important is it to set 'stuff' to NOTHING in the following? Dim cnn As ADODB.Connection Dim rstCustomers As New ADODB.Recordset What happens if you don't? Anyone konw?

Anyone know how to do a find and replace to include 2 lines in the replaced text i.e. Replace x = 1 with x = 1 y = 1

Using CREATE TABLE with YES/NO Field How do I create a table using CREATE TABLE for fields that are Currency and Yes/No fields??? This does not work. SQL = "CREATE TABLE Voucher_Details (VoucherReference NUMBER, ProductID NUMBER, Cost CURRENCY, Redeemed BOOLEAN)"

I have an application where the MSGBOX appears behind the current form but if you press the Alt key it comes to the front. It doesn't happen on my PC but it happens on the business PC. This is causing major problems because it looks like the application has frozen. Any ideas what may cause...

Is it possible to unlink and link to tables in a back end using VBA in the front end? I need to do this or something similar because when I send updates of the front end out I may have added an extra table and thus want to be able to get the user to run an update module to link any new tables...

This is driving me mad - can anyone get there head around this I want to programatically add/delete fields ect from the front end. However I keep getting "Password Not Valid" at the set db line when I know it's correct Dim wrkJet As Workspace Dim db As Database Dim cnn As ADODB.Connection Dim...