Search results for query: *

Thanks for the reply. It is unfortunate that the only way is the code behind the button way, but there it is.

Apologies for the double post

Hello. I've got a database which has the following general structure: Customer_Details - stores general customer information, including a customer_ID Customer_Purchase_Link - stores customer_IDs and purchase_IDs so one can keep track of each customer's purchase history. Various other tables...

Hello. I've got a database which has the following general structure: Customer_Details - stores general customer information, including a customer_ID Customer_Purchase_Link - stores customer_IDs and purchase_IDs so one can keep track of each customer's purchase history. Various other tables...

Hi. I'm trying to hook up a Pocket PC that will communicate wirelessly with an Access database resident on a desktop pc. There is some sort of problem with the ODBC link, as the client comes back with the following error: [ODBC][Driver Manager]Data source name not found and no default driver...

Cheers. Will do.

(bump) Again, any help at all would be most appreciated... have tried to implement all sorts of solutions but none seem to work.

No, they're only changing data. Users DEFINITELY do not change the design of the form. Additionally, I decided to run a multiple user test on the Test environment and it turns out that the problem occurs there too. Therefore it is definitely something to do with the form itself and not with the...

Apologies - have reposted this in the correct "Access forms" forum.

Hello - I'm having a bit of a problem, and that's an understatement. Firstly, I'm working with an Access 97 front end with a SQL Server back end and it's a multi-user system. I am bring driven up the walls by the following message: "'[FormName]' has been changed since the last time you...

Hello - I'm having a bit of a problem, and that's an understatement. Firstly, I'm working with an Access 97 front end with a SQL Server back end and it's a multi-user system. I am bring driven up the walls by the following message: "'[FormName]' has been changed since the last time you...

Thanks - should really have thought of that myself. I did as you suggested and the file has been deleted successfully.

Was experimenting with workgroup creation and such things with a view to securing a particular database. I created a workgroup called Workgroup.mdw and then gave myself (admin) a password for Access. I then disabled the security login by deleting my password, however I am unable to get rid of...

Hello all. I have a mystifying problem. A textbox on a form disables itself periodically for no apparent reason. There is no reference to the textbox in any code behind any button or form in the entire database, and I'm completely stumped. Users need to be able to copy the data in this textbox...

Thanks for the pointers. That looks as if it will faclilitate my needs.

Hi. The database is Access 97. The user runs a query that finds a specific piece of text in a large text field. The field is then displayed in a text box on a form. I want to highlight the specific piece of text within the text box that the user had been searching for, and indeed each occurence...

Thanks for the reply. I have tried making a blank db and importing everything from the original db, however it refuses to import the offending form. I trawled through the Microsoft Knowledge Base and eventually found a page entitled "How to Repair a Damaged Jet 3.5 Database...

Have encountered a problem with an Access 97 database that has suddenly stopped working. The tables all seem to be fine, but when I try to open a certain form I get the following error: The Microsoft Jet database engine stopped the process because you and another user are attempting to...

Until they provide us with count(distinct [fieldname]), then in Access 97 at any rate, your best bet might honestly be to split it up into two queries - the first selecting the distinct values and the second using the first as a source. An inelegant solution, but it would get you moving along...

Thanks for your reply, it actually hit on a number of things which we had considered to be real candidates to be our chief problem-causers. I've passed these pointers on to my SQL Server guy and he'll get to it. Thanks again.