Search results

Right....the ones that are unique I want to keep. There ARE several thousand complete duplicates, however. A find duplicates query shows this. I don't understand why the SELECT DISTINCTROW isn't working. Thanks, Ed

Well, if only it were that simple. The table is actually my firm's internal docket. The fields consist of RecordNumber (autonumber field), DueDate, FileNo, ClientNo, Atty, Action, and Comment (a memo field). Often the exact same action is required, just on different dates, so the only thing...

I have been searching the archives on this forum for a couple of days now, but I am unable to find a solution to my problem. I have a table that has been imported from FoxPro which was part of a very poorly designed database. There are now 98000 records in this table, many of which are...

On access XP in win 98, the scroll wheel does not work in the VB window for me, either. It works everywhere else, though. Ed

I am not sure what problem you're having. I d/l your file, created a new blank database and imported your file (as a DB 5 file type), and got a table that had many, many fields. Is there a specific field you're having a problem with? Ed

Thank you sir! Ed

Well..... I spoke too soon it seems. This is almost working the right way ..... The only problem is that if a BILLDATE range is given, only records that actually have a BILLDATE will be pulled -- I need ones that are NULL in that field to also be pulled. However, if no BILLDATE range is given...

Thank you!!!!! It finally works!!!! Ed

Sorry. I've been away for a few days working on another project. I tried the above suggestion and it did not work. I'm posting a copy of the SQL for this query with the above included for [BILLDATE]. How I can get no entry for the BILLDATE parameters of [Start Bill Date] and [End Bill Date]...

Maybe in the OnFormat event for the Detail Section, you could set the IsVisible property to False after testing whether or not data was present. Hope this helps, Ed

Right. I've seen that page many times. I just am not sure how to incorporate the OR statements with "Between [Param1] And [Param2]" I tried using () and saying Between ([Param1] Or Like [Param1] Is Null) And ([Param2] Or Like [Param2] Is Nulll) This did not work. How must I modify this...

I am working on a query regarding billing data. There are 2 date fields in this data: DateEntered, and DateBilled. I have a query which selects both there ranges with parameters. Under the criteria for DateEntered I have: Between [Starting Date?] And [Stopping Date?] Under DateBilled I...

Change the criteria for the query that the report is based on to select nonzero values for that field. For example, if your field was called "MyField", then in the design view for the query change the line labeled "Criteria" under MyField to read "<>0" (don't use quotes, though!) Hope this...

The only way I know of to test for faulty networking hardware is to use each network box exclusively for a period of time to see if you can recreate the corruption with that machine. Then you will know it is bad. As for packet collisions, I'm not too sure how to detect these.

Networking collisions can also cause this problem. Or if someone has some networking hardware that occaisionally sends bad packets, the db can get corrupted. It's a known issue with access and jet, according to microsoft According to the KB article, ed

Sorry everyone. I answered my own question. I had to set "allow edits" to yes under to general properties of my switchboard form. Ed

Hello all. I have a database with a number of queries and reports that require date range criteria. I put two unbound text boxes on my switchboard: one for a starting date, and one for a stopping date. I set the default dates to be #1/1/95# and Date() using the properties for those...

You are assigning the string contained within strSQL to the control Me.EmployerTemp. At no point have you given a command to execute an sql statment. Try using DLookup; it's very similar to the SQL statement you're using. HTH Ed

Microsoft Access Runtime version is NOT free software. It comes with Office Developer XP. Is this the MS version, or is it some sort of clone? Ed

Check out VB help on the "StrComp" function. You can compare 2 strings this way. Then have a messagebox reporting if its a dupe. Ed