Search results

  1. L

    Print a report in a specified printer tray

    I want to print a report to a specific tray using VBA. Tried using acPRBNLower enumeration datatype to select bottom tray Drawer 2 of my Canon printer, but not working. Can I please get help with the code?
  2. L

    VBA code to Insert a combo box selected value to a specified column in Access table.

    Hi everyone, I have a table tblUserLog with 16 columns- A1, A2, so on till A16; these are decimal data type columns which has time taken by each user for designated area. All these values are entered via an input Time Sheet Form which has: Textbox1 - user enters time taken and Combo box - drop...
  3. L

    Creating dynamic text boxes to hold multiple selections from list box

    I have a text field column in a table which gets data from a form's list box(multi selection list box). All the selected values from list box are added to the column as comma separated values. Now I need to display each value in a individual text box in a report. How can I create text boxes...
  4. L

    The query did not run or the database table could not be opened

    I have this Excel spreadsheet to display live SQL data. It was working fine and then suddenly a few users cant refresh data it gives the following message "The query did not run, or the database table could not be opened" and other users can.
  5. L

    Check box in Forms

    Is there a way to populate the check box in a form as checked based on a Query? I mean can I compare two columns and if the value matches i need to populate the checkbox as marked.
  6. L

    Access front end

    We are using Access 2010 as front end with all the forms and SQL Server for all the back end tables data. If we make design changes to any of the Access 2010 front end forms what is the best way to distribute these changes to all the users? All the users are accessing the shared Access database...
  7. L

    Upgrading from Access 2010 to Access 2016

    We are upgrading to Access 2016. Right now we have Access 2010 as front end and SQL Server 2012 as back end. Access has all the forms,reports and tables are linked to SQL Server 2012, where we have our source tables as well as views on which the queries are written. What are the steps I should...
Back
Top Bottom