Search results

Ghallandra, been here since launch

Adam, The subform's control source is set to a select query. I am able to enter information into the subform. The subform saves the information entered to the table I originally had the control source set to. This is expected and normal? I thought a select query could only display...

Well, I changed the subform control source to a query and did as Craig instructed and it WORKS! THANK YOU CRAIG! To answer some of your questions AJ, The "due" column is used specifically in the command button cmdQC9. The button exports different fields on the form and subform to different...

For some reason the subform only "sees" one record at a time. Each field in txtUD is being populated with whatever record has focus. Me.txtUD = DSum("[UnitsOrdered]", "[Inventory Transactions]", "[Job]=" & Nz(Me.txtJob, 0) & " AND [PartNumber]=" & Nz(Me.txtPart, 0) & " AND [TransactionID]<=" &...

Craig, Thanks for the help. The code works if I select a record on the subform manually with the mouse. The funny thing is, it sets every due field to whatever value the record that has focus holds. Is it possible to have each record update individually and retain its value when the focus...

Yes, the Form is bound to a table named "Purchase Orders". The subform(datasheet view) I am working from is bound to a table named "Inventory Transactions". And all you want to do is change the value in an unbound textbox to sum up quantities in a certain field of a table where a part number...

I'm still unable to solve this. I keep getting a #Name? or #Error display in my control when I run the form. in the control txtUD I've set the following under the BeforeUpdate event Dim intUD as Integer Dim strPart as String Dim strJob as String intUD = DSum("[Inventory...

Date Job Part Description Price PO GPC Requested Received Due Rejected Invoice Number 11/9/2007 222 2252 bolts $2.25 27 CAM 5 3 2 0 MOSL223224 11/9/2007 222 2452 nuts $1.85...

Alright, I now have a better understanding of what queries can be used for. I don't believe a union query is necessary because one table holds all of the fields I need to work with. I may need a query to hold the values of each record since txtUD (Units Due) is not stored in an actual table...

=[UnitsOrdered]-[UnitsReceived] is how I keep track of units due. You think I have a normalization problem? That is one of my biggest fears, that I didn't set this up properly to begin with. I asked about it at one point and didn't receive any negative feedback on table structure. I am reading...

The next part of this project is pretty technical. I have a question… Purchase Orders Subform Date Job Part Description Price PO GPC Requested Received Due Rejected Invoice Number 11/9/2007 222 2252 bolts $2.25 27 CAM 5 3 2 0 MOSL223224 11/9/2007 222...

I do have a question about comparing string (text?) values to integers. Is this the best way? Dim strSQL as String strSQL = Me.[Purchase Orders Subform].Controls("UnitsReceived").Value If CInt(strSQL) > 0 Then .Cells(y, 5).Value = [Purchase Orders Subform].Form!UnitsReceived End If I want...

This whole process of moving the data from access to excel is being difficult. Date Part Number Description Unit Price PO ID: GPC Units Reqested Units Received Units Due Invoice Number 11/9/2007 2252 bolts $2.25 27 CAM 5 5 0 MOSL223224...

If strINV = strINP & strIDD > 0 Then... strINV is the invoice field in the subform. strINP is the value in the input box. strIDD > 0 is supposed to see if the value in strIDD is greater than the number zero, but from what I derived from your earlier post a string can't compare to a numerical...

That was it, I used the & symbol instead of And and now, it works. What is cint(strIDD) ? what does the cint do?

I am trying to use an input box value as a parameter to return values, it is comming back blank. If I remove the input box related code, it returns all values, so there must be an error with the input box coding. Can someone help me identify it? Private Sub cmdQC9_Click() Dim strINP As String...

Well, Its sort of working, but not really, it is posting everything over, even the rows with a value of 0, so the If statement code is doing absolutely nothing at all I guess.

Yes it shows the first value, which is 5 in the proper field I called for.

I'm sorry guys, I'm trying all the things you're suggesting. I'm actually really new at VBA, just sort of dove in and now I'm over my head I guess. I'm trying each suggestion I get. How can I look at the string in a message box? I assume you want me to try this to see if its holding a value at...

What would you suggest? I've tried... If strIDD > 0 THEN and it doesn't work either. Nothing I've tried works yet.