Search results

probably not the best way but... on form load I'd set txtDate to the current date (check out the date function in access's help). for the on click I'd set the txtDate to the current date +/- 1 depending on which button they click (again using the date function). the way I'd load the subform...

this is a one off task that I'm doing, normally the invoice details aren't in there, but for this particular project I need the customers latest invoice date. normally there's other fields in the table like a contact name, but I didn't have the space to put up all the fields. I figure I can deal...

ok, here it is, I've stripped it down to the 3 fields that I need to work with. I need to remove duplicate entries where the company name and zip are the same. I want to keep the record with the most recent invoice date. now I chopped this down to only 5k records however, when I do this it...

I'm still having problems, anyone willing to give it another shot? If needed I can upload part of the db that I'm working with.

thanks man, worked beautifully

I'm using access 2000, and have built a long form. My users would like to be able to use their mouse wheel to scroll down the length of the form rather than having to click the scrollbar. is there a way to do this? (I'm sorry if I missed this being answered in another thread, I looked but did...

actually got to it just now, still no love. I double clicked on your delete query and it said "Specify the table containing the records you want to delete" so I opened the query and just drug down the star from tblcompany, and I get "Could not delete from specified table"

thanks man, I haven't been able to play with it yet, won't till tomorrow, but from first looks it should work out ok.

just tried that, still no love, any chance I can get you to throw up a quick example mdb?

well, when I run the query in the "select" view it only gives me the correct records...

so here's what I did, I ran the find duplicates query wizard, then changed it from a select query to a delete query using the examples above and the query wanted to delete all 3 records.

so do I just make the find duplicates query and turn it into a delete query?

Hi guys, I have a question I've been trying to figure out with no luck. I have 2 fields, companyname and zip, these 2 fields may have duplicate values or they may be uniquei.e. companyname zip billybobs 68135 dilberts 68137 billybobs 68135 what I...

my wife and I have been together 7 years, married 4.

not really sure I can help. but here goes. first thing I'd do is try to have it be created locally. If you still get the same error, you might look at your database size, it might be blowing up to huge proportions for some reason. maybe decompile it, then do a compact and repair

Thank you so much Pat, I've got most of what I'm trying to do done. I really appreciate your help.

Pat, I thank you greatly, as that answers many questions that I had. So from what I've gotten, its no better for me to even use pass-through queries as they all queries are sent to the server for processing? Also, I don't know if you can link to any of those articles but it would be great if...

now I'm really confused as I've read that using linked tables cause more bloat (from a different forum) and less bloat from here. I've also read that using linked tables isn't a really good idea because it causes more network traffic, as all the records from a remote database are sent to Access...

Hello, I've got a problem that I can't seem to figure out. Here's some back story on the system I work with. In the company I work for I have 32 separate sales divisions. I need to pull each division's customers on a weekly basis and put them into their own tables. Now the database that holds...

Figured it out with much research. Looks like when Microsoft updated their Jet drivers, they broke connectivity with MySQL, I couldn't even link tables, or get Access to connect to MySQL at all. Below is a link that show's the issue for anyone else. http://bugs.mysql.com/bug.php?id=9932