Search results

  1. M

    BackColor for textboxes

    one way... http://www.access-programmers.co.uk/forums/showthread.php?t=40228&highlight=alternate
  2. M

    VBA code to change a child form

    ..see demo
  3. M

    Sum help

    Do the sum in the query like this: Outer_Total: (Nz([Outer1])+Nz([Outer2])+Nz([Outer3])+Nz([Outer4]))
  4. M

    Counter creation

    This MS article explains how to do that. http://support.microsoft.com/default.aspx?scid=kb;en-us;210340&Product=acc
  5. M

    Change Password Mask

    In the query that fills the form add a new column like: Mask: "*****" & Right([SSN_Field],4)
  6. M

    linking to Parent Form in query?

    WHERE tbl2.aID = Forms!parentform!aID
  7. M

    Linking a spreadsheet (it is a form question)

    Is the form based on a query that involves more than 1 table?...if so verify the relationship between the tables in the relationship window. Broken relationships = locked forms.
  8. M

    SetValue of Combobox ??

    Me!ComboName.DefaultValue = "" or set a value Me!ComboName.DefaultValue = "Some_Value_in_Combo"
  9. M

    SetValue of Combobox ??

    oops...Duplicate
  10. M

    Exact Match in Search

    should be... Like [Forms]![Search]![BoxNo]
  11. M

    Picture on tabulated form

    did a demo for you...see attachment..you need to update the Paths to the images.
  12. M

    automatically select value from a calculated field

    something like this should work...try in in the AfterUpdate event of the Age control or maybe the Current event of the form varage = Me!Age Select Case varage Case 18 To 40 Me!NameofYourSubform.Form!AgeNo = 0 Case 41 To 60 Me!NameofYourSubform.Form!AgeNo = 1 Case 61 To 70...
  13. M

    Custom ID's as Primary Key

    Hi provoked, take a look at the attachment in this thread http://www.access-programmers.co.uk/forums/showthread.php?t=75516 , ...another way of creating a unique ID. If implemented properly there should be no need to check for duplicates.
  14. M

    Making the Orders Form into a Web Page

    You need to make a web version of your form usiing ASP & HTML, DAP's or Infopath forms are no good for the web because the end user must have MS office XP installed to use DAP's or a copy of InfoPath to use the InfoPath form...sucks I know
  15. M

    Security lock

    ...see attachment
  16. M

    Specialized Autonumber

    Download the attachment in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=75516
  17. M

    Dynamically Linking front end & back end

    You can't use an Access front-end over the internet. The only thing you can connect with are the Tables of data in the database, not forms or reports. You need to write ASP or ASP.net scripts to edit/update/delete the data. Each ASP file usually has an include file called strconnect.asp which...
  18. M

    Generate table of weekend dates through VBA?

    Something like... WHERE Weekday([DateField]) = 1 or Weekday([DateField]) = 7
  19. M

    Sort order of subreport is ignored

    Bring up the Poperties box of the sub-report by double-clicking it, click the Data tab and make sure the 'Order By On' value is set to yes and that 'Order by' has a value. If that's OK then, look at the 'Grouping and Sorting' properties box (right click over the sub-report to select it). The...
  20. M

    Import Tables & Table Permissions

    Thanks for the reply Uncle Gizmo, I had thought of that, but I'd be worse off, I'd lose the permissions on all the forms, reports and queries. It seems such a simple thing but it's a bloody nuisance. Regards
Back
Top Bottom