Search results

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

Well to add more information to my original post, the field is actually already a combo box, the limit to list is set to Yes and I am using the NotInList event procedure to display a custom msgbox asking the user if they want to add the customer and if so then opens the appropiate form to add...

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

Sorry to reply to my own post, but this is an important issue that I need to correct. I figure that maybe my original post was long and confusing which is why it got no responses, so I will re-describe it now in a simpler manner: Basically I have an Orders form based on a query. That query...

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

Thanks for all the suggestions. As stated in my third post in the time it took to write this all out and get responses I just did the dirty work I was originally trying to avoid. I entered all the fields I needed in the query and used totals to not display the duplicates, then saved it and...

When I try to run that query it asks me for a value for [Orders].[Customer ID]. I added the Orders table without adding any inner/left/right joins and a few other modifications, and I got it to work, but that still doesn't solve my problem about having to add those 40 or so fields manually. Its...

I kind of caught that after I posted it. Actually I do NOT need any information from the orders table just the Customers table. I just need a list of customers that have open orders

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

Ok, so what I am understanding your response as is... I have some action on my main form that triggers the open of my message box form. I select the apropiate answer on my message box form and, lets say the onClick of the "Yes" answer I attach an update query that updates the record of the table...

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

Thanks good thoughts...I tried that and it is working.

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

I am creating a XML document in VBA using MSXML 6 object library. I have written all the code to create the document, but am missing the declaration line of the document (<?xml version="1.0" encoding="utf-8"?>). How do I enter this line? My code format is as follows (not my actual code, but...

Thanks. I dont know if I am misunderstanding your answer or you are misunderstanding my question, but to go back to my msgbox() example, notice where the arrow is pointing to in my attached picture. Do you see the "drop down" options I can select from? I named my post "Custom Type" because I...

Im not sure if my title is the correct terminology, but I am writing a function in VBA that I will need to call many times in my future designing. One of the parameters being sent to this function will be one of 5 set options. What I want is when I am calling that function within VBA editor...