Search results

Thanks Bro .. learning as always I mean at the form properties.

Hi guys I have a form with view as 'Pivot Table' and want it to be use for 2 instances with different recordsource. I normally can do this in all my other forms by changing the recordsource at the Open Event, be not with this form. I tried the following options without any success: 1 Change...

DBguy I use instead at target field ControlSource =Forms!MainfrmName!sourceSubfrmControlName!fieldName It reflect source field value. Cheerio

Micron ..the tabCtrl is in the main form. Each page of the tab has one subform

Will try thereon. THANKS

Hi members I have a main form with number of subforms separated by tab control. Lets say there is field T1 in SubFrm1 & in subFrm2 there is field FldNew. i want to place T1 in FldNew. What is its field value. EASY but I don't know. PLEASE!

Sad to say I am using win7 so I have stick to v2008, apparently v2012 have issues with win 7

Thanks bro, so the trick is the ODBC

Hi guys First of all, the forum new looks is very good & trendy. Congratulations to the Administators for the upgrade. I am contemplating to install SQL Server Express 2008 R2 to try my hand on using its database. As my favourite is still the older versions of msAccess eg 2003, which version...

Thank you for the care in the response. I guese i need to think again what i really want to sub optimize. TQ again guys.

TQ isla Yes bad idea but then what other option if i want to share data in the cloud.

Db guy I think One drive should do the trick. Once installed in it appears in win Explorer.

Hi peers I am toying with idea to place a Split Back End mdb in Cloud storage. Is this a viable path to take in terms of: 1 Will it be any lag in reading or transferring data to and from the backend? 2 Can we use UNC for the backend eg \\myData 3 What if i want to use sql server then where...

Thank you June It looks like i have to use query or code to create such a running sum field then incorporate to the form. Essentially can't do within the form design, right?

Dear forum members In a report we can cumulate a field value using "running sum" over a group. How can we acheive the same result for a field value in a form? Appreciate guidance

THANK YOU for all responses As Macron rightly post, CHANGE of rowsource is possible. SORRY i made the mistake of setting a sub report from main report & later make further settings in sub report. Access already open sub report so further setting off sub is forbidden A timing issie

It is done in open event, not much event choice, other is activate in which the same forbid Iif not possible as i am relying on openargs to flag change Thanks for trying

Hi guys I want to change the ControlSource of a field in a report during opening of it but is not allowed in printPreview or after it is started. How to work around this? Help please.

Not shared but it should not matter I will prefer to have name of xls simple without space So you have a table named transactions in your current project

may be the issue is behind the scene the tb01 worksheet still exist even though there is the nothing apparent or it may be hidden even when it don't show in format>unhide