#name? on form text box

[wptaylor4]

I am setting up VBA to run multiple append queries in consecutive order. The append queries are supposed to pull a four digit number off of a form that will allow them to know which data to append. I want the number to be stored as text to correspond with the tables I am working with, but I am having trouble getting the form to work.



Here is how I would like it to work:

I enter my 4 digits in the text box on the form. Say "1305" for May 2013. I want to then run my vba (my queries update using the forms!txtupdatequery!textbox I have put in the criteria of the queries) and all of them run.

Is anybody able to help with that? I enter my date (as a number but I want it to be text) and the form gives me a #name? error.

[rpeare]

You're leaving something out but I don't know what it is.

You enter 1305 in a text box on a form
You run a series of append queries (which you say all run, does that mean they all run correctly?)
<something is missing here>
you're getting a #name? error but you don't mention where, is it on a table, a query, a report?
typically this happens when you try to perform an operation on an incompatible data type, for instance trying to do something like AAAA + 42

you can change the nature of your string using the cstr() to change something to a string value or cint() or cdbl() to change a string to a numeric value.

Check the properties of your text box on your form, does it say numeric? if it does you're going to want to change it to text.

[wptaylor4]

Hi, sorry, let me try and clarify.

I have 13 append queries that I would like to run back to back each month. They normally update from a parameter that asks for the period (for example, 1305). I am trying to change them to all run off of a form where I can enter the period into a text box once and and not have to do it 13 times ([forms]![txtupdatequery]![textbox]). I will then use vba to update them all in a row with one click (docmd.openquery(queries 1 through 13)). However, I am having trouble with the execution. When I close my form the #name? comes up, and my when my queries run random parameter boxes are still popping up.

I want to make it so that I enter my number (ex 1305) in my form, start my module (all the docmd.openqueries), walk away and they will append. Is there any way to do that? Is the name thing just something that will happen after I close and re-open the form?

[wptaylor4]

I am actually starting to realize that this is not really my problem. I believe I will start a new thread (with more clarity). This one can be deleted.