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 ...
|
