Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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 •...
Back
Top Bottom