Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
Access
3rdpartyusrgrp
access
activexcontrol
adp.sqlserver
commandbarsui
conversion
dataaccess.pages
developers.toolkitode
devtoolkits
externaldata
forms
formscoding
gettingstarted
internet
interopoledde
macros
modulescoding
modulesdaovba
modulesdaovba.ado
multiuser
odbcclientsvr
queries
replication
reports
security
setupconfig
tablesdbdesign
  
 
group : microsoft.public.access.modulesdaovba      view archive
page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>



disable double click to change window size     Mon, 07 Jun 2010 21:06:20 GMT
Hi All, I would like to be able to disable the double clicking of the main access window, my application starts maximized and i dont want anyone restoring it to a window size. Can this be done with VBA ? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-modules/20 ...

Change control in dialog form     Mon, 7 Jun 2010 11:20:32 -0700
Using Access 2003. Using VBA to change the content of a text control on a dialog form. (The form is opened from another form using doCmd.FormOpen ,,,,, acDialog) The value of the control will change from the form Open by simply using ControlName = "New text" or Me.ControlName.Value = "New text" This d ...

Access runtime ribbon - export to word option missing.     Mon, 7 Jun 2010 11:06:10 -0700
When you create a 2007 runtime application the option on the print preview ribbon to export the report to word disapears. I have had to create my own Ribbon code to export data to excel (see below - this works by the way I am just positing it for info) because that option also disappears. Do I have to crea ...

Insert Into -- expected end of statement error     Mon, 7 Jun 2010 09:02:42 -0700
I need to add a record into a table. I'm getting "expected end of statement" table name: tbl_details field: ID (key, number, long) syntax I'm trying to use in the module: INSERT INTO tbl_details ([ID]) VALUES (999) Your help would be VERY appreciated! ...

Assistance with Output     Mon, 7 Jun 2010 08:33:37 -0700
I fould the below code demonstaring how to output multivalue fields; Sub BrowseMultiValueField() Dim db As Database Dim rs As Recordset Dim childRS As Recordset Set db = CurrentDb() ' Open a Recordset for the Task Table Set rs = db.OpenRecordset("Tasks") rs.MoveFirst Do Unt ...

Set Variable to lookup field     Sun, 6 Jun 2010 21:08:56 -0700
I need to set a string variable to a lookup field on a form. I have two tables "tblCase" with fields: CaseID autonumber (key) CaseType, text, 15 char "tblClient " with fields: Last_name First_ name CaseType, number, long (lookup to table tblCase) etc. In the "client" f ...

Conditional updating     Sun, 06 Jun 2010 13:21:45 GMT
I have the following working updating function which is ok: CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72" I want to add on a condition depending on the field â??codeâ? in the same table products. But I do no know how to do it.I do not want to use a form but otherwise is it possib ...

Conditional updating     Sun, 06 Jun 2010 13:21:35 GMT
I have the following working updating function which is ok: CurrentDb.Execute "UPDATE Products SET office = products.grossprice*0.72" I want to add on a condition depending on the field â??codeâ? in the same table products. But I do no know how to do it.I do not want to use a form but otherwise is it possib ...

Sendkeys "{ESC}"     Sun, 6 Jun 2010 03:12:36 -0700
Hi untill now I used the Sendkeys "{ESC}"/Cancel in the event BeforeUpdate, but occassionaly I had some problems. From now on I follow the instructions of some users in the duscussion Groep and I replaced the Sendkeys "{ESC"} by the .Undo. It works fine except in a ComboBox. Is this normal? ...

OLE, INK and Reports     Sat, 5 Jun 2010 14:19:35 -0700
Hello everyone, here is my problem. In my app I have 7 spots where a signature can be required. They are all OLE controls that when they get the focus they are scaled in size, 4 x, when you double click the control paint is opened and an existing empty bmp is opened so you can sign your name. When the con ...


page nr.: page nr.   1      2      3      4      5      6      7      8      9      10      11      12      13      14      15      16      17      18      19      20    next >>
Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us