Search results

Yes this appear only in one form.

Hi, I have error message on every event I have in a single form. I get below error when I move the mouse (Did not click anywhere). The error message is: The expression On Mouse Move (in this case) you entered as the event property setting produced the following error: statement invalid...

Hi Rx, I'm trying to automate Excel from Access VBA. I have all the data in Access and executing the SQL in Access writing data in particular cells in Excel Sheet and after that I need to sum these cells. And these number of columns need to dynamic e.g. it can be =SUM(B3:B7) or =SUM(B3:B10)...

Hi I need to calculate SUM of selected cell range e.g. PB YU Bud PBud Actual TC Sam 120 130 190 130 150 James 130 150 110 120 130 Raj 150 120 120 100 120 ================================= Total 400...

Sorry for the formatting of the file. Please find attached here excel file for the formatted sheets.

Hi All Is there any way to show list data in tabular format using SQL query in MS Access? Private BankerYearMonthVolatile IncomeJames2012013244James2012023467James2012034667James2012045668James2012052378Andrew201201345Paul2012013456Paul201202-234Paul2012030Paul2012040Paul2012053456 Show...

Is there any other option get this result without using outer join. Because I need to cosolidate 4 different tables. And Primary Key in all the tables is BankerName and all Banker's will not exist in all the table e.g. Table 1 BankerName Rob James Tim Table2 James Bob Paul Table3 Andrew...

Please let me know how to use UNION query in MS Access. I have a table A with columns (RMName, AUM, AUA( and Table B with Columns (RMName, NNA, REV) Table 1 RMName, AUM, AUA James 10 2 David 20 6 Andrew 18 4 Table 2 RMName, NNA, REV James 6 3 Paul 3 1 I want the result to be...

Hi I am calculating YTD and MTD amount. I am using sub query SELECT "VolatileRevenue" AS Comment, TB.[Private Banker], Sum(TB.RevenueInUSD) AS SumOfRevenueInUSD, tbl_Oneoff_Adjust.[Volatile Adjust], tbl_Revenue_Target.[2012 FY Trade Revenue Target], (SELECT Sum(TBI.RevenueInUSD) AS...

My both databases (Source database and destination database) are password protected. While importing it's prompting for the password which I don't want. I have tried lot of options but no success. Please help... Below is the code for your reference. Private Sub ImportFromAccess(sDatabaseID As...

This is not linked table. I checked while login time if all the source databases are available, if any of the database is not available prompt the user before starting any process.

Is there any option in the TransferDatabase method which enables you to import selected data? I want import all the recrods before certain date e.g. WHERE Right([BookDate], 4) >= Year(Now) - 1 Please find below the existing code which is bringing everything. I have 6 years data in origional...

DoEvent did not work. I have used Public Function Pause(intSeconds As Integer) ' Comments: Waits for a specified number of seconds ' Params : intSeconds Number of seconds to wait On Error GoTo PROC_ERR Dim dateTime As Date dateTime = DateAdd("s", intSeconds, Now) Do...

This overlapping did not work. My form in debug mode disappeared or minimised. And after completing the debugging this does not come back. So every time I need to close the form and open it again and I can’t see the information printed in the form while debugging.

Please find attached screenshot before and after debug mode. After reaching breakup point (where ever breakup point set using F9) form is minimised and after checking / debugging completed form is not displayed back and need to close the form and open again.

How can I tell my VBA script to wait until previous process / action has finished before continuing with the next process / action? Seems one process / action is not completed and VBA moves to next process / action which is creating lot of problems. How to make sure that current process /...

Please find attached here the structure. Is there anyway to check if prior statement / function is completed before moving to next step e.g. If I'm importing the data how to make sure that data is imported before executing the next statement e.g. INSERT / UPDATE.

Hi All, I’m having problem returning number of records available in the Table using VBA. Below is the code returning number of records available in the table. If I run the same code in debug mode is shows correct number of records but when it prints on screen it's showing 0 record. Call...

I mean when If I set breakpoint using F9 and start debugging. After finishing all the checks when I got back to main page Form is not displayed. I have attached the screenshot.

Hi I have application with toolbar. When I run the form in debug mode after completing debug form is not opened (Please see the screeshot attached). I need to close the form and open it again. Is there anyway to keep that form open in debug mode (Top of other forms) Thanks