Recent content by andatabase

  1. 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.
  2. A

    MS Access hanging when switching to Design View

    compact and repair I've done, but I will try the decompile/recompile!
  3. 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...
  4. A

    MS Access link to a Sharepoint Excel File via Connection String

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

    Solved Stock Database Help

    Thanks, was able to come up with a solution many years ago. Forgot to reply!
  6. 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...
  7. A

    Storing SQL results via Recordset in a text box

    Thanks @MajP
  8. A

    Storing SQL results via Recordset in a text box

    Woops! Sorry, just read the header. I will have a look. thanks
  9. 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.
  10. 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...
  11. A

    Solved Stock Database Help

    Hi, I still need help on this. Your advice would be much appreciated!
  12. 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...
  13. A

    Solved Stock Database Help

    Ok, that's great. So what would i need to do on the form side, so that only the latest prices are displayed? thanks in advance.
  14. A

    Solved Stock Database Help

    Hi All, I need some assistance building a stock database. Premise: To monitor movements in stock on a period by period basis. The movements are then used to create journals to ‘revalue the stock’ in our accounting system. • Users use the previous valuations to review and update the stock •...
See more
Top Bottom