Thanks SFreeman. You stirred my memory. I shall try the Requery Method on the "after update" event because, if I am reading the documentation correctly, Requery Method reflects addtions & deletions to the recordset.
All:
I have been programming in Access for 9 years. The other day a user in a department I service asked me for help with a database he had created and was having the following problem with:
Clerk A enters record 1 on a form bound to access table and then goes on to enter more records on the...
Dear fellow members,
I need to loop through a table (or view created by a query) reading and processing one record at a time. I know this is possible but am experiencing a mental block on how to do it in VBA. Can anyone out there give me an example?
Much thanks,
Demivolt
What is dual booting? Booting using partitioned hard drives? Booting with separate hard drives? Also, from reading other threads associated with this issue, I've gleaned that Micosoft doesn't "support" VI6 with WinMe, as in "offer tech support," but can VI6 be made to work...
Rich
I tried the project setting you suggested, but to no avail. However, I apparently don't
have any service packs installed on VI6 because they areen't mentioned in the "about." My version is 8426-. I originally installed VI6 when I installed Visual Studio 6.0. Since then I have...
Fellow subscribers:
I'm a SQL-VB programmer just starting out in VisualInterDev 6. I have
VI6 installed on my office machine (Win2000) and everything works okay. I also
installed VI6 (pro edtion) on my home machine (WinMe) and when I try
to start a new project VI6 tells me it can't find the...
Donald, here is the code plus some instruction. If you need further elaboration
don't hesitate to post it here. Please note, in posting this I may have misplaced a
comment (') or a line-continuation character so you might want to review the
2 code modules I first pasted in and then edited to...
Stew, much thanks for your nudge in the right direction. I found 2 samples of the code you mentioned right here on Tek-Tips ( plus links to samples in other sites); and, through cannibalization as well as at bit of my own code, was able to cobble together the VB6 exe, the VBA code and Access...
Yes, I know the .ldb won't go away as long as I'm in the DB. It also hangs around while NO ONE IS IN IT! I'm trying to work around a domain/Office 2000 bug. This is what I mean by FALSE LOCKING.
I need the ability to delete a Access Locking database (.ldb) that may or may not be in use. I'm attempting to work around some false locking problems on a file server that occur when I have to compact/repair/change an Access DB. I might be the only one in the database but still I am locked...
I also installed SR1a and it did not help even thougth the MS KB said it would. This was 2-3 months ago. After still encountering the problem I opened a (free) incident with MS tech support. Their tech was very willing to work with me and we did a good bit of testing. He also sent me 2...
Dear Terry,
Thanks for pointing me in the right direction. The chapter on triggers mentioned
the Inserted & Deleted tables as well as giving some examples, but apparently I was
mentally adrift when I read this part. I paid closer attention this time & now see my solution. Once again, thanks.
Dear subscribers,
>
> I have triggers attached to a number of tables in a vendor's database.
> When certain columns in these tables are updated or inserted to, the
> trigger fires a stored procedure that builds a table containing all records
> within a rather broad range. Because the database...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.