Search results

Hi, I wrote below code to export data from query to excel and then format the excel data. I am getting run time error ‘1004’ Unable to set the Horizontal Alignment Property of the Range Class. Below is the piece of code. Kindly help me to have correct vba code to format Table Column Headings...

Hi, I have a query based on multiple tables which extract different fields from tables based on parameters. I am using this query as source for report. The query result will have different number of fields so there is no fix template for report. On run time VBA should first clear all existing...

Hello, Request quick Help. I have two tables; TableA (fields CoCode, EmpDept) and TableB(Fields CoCode, EmpDept, ReportingMapping) Both Tables are linked through CoCode and EmpDept Need help to form delete script to delete records from TableA, only those records which does not exist in TableB...

Hi, I have a form in my db. It has button to minimize the application. These code I copied from MS site to minimize the application. Once I click on “Minimize Button” it minimize access application. This same function I wanted to have on minimize control of the form instead of button on form...

Hi Expert. I am facing a challenge to show the form at the center of the screen. I am using Access 2010. I search on net but unable to get the correct guide line. I wanted to open the form in maximize mode to cover complete screen. The contains of the form should be displayed at the center. I...

Hi, Please guide me. I have a table tblDepartment with below records; DeptID Department 1001 Finance 1002 Mr.Bean's Office 1003 CEO's Office 1004 Bazza@Home 1005 HR On a form a field is available as txtDepartment. Once I enter value in txtDepartment a...

Hi, Can someone help to update Table3. I have three table with data; Table1 RECID NewCode 1000 RA1 1001 RD1 1002 RC1 Table2 RECID OldCode 1000 RA3 1001 RD0 1002 RC1 Table3 CoCode RD0 RA3 RC1 I need to create a...

Hi, Can some one share their experience or expert advise to interface handheld scanner with access table. once user scan the barcode, then that bar code numbers should be stored in a table. Please guide how this can be achieved. Thanks Ismail

Hi Guru, To BypassShift Key, I used the code given at below link in this forum; http://www.access-programmers.co.uk/forums/showthread.php?t=51479&highlight=bypass+shift+key I created a sample .accdb (the same is attached) and followed the steps. Then I converted the db into .accde but unable...

Hi, On a form there are 4 combo boxes. Each combo box will have the multiple list of values. These list of values are uploaded while opening the form from a table. I am using the nested loop to assign the list of values. Like; Private Sub Form_Open(Cancel As Integer) Dim sqltxt As String...

Hi Experts, I created three forms which I need to give to end users. These forms are used to collect some basic information about business transactions. I wanted to restrict the users activities therefore I have to give the form in such a way that end user will not access database. In short use...

Hello, Writing VBA and reducing repeating code by defining user defined functions is very new for me, So need help to understand the basic structure of UDF and how it should be structured In correct way. I created my codes like; Private Sub cbxEmployeeName_AfterUpdate() Dim condition As...

Hello, This is my first question on this forum. I got good help from time to time by reviewing others threads and issues. I have problem to manage the values from two different forms. On first form we calculated results from two textboxes and store into a public variable. On this form there...