Search results

Hi all, I have an interesting issue and I was wondering if anyone has seen the same thing. We have an access database which has an oracle ODBC linked table. It is a large table with ~2.9 million records. A few days ago the table was working fine, opened instantly in Access. The DBAs have...

Hi folks, I have noticed this issue a couple of time and I know the solution but have no idea how it happens. Just wondering if anyone has seen this before? On a couple of users computers, not all users and not a the same time, users have been been getting errors in VBA where the Microsoft...

Thanks! I have heard before that access 97 will be the best for performance. I am glad to hear that they will be okay.

Hey, was hoping somebody could help me. I hope this has not been answered somewhere before but I could not find it. Our office is stuck using access 97. For obvious reasons I would like to follow the rest of the world into this century and move to 2010. Problem is that over the years many...

Thanks for all of the replies! I believe the OnError action is only available in the later versions of access. Unfortunately I am restricted to 97 for now. I also had the idea of trying to find a way of looping through actions in a macro so I could parse them and then handle each action as...

Oh well, thanks anyway! At least I know it can't be done now.

Well the thing is that we have loads of access macros that are running as scheduled tasks. The whole process was set up by people who are not very experienced with access and has now snowballed a bit. We are not even sure what macros are even needed any more and lots of them are throwing errors...

Hey, Does anybody know of a way in Access 97 to trap an error thrown by a macro. The macro is been called in vba by docmd.runmacro so I presumed that the error thrown by the macro would be caught by VBA error handling but it is not. Any ideas? Ps. I know this is easier in the newest versions...

Hey Rich, Would this work in the on_delete event? So users could hit the delete key instead of having to click the button?

Yes a role would be a customer, supplier etc. The reason I did this is because there are going to be alot of companies and I want to be able to filter the list to only show appropriate companies in certain situations, eg: when selecting a customer in a transaction only show companies with a...

I still don't see how I can tell if no records will be left after the delete is executed... If I look to see how many records are left in the if statement of the on delete event, it will still get the amount of records before the deletions, same as if I do it in the before update statement...

Hi vbaInet, thanks for replying. That sounds good but the only problem is that the subform is displayed as a datasheet, which I should have mentioned before! Therefore the user can delete more than one record at a time. I would prefer to display the form as a datasheet but if it is the only...

Hi! Can anybody help please? I have a form frmCompany and a subform fsubCompanyRole in an ms access front end. They are bound by tables tblCompany and tblCompanyRole and linked by lngCompanyId in an ms access backend. I want to stop users deleting all records from fsubCompanyRole for any...

Probably not exactly what you are looking for but I find this good... http://allenbrowne.com/ser-51.html There is also a link to wrapper class for the calendar control at the bottom of the page.

Hi, You can use a subquery to return a list of emloyee ids that occur 3 or more times and then use this in the where clause of your main query. SELECT * FROM YourTable WHERE EmployeeId IN ( SELECT EmployeeId FROM YourTable GROUP BY EmployeeId HAVING COUNT(EmployeeId) >= 3 )

Hey Rob, try putting me.Refresh in the AfterInsert event of the form. This should make recent changes to the database visible in you combo boxes. Private Sub Form_AfterInsert() Me.Refresh End Sub

I'm very new on this forum so I hope nobody minds me butting in but I was browsing the threads and thought I could help... Assuming your combo box is called cmbQueries, try this in the AfterUpdate event for cmbQueries. The error catching is neccessary because you cannot execute a select query...