Search results

  1. T

    Button to Compact & Repair Database

    As i develop my database in Access, i notice the file size can double and then halve after I click on the Compact and Repair Database option. But if i release my database as a standalone to my users, how can they compact & repair? Is there a need? Is there a way to include a command button with...
  2. T

    Solved Form to only create record or update record when button is pressed

    Hi, Database as attached. Open Main Menu form. Click on Admin tab. Click on View/Edit Analyst button to open up a Form that shows a datasheet-view of analysts. My story starts here. In the above datasheet, clicking on the Edit hyperlink next to an Analyst's name will open up the form...
  3. T

    Solved Updating or refreshing subform after value/s in main form is updated.

    I have a form where I can select a value in a textbox and combo box (e.g. date and name of analyst) I have a subform in the above form which is based on a query (let's call it query_for_subform) that returns a few values. Two of the criteria for this query_for_subform uses come from the above...
  4. T

    Form that can edit selected record or create new record depending on selection in a Split Form

    Good afternoon, The end goal of my Access is to have users use it in standalone (runtime). As such, it is not ideal for them to edit the tables of records directly. Also, the tables may not be readable as some fields are foreign keys (autonumbers instead of corresonding value, eg analyst_id...
  5. T

    Cross Tab Query doesn't recognise textbox value as valid field name or expression

    Good afternoon, In the attached test planner, I created a crosstab query. I wanted the query to return the results from a range of dates from 2 textboxes located in the Main Menu Form. In the criteria for the crosstab query, I placed the following: Between [Forms]![Main...
  6. T

    How to check if a recordset is empty (or get the count of records) and to get summary values (e.g. max, min, avg)

    Hi, How do I check the following in a recordset (which is from a query, not a table): 1) if it is empty 2) number of records inside it (if i open the recordset with dbOpenDynaset) 3) max, min, avg I get a type mismatch error if I try the following to get the max: Dim myR As Recordset...
  7. T

    Using VBA to call a Query which takes a parameter from a textbox

    Hi, I'm trying to stretch my VBA skills. So I wrote the following code; My first query is intQuery_for_AutoAssignment which returns a table of tasks to be assigned. Fields include the date, analyst_ID and duration. My first loop runs through each record from the about query in a recordset...
  8. T

    How to return zero in a field if it is null

    Hi, Test planner file is attached. So there are these 3 tables of interest in the database. Availability which lists the dates, analyst ID and the number of mins they have available. e.g. Date / Analyst_ID / availability 1 Feb 2022 / 1 / 400 1 Feb 2022 / 2 / 400 2 Feb 2022 / 1/ 400 2 Feb 2022...
  9. T

    Iterating through dates in a For loop

    Hi, I have a Form with the following: comboBox that allows the user to select their choice of Analyst - cboAvGenAnalyst 2 textboxes that allows the user to select the start and end date - txtAvGenFromDate & txtAvGenTillDate a textbox that allows the user to enter the duration in minutes -...
  10. T

    Solved Subscript Out of Range error when importing back tables

    So I'm trying to reset my database. So I exported most of the tables. Then I saved the database as a template and created a new database based on the template. When I try to import the (exported) tables back in, some of the tables imported in with no issue, but some of them failed with the...
  11. T

    Solved Append query overwrite existing rows in target table, instead of creating new rows.

    Hi everyone, For my database, I have a append query which takes all the rows from Temp_Table (except the primary key field) and appends it to the main table (Task_Detail_Table). What I discover is that it does not add the rows as new records to the main table but overwrites existing rows...
  12. T

    Default value for field not appearing in Form. also, how to have the Default value for one of the field to "draw" from another related-table.

    [apologies that i posted this in Reports instead of Forms by mistake. But I do not know how to move or delete this thread.] Hi everyone, But before I describe the Current Issue, let me describe my database first (attached). (note: dummy data is fed into this database) Tables...
  13. T

    Solved Need help creating a query to calculate "Time Utilisation"

    Hi everyone, I'm trying to create a particular query (so as to output it as a report). But before I describe the query (Current Issue), let me describe my database first (attached). (note: dummy data is fed into this database) Tables: Analyst_Availability: Each record has a date, analyst_ID...
  14. T

    Trying to create 2 similar records using a form and 2 subforms.

    Hi everyone, Before I ask my question, the following is a bit of context. I'm tasked with creating a database that tracks the testing of samples (tasks) in the QC lab of a factory. The overall database will be managing the availability of lab analysts, analytical methods, test records...
  15. T

    Hello!

    Hi everyone, I first learnt about Access 10 years but it is only now that I'm beginning to use it to create a database to manage some tasks at work. It has been challenging and I haven't got it fully worked out. I look forward to learning from everyone here.
Top Bottom