Search results

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

To my knowledge, you would have to do this in an Onopen event, or make 2 seperate forms. I have a similar cases in some of my databases, and thus put the following function in a global module that I include in all my databases. It makes it easy to build conditionals based on if a given form is...

change your line that says MsgBox Err.Description to be MsgBox err.number & " - " & Err.Description Then see what number it is returning.

I personally hate domain functions, but If it is imperative that you keep the key sequential, and dont feel comfortable doing it in code, dont use an autonumber. Set the datatype to be a long, and make sure that it is Indexed as Yes (No Duplicates). In your form(s) set the default value of the...

I am having this exact problem. I have identified the culprit, but I have no idea how to fix the problem. I was working on a form that I had imported from another database, I had made some changes to the forms module, but was unhappy with the changes I made. I closed the VB editor, and the...

Try replacing : Strsql = "Insert Into tlkupCounty ([County]) values ('" & NewData & "')" with Strsql = "Insert Into tlkupCounty ([County],[Country]) values ('" & NewData & "', '" & me!country & "')"