phytorion
Last Activity: Mar 27 '08, 01:31 PM
Joined: Feb 21 '07
Location: Outside of Milwaukee, WI
-
errors out and say i can't have an aggregate function. I'm not really sure what the limits are to the Dlookup() are but i'm guessing it can only handle one statement in the where clause. Is there a function i'm not thinking of that i should be using?... -
Loading text box after combobox selection
This seems like it should be simple to do but i can't seem to get anything to work. I result i'm looking for is after a user selects a "Build Name" from a combo box it goes to the the table "tblWORK_DETAIL " and returns the field(in this case "RESOURCE_I D" where "WORK_DATE" is the newest work date for the given "BUILD_NAME ".
This is the SQL:
...Code:SELECT A.RESOURCE_ID
-
Updating a Table from VBA
I'm trying to to update columns in a table in access from values entered in a form. I think my code is bombing because it doesn't know the table i'm trying to update. Does anyone know the syntax to point to an access table? (In this case tblWORK_DETAIL) This is a simplified version of what i'm trying to do.
...Code:DoCmd.RunSQL ("Update " & tblWORK_DETAIL & "Set BUILD_NAME = " & Me.cboBUILD_NAME) -
Thanks NeoPa i think that should work.
Eric...Leave a comment:
-
Using VBA SQL returned values
so my problem is I want to use the values returned from the below SQL to populate textboxes etc. on my form. Is there a way to assign these values(VALUE1,V ALUE2) to variables?
Thanks,
Eric
...Code:Dim strSQL As String strSQL = "SELECT A.VALUE1, A.VALUE2 FROM tblWORK_DETAIL A WHERE A.BUILD_NAME='" & Me.cboBUILD_NAME.Value & "’ " & _ -
If i understand what your looking for. you can enter the formula =SUM(A1:A52) into the cell where you want to have the sum of all your weekly incomes from columns A1 to A52.
You probably want to format the cells for currency as well. You does this by highlighting the entire column by right clicking on the A at the top and selecting "format cells" and selecting currency.
Hope this helps,
Eric...Leave a comment:
-
It isn't really a solution for this problem i used and action query to add all the rows in one table so i didn't need the combo box to switch between the two tables.Leave a comment:
-
Thanks for the help but i found a work around.
EricLeave a comment:
-
Nevermind I solved the problem. Thanks for all the help
EricLeave a comment:
-
Alright one more question...The DELETE SRCE_TBL_STRUCT URE.* seems to of solve my original problem,(atleas t its stepping further through before it errors out),but now its giving me an error saying i have to few parameters(expe cts 6). The problem is that the three parameters i listed are what identifies the rows i want to delete. Is there a way to pass a wildcard or ignore the rest of the parameters it's expecting?
[code=vb]PARAMETERS...Leave a comment:
-
Alright thank you for all your help. I think i know what i need to change now.
EricLeave a comment:
-
Just to clarify my understanding. There is not a way to delete only certain rows in a join delete. So I'm going to have to delete everything and then reload the table....Leave a comment:
-
Any tips on how to add a column to a linked table. It won't let me save a new column in the table. I need to insert the field to bind the combobox to.
Eric...Leave a comment:
-
Auto filling ComboBox?
idk why this is giving me such a problem but here it is. I need to add a combobox to a continuous form. This combobox needs to allow the user to select between "S" and "T" for each record in this recordset. I've tried to make it work selecting the values from a table and i've tried just having a valuelist in the combobox. both give me the same result when i run it, when you select a value it automatically selects that value... -
I thought that was the definition of Insanity....Leave a comment:
-
That would be a great spelling bee word. I could just see the look on contestants faces =O...Leave a comment:
-
STREAKING!!
123456789...Leave a comment:
-
No it says "Specify the target table and records you want to Delete" in a msg box and then exits.Leave a comment:
-
I've tried substutition variables and when i step through the VB code i can see that the correct variables are being looked up. i think that the error is coming when its trying to pass the actual parameters. This is the SQL for the delete query. Any ideas? Thanks
Eric
[code=sql]
PARAMETERS
[Target Table] Text ( 255 ),
[App Vsn] Text ( 255 ),
[Cust ID] Text ( 255 );
DELETE...Leave a comment:
-
Thanks for the reply. I've tried switching the the lines you suggested but it didn't seem to solve anything. I'm thinking this is going to be a little to involved for help over the web. Do you have any suggestions on Helpful reading material that covers querydefs in detail so i can better understand how they work?
EricLeave a comment:
No activity results to display
Leave a comment: