Recent content by Nelz

Well, thats what the customer wants. They want to save the tables for a while. It is a multi user enviornment. I had it set up to just use one table , then they could export the e-mail addresses to their mail program...but they said they got confused as to what customer type they were...

I have a query that creates a list of e-mails on the fly from current data. The user uses a form with a drop down selector to run the make table query, and the query uses the critera from the drop down list as type of customer to generate the lists. The problem is...since it is a make table...

OK, so basically what I did was to add a field to the form for OrderPersonID .....then I put in the OnClick event of the combo box Private Sub OrderPersonID_Click() Me![Text144] = [OrderPersonID].[Column](0) End Sub Text144 is the text field for the OrderPersonID . Its confusing, because the...

I have a combo box that displays peoples names, as well as their ID numbers. When the user selects a person from the list (only their names are displayed) I want to have their name entered in the [OrderPerson] field of the order, and their number entered in the [OrderPersonID] field...

OK...I think I have it. I changed the name of the combo box that selects the number to SelectOption... I changed the code on the text box to this: Private Sub Text58_GotFocus() Me.Text58.ControlSource = "Opt" & Me.SelectOption & "Name" End Sub It worked. It updated the...

Well ...I caught one mistake. I had Text 58 as my number and I left your text47 in there. Changed that, and I now get the Contrlo Source being set....but without the number in the middle. It just says OptName no string number in the middle...

Well...I tried what you suggested...I have: Private Sub Text58_GotFocus() Me.Text47.ControlSource = "Opt" & Trim(strNo) & "Name" Me.Refresh End Sub for the text box... I have the form linked to the appropriate table...and I have this code for the combo box that picks the...

Hmmm...I was able to build the first part and create the appropriate field names in text boxes on the form from a numerical dropdown list as you suggested...I just cant get the update query to recognize that text box on the form as a valid field name in the query.... I am not following the VBA...

I tried this: "Opt" & [Forms]![Options form]![Text8] & "Name" as the field name...but it doesnt work....

I can do a little if i have instructions....I've used it some.. Heres the problem somewhat reworded... I want to make an update query...and in the field name I want the part of the field's name that's a number (the fields are named Opt1Name, Opt2Name, Opt3Name etc... ) to get its value from an...

well...basically I want to inser t a variable in the field name that I want to update. Like in an update query it asks which field to update...and instad of calling the field Opt1name I want to call it Opt[variable number]name where the variable number is a number entered either in the...

I have a query that I want to use to append a table. I have 10 sets of fields that can be updated, and I want to use the same form to update ANY of the 10 sets of fields. The field names are the same except for the number.....for example...there is a fild in the table called Opt8Choices...

I am using Access 2000. Any ideas about a "find and replace" throughout the entire database? Can you do that within the modules or something? Thanks again.

Well, thanks to all. I guess I will clean up the data...that makes sense. I dont understand the concept of the Clng expression I guess. I took it from a sample database that used that formula to calculate sales tax.. What I should have done is stored the total somewhere....but I actually...

Thanks... I have already gone through my entire application and changed all the formulas to be the same....(the Clng version as opposed to the other...there were some of each before depending on when it was I built it (lol) ... Anyway...my current solution was to put >0.009 or <-0.009 in the...