Search results

Perhaps I can use the two queries to create a temporary table and then export the table to excel? mafhobb

Ok, I'll try that. But what about having the two queries export to the same excel sheet? How can I organize the data in the sheet. Nothing fancy, just a couple of headers, one set of results from the first query, then another set of headers and the results from the second query mafhobb

Hi On a form I have a listbox that gets its data from this query: SELECT [Stats SKU Issue Type Percent].[IssueType], [Stats SKU Issue Type Percent].[Stats SKU Issue Type].[CountOfIssueTypeID], [Stats SKU Issue Type Percent].[Stats SKU Issue Type Total].[CountOfIssueTypeID], [Stats SKU Issue...

This did it! 'Set focus to frmInvParts Subform Control on frmInv (Parts is the Control Name) Forms![frmInv].Form.[Parts].SetFocus With Forms![frmInv]![Parts].Form .Recordset.AddNew End With Thanks mafhobb

Thank you Minty, So how do I put the subform in "new Record" mode...but only using VBA in this sub, because this subform can be opened from other forms and it is fine as is. I believe that I need to use DoCmd.GoToRecord , , acNewRec on the subform, except that I do not know how to invoke this...

I have a pop up continuous form (frmEspecialServiceParts) with a bunch of data and a "Add Data" button on each record. I also have a form (frmInv) with a subform on it (frmInvParts). The control name for this subform is Parts. What I need to do is to copy the data selected by the user on...

Yes. This was it! Many, many, many thanks!!!! mafhobb

uh? Could you elaborate on that? I do not know what you are talking about. I believe that all computers are running Windows 7. mafhobb

Hello. I am running into a situation that has me completely baffled. I have been working on a database for a few years without any issues. Approximately every 3-4 months I upload a new version with new functionality. A few days ago I uploaded a new front end (V1.14) to some computers. The...

Hi I have the following line of code near the end of an error-reporting function: If ErrorNumber = 3075 Or ErrorNumber = 2471 Or ErrorNumber = 2450 Or ErrorNumber = 2491 Then MsgBox "In der Ausführung ist ein Fehler aufgetreten. Sie müssen die Database neu starten. Error = "...

Hi I have a table with a field that gets its values from a combobox. The combobox values come from a list. This db has been in use for months and there are thousands of records in it, unfortunately there is a typo in one of the values I typed for the combobox and that means that this typo is...

This is what did it: If Me.cmbSearch.Value <> "" Or Not IsNull(Me.cmbSearch) Then If fraResOption = 1 Then Me.lstsearch.RowSource = "Select [ContactID], [maxofsubcallid], [CallID], [SubCallDate], [SKU], [WhoPickedUp], [IssueType], [StatusAfterCall], [ResolutionDetails]...

Ok, so something like this: If chkboxInProcess=1 then ..... "Where [StatusAfterCall]="In Process 1" OR [StatusAfterCall]="In Process 2" OR [Status After Call]="In Process 3" OR.......& "Order By [StatusAfterCall], [SubCallDate]; " ..... ElseIf chkboxFinished=1 then ..... "Where...

Hi I have been asked to modify a form that uses the following query to display results: Me.lstsearch.RowSource = "Select [ContactID], [maxofsubcallid], [CallID], [SubCallDate], [SKU], [WhoPickedUp], [IssueType], [StatusAfterCall], [ResolutionDetails], [CustomerID] " & _...

This is what did it! If Me.OpenArgs <> "" Then strFilter = Me.OpenArgs Me.Filter = "[AutoEmailCode] like '*" & strFilter & "*'" Me.FilterOn = True End If Thanks a bunch! mafhobb

Thanks Minty, but no luck yet... When I modify the code as you show I get an empty continuous form. It looks like the "Like" parameter is not working.

I am trying to filter a bound, continuous form on load so it displays only the records with a specific field containing a string somewhere in the field value. This is what I have: If Me.OpenArgs <> "" Then strFilter = Me.OpenArgs Me.Filter = "[AutoEmailCode] like &...

Is it possible to embed images in an SMTP e-mail?

I have STMP code that I use to send e-mail messages from a database. Dim iMsg Dim iConf Const cdoSendUsingPort = 2 Set iMsg = CreateObject("CDO.Message") Set iConf = CreateObject("CDO.Configuration") Set Flds = iConf.Fields With Flds...

I don't see any of the words I use in the reserved word list.