Search results

  1. N

    VBA Path file

    So is there a way to create a pathfile for a network that can be used on any PC?
  2. N

    VBA Path file

    Can this been done for any network (shared drive) path file?? Hope someone can help. :D:D:D
  3. N

    VBA Filtering a chart in a form

    Work won't allow it unfortunatley. Thanks for all your help though.
  4. N

    VBA Filtering a chart in a form

    I have no idea what to do. If I have a textbox (DateSold) in my FrmCustomerDetails surely the code should filter between 2 dates but it just show resualts for the entire DB in the graph.
  5. N

    VBA Filtering a chart in a form

    No different. Is there another way say have 2 textboxes DateFrom & DateTo on the actual form with with a click button that can filter the graph?
  6. N

    VBA Filtering a chart in a form

    SELECT TblCustomerDetails.ProductCost, TblCustomerDetails.EmployeeName, TblCustomerDetails.DateSold FROM TblCustomerDetails;
  7. N

    VBA Filtering a chart in a form

    Its saying there is a syntax error (missing operator) in query expresion? SELECT [EmployeeName],Sum([CRMCost]) AS [SumOfCRMCost] FROM [QrySales] GROUP BY [EmployeeName];
  8. N

    VBA Filtering a chart in a form

    run time error '13:' Type mismatch and highlights the code below. DoCmd.OpenForm strForm, lngView, , , , strWhere
  9. N

    VBA Filtering a chart in a form

    The first part I changed to this as it only works with 5 ,,,,, Then I get a compile error - Method or data member not found in the 2nd part of the code on the from open event and highlights the Me.Rowsource Me.RowSource = Replace(Me.RowSource, ";", "") & " Where " & strCriteria
  10. N

    VBA Filtering a chart in a form

    Row Source is SELECT [EmployeeName],Sum([ProductCost]) AS [SumOfProductCost] FROM [QrySales] GROUP BY [EmployeeName];
  11. N

    VBA Filtering a chart in a form

    The FrmDateFilter is set to unbound and the the SalesChart Form Record Source is set to TblCustomerDetails
  12. N

    VBA Filtering a chart in a form

    Thanks for the reply, however nothing is happening to the chart. :confused:
  13. N

    VBA Filtering a chart in a form

    Hi Guys I have a button that opens a small form where the user can choose the dates between, then they click a button on that from which opens a form with a chart/graph relating to TblCustomerDetails. Everything works fine but it doesn't filter or change the chart. This is the code I'm using...
  14. N

    VBA Textbox back color from load? Current?

    Now the box is completely garyed out and grays out the text so you can't see anything?
  15. N

    VBA Textbox back color from load? Current?

    preferably both. (-:
  16. N

    VBA Textbox back color from load? Current?

    I like to not have the black background if possible and be transparent.
  17. N

    VBA Textbox back color from load? Current?

    Cheers Minty, However in the textbox 'Enter Password' is set, by doing your solution it just makes everything gray and therefore can't see 'Enter Password' or am I missing something. (-:
  18. N

    VBA Textbox back color from load? Current?

    Hi All I have a combobox and textbox for username and password blah blah blah when I start up Access the login form appears as usual and is .setFocus to the combobox, silly really but I want to lose the black back color and just have it transparent when the curser is flashing. I've tried all...
  19. N

    Listbox filter VBA

    Hi arnelgp Just one last question, when filterng is there anyway to make the other fields no visable, when i filter the name then the login date it filters that specific date and then filters that specific date in logout and logbackin also filters random dates. Thanks for any help.
  20. N

    Listbox filter VBA

    OK thanks I've worked it so that it works on a click button instead of after update. Thanks again for all your help.
Back
Top Bottom