Search results

I figured out the problem if anyone is interested. The Set db line should read Set db = wrkJet.OpenDatabase(<database path>, True, False, "MS Access;PWD=<password>")

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

Thanks for the reply. What I will need to do is maybe create a table in the backend programatically from the frontend. That table will then need linking. This is purely so I can send out updates to clients allowing them to run an update routine from the frontend so they need not get involved...

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

OpenDataBase- Not a valid password 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...

Top man!! That works now. Still got so much to learn.....!!! Thanks Oliver

I was thinking that maybe I need to use a LEFT join Is this what you are sufggesting??? Will give your suggestion a go now - Thanks.

As I am an SQL novice I need some help I have 3 tables Table - Fields SalesLedger - TransactionID, ProductID Vouchers - TransactionID, Voucher_Ref Products - ProductID, Product_Description The Salesledger has fields TransactionID and ProductID The Salesledger is linked to the Products table...

As I am an SQL novice I need some help I have 3 tables Table - Fields SalesLedger - TransactionID, ProductID Vouchers - TransactionID, Voucher_Ref Products - ProductID, Product_Description The Salesledger has fields TransactionID and ProductID The Salesledger is...

That sounds interesting Rich. I'd appreciate that. I'd admit that it's not the best designed system in the world and It's rather frustrating finding out how badly I have done things, but highly rewarding when the changes are made. Just seems neverending...!!! I need to make a start onm the...

I have designed a point of sale system for a salon I do have about 30 forms but they're not all data entry so a slight exageration. Such forms as Client details Employee details Business Contact details Product details Entering sick days, holidays, overtime Till declaration Refund Main...

Your the man Rich All I need to do now is go through about 30 forms and do this for each text box......Arghhhhh! Cheers..........

:) :) :) :) :) :) :) :)

If a user enters too many characters into a field I want to display a message and then keep the user in that text box until less characters are entered. This is the code Private Sub txtTitle_LostFocus() txtTitle.Value = LTrim(txtTitle.Value) If Len(txtTitle.Value) > 50 Then...

You could just count the records in the record set NumberOfRecords = Table.RecordCount then create changes the caption properties of a label to read label.caption = "Viewing 1 to " & NumberOfRecords & " Products" Example: Dim cnn As ADODB.Connection Dim rstTable As New...

Can anyone tell me how to disable the right mouse button as this post didn't answer it. Thanks Oliver

Thanks guys I take it you have to be a little careful here because once it is set up to open and close you can no longer edit it!!

I am trying to make my database as secure as possible so I can sell the application I have written. Certian things are stored in a table to make the application unique to the buyer to hopefully stop free distribution. So I need to make sure that the user cannot acces the tables and make changes...

Sorry mate, but I don;t really understand what you are trying to achieve here. Is AssighmentID a text box??? From what I can tell you checking the Value parameter of the AssighmentID text box to see if it is equal to the passed value and if it is then you want to change the back colour to red...