Search results

  1. A

    Popup Tables

    Try 'Modal' and 'Popup' depending on your needs @namliam it's great advice from you and agree with it 100%, your latest reply would have been a more constructive one than just read a link.
  2. A

    Popup Tables

    Ok, we'll check the db windows settings I suggested before and let me know. If you're able to add a screen shot of what is happening that might help diagnose it better too.
  3. A

    Popup Tables

    @namliam it would have been handier to say what you thought the reason for posting that link was. If you'd replied with a suggestion for an answer and also suggested best practices that would have been nicer. @LM although it is a small database and your names are clear in what they do they...
  4. A

    Popup Tables

    Hi Which version of Access are you using? Are they showing up as Tabs? In File | Options | Current Database Do you have your 'Document Window Options' set as Overlapping Windows or Tabs?
  5. A

    transfer company name from one form to another form

    Another option would be setting a control on the Form in vba after the Form has opened. That way it doesn't need to reference a particular Form as it's set per button click
  6. A

    transfer company name from one form to another form

    Is this a Form in datasheet view or a Table that's open. Would it have multiple Companies? In the intermediate window try ? Me.Field1.Value Or try using MsgBox Me.Field1.Value
  7. A

    transfer company name from one form to another form

    You could use a DLOOKUP =DLOOKUP (Field, Domain, Criteria) http://www.599cd.com/tips/access/dlookup-function/?key=AlexForum =DLOOKUP ("Company", "CompanyT", "CompanyID=" & Forms!CustomerF!CompanyID) You need to get the CompanyID from somewhere though. Is there a Form you'll always have open...
  8. A

    transfer company name from one form to another form

    CompanyID = Forms!CustomerF!CompanyID
  9. A

    Help with OpenArgs function

    Have you added any Format to [Lab_Ref_No]? Just replicate from your original Form. You could use the Format Painter and copy it over or just add it manually.
  10. A

    How to open web page

    You could use some VBA with a SELECT CASE Check the tracking number and set which type you need then build the URL.
  11. A

    transfer company name from one form to another form

    You could add a textbox to the Form then set it to =Forms!frmCustomer!Company Where frmCustomer is the name of your Customer Form and Company is the name of the Field you store your Company in. I take it both Forms are based on different Tables. How are you relating them? Are you wanting the...
  12. A

    Problem with DateDiff function

    Wrap the d in double quotes, not 2 single. DateDiff(interval, date1, date2 [, firstdayofweek] [, firstweekofyear] ) Example: =DateDiff("d", Now(), [Orders].[ReceiveBefore])-10) http://office.microsoft.com/en-gb/access-help/datediff-function-HA001228811.aspx
  13. A

    Control wizard creatars macro, not VBA code

    If you open the Macro in Design View then click on Convert Macros to Visual Basic This was just a simple Macro that opened a Form and produces the following. '------------------------------------------------------------ ' Macro1 '...
  14. A

    Newb needs help with statistics in reports

    You could add textboxes to the footer and then add calculations like SUM etc using the Fields from the Report. Simple Form Footer Example http://www.599cd.com/tips/access/form-footer-total-sum/?key=AlexForum This could be used in Reports and is just a starting point.
  15. A

    Control wizard creatars macro, not VBA code

    There is a button that converts macros to vba in the ribbon. You could then add to that.
  16. A

    Format calculated field

    Great to hear it's working. Thanks for letting me know about the ; localisation, I wasn't aware of that.
  17. A

    Quartile Function in Access

    Cross Post: http://www.accessforums.net/showthread.php?t=40274
  18. A

    Format calculated field

    Also your Format looks incorrect 'monthname: Format(Month();"mmmm"' Change the ; to , monthnameX: Format([birthdate], "mmmm")
  19. A

    Format calculated field

    MonthName ( number, [abbreviate] ) Month ( date_value ) Join them together: MonthName ( Month ( date_value ), [abbreviate] ) Replace with your Field MonthName ( Month ( [Birthdate] ) )
  20. A

    Sum Macro

    You could use a DSUM. http://www.599cd.com/tips/access/130809-dsum/?key=AlexForum DSum ( expression, domain, [criteria] ) DSum("b", "tablename", "a=tea")
Top Bottom