User Profile

Collapse

Profile Sidebar

Collapse
favor08
favor08
Last Activity: Mar 14 '08, 03:08 PM
Joined: Jan 10 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • favor08
    started a topic attaching report as rtf

    attaching report as rtf

    Is there a way to change this code so that the document does not go in as a attachment but in the body of the email.

    Currenty the person would have to use the forward button in order to keep the document attached to the email. Most cases they would just hit reply, but I need the document to stay attached. Thoughts?

    Code:
    DoCmd.SendObject acSendReport, "RptRequest", "Rich Text Format", , , , "Title",
    ...
    See more | Go to post

  • favor08
    started a topic I seem to be writing this statement wrong

    I seem to be writing this statement wrong

    this is within the control source of a checkbox called Yes:

    Code:
    =IIf([PrgrmCd]="033" Or "035",True,False)
    and this is within the control source of a checkbox called No:
    Code:
    =IIf([PrgrmCd]="033" Or "035",False,True)
    when I open the report the yes checkbox is true for every report and I know that it shouldn't be. there are only 10 that...
    See more | Go to post

  • favor08
    started a topic convert date stamp to previous date

    convert date stamp to previous date

    7/19/2007 12:46:30 am. is in a field called CmplteDte. It is a date stamp of when the user completed the item. I need the time for a report but for a form that the supervisors use to QA the previous days work I format the date to 7/19/2007 using a query Format([CmplteDate],"mm/dd/yy") so that they see everything for that date and not just that time.

    My questions is that when work is stamped after 12 midnight it date stamps...
    See more | Go to post

  • favor08
    started a topic calculate dates

    calculate dates

    have serval date fields in my table that i need to perform calcualations to bring bring a certain # of items.

    Fields:

    RptDte Date filed closed always the last date of previous month--- 6/30 for this example
    EntryDte Date item was entered into system --could be multiple dates
    EffDte Date item was or will be effective.--could be multiple dates


    My first critera needs to be
    ...
    See more | Go to post

  • favor08
    started a topic Adding outlook signature to email through access

    Adding outlook signature to email through access

    I'm have automated the creation of an email from Access; whic works
    fine,
    but the new email doesn't have the user's default signature on it. Is
    there any way to either have it find the user's default signature and
    add it to the bottom of the email.

    Here is my code for sending the emails:

    Code:
    Function SendEmail()
    Dim rst As DAO.Recordset
        Dim strSQL As String
        Dim olApp
    ...
    See more | Go to post

  • favor08
    replied to filter not working
    it filters a subform.

    and it was working fine until I added the dateIn code.
    See more | Go to post

    Leave a comment:


  • favor08
    replied to filter not working
    Here is the complete Code for this piece:

    Code:
    Private Sub StobMainFrame_AfterUpdate()
    On Error GoTo StobMainFrame_Err
    Dim linker
    Dim strSQL As String
    linker = StobMainFrame.Value
    Select Case linker
    Case 5
    ittype = 5
    'dayone QUEUE
            Me.Cmdclose.SetFocus
            Me.FStobDaily.Form.FilterOn = False
            strSQL = "TStobDaily.PendDte Is Null AND
    ...
    See more | Go to post

    Leave a comment:


  • favor08
    started a topic filter not working

    filter not working

    Code:
    Dim linkerDim linker 
    Dim strSQL As String 
    linker = StobMainFrame.Value 
    Select Case linker 
    
    strSQL = "TStobDaily.Category In('61','73') AND TStobDaily.DateIn 
    
    
    
    >#5/31/2007# AND PendDte Is Null AND Tstobdaily.LogInID=fOSUserName()" 
    
    
    End select 
    End Sub
    The "DateIn" is still bring back dates less than 5/31/2007....
    See more | Go to post

  • favor08
    replied to filter report based on filters in form
    Code:
    Dim StrWhere As String
    With Me.[FPastDuePendingsSub].Form
      If .FilterOn = True Then
        If Not IsNull(Me.CboOpid) Then
          StrWhere = .Filter & " AND ([opid] = """ & Me.CboOpid & """)"
        Else
          StrWhere = .Filter
          End If
          If Not IsNull(Me.cbofilterProd) Then
          StrWhere = .Filter & " AND ([prodcd] = """
    ...
    See more | Go to post
    Last edited by NeoPa; May 27 '07, 09:57 PM. Reason: I don't want to be wasting my time on these code tags again :(

    Leave a comment:


  • favor08
    replied to filter report based on filters in form
    so do I continue to add iff then statements for the other filters?...
    See more | Go to post

    Leave a comment:


  • favor08
    started a topic filter report based on filters in form

    filter report based on filters in form

    have a mainform called PendingsMain and a subform called
    PendingsSub. You can filter the subform by different filters and this
    works fine.

    i want to create a report that will print out the results of the users
    filters or print everything if there is no filters submitted within
    the form.


    Any suggestions


    This is what i have so far:


    ...
    See more | Go to post
    Last edited by NeoPa; May 27 '07, 05:09 PM. Reason: Tags

  • favor08
    replied to toolbar
    I wanted to force them to use the tool bar I created for them. I put the print incon on this tool bar but it prints everything and doesn't give them the option to select a page....
    See more | Go to post

    Leave a comment:


  • favor08
    replied to toolbar
    the right click option does not work unless I am in design view. I think I turned if off but I am not sure how...
    See more | Go to post

    Leave a comment:


  • favor08
    started a topic toolbar

    toolbar

    I have a report were the users would like to be able to select the pages they would like to print. How do I create a customized tool bar that when the user clicks on the button the print dialog box will open and allow them to select what they want to print.
    See more | Go to post

  • favor08
    started a topic create a summary report.

    create a summary report.

    I have a table that list a bunch of QA results performed on different dates.

    there are 9 yes questions and 9 no questions. each question has a weight. which is nto important right now.

    what I am trying to do is get a total count for each question. I have the individual queries that give me the count for each question for each day.

    What I can't figure out is to get the count of each question into one query...
    See more | Go to post

  • favor08
    started a topic Creating a Summary Report.

    Creating a Summary Report.

    I have a table that list a bunch of QA results performed on different dates.

    there are 9 yes questions and 9 no questions. each question has a weight. which is nto important right now.

    what I am trying to do is get a total count for each question. I have the individual queries that give me the count for each question for each day.

    What I can't figure out is to get the count of each question into one query...
    See more | Go to post

  • favor08
    started a topic batch file

    batch file

    Can I have command with code on the on click go out and open a bat file that is on another pc local drive. that bat file will open up an access database and run some down loads.

    I need a user to tell me when they are done so I can download the files and I wanted to automate this so I didn't have to wait until they say they are done then go and hit a button on my second pc to download the files. it will lock the computer up for about...
    See more | Go to post

  • favor08
    replied to dialog box
    i do have admin privilages, so how do I turn it off....
    See more | Go to post

    Leave a comment:


  • favor08
    replied to dialog box
    microsoft office outlook

    a program is try to automatically send e-mail on your behalf. do you want to allow this? etc

    Actually even if I say "NO" it still happens. So NO is not stopping the fax from process.
    See more | Go to post

    Leave a comment:


  • favor08
    replied to dialog box
    I had to add "end if" statements to get the code to work.

    But the microsoft dialog box still opened up.

    im db As DAO.Database
    Dim rst As DAO.Recordset
    Dim strName As String
    Dim strFaxNo As String
    Dim strFax As String
    SetWarnings = False
    Set db = CurrentDb


    strSQL = "SELECT TProdInfo.ProdC d, TProdInfo.[Contact Name], TProdInfo.[Fax Number],...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...