User Profile

Collapse

Profile Sidebar

Collapse
crazyhouse
crazyhouse
Last Activity: Mar 3 '09, 10:41 PM
Joined: Aug 17 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • Thanks, worked like a charm
    See more | Go to post

    Leave a comment:


  • crazyhouse
    started a topic Print Access 2007 Attachment with VBA

    Print Access 2007 Attachment with VBA

    Hi,

    I dont even know where to start on this one. I found this on the net (everything in italics are the authors comments):

    Code:
    Public Function OpenFirstAttachmentAsTempFile(ByRef rstCurrent As DAO.Recordset, ByVal strFieldName As String) As String 
    
        Dim rstChild As DAO.Recordset2
        Dim fldAttach As DAO.Field2
        Dim strFilePath As String
        Dim strTempDir As String
    ...
    See more | Go to post

  • Filter report by date greater than inputbox value

    I am trying to view a report that has records that are filtered by date. basically all of the records that are greater than whatever date is entered into an input box. I would actually like to know how to give a start and an end date, but i figured i might be able to master that once i get the first code down. Here is what i cam currently using. ncrdate is a field from my table.
    Code:
        Dim stDocName As String
        Dim mydate
    ...
    See more | Go to post

  • Check fields from hidden form and change data on original form

    Ok, so i looked up the information that i needed, but now I see that what i was trying to do was really made for a SQL statement.

    Here is what happens. I open a form (hidden) with 20+ fields on it. Any of the fields may have a term on it. (MPI or LPI) <-- text obviously. If they exist in any of the fields, then i need to make a label visible on the form that is actually going to be used. Then the hidden form closes.

    ...
    See more | Go to post

  • nevermind..... silly question. sorry
    See more | Go to post

    Leave a comment:


  • thanks DonRayner, worked like a charm.

    Dan2kx, it ends up being one record, but i guess it could have been multiple records. But you bring up something I am interested in. Can i get rid of the previous/next button in code..... so that it can be conditional. Instead of having it either load everytime or not?
    See more | Go to post

    Leave a comment:


  • stLinkCriteria on multiple criteria, different types fo criteria

    This is the line of code i am trying to use. It doesnt work. I want the form to open only records that match the inspectjn, and accqty isnull.

    inspectjn is text
    accqty is a number

    Code:
    stLinkCriteria = "[inspectjn]=" & "'" & [strTrackingNum] & "'" And IsNull([accqty])
    Any help would be greatly appreciated. Thanks in advance.,
    See more | Go to post

  • crazyhouse
    replied to Run query from Report
    Maybe. I dont have very much experience with this. How many queries can i run in the recordsource, and how will i direct them to the proper field on the report. Maybe i dont understand completey. Will i be able to pull from more than 1 table... the recordsource only seems to allow 1 table.
    See more | Go to post
    Last edited by crazyhouse; Jan 7 '09, 01:03 AM. Reason: misunderstood NeoPa's statment

    Leave a comment:


  • crazyhouse
    started a topic Run query from Report

    Run query from Report

    I am trying to run a query from a report. I have gotten some help here before on setting up a query. This is what i am trying to run...
    Code:
    SELECT tblHL.[Heat Number]
    FROM tblHL, Table1
    WHERE (([hl]=[table1].[hl1]));
    In a reported field. Access tells me that anything in the field needs to start with "=", but I tried that too. I do know that i am putting the sql statement in the wrong place. On a form it would...
    See more | Go to post
    Last edited by NeoPa; Jan 5 '09, 02:24 PM. Reason: Please use the [CODE] tags provided

  • How to select a record from a different table based on info entered

    I have 2 tables - tblCertData and tblHL
    tblCertData includes multiple fields, but the ones that matter at this point are
    [1HL] (number field) and [Matl] (text field).

    tblHL includes fields [HL] (number field) and [MatlDesc] (text field)

    On my form that writes all of its data to tblCertData there is a dropdown box for [1HL]. The info in this dropdown box comes from tblHL [HL].

    I would like...
    See more | Go to post

  • crazyhouse
    started a topic Use custom function filtered information

    Use custom function filtered information

    I am using a custom fuction (I got the information from Microsofts site for the code)

    Code:
    Function Median (tName As String, fldName As String) As Single
      Dim MedianDB As DAO.Database
      Dim ssMedian As DAO.Recordset
      Dim RCount As Integer, i As Integer, x As Double, y As Double, _
          OffSet As Integer
      Set MedianDB = CurrentDB()
      Set ssMedian = MedianDB.Openrecordset("SELECT
    ...
    See more | Go to post

  • Thanks again. You have really helped.
    See more | Go to post

    Leave a comment:


  • I swear, i tried to change it but i couldn't figure it out. How do i make this work for a number field?
    See more | Go to post

    Leave a comment:


  • Thanks for the help, it worked great.
    See more | Go to post

    Leave a comment:


  • Display message box when search is not succesful.

    I am using the following code on a search page.

    myvalue = InputBox("Pleas e enter the Tracking Number.")

    stDocName = "Inspection_for m"
    stLinkCriteria = "[tracking_number]=" & "'" & [myvalue] & "'"

    DoCmd.OpenForm stDocName, , , stLinkCriteria, acReadOnly

    What i would like to know is how to open another form or msgbox if...
    See more | Go to post

  • OK let me explain how i got the Me.Refresh

    from one of my previous threads, about updating a field from another field (part number, and description if you remember), on another table. I got it to work with a subfrorm that is hidden on the table. When a person enters the part number into the visible field it looks up the partnumber from the invisible table, after that point i had (in code) the visible description made equal to the...
    See more | Go to post

    Leave a comment:


  • Sorry, i just realized that your comment said to use BeforeUpdate(), not after.
    See more | Go to post

    Leave a comment:


  • Linq, if you dont mind i would like to get the answers from the questions in my previous post, but I decided to just make the other fields on the form disabled until the inspector name is entered. That way it HAS to be first.
    See more | Go to post

    Leave a comment:


  • The bulk of it will be the different parts of a valve assembly

    stem
    packing gland
    bonnet
    and 36 other parts

    each one will have a disposition that is one of these 3 (the fourth option that i talked about earlier really doesn't apply)

    replace
    rework
    reuse

    I had thought that i would make it look like the form(paper) that is currently used. I realized that...
    See more | Go to post

    Leave a comment:


  • Does the me.refresh save the current form? The only reason that i am using it is because when i setfocus, the cursor wont actually move until the me.refresh occurs. I tried it without it, and the cursor did not actually move, when i put the me.refresh in there, it did. I am also populating other fields with me.refresh (using earlier fields in the same record to get their information). If there is another way of doing this, please inform me. ...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...