Recent content by Paul_B

thanks RuralGuy, I'm almost there. that fixed the error, however I'm now getting the same error on the next line? I've changed it to: Forms.frmLookupMaint!frmSubProjects.Form!RecordSource = strSQL a mouse over of the above does reveal that the recordsource = "tasks" which is correct...

ok, i've discovered filtering does not work on subforms so i have searched the forum and modified some code to this: Dim strSQL As String strSQL = "Select * from tasks where" strSQL = strSQL & Me!frmSubProjects.Form!Project = 2 Me!frmSubProjects.Form.RecordSource = strSQL...

Hi, I've search all over for an answer to this and haven't found anything, so my expectations may be way off... I have a form linked to an Outlook mailbox folder that i can browse through, select an email and append a table with certain fields from the email. What I would then like to do is...

if i've understood the problem correctly, it sounds similar to something i have. my recordset is based on a form which loops through and processes each record. paul This is what i use: Dim rsemail As DAO.Recordset 'Dim fs As Object 'Dim objOutlookAttach As Outlook.Attachment Dim objOutlook...

can anyone please explain why this code works.... xxx = "Format([Start],'dd/mm/yyyy hh:nn') between #22/01/2004 00:00# and #22/01/2004 23:59#" DCount("[id]", "[query]", xxx) 'result is 2 and this code doesn't: xxx = "Format([Start],'dd/mm/yyyy hh:nn') between #22/01/2004 00:01# and...

try objXL.Application.displayalerts = False

http://www.miesoftware.com/downloads3rdparty.htm

on the groupheader for each new customer, use this [Event Procedure]: Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer) Page = 1 End Sub Paul.

I forgot: make sure you add Microsoft Word to the Reference library or it won't work.

How about putting the macro in access and run from there after opening the word document? eg Dim appWord As Object Set appWord = CreateObject("Word.Application") appWord.Visible = True appWord.displayalerts = False appWord.Documents.Open FileName:="c:\personal\02-03 KDDPS Supplier.doc", _...

after you've created the tables in design view this is the vba: DoCmd.OpenQuery "your_query_name" or the faster way is to run everything in vba: DoCmd.RunSQL ("your_sql_code_goes_here") Paul.

I had the same problem and overcame it by creating the charts in Excel (so much better/easier) then linking the actual excel worksheet - not the chart - back into an Access report. Insert the Excel object etc, then you select the source doc (name and path of the excel file) also make sure you...

I use animated gifs on a pop-up form while my code is running... and just for the fun of it, the code also randomly selects which gif each time it's run. :cool: If your interested search the Forms Forum on how to get them to work. Paul.

I've just had the same error with a combo box on my form and traced the problem back to the actual field in my table that the combo was linked to. I deleted the field and saved the table etc then recreated the field and now the combo box works and the form populates! (and I still don't know...

bill, i also export most of my charts to excel for ease of formatting etc, then just to complicate matters I link excel back to my access reports for customer distribution. however, if you download these sample access 97 graphs from msn, they also work in access 2000, and might be what your...