Search results

Hi everybody.

I figured knowing the last proc that executed might be cleaner sometimes, easier to keep track of, than setting and resetting some kind of switch.

So yeah, it is stupid to do that. I ended up doing something different after rethinking it. Thanks a lot for all the comments! That helped a lot.

Detail is probably gonna be difficult. They are coupled necessarily in this case and its not all that messy. Everything is behind one form so all event subroutines, etc are unique. Passing the name works. I was just thinking it might be useful in general to be able to tell that. If its...

Thanks! But I was looking for a way to pass the name of a calling procedure to a subroutine, to do different things depending on which event called it for example. A better way than setting some kind of flag that is. If there was one.

Hope this isn't a stupid question. But is there a feature of some kind in VBA that will tell me what event called my subroutine? ...other than setting some kind of flag in the calling procedure. Like is there anything that will tell you what the currently executing event is as your sub routine...

I'm having the same problem. It's an database in .mdb format, 2002-2003. I haven't converted existing databases to .accdb, just do it with new ones. But it's just one of those so far I'm having this problem with. The backend is SQL Server, is the only linked objects in it. There was never an...

Hey thanks for this code! Works great.

Thanks! Both comments make sense. I was working with a lot of forms and sub forms. I think what was bugging me was having them open separatly as I was navigating between class modules using the explorer instead of going to each form first.

I'm experienceing some frusterating behavior in Access 2007 where when I'm editing VBA each form opens in design mode as I edit the code behind it, whether I started out from that form in design mode or not. So when I close the VBA editor I have a screen full of open forms in design mode in the...

Thanks! That was my thought too. That they weren't really doing anything. There are a lot of them though, with multiple keys that aren't really keys. So I was hesitant to leave them all out. But I think I really have no choice. I can't really do much data clean up. For one table, 75% of the...

Thanks for the thought. That's sort of the trouble though, replacing that kind of relationship in SQL Server. The problem is there are relationships set up in the Access backend that have Enforce Referential Integrety turned off creating an unenforced relationship. Several years of data now...

Sorry this is kind of a crappy title. I think I'm basically wondering what the affect of removing unenforced relationships that exist in an Access database might be? ...what potential problems I'm looking at by doing it basically. I'm moving the tables from an Access database to SQL Server...

I have checked both boxes to show the status bar, the one under Current Database and the one under Advanced. The status bar still does not show up in any Access database that I have. They are all A2003 .mdb databases. I don't know if that might be the problem or not. Does anyone know why...

Thanks!! That works great. I didn't really understand what missinglinq meant. I guess cause I wasn't trying to have anything happen when I clicked on something. Since they were talking about buttons vs. a textbox I figured he just meant you could format a text box, so use it instead of a...

This is my question as well. Namely... How do you set enabled to true on a control for a record where a condition, in that record, is met and false where it isn't on a continuous form? The current event doesn't work. Doesn't seem to be a good event for that in the list on the form.

Thank you!!!! ...I was having the same problem. Microsoft should get you to write the text for their error messages. :)