Search results

Excellent! Thanks for your help!!

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.

Spot on mate - Cheers Bl**dy windows messing with my application....Grrrrr!

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...

Ignore me!! I was looking for some permissions that needed to be set within Access. A simple tick of the box labeld "Allow users to change my files" under the sharing and security properties of the sharded folder sorted it out....!! How embarassing :p

Thanks for your reply. You must misunderstand my set up. I have 2 PC's on my desk networked together using a router. There is just me on the network...

That would seem logical. I have not done anything on Security or Permissions within Access yet. It's unchartered territory so any suggestions on whet to look for?

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...

Those suggestions do not work because they cause an error: "Cannot move focus to <control>" I solved the problem by creating two text boxes and the focus cycles between the two.

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...

Thanks for your help guys

I am also trying to find a way of distributing my package. Yes, most PC's have Access but being able to run it standalone just gives it that extra bit of Professionalism from a users point of view. I wrongly thought that Visual Studio 2005 contained the developer extensions so I got the full...

Yeah, see what you are saying but if they are read only then the VB code will not be able to write to them either. I can see the logic now that if you need to write to the database in the code then how can you distinguish the difference between doing that and the user going into the table and...

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?

Sorry yes, I have set them to something like so Set cnn = CurrentProject.Connection rstTable.Open "Table", cnn, adOpenStatic, adCmdTable Just wondered if I was piling up a massive problem somewhere as I haven't set anything back to nothing anywhere in my application. I have started and done...

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

Superb!! Thank very much...

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)"