Search results

  1. P

    Import Data and Validation

    Hi All, I hope everyone is keeping well! I am trying to import an Excel file into Access. The trick being, I only need to import certain fields. I have a spreadsheet named 'Data.xlsx'. It has data I need in the range D:F but I only need columns D and F. Column D in my spreadsheet contains...
  2. P

    Solved ADO ListBox and Filter

    Hi All I'm having some serious problems that I'm just unable to solve which I hope you can be of assistance with once again. I have a listbox that I am trying to filter a subform with, the problem is when I use queries the filter just hangs as I have a user defined function and it just stops...
  3. P

    Solved Listbox and SubForm

    Hi All I have a parent Form with two subforms. SubForm1 is a listbox and is unbound. Subform2 is bound to the parent form. What I want to do is click on the listbox and it filters subform2 by column(0) which is the same in both subforms. Any suggestions/tips/good programming etiquette are...
  4. P

    Stop clock on Working Days

    Hi All, I'm struggling with amending some code, if anyone has time to look at it, it would be greatly appreciated. Basically, I have 4 dates. Date 1 and Date2 return the number of working days in a period (public holidays are passed from an array) What I want to do is if date 3 and 4 are...
  5. P

    Group by on Continuous Form

    Hi All After traversing the web for 6+ hours and finding no solution, I'm holding my hands up and asking for assistance with a problem. Is it possible to read in records from a parent form and then do a group by these records on a subform that is continuous? If I make the query directly to...
  6. P

    Solved Storing the value of a Function

    Hi All, I am calling upon your expertise once more. I have what may be a very quick question to answer. I have a main form where the record source is run from a query - within this query there is a function that performs some calculations (the actual calculations are not bound to any field in...
  7. P

    Solved Checkbox question

    Hi All, I have what is hopefully a very quick question. I have a form where the detail section is populated based on a query. There are two fields that can have variable number of records returned. I was wondering would it be possible to add a checkbox for each record that is returned without...
  8. P

    Solved Record is deleted (multi user database)

    Hi all I have a database that multiple users use simultaneously (front end and back end). Within this database the main form is a continuous form. The problem I have is when one user deletes a record, other users of the database see the #deleted and get an error “record is deleted” when they...
  9. P

    Solved multiple combox

    Hello, I hope someone can help me. I have a combobox with an on focus event that is equal to "customer name", "customer age", "customer address", these are all column names in the Customer table. I would like a second combobox that will query the customer table based on the value that is...
  10. P

    SubForm with calculated fields

    Hello All I am very new to Access and I hope some of your experience and knowledge can help me out. I have a main Form called 'Orders' that can have 'OrderTypes' that are constantly being updated. I am looking to create a subform (sub form will be a pop out window) linked to the main form...
  11. P

    Task Scheduler

    Hello All I have a question which I’m sure has been asked a million time’s before. However I am unable to find an appropriate solution. I am looking to schedule recurring tasks for the year, some are weekly, monthly, annual. Of these tasks some start on the 1st of month and others say the...
Top Bottom