Search results

Re: "ActiveX component can't create object" when calling QuickBooks SDK functions Never mind.... I installed only Access 2007 32bit along side of Office 2013 64 bit. Then just opened up a copy of my database pre 64bit modifications and then everything was working just as it was previously...

Re: "ActiveX component can't create object" when calling QuickBooks SDK functions OK, so i jumped the gun a little on this post as I think I found out at least "why" I am getting errors. Viewing the following site, it seems like the QuickBooks SDK only supports 32 bit systems...

"ActiveX component can't create object" when calling QuickBooks SDK functions Hello, I have an older database created with Access 2010 (32bit) that I haven't uses in a while. This DB had lots of VBA code used to communicate with Quickbooks using their SDK which information can be found here...

Hey all Thanks for the suggestions. Sounds like they should work. I haven’t tried it yet though as I ran into other snags with access in general regarding not being able to import a simple spreadsheet into any database, then getting some random active x error. Been working on those which is...

I have a table holding banking transaction information (exported from quickbooks). This table holds a few thousand records. I am using Access to get some quick results so this database does not have a separate “payee” table with a relationship to the transaction but is only a single table with...

Ok so this question might be a little off topic for this heading but hopefully someone can at least point me in the right direction. My company software uses a MySQL database for its back end data. Its front end software is pretty primitive and basic. I am using MS Access to make up for the...

I don't know if this would be a query question, report question, or even an Excel question but here it is... I need to file an annual report that lists all customers (with basic info like name, invoice date, service address and total amount) who had more than 1 invoice in our system for the year...

Thanks for a suggestion. I've been tinkering with this all weekend, but still cant seem to figure it out. I was originally having trouble getting the layout correct for just one page, yet alone figuring out the two page report. The way I figured out the layout of the one page is that I just...

I have a 2 page paper form/report (however you want to categorize it) that I manually have to fill out and submit every month. I am trying to digitize this process using Access but am having difficulties. This paper form is actually pretty simple. The top third of both pages contain just...

I have a simple question but its hard to explain exactly what I mean. Ill give it a try... I have simple table data structured as follows; [Origin], , [Weight]. The Code field is a lookup field that will contain one of 8 choices; 10, 13, 13c, 23, 25, 27, 27a, & other. The other fields are pretty...

Thanks... Inner joins yields the same results as described originally. In all honesty this query data is not intended for a form/report to be bound to. It is intended to be manipulated via VBA code (opened as a VBA recordset) and data updated within that code.

I am trying to create a query consisting of 3 different tables. All tables have a relationship on the CustomerID field. My problem is that every variety of design I come up with, the query is still NOT updatable and I need it to be. Here's the strange thing... When I create this query in...

Thanks Bob Fitz and Mile-O... Those were 2 ideas I thought up after posting this. nanscombe - I never worked with tempvars before. Will try it out and see how it works for this situation.

Thanks didn't know that. Now any suggestions on how to have that form return a value to the calling procedure? for now I just plan on using something in the message box form like (forgive syntax, haven't actually written it yet): "Forms!"calling form"!ControlName.Value = "value...

I have created a custom message box form that suits my needs for this particular situation. It is called (opened) in the middle of a bunch of other VBA procedures. What I am having a problem with is how do I "pause" the rest of the code from running after the message box call? For example...

Thanks for you response. I decided to go a whole other route with this. I don't need to go into the details since im not using it anymore, but I think my problem had to do with several dlookup() and insrt() functions used. You see the original tables were actually queries based on the...

I have a simple query where ultimately my goal is to count the number of certain items sold between certain dates, but I am having problems before I can even get to that. It is a simple invoice/invoice item query but it is taking unusually long to open even before even I apply any filters to it...

Thanks for the suggestions... I have already tried to import objects into a new database before starting this thread, but after I select the "corrupted" database to import from, I get the same error messages stated in my original post. I also was able to open the database while holding Shift to...

Sorry for the delay, have a new problem I am working on which I just posted a new question for that. My new problem is preventing me from accessing my VBA code, so this is off the top of my head here... From my memory I think I was inncorect. Function2 does not actually have an error trap...

I have a database saved on a flash drive. I use this copy whenever I make any updates to it, and keep the production one on my hard drive for actual use and copy it over as the updates are completed. I was making updates last night and quit for the night in the middle of something. I left the...