Recent content by Waltang

You can definately build a second query related to the find duplicates query you just built. Have the query show all fields, and build a relation ship to the find duplicates query. Only problem is that the resulting query may not be updateable. Sometimes these things are easier to do than to...

Just for the heck of it.... Change the line that says Dim rst As DAO.Recordset to be just Dim rst As Recordset

What all libraries are checked when you goto references?

See if this fixes it. Its been a while since I messed with Acc97. Run the form, and when you get the compile error, hit ok. This should bring you to the Visual Basic Editor. On the menu at the top, goto Tools -> References. now find the library called Microsoft DAO 3.x Object Library (I'm...

Do you have an = in the criteria? >= [Startdate] and <= [Enddate]

Is this what your looking for? I didnt have Acc97, so hopefully the libraries are working. The problem that you were having seems to be that you were trying to use the Bound Field with the date as a form of search. By changing that date on the form, you were changing the underlying table, and...

That will give a message box. To then prevent them from changing it, put the following line right below the messagebox me!status.locked = true You will then need some code to Unlock the status field if the balance is equal to zero If Me.Balance <> 0 Then Msgbox "The balance must be 0"...

Be sure that you are going to a new record. The error you got sounds like you tried to change the existing Date record, but that the relationship is not set to allow cascading updates. I dont completely understand what your trying to accomplish, but It doesnt sound like you have the best...

Can you add them to the report and make them not visible?

I don't believe there is a fix for this. The problem seems to stem from the fact that windows cannont differentiate between the versions because they share the same file extension. The file extension is what windows uses to determine what program to open it with. If you trust the users to...

Try going to Tools -> Options Then goto the Advanced tab Make sure that the Default Open Mode is set to Shared, and not exclusive. I can't remember for sure, but you may need to set this at each machine.

You may have to restructure your data a bit, but take a look into partial replication.

Goto Tools-> Relationships then tell it to Show all

It sounds like your report just needs a running sum field.

Someone may know a better way, but I ran into the same problem, and the only solution I found was to put the path to the correct version of access in the shortcuts. For example, If I make a shortcut to my Access 2000 frontend database, it defaults the target to be : "C:\Main\SQL...