Search results for query: *

Hi, this is written in VBScript, but the query values are not working, I am still retrieving a years worth of data instead of just the data I am looking for. Query.AdditionalCriteria = "Date_Shipped >='" & dStartDate &"'" Query.AdditionalCriteria = "Date_Shipped <='" & dEndDate & "'"

Good morning, I posted the following thread in the forms forum, but recieved no response, does anyone have suggestions? thread702-928194

Good morning, How do I display a text field as multiline in a datagrid view on a form, such as I have a description field on a form, it can have 255 characters, but in the datagrid I want it to display to fit the grid, this also needs to carry over to the report.. any suggestions?

Good Afternoon, I have two forms, frmMain and frmAddChange. On my frmMain there is a button cmdOpenAddForm that when clicks opens the frmAddRecord Private Sub cmdOpenAddForm_Click() On Error GoTo Err_cmdOpenAddForm_Click Dim stDocName As String Dim stLinkCriteria As String...

Good Morning, I have 4 comboboxes on my form cboEmployees cboSystem cboReason cboType these are bound to the corresponding tables with select statments ex: SELECT Employees.EmployeeID, Employees.LastName FROM Employees; I have another table called ChangeDetails, this tables stores the ID...

Please see thread Default Value of Option Groups thread703-921823

Good Morning, I have a form with 1 textbox, (NOT UPDATABLE, the value is pulled in via a module is_modGetCurrentID()) 3 comboboxes and one list box, here is what I want to do. I want to have the the values input from my table into the corresponding comboboxes for the existing records, here is...

Good afternoon, I want to update my account table delivery value based on what is choosen in teh option group, but at load time I want the value to equal what is currently stored in the account table, how do I do this? I tried to set the default value of the frmDelivery =...

Good Morning, I have three option buttons on a form stored within a frame I want to reference them such as: If opt70 is chose then do commands else if opt140 is chose then do commands else do commands end if. This is how I currently have it, but the frmDelivery.Value is obviously not the right...

Here is my query first off UPDATE api_tblTmpJobQuote INNER JOIN user_tblJobProp ON api_tblTmpJobQuote.[Job ID] = user_tblJobProp.ID SET user_tblJobProp.Delivery_Charge = Sum([api_tblTmpJobQuote]![TrussExtPrice]) group by api_tblTmpJobQuote.[Job ID],user_tblJobProp.ID ; What I want to do is...

thread703-920938 I have not recieved any responses, I was hoping someone in here might be able to point me in the right direction

Good Morning/Afternoon, I have a report [api_rptJobQuote] that I have made some modifications to, this report is generated from a query, I have removed fields from the report, however at run-time I am asked for the parameters of these two non-existant table fields, I have checked the vba code...

Good Morning, The following is a transcript from the Access Forum I am hoping someone in this forum will be able to pinpoint the problem with the statement. The SQL statment is not updating the field. MsMope (IS/IT--Manageme) Sep 16, 2004 Alright, here is the last mod to this, I found a...

Good Morning, I have a variable jobID which is set to a value within a recordset. Set JobID = rs.Fields("Parent_ID") Later on in the code I want to reference the value stored in the variable in a SQL statement such as: strSQL = "UPDATE user_tblJobProp" & _ "SET...

Good Afternoon, I need to update a record in a table (user_tblJobProp)based on a selection in an option group on a form, however I need to know how to store the current records ID or call the current record ID into a variable, Any ideas? Private Sub frmDelivery_AfterUpdate() Dim strSQL As...

hello, I am reviewing the attached code and trying to add an additional job status condition, "on hold" If this is the chosen condition I want to input the system date into ctldate_changed. However, when I attempt to do this I recieve error " | is not found", or ctldate_changed, must have...

Does anyone know how to relatively record a macro in excel 2003?

Location: Posts: 1 MultiSheet macro, to sum based on condition I have a three sheet workbook, one sheet is a summary sheet, the second is a data sheet and the third contains the constants. I need to sum information from sheet2 and display in sheet1, sound simple enough. I am summing the...

Good Morning, I have an enumerations declared in a common class written in C# (company.common) I want to dispaly the members of this enumeration in my comboBox(cboCategories). Any Ideas? Private mBuilderNote As New WausauHomes.BuilderProfile.whws.wausauhomes.com.builderservices.NoteTypes

Good Afternoon, I have a combobox on my form (cboBuilderName) that I am filling with an array: Private mBuilderCompany() As Builder = mBuilder.GetBuilders("") Dim pintCount As Integer For pintCount = 0 To mBuilderCompany. _...