Search results

Thanks a lot. The knowledge imparted by u is also useful and i have noted it. But... I want to change the default short date format of Windows from m/d/yy to dd/mm/yy thru VBA code

How do i write a query for full outer join in MS-Access ? (Right now i am using a union of left join from table t1 to t2 and remaining values of t2 to solve it but it is slow and inelegant)

I want to access and change the following things thru VBA (including the use of Windows API if needed) :- 1) The default short date format in Windows that is usually accessed thru Control Panel -> Regional Settings -> Date 2) The no. of digits in group accessed thru Control Panel -> Regional...

Is there a way to always show full menus thru code? View -> Toolbars -> Customize -> Options tab Always show full menus is to made true thru VBA. (I searched all docmd.runcommand options was unable to spot it) Allowfullmenus property of currentdb or the Allow full Menus in startup dialog box...

What i understand is that the wizard might have been turned off on the toolbox. Click on the wizard button (magic wand) to activate the wizard on the toolbox toolbar.

For benefit of others let me mention that the trick i mentioned above is fool-proof and has been used by me on some occasions now.Please check spelling mistakes , the form's recordsource carefully. the syntax should be [Storetotalcharge]=[total charge] [field-name]=[calculated-controlname]...

Well it's not simple as it sounds. After a lot of banging my head on a wall, i have been able to deduct that For a PC with a sound card and no speakers, docmd.beep or the beep API function goes thru the sound card and gets lost (there is no sound as there are no speakers) whereas DOS uses the...

Colinessex's solution is the best. But to get on with your question, the syntax is [field-name]=textbox-name for eg. the fieldname is totamt and the calculated control name is calctotamt then [totamt]=calctotamt in form_beforeupdate would do the trick.

I want to setup the Report page height from VBA. For eg. the report is formatted for page size letter (81/2 x 11") and i want to set it to fanfold (81/2 x 12") by using code. How do i do it?

I want to sound a short sound (something like a beep) even on a PC without Speaker. It is possible in DOS using ascii value 7 ? How do i do it ? docmd.beep doesn't work.

If the purpose is to disallow deletions use form.allowdeletions=false IF u wish to disable command buttons , use commandbars(command-bar name).controls(controlname).enabled=false commandbars("Menu bar").controls("edit").commandbar.controls("delete record").enabled=false Use a form's...

Use subform-name.form.recordset.movelast subform-name.form.recordset.movenext when u want to go to a new record. Hope that helps.

Like Mike it seems a little baffling to me too. But, then with your question , use the querydef object if the form's recordsource is a saved query and use currentdb.querydefs(me.recordsource).fields(textbox. controlsource).sourcetable This will provide u with the sourcetable.:cool: Look...

i have been misunderstood. I know about MDE files etc. etc. Let's say i give u my reporting tool developed in Access (i.e. i give u my application) and i want it to work as part of your application but u should not be able to see my forms' designs and code. How do i do it?:confused:

Is it possible for a database to run a form without having access to that form's object design and code ? My intention is that i provide a reporting tool to an MS-Access application developer that consists of tables,reports and forms with the table containing the configuration (hence making my...

The answer is very simple form_afterdelconfirm(status as integer) If status=0 then ' Write the code u want to be executed endif If you need to update a table based on the key value of the record that was deleted use the form_delete event to store it in variables.

How can i refer to a particular instance of a form that has multiple instances open ?

I am also looking to limit my application to a single instance. In your second last reply u said that u had a very simple solution if application.previnstance.... Then u wrote that u had to use API. Does the method of using application.previnstance not work?

I am using Windows 98 and Access 2k2. The problem is that i want to set the format property of a text-box to ##,##,##,##0.00 which is a bit different from the usual ###,###,##0.00 so that 123456789 is displayed is 12,34,56,789.00 and not as 123,456,789.00. If i set the format property manually...