Search results

"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...

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...

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...

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...

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...

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...

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...

I have a function (lets call it Function1) that runs several calulations and etc. One of the first lines of this function is the error handling line of: On Error goto err Then in the err section I have the appropiate error trapping code. Somewhere in the middle of Function1 I call Function2...

I am geting the error "You tried to assign the Null value to a variable that is not a Variant data type" after deleting the data from a field. I kinda get why I am getting the error, but I need to find a way to avoid the user getting it. Also, no code behind it is trying to assign any value to...

I recently modified a query, which obviously did something to it because it worked before, but I'll explain in more detail. My problem is that when I am trying to enter a new record I cannot modify any fields that are "auto populated". By "auto populated" I mean, the query is for an orders...

I have a Customers form and I want to place in a subform that is based on a query that is based on a linked MySQL database table. I have created the form that will become the subform, and when opened, it displays everything correctly, but of course shows all records in the table. When I insert...

I have a table where I need to create a running total column, but its not as simple as a regular totals query. The underlying table is a charges table from a linked MySQL database, from which I did not design nor am i able to modify any structure of, and I am creating the query in Access. The...

If anybody is keeping track, I did post a similar question a few months ago, but this is slightly different. I am receiving an XML document as a response from a server and I need to parse it and retrieve data from that document. There is sample code and documentation about how to do this...

I need to complie a list of customers with open orders. This one should be pretty simple but I am stummped on how to get it. I have the following query, but it returns a list of each open order for each customer, essentially listing the same customer multiple times (if they have multiple open...

I have several situations where I need to get data entered on form2 into form1 where form2 is an unboud form. For example, I have situations where a simple msgbox() function will not suit my needs so I created some so called custom "message box forms". (situations like I need to change the...

I have an invoice form with an invoice subform displaying the items and amounts (similar to the Northwind Orders form). I need to have the invoice total be saved in the underlying invoice table once a button is clicked (which when clicked, does other things also). I kinda got it, but just...

This has probably been asked a thousand times, but even with all my searches I still cannot find the correct answer for my situation. I need to mask a SSN field and display only the last 4 digits so it would display like "XXX-XX-1234" I figured out that I can just set the control source to...