Search results

I have been developing a database that is now in the implementation stage. Everything is functioning very well except that after working in the database for a couple of hours, I get this message: "Can not open any more databases." I think this may be from improperly calling and closing...

I'm getting the 'can not open any more databases' error with Access 2010. This happens whenever I have about 6 forms open. I know some of my forms are pretty big, so I'd like to find some way of measuring how much each form eats up. Then perhaps, I can rework a single problem form. Is there a...

I used Steven Lebens code a few years ago to get and set the scroll bar position on a subform in Access 2003. Now that I've upgraded to 2007 I noticed that the code no longer does anything. There are no errors, but no results either. Looking on his site I don't see anything that talks about...

Hello, My boss just switched our entire company to Mac. For now, he is allowing people to use Parallels to run non-mac software (such as CorelDraw), but he has set a timetable for eliminating Parallels as well. Of course, this will kill the Access database that runs a large portion of our...

Is there any way to refer to a variable in a Form without literally spelling out its name - through a collection perhaps? For example: I am using a class module to handle multiple instances of a subform in the same form. Public basIF As New basItemFind '1st Instance for...

I'm running 2007 on Win 7. So far, I'd never had a problem with database corruption with this setup. But now, I can load the DB, open all forms with code that runs in the background - but I can't goto the VBA editor. If I press F11 then Access freezes. Something must have gone corrupt - Does...

This is really weird. I've been using this little function for years with no problem. It generates a message box where the first sentence is in bolt type (similar to the built in MS Access messages.) It has always worked until today. Now (and only in one case on one form), it will generate the...

I am finishing up a Access 2003 database in 2007 - retaining the .MDB format. I've noticed a few odd things, but have been unable to find any documentation addressing them. I'd like to know if anybody else has noticed the same things, or if I'm just weird or my computer is evil. 1) It seems...

I'm about to start a new project and would like to get your thoughts on a few different issues: 1) Macros vs. VBA My last project didn't use a single macro (except AutoExec and AutoKeys). With error handling for macros in 2007, is there a case for using them to handle repetitive tasks? For...

I would like to have more options than the 60 or so generic images that come up when you click the ... in the picture field of a command button. But, I can't figure out how to save a BMP in a way that Access will load transparently. Has anybody made their own transparent BMP and put it in a...

Is there any possible way to link to a query in the same way that you link to table in your back-end? I ran into a scenario where I have to update the SQL statement of a stored query on the fly - basically a temporary stored query instead of a temporary table. (Had to do this because 6 other...

When I add a filter to my form, the underlying query, of course, does not include the additional criteria from the form. I need to use the underlying query to supply data to an update query. But the update query must only affect records shown on my form. Is there any way to feed the form's...

I recently ran across a web site for a software package that proclaimed: "While Access is great if you want to organize your baseball card collection, everybody knows that if you want to get anything done you have to look elsewhere." Do all the Access haters have a point? It seems to me that...

I appear to have accidentally discovered something that may useful if anybody else can recreate it. Requerying a subform by referring to the control on the parent form appears to requery without losing the current record or the selected control on the subform. myForm!mySubForm.Requery -...

I've read that it's best to store a memo field in a seperate table, so I've got 2 tables: tblTrackingNumber & tblPurchaseOrderItem - one to many. I can't figure out why I can't edit the tracking number in this query: SELECT tblPurchaseOrderItem.PurchaseOrderItemID...

I have a table that shows links between items in an ordering database: SourceItem TargetItem 1000 1001 1001 1000 1001 1005 1005 1001 Item 1005 is not directly linked to item 1000. Is it possible to return all 3 items with a query? Some type of...

I'm about to jump up to Access 2007, mainly because of the Data Collection feature. My database sends out emails to our suppliers requesting the shipment of various items. I want to use data collection so that they can reply with delivery dates, etc... However, I read that the Data Collection...

I have two tables in a one to many relationship - tblOrder and tblOrderStatus. How can I create a query that returns each record in tblOrder and only the last matching record per order from tblOrderStatus? I've tried using a subquery for tblOrderStatus - with a TOP of 1 - but this only...

I thought that if you use a subquery you can't have an updatable query. This has always been true for me. But now I have a query that includes a subquery among its source tables and it is fully editable. Now I'm wondering if this is just a fluke, or if there is some logic behind it? Thanks...

When something is wrong with an order, my database generates an email to the purchasing manager, saying: Such and such is wrong with this order, etc... Is there any possible way to include a link in the email, that when user clicks will pop open access, load the correct form and goto the...