Search results

That's not exactly what I'm after. What I'm trying to do is put a button on a form which, once clicked, deletes unmatched records and then shows a message box, for example "Cleanup complete. 12 records were removed." Hope this helps, - Javawag

Hi there, I'm creating a few DELETE queries to remove records in one table which don't have a relation in another table - I used the "Find Unmatched Query" wizard to generate the SQL and this works fine. What I'd like to do is show a message afterwards to explain how many records have been...

I understand that. I've only really decompiled it and done various Compact/Repairs, but I must say the problems are a lot less frequent (I hope I didn't just speak too soon!!) Thanks for the help! - Javawag

OK, just to report I've transferred to the hard drive but unfortunately the corruption situation is about the same! All I do now is backup really often so I can get back quickly, and as evanscamman points out, it's only form design changes that are lost as VBA can be saved! - Javawag

OK, so I'll get it off my USB drive and into my documents on the PC! The only reason it was on the flash drive in the first place was that I was hotdesking at work - but now I have my own desk. I've run a /decompile before, but I'll do that again and compact/repair in between as the...

Oh ok. I don't use CompactOnClose because I'm always opening and closing my Database and it gets quite tedious. However, I do perform a Compact and Repair on it daily. - Javawag

Ahh, I didn't see it on the about form before :o. It turns out I have SP3; is there any way to find out if I already have the hotfix installed? The problem is to install it, I'll have to phone the IT department as I don't have permissions to install anything on here. - Javawag

Sorry, I'm using Access 2003 - I'm not sure which patches (if any) are installed, as it's a work computer. How can I find this out? - Javawag

Form corruption whenever I edit anything! Hi all, I'm experiencing a problem with my database - sometimes when I edit any form (even just adding a textbox triggered it earlier) it causes major problems. After I've finished editing, if I click close and choose "Yes" to saving, the form no...

Wow, thanks! I actually ended up half doing that and half recycling my SQL from the form, it seems to work fine though! The problem now is, how do I pass the start and end date values to the report? I know I can set fromDate and toDate as global variables and have a function (i.e...

I did try a report but I couldn't seem to get the grouping to work properly. Perhaps you could explain how to group records by Staff member? The only real reason for using a form was that I thought I could populate the ListBox using VBA, which I find easier to do than using reports - but if it...

1. The list box shows a list of allocated to a staff member (more precisely, it finds jobs that were allocated before the "end date" parameter and which either have not closed or closed after the "start date" parameter - so all current jobs for a given staff member in the timeframe provided) 2...

It's ok, I've taken a backup :D. Ok, I've thrown my SQL into the RowSource. The date arguments being controls could be done, that sounds sensible. The problem I'm having now is that it's now showing all the records - it's not linking the StaffID in the SQL statement with the StaffID of the...

Yeah, the continuous form shows a record for each staff member in the database (so it should be bound to StaffID I imagine? It's a primary key/autonumber id field...). So, I've set my ControlSource to that now, how do I get the listbox to run the query using the StaffID as an argument? The...

Right. So, if i set the RowSource (or is it ControlSource? One of them!) to an SQL statement/Query, will that show different values properly? Thanks for the quick reply! - Javawag

On Current Event on a Continuous form Hi, I have a "continuous forms" Form set up which shows a listbox for each person in my database (well, I only put one in, called lstJobs, but as you know, on a continuous form it shows up once for each record instead of just once). I was hoping to...

Sorry to double post, but i thought i would explain how i solved this. I did try the suggestion of using a SubReport with a GROUP BY clause, which seemed to sort of work, but to have more power and control over how the data is pulled out and presented, I committed the ultimate sin. I actually...

Your first suggestion sounds good to me! Is that just using a SQL query with "GROUP BY" in it, and then showing in the elements column something like (psuedo-code): if elementID = 0 'all elements show "all elements" else if no dups 'just one element... use DCount to check this show...

I can't remember what normalization means - but I believe it means that the database uses multiple linked tables instead of just 1 table, which is true. I'd love to upload the database, but it's for work an has sensitive information on certain individuals, so I can't. However, I'll try to...

I understand that, because they're designed more for input than displaying data. I've tried using a subreport, but due to the way my tables are designed, some records are showing up more than once as duplicates! I was wondering, is there any kind of control I could use instead of a listbox...