Search results

  1. P

    Subform filtering workaround

    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...
  2. P

    Subform filtering workaround

    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...
  3. P

    Open specific email message using access

    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...
  4. P

    Automating Outlook

    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...
  5. P

    lookup date AND time problems

    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...
  6. P

    Help! I Can't Disable all Excel Warnings

    try objXL.Application.displayalerts = False
  7. P

    Snapshot Viewer Download

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

    Help! Page numbering on mail merge

    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.
  9. P

    Open and run A Macro in Word from Access

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

    Open and run A Macro in Word from Access

    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", _...
  11. P

    Help on Query Codes

    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.
  12. P

    Advanced charts. Excel vs Access

    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...
  13. P

    Pointless and Flashy

    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.
  14. P

    Record Search via Combo Box-- wierd error

    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...
  15. P

    MS Access Graphs

    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...
  16. P

    Update Chart Properties in Report

    Help, I have a chart within a report (MSGraph.Chart.8) and need to manipulate some of the properties each time it prints for a differrent customer. Can anyone explain why the first three lines of code work, then fails on the next two: Chart.charttitle.Font.Size = 8 Chart.Legend.Font.Size = 8...
  17. P

    SendObject

    Rob - The problem is with the sendobject command and has been verified by Microsoft. You can read more about it at:http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q260819& I had the same problem - the first email was always sent and then nothing not even an error message. I had to...
  18. P

    Animated Gifs driving me crazy !

    I'm having two problems getting animated gifs to work: 1. The code runs too fast.... On opening a form I have the gifs property set to not visible, then I want it to become visible while the database copies several large files from the server (takes anything up to 1 minute). Problem is the...
  19. P

    Emailing very large memo fields

    Help!! with Acsess 2000 I am trying to send an email using: DoCmd.SendObject acSendNoObject, , acFormatTXT, assignto, , , task, comment, False where 'comment' is a memo field on a form. After much tedious test I have discovered it only sends if the length of the memo field is less than 2184...
Back
Top Bottom