Recent content by andatabase

  1. A

    Filtering on a crosstab queried subform

    This is what I have done. I want to filter the results even further.
  2. A

    Filtering on a crosstab queried subform

    Do I add this to the 'Link Child Fields'? Thanks for your suggestion.
  3. A

    Filtering on a crosstab queried subform

    Hello, I have a crosstab query (dynamic fields) which is now acting as a 'subform' in a form. I want to filter based on user selection, but some of the things I have tried are unsuccessful. 1. As it's a query and not an actual subform, the option to update the record source. I only see a source...
  4. A

    MS Access hanging when switching to Design View

    I did the suggestion, but still encountering issues. I think it has to do with the Sharepoint tables that are connected.
  5. A

    MS Access hanging when switching to Design View

    compact and repair I've done, but I will try the decompile/recompile!
  6. A

    MS Access hanging when switching to Design View

    Hello! I have a query relating to switching to Design View in Forms. For me it hangs and takes ages to load. I am not really sure what the issue as if I look for the form object, right click, and open in Design View, then it loads instantly. It is a workaround, but is frustrating that I need to...
  7. A

    MS Access link to a Sharepoint Excel File via Connection String

    I will have a look. Not sure my company will allow it.
  8. A

    Solved Stock Database Help

    Thanks, was able to come up with a solution many years ago. Forgot to reply!
  9. A

    MS Access link to a Sharepoint Excel File via Connection String

    Hello, I am writing to see if it is possible to connect to a Sharepoint Excel File via a connection string? It would be similar to the below: SELECT * FROM [Excel 12.0 Xml;HDR=YES;IMEX=2;DATABASE=Link to Excel File]; This works for files on shared drives, but I need one linking to a...
  10. A

    Storing SQL results via Recordset in a text box

    Thanks @MajP
  11. A

    Storing SQL results via Recordset in a text box

    Woops! Sorry, just read the header. I will have a look. thanks
  12. A

    Storing SQL results via Recordset in a text box

    Listbox won't help as this needs to be for info only. This text box will display the customers for selected records: "Selection includes: Customer A, Customer B" Thanks for your suggestion, mind. I will need some help on the for loop and concat string, if that is the case.
  13. A

    Storing SQL results via Recordset in a text box

    Hello, I am currently building a form where I need to store the results of an SQL into a text box. The results will be a one field query, where it will display the Customer names. The bit I am stuck on is not the SQL, but to go through the results and assigning it to a textbox. Will I need to...
  14. A

    Solved Stock Database Help

    Hi, I still need help on this. Your advice would be much appreciated!
  15. A

    Solved Stock Database Help

    JLCantara, in response to your queries; How are the periods defined? The database would be reviewed every six months, so March & September How does valuation influences 'stock'? Previous valuation prompts the use to review stock at a particular site, and then provides an update. If the...
See more
Back
Top Bottom