Search:

Type: Posts; User: colecole

Search: Search took 0.01 seconds.

  1. MsOf07 Re: Search Form Continuous Reloading After Split and Placed On Server

    I'm posting the whole database on 4shared.com. It is in Access 2007 and completely safe.

    http://www.4shared.com/file/ZXgnT2tK/DCS-SOPs-DEMO-4Shared.html

    I have dummy data in place. If you...
  2. MsOf07 Search Form Continuous Reloading After Split and Placed On Server

    I'm using Access 2007. I created a split database and protected the front end as an accde file. I have a document search form that queries a listbox of documents to choose from. It worked great...
  3. MsOf07 Re: MsgBox Error Popup with Primary Key

    Figured it out. If anyone looked at it yet, it was on my frmMasterTabForm, Case Else MsgBox frmType.
  4. MsOf07 Re: [RESOLVED] Cont Form: Filter = Allow Additions or Show All if No Records Returned

    Figured it out. It was on my frmMasterTabForm, Case Else MsgBox frmType.
  5. MsOf07 [RESOLVED] MsgBox Error Popup with Primary Key

    I've attached my database in Access 2007. I am getting a MsgBox Popup with the docID (my primary key for my main table) in quotes. I can't figure out what I wrote in the code to cause this or if it...
  6. MsOf07 Re: Cont Form: Filter = Allow Additions or Show All if No Records Returned or Hide *

    Ok. I think I am good with the #Error workaround I described above. I am getting another error, ugh I thought I was done. When you select SOP Document Tracking from the SOP Document Management...
  7. MsOf07 Re: Cont Form: Filter = Allow Additions or Show All if No Records Returned or Hide *

    If you can't think of a way to hide a row where there isn't a value for docID, I have eliminated the #Error from steps 8, 9 , and 10A by adding a Nz([docID],0). For example Step 10A's control source...
  8. MsOf07 Re: Cont Form: Filter = Allow Additions or Show All if No Records Returned or Hide *

    Ok, I'm having a blonde moment. docID is my primary key for every form control source with this issue. So if I could set up an If docID=null Then Visible=False would make more sense. Sorry.
  9. MsOf07 Re: Cont Form: Filter = Allow Additions or Show All if No Records Returned or Hide *

    One more thought. If there is any record where docType=null it can be hidden, it shouldn't ever happen but I don't think you can hide just one row on a continuous form, so based on this condition...
  10. MsOf07 Re: Cont Form: Filter = Allow Additions or Show All if No Records Returned or Hide *

    Thank you Mr. Barrett! That is great stuff. My kids love dancing around with me to Love You, it is one of their favorite songs, too cute.

    Take your time, I'm sure when you get off work the...
  11. MsOf07 Re: Cont Form: Filter = Allow Additions or Show All if No Records Returned or Hide *

    It started when I added this find as you type text box. If you open frmSummaryOutputs: "Allow Additions" has to be set to "Yes" or when the filter returns no records, it will freeze the detail...
  12. MsOf07 Re: Cont Form: Filter = Allow Additions or Show All if No Records Returned or Hide *

    Absolutely! I uploaded the MS Access 2007 file to 4shared.com If you can't open it let me know. The forms to look at would be frmSummaryOutputs, frmDocMaintenanceHistory, frmAnnualReviewHistory
    ...
  13. MsOf07 [RESOLVED] Cont Form: Filter = Allow Additions or Show All if No Records Returned or Hide * Row

    I used MS Access 2007 to create a continuous form with the Allow Additions Property set to Yes. The user selects from a combo box and uses the After Update Properties of it and a "Find As U Type"...
  14. MsOf07 Re: DMax Date Text box function on continuous form with two where clauses

    Private Function getMaxSigDate() As Date
    Const fldName = "dwfDateComplete"
    Const tblName = "tblDocWorkFlow"
    Dim strWhere As String
    strWhere = "dwfTitleNo = 2 And dwfDocID = " & Me.docID
    ...
  15. MsOf07 Re: DMax Date Text box function on continuous form with two where clauses

    Thank you I will try that tomorrow at work and let you know how it worked out for me. Thanks again!
  16. MsOf07 [RESOLVED] DMax Date Text box function on continuous form with two where clauses

    I created a continuous form frmStep10a where I want a text box SignaturesComplete to get the last date that an employee entered a signature for a document. I have it set up as follows:
    ...
  17. MsOf07 Re: Calculate Fields in Domain Aggregate Functions using DateDiff

    Thank you! I was using DAvg and it was giving me an error #Name?. ugh.... Thanks again.
  18. MsOf07 [RESOLVED] Calculate Fields in Domain Aggregate Functions using DateDiff

    I have a table tblDocInfo which I made a continuous form with the fields
    PurchaseOrderApprovalDate and ActualDeliveryDate and primary key docID (autonumber). I have a calculated control...
  19. MsOf07 Re: [RESOLVED] MS Access 2007 VBA: Version Number is populating my Document ID Numbe

    Yes, this one is solved, the one I am still having problems with is filtering on this post:

    http://www.vbforums.com/showthread.php?t=614093
  20. MsOf07 Re: Filter continuous subform from combo box selection MS Access 2007, Office 2007

    I had received some advice as follows:

    "From your mainform, you can set a Filter on a Subform like this:

    Me.NameOfYourSubformCONTROL.Form.Filter = " dwfTitleNo=1"...
  21. MsOf07 Re: [RESOLVED] MS Access 2007 VBA: Version Number is populating my Document ID Numbe

    Thank you koolsid!!
  22. MsOf07 Re: [RESOLVED] Tab Control Form Set Focus--Now won't hide any pages (tabs)

    The devil is in the details!!! Sorry I took so long to Thank you, I have jumped into another set of tweaks I need to make. If you want you can check out my most recent post! I changed the pages...
  23. MsOf07 [RESOLVED] Filter continuous subform from combo box selection MS Access 2007, Office 2007

    I am trying to get (2) pages of a form's tab control to filter subforms based on a combo box entry. I can't get the Filter property to work.

    The combo box is derived from "tblWorkFlowTitles" and...
  24. MsOf07 Re: Tab Control Form Set Focus--Now won't hide any pages (tabs)

    the form with the tabs is frmMasterTabForm. Some of the code is also in the class module mdlDocUtilities. This little project has turned into a MONSTER!! But it should be pretty cool when it is...
  25. MsOf07 Re: Tab Control Form Set Focus--Now won't hide any pages (tabs)

    This is my latest version 17. I uploaded it on 4shared.com at the following link:

    http://www.4shared.com/file/C1BShL5n/_2__FINAL_SOP_DCS_V17.html

    Thank you!
  26. MsOf07 Re: Tab Control Form Set Focus--Now won't hide any pages (tabs)

    That did not work either. The code I created is hiding the cases Perfectly that do not involve Hide Page pgEvaluations. I was getting an error when I tried to hide it that you can not hide a page...
  27. MsOf07 [RESOLVED] Tab Control Form Set Focus--Now won't hide any pages (tabs)

    I was getting an error when trying to hide a page on a tabbed form in access that you can't hide a control that has the focus. So I used a line of code Me.tabIwasnotusing.SetFocus and now it doesn't...
  28. Replies
    3
    Views
    5,633

    MsOf07 Re: DMax invalid use of null

    anhn: great solution!! worked perfectly. Thank you SO much!
  29. Replies
    3
    Views
    5,633

    MsOf07 [RESOLVED] DMax invalid use of null

    I am getting an error of Run-time error '94': invalid use of Null. I have the code below. This is when I am creating a new record and there isn't data to add to... I have a default value of 0 in...
  30. MsOf07 [RESOLVED] MS Access 2007 VBA: Version Number is populating my Document ID Number (Code Error)

    I am attaching a copy of my Document Control System I created. I have a 3 part Tracking number for each document. Document Type + Sequential Document Number + Version Number. There is also a Doc...
  31. MsOf07 Re: MS Access VBA tracking number adds +1, need to force a ".0" decimal point on the

    Thank you so much!
  32. MsOf07 Re: MS Access VBA tracking number adds +1, need to force a ".0" decimal point on the

    Yes, I am sorry I have the following code incorporated in:

    Public Function getStrVersion(decVer As Single) As String
    getStrVersion = Format(decVer, "v#.0")
    End Function

    However, if the most...
  33. MsOf07 [RESOLVED] MS Access VBA tracking number adds +1, need to force a ".0" decimal point on the end

    I am working on a document control system in MS Access. When different actions are performed on a document, the document number changes. Where I am having trouble is when a document is revised the...
  34. [RESOLVED] need help MS Access 2007 tabbed form change focus

    I have a tabbed form. I have written code that hides different tabs depending on what was selected from a combo box. However, whenever the associated selection includes hiding the "pgEvaluations" I...
Results 1 to 34 of 34



Click Here to Expand Forum to Full Width