Search results

Its working now. Thank you so much, really appreciate your help!!!

I got an error Object variable or With block variable not set.

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?

Sorry, I did not describe the complete table structure here. I do have a unique id key and other columns beside the list I mentioned above. The ID column and Assign columns are being inserted to the table via another input form which is User Assignment Form. So, basically I need to fill in A1...

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...

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...

I have a text field 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 text field separated by commas. Now I need to display each value in a individual text box in a report. How can I create text boxes dynamically...

How to validate the connections? Can you please explain Yes some users have a different version of excel

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.

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.

Sorry for all the confusion. Yes i did check in the user's computer and came to know each of them have a shortcut of the database which is on the shared folder on network. This is how its being done from past many years. So what is meant by having their own copy of front end? How can I do that...

Sorry, each user has their own copy of FE in their PC's. So what do you think that is causing FE corruption?

The Access FE is on the server and each user is given read/write access to the database and has a shortcut on his/her PC which refers to this server location of the database file. Yes, there is a record locking information which can be seen when someone is using the database. There are 10 PC's...

Yes, each user have their own copy of FE in their system. Whenever there is a design change I need to update on the network server and the shortcuts point to that location.I always take backup of the database before making design changes which helped me when the FE gets corrupted. Also can you...

Please correct me if I am wrong. I have my own copy of the database in my folder, so can I make changes in that copy and replace the original database on the server with this modified one? Or should I import the form from the copy of database where I made changes.

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...

Yes we have pivot tables in Excel spreadsheet reports which are linked to SQL Server. Can they be viewed in 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...