Search results

  1. V

    Cant find ID unless all Combo Boxes have value.

    This is a new one for me, I have a simple line of code to open a audit log DoCmd.OpenForm "frmAuditHistoryDetail_Audit", , , "[AuditHistoryID] = " & Me.AuditHistoryID.Value The button is found on a continuous subform, and just allows the user to see a audit history for the selected record...
  2. V

    More Calendar Problems

    Not sure what calendar you are talking about but if its a button why not just add Me.DateField.Refresh on the OnClick
  3. V

    ***Need help on setting up a box in a form

    Not sure how you have everything setup but I would do th following. Have my staff table be the main form then have a clients table as a subform. THis means that what ever staff memeber is currently active it would filter the client list below. To change staff memebers just use the combo...
  4. V

    Must be a better way to manage a text box

    I have a text box thats getting just a bit more complex than I like: ="REMOVED classifies audit observations as Critical; Major; Minor; and Comment as defined below. The audit revealed " & _ IIf(fTableRecordCount("tblObservation","WHERE [fk_QualificationID]=" & [QualificationID] & "AND...
  5. V

    Please Help... Forms are now my nightmare!

    If possible, downgrade your database to a .mdb lots of users dont have access 2007 yet. Good luck!
  6. V

    Enter data in subform with button

    I will give this a shot, there might be a better way but this is how i see it :) I would use VBA for the On_Click of a command button. It will need som code but I think you should be able to get it. You will need to get the table name your subform is working with and the one or two fields...
  7. V

    Accessibility in Access Forms

    I might not look at this from the Access side (talking about the program here) I would get in contact with the company that makes the screen-reader your staff is working with. I am sure they can lead you to some helpfull documents or they might even have staff that can help you work with the...
  8. V

    Creating a list of open trouble tickets

    DoCmd.OpenForm "frm_TroubleTickets", , , "[Status]=" & Chr(34) & "Not Started" & Chr(34) Will that work? BTW this outputs [Status]="Not Started" the Chr(34) is another way to add in quotes, I have found it to be easy to work with when trying to get the code right.
  9. V

    Backcolor Property

    If its HEX then you need to enter Me.Field.backcolor = &HFFFFFF
  10. V

    Java code to vba

    I am trying to learn Java, just wanted to say that this is really cool to see :D
  11. V

    Split form and Enable/Disable

    Ok I dont have a clue whats going on with this, my code is below and the issue is that when I change records my enable/disable options start getting mixed up for some reason! After a while the fields might grey out even when they should be enabled, also sometimes the spit form will be grey...
  12. V

    VBA (SQL) Check for record before INSERT

    Scratch that i forgot the octothorpe If fTableRecordCount("tblSurveillance", "WHERE [fk_SiteID]=" & [fk_SiteID] & " AND Year ([Surv_AuditDue]) =" & "Year (#" & DateAdd("yyyy", 1, Me.Qual_InspectionDate.Value) & "#)", False) > 0 Then
  13. V

    VBA (SQL) Check for record before INSERT

    Thanks for the tip I updated my If statment to the following: If fTableRecordCount("tblSurveillance", "WHERE [fk_SiteID]=" & [fk_SiteID] & " AND Year ([Surv_AuditDue]) =" & "Year (" & DateAdd("yyyy", 1, Me.Qual_InspectionDate.Value) & ")", False) And this is the SQL it spits out but it still...
  14. V

    VBA (SQL) Check for record before INSERT

    Hey guys I have the code below that I created and it works great for checking if an exact date is in the table, but what I really want is to check if there is a record in the table that matches the year. I am attempting to do this with Datepart and Like. So I change If...
  15. V

    Simple VBA Date issue (SQL)

    I still need practice it would seem :) Thanks!
  16. V

    Simple VBA Date issue (SQL)

    I just want to get a Date back when I run the following DoCmd.RunSQL "INSERT INTO [tblSurveillance] ([fk_SiteID], [Surv_Audit]) VALUES (" & Forms!frmMain_toplg!SubForm1!SiteID.Value & "," & #1/1/2000# & ");" But instead I get 12:00:43 AM I am sure this is simple, Help!
  17. V

    Memo field cutting @ 255 still

    Found this searching google, it was the first page i checked.... Might help you!
  18. V

    Working with tags to hide form items

    Thanks for the help this worked, Private Function fHideForCase() Dim vVisible As Object For Each vVisible In Me.Controls If vVisible.Tag Like "h*" Then vVisible.Visible = False 'This will hide ALL options. Next End Function
  19. V

    Working with tags to hide form items

    Hey guys, I have a Report form thats got all sorts of controls to filter reports the way a user wants to. I also have a lot of things that need to be hidden or shown based on what radio button a user selects. This is the code I had before but I know some of the changes i need to make in...
  20. V

    Requery field on Subform?

    Typo is my guess should have been: Me.Child02.Form.Requery
Back
Top Bottom