Search results

  1. C

    Query By Form; Range of Data

    Dear All, I've seen a QbF query that is active but the TS has a different question so I don't want to derail his thread, so apologies if I make another thread regarding QbF. Anyway, here's my problem. I have a query with a column that returns number of days per record. Using a form, I can...
  2. C

    Suppress "Communicating with OLE server" error

    Hello Everyone, I have a form which basically is composed of charts and graphs whose details are fed by queries. The form is in ACCDE format distributed to users and the tables are hosted in our company Sharepoint (2013). Now sometimes when the form is already open, charts loaded, an error...
  3. C

    Access forms not working after re-link of sharepoint lists

    I have a database linked to Sharepoint lists. My forms are working perfectly until after I made some changes to the sharepoint list and re-linked the database to these lists. After the re-link, the buttons on my forms are not firing anymore despite checking the events code and compiling the...
  4. C

    automatically fill a table using a list from another table

    I have a table being filled everyday that contains the following: ID EntryDate Ward_ID (linked to the Wards table) Census At present, the data encoder manually chooses the ward via drop-down list to identify the ward, and fill the census field. Since we have 20 wards, we find this exercise...
  5. C

    Daily data collection with constant elements

    Hello. I hope someone here has had experience designing forms based on the following: I have a table that is populated everyday, with following columns: 1. ward (linked to the wards table) 2. date 3. number of patients We have a total of 18 wards, wherein the daily number of patient in each...
  6. C

    skipping controls on validation check before update

    Hello everyone. Newby VBA learner here. I'm working on a code that checks all blank/null text fields and combo boxes in a form and notifies the user if a field is not filled. The code below works if all fields are required, but I can't use it on forms that have fields that are not really...
Top Bottom