Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Darrylles

    Code not working

    'Code not working'. Wonderful term to enable people searching for a 'filter another form' solution - to find this particular issue. *sigh* Come on Moss - THINK ABOUT IT! ;-) How about "Can't filter form from another form"? ATB, Darrylle
  2. Darrylles

    FILTER SUBFORM USING MAIN FORM FIELDS- VBA

    Kim, Please report back here, when you achieve your solution. You have no need to follow advice, these things can be done many different ways, but, it's always nice to see how things panned out. ;-) Darrylle
  3. Darrylles

    FILTER SUBFORM USING MAIN FORM FIELDS- VBA

    Andrzejek, ;-) ATB, Darrylle
  4. Darrylles

    FILTER SUBFORM USING MAIN FORM FIELDS- VBA

    ...that 'All' was an option, and as such - there should be an IF statement BEFORE building the SQL string - e.g.: If 'ALL' is checked: SQL = "SELECT *" else ..... (build the selective SQL string). I get your drift Andrz (and you've been here a long time - like me). I COULD provide the entire...
  5. Darrylles

    FILTER SUBFORM USING MAIN FORM FIELDS- VBA

    Kim, I would list each of your permission 'types' (Division, Unit, Shift, Rank) in multi-select list boxes (not individual checkboxes, which are cumbersome to process). The list box entries for 'Rank' would be the actual 'Rank' values. Multi-select means that zero, 1 or many can be selected at...
  6. Darrylles

    WScript / MS access db compacting

    Imagine a remote system where there are a large number of MS Access database apps (a lot created by 'laymen'), many poorly defined / designed / produced. (You may find this easy to do). Some are having problems with exceeding the 2gb max database size, which in turn creates issues of locked...
  7. Darrylles

    Any Like for Like replacement for Calendar in Access 2003?

    Hi torq, I've uploaded a small app that contains 2 forms only: 1 is the calendar form, 1 is a small example calling form. All code is documented. I've had problems with command buttons not being raised (3d); I think it's a local installation problem - hopefully it's fine on yours (although for...
  8. Darrylles

    Any Like for Like replacement for Calendar in Access 2003?

    I got sick of depending on library controls (and having to redesign every time there was a change), and, I also couldn't depend on said controls being available in secure environments, so I built my own form that emulates the usual calendar control functionality. What you would assume to be a...
  9. Darrylles

    Report, replace by Recordsource Field name value...

    If I understand you correctly: You can't pull the value to be edited from the report, you must first edit the value, then pass it to the report. So, what is the report data source? Intercept the data source, and amend that. ATB, Darrylle
  10. Darrylles

    SQL Solution?

    Your link table should have 2, distinct foreign key fields: FID_fk and TID_fk. Now you can join tblForm.FID on tblLink.FID_fk and tblTransaction.TID on tblLink.TID_fk, rather than concatenating them. P.S. This should be in the MS Access {Tables} or {Queries} forum. ATB, Darrylle
  11. Darrylles

    How to use the Json dictionary & collection in VBA Ms Access

    Did you resolve this? ATB, Darrylle
  12. Darrylles

    Compiler 'Argument not optional' in Function

    This is not 'solved', however; I replaced the function with a procedure with a parameter of a collection passed ByVal (by default), where the collection was defined by the calling procedure (not the called function). It seems strange that I can pass an array variable back to a calling sub -...
  13. Darrylles

    Compiler 'Argument not optional' in Function

    combo ListFilesInDir is a function. Can you 'Set' a function return value? ATB, Darrylle
  14. Darrylles

    Compiler 'Argument not optional' in Function

    OK, I changed the function to a sub, and passed a collection 'byref' (newly defined in the calling sub). Testing that now - but it does at least compile ok. Doesn't sound right having to do that though. Any info. appreciated. ATB, Darrylle
  15. Darrylles

    create Excel file using stored procedure

    GShen, Did you see this?....... https://access-programmers.co.uk/forums/showthread.php?t=249509 ATB, Darrylle
  16. Darrylles

    Export Access tables to CSV file - records need to have varying record lengths

    tbclbd What method are you using to 'export' this data. Please post your code (don't forget to format it). ATB, Darrylle
  17. Darrylles

    Compiler 'Argument not optional' in Function

    ...at 'ListFilesDir = col')... Public Function ListFilesInDir(strPath As String, _ Optional strFilter As String = "*") As Collection Dim col As Collection Dim strFile As String On Error GoTo ErrHandle ' Make sure path has terminating \ ...
  18. Darrylles

    Filecopy Access 2016?

    You "switched to FileSystemObject and CopyFile method". Did that work? If not, what's the problem now? And FYI, you are not alone: Link Darrylle
  19. Darrylles

    change copy count windows 10.

    Checked: MS Access 2007 is supported by Windows 10. However, it sounds like you have jumped from Vista straight to Windows 10 (a lot of major versions since). Is that correct? Not sure how much VBA code is involved, but have you re-compiled that application code? If not - try it: Open the DB ->...
  20. Darrylles

    Update Main Form from Button on sub-form

    puforee This forum is for the benefit of everyone - not just for YOUR individual problem. You raising a question, then saying "I fixed it" - doesn't help anyone. If I search for "Update Main Form from Button on sub-form", YOUR post comes up in the results. I drill into it, and the solution...

Part and Inventory Search

Back
Top