Search results

Hi Spike - that does not work. myForm is a string so tried it with the Argument myForm as Form but that did't work either. Error is Can't find the the form [F-Jobs].[SF-Job Hyperlinks].Form.Name etc .... Thanks for your suggestion.

I am using the File Browse Dialog to select and store a file path. Here is the full code Public Sub FileBrowse(myForm As String, myControl As String) ' This requires a reference to the Microsoft Office 12.0 Object Library. Dim fDialog As Office.FileDialog Dim varFile As Variant '...

You will only achieve the automation you require with VBA. You are on the right path by creating a table with all the filenames (AND Paths) so that the principle of looping through them would then be possible as the loop runs from each table record to the next. Do you know anything about VBA...

What you have written is a mess; for each and every IF there needs to be an End If. Have you come across Select Case - that may help. Also code lines like If OptbtnSalesComms Then will not work as OptbtnSalesComms needs to equal something; such as the other lines in your code If...

I would try a combo rather than list box; it sounds like your scriteria election is not be fed through.

Try ORDER BY Month; as you have created Month as a Field. This still may not work however as although you have formatted Month as mmmm-yyyy, the underpinning date will be dd/mm/yy and any sort will be in Ascending order of Date. Changing the format only changes the way the date is presented...

Seeing no one has replied yet, let me give you a few thoughts. Firstly, using Access97 to do what you are asking is going to be hard work as Access 2007/2010 has a rather natty little text box calendar which is ideal for using to filter between a date range. Making a combo box with 52 date...

Should be simple enough. What have you got in your macro fields?

Try putting a full stop instead of a ! between [Filter].[Combo15]

You need to close the Dialog box when one of the 3 selection buttons are pressed so whatever code is behind each selection button you need to add Docmd.Close acform, "YourDialogBox"

Lots in this. Firstly I would recommend you use the Outlook Object as the basis for your eMail code. Many posts here in the forum on that. Then if you want a text box to be the basis for the body, I suggest you make the field a Memo. Then what I have used in the past is a bound PopUp form...

Try this If DCount("*", "cost", "order_no= " & Me.Text0 & " AND pallet_cost= " & Me.Text2 & " ") = 0 Then You may be concatenating when you don't need too.

is your field idquote.value an integer or string?

Why are you using brackets - you don't need them. My examplar was Me.Filter = "idquote.value = " & lngidquote

idQuote cannot be a control and a variable. Something like this is better where lngidQuote is a (Long) Public Variable Me.Filter = "idquote.value = " & lngidquote

When the SendObject run it essentially 'reprint' the report. Therefore, when you need to have a Filter in the Open Event of the report. Something like this where lngNo is your Quotation number and has been 'set' before your run the SendObject routine as you cannot Filter within the SendObject...

Try this as your bracketing is incorrect Format([Transactions].[Transaction_date],"mm-yyyy") INNER JOIN TCounts.MonthYear'

Maybe try instead of the Echo's. It may just work but beyond that - can't help. Docmd.SetWarnings False Docmd.SetWarning True

You could also refer to the Post I just made in the Macros section of this forum. http://www.access-programmers.co.uk/forums/showthread.php?t=208462

You could also refer to the Post I just made in Macros section of this forum. http://www.access-programmers.co.uk/forums/showthread.php?t=208462