Search results

docmd.openform ("formname") forms("formname").filter = "[ID] = " & sID forms("formname").filteron = true That works but I never figured out why it was ignoring the filter on my original line. Oh well!

Yep, I checked that already and if they weren't allowed it should block it even on the 2nd attempt. I don't understand why it isn't working but it should work another way by just doing... forms("formname").filter = "[ID] = " & sID forms("formname").filteron = true Sorry, I should have thought...

It is being called from a button on a separate form. I do want the filter but it is not being applied. I am assuming there is a form property barring it from working because this works on a trial database I tested it on.

My code seems to ignore the WHERE condition when it initially opens the form but if I run it a second time with the form already open the filter is applied. Just seeking advice on what property on the form could be blocking this from working properly because in a simplified database I tested...

There are relationships based on those keys that will make the move to Access a lot cleaner if they stay the same.

Right, but what I was doing was adding an autonumber after records have been added. I'll give a bit more information so you can understand what I was doing. We are changing to Access from a different database software so I'm importing tables from that previous database. There is an existing...

I was adding an autonumber field to an existing table and I assumed the numbering would follow the order of the primary key but that doesn't seem to be the case. I was curious if anyone could shed some light on this.

Yep, that works perfectly. Thanks once again!

Thanks for your responses and patience with me. That makes sense, I had that originally but was trying to add more and more when it wasn't working with the ApplyFilter event and obviously that didn't solve anything. Should that code you provided work with the ApplyFilter event because I'm not...

Thanks! That makes some sense to me but your knowledge is somewhat wasted on me because I'm pretty clueless! I've been learning as I go so I don't know much about parameters in cases where the code builder automatically generates them. I'm still not figuring out how to consistently link the...

The outcome of the code is when you toggle the filter (using the toggle filter button) off you get a message saying "filter ON" and when you toggle it on you get a message saying "filter off". So either I'm misunderstanding something or the toggle filter button is a bit weird. It returns the...

You probably have given up hope on doing this since this is an old post but I was scouring the internet for a way to do this very same thing several months back and I did eventually find a way. All credit is given to Amir Parmar's channel on YouTube. That's where I got most of the help I...

I have a form where I originally was going to have a table view subform but the users requested that it be a popup window so it could show more information and could be dragged to another monitor and viewed at the same time as a data entry form. I had the two forms up and running with the...

Thanks, that's helpful. I guess how we use our database differs from how others use theirs. I can understand why partial records or constant saving would be a problem in many databases but in our case I don't see it being a problem.

Right, that is exactly what I'm looking for. Is there an event you can safely tie this to that would do this passively rather than require a user to click save? Thanks!

Sorry if I wasn't clear. It does save when I go to another record. My issue is that is the only time it saves. What I'm asking is if there is a way to save as you enter the information.

Within the database I've been building I have a form that has ~30 fields. I have a fear that users will be very unhappy with me when the data they've entered gets lost. Perhaps I have built the database improperly (this is my first attempt) but it seems strange to me that a record isn't saved...

Ooop, that was easy, a compact & repair fixed it

I've been in the process of building my first Access database over the past few weeks. It has been pretty enjoyable so far but I just came across something that worries me. When I go to make a report or form and click 'add existing fields' my main table shows as ~TMPCLP followed by various...

Thanks for the responses. That's a bit awkward, I found a pretty obvious error in my code so it was actually working exactly as written, it just wasn't what I had intended it to do! Which seems to often be the case. I thought I'd looked over it a dozen times so carefully, I guess I just needed...