Forum: General Discussion
June 5th, 2010, 04:45 AM Posted to microsoft.public.access
|
|
Replies: 4
Views: 3,785
Close Form Event
You can code the save button like this:
Private Sub btnSave_Click()
Dim strMsg As String
strMsg = strMsg & "Save Changes?" & Chr(13) & Chr(13)
If Me.Dirty = True Then
If MsgBox(strMsg,...
|
|
Forum: Database Design
June 4th, 2010, 11:43 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 2
Views: 3,777
Confused over new db
The starting point is to know what the database is expected to do.
What happens after the questions have been answered?
For example: is it a survey database and it will print out a report showing...
|
|
Forum: Using Forms
June 4th, 2010, 11:30 PM Posted to microsoft.public.access.forms
|
|
Replies: 4
Views: 3,778
Tab Order
What settings do you have for tab stops for each textbox and checkbox?
What is the tab order for the form's detail section?
Do you have the form's cycle property set to All Records or Current...
|
|
Forum: Database Design
June 2nd, 2010, 10:43 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 5
Views: 17,303
Hyperlink datatype
I avoid using hyperlink data types as I have had similar experiences.
I store the file name in one field and the path in another field.
When I want to open the file, I concatenate the path with the...
|
|
Forum: Database Design
June 1st, 2010, 10:56 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 5
Views: 17,303
Hyperlink datatype
See if this helps:
http://allenbrowne.com/func-GoHyperlink.html
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"Trini Gal" wrote in message...
|
|
Forum: General Discussion
June 1st, 2010, 10:21 PM Posted to microsoft.public.access
|
|
Replies: 1
Views: 641
Form View
Here is a link to 2 sample databases showing how to have the new record
appearing at the top of the form.
http://www.rogersaccesslibrary.com/forum/topic374.html
To show the most recent record,...
|
|
Forum: Using Forms
May 30th, 2010, 10:29 PM Posted to microsoft.public.access.forms
|
|
Replies: 4
Views: 952
How to display progress on slow opening form.
I would use the 'form with load message' to open form2.
You could use the current event of 'form with load message' to open form2
hidden.
At the last line of code in the load event of form2, you...
|
|
Forum: Using Forms
May 30th, 2010, 09:43 AM Posted to microsoft.public.access.forms
|
|
Replies: 4
Views: 952
How to display progress on slow opening form.
Create another form that shows the message about taking a long time and open
it just before you open the form that is slow to load.
When the slow form has loaded, then you can close the form with...
|
|
Forum: Using Forms
May 29th, 2010, 12:40 AM Posted to microsoft.public.access.forms
|
|
Replies: 1
Views: 593
|
|
Forum: General Discussion
May 28th, 2010, 08:42 AM Posted to microsoft.public.access
|
|
Replies: 3
Views: 670
AfterFinalRender
From the help on msdn, there is some sample code.
Private Sub Form_AfterFinalRender(ByVal drawObject As Object)
MsgBox "The PivotChart View has fully rendered."
End Sub
Here are helpful...
|
|
Forum: Using Forms
May 26th, 2010, 07:49 AM Posted to microsoft.public.access.forms
|
|
Replies: 3
Views: 749
"Enter key" default
Here is some code that will do that.
-------------
Public Function ChangeSomethingOnControl()
Dim aob As AccessObject
Dim frm As Form
Dim ctl As control
' Ignore any errors
On Error Resume...
|
|
Forum: Using Forms
May 26th, 2010, 03:59 AM Posted to microsoft.public.access.forms
|
|
Replies: 3
Views: 749
"Enter key" default
On the text box's property dialog, on the 'other' tab, look for Enter Key
Behavior.
You have a choice of Default or New Line in Field.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria...
|
|
Forum: Using Forms
May 25th, 2010, 10:41 PM Posted to microsoft.public.access.forms
|
|
Replies: 2
Views: 781
Not wanting to displaying certain forms
I have 2 different answers for you, depending on what I think you meant.
1. If you have a continuous form, you can lock the rows marked as do not
call.
Put code on the current event of the form like...
|
|
Forum: Using Forms
May 25th, 2010, 10:34 PM Posted to microsoft.public.access.forms
|
|
Replies: 3
Views: 635
Common "Button Block"
An easy way is to use a template form.
You can make a set of template forms with the most common forms you use.
To use a template form, simply make a copy of it and use that to start your
new...
|
|
Forum: Using Forms
May 24th, 2010, 10:08 PM Posted to microsoft.public.access.forms
|
|
Replies: 3
Views: 600
Provide Help/Tutorial Form
If you are using only a single form or a couple of forms, put the info into
a label control, or several label controls.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria...
|
|
Forum: General Discussion
May 24th, 2010, 10:04 PM Posted to microsoft.public.access
|
|
Replies: 1
Views: 198
Combo Box Problem
Copy and paste the code on the combo box into a post.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"judyb" wrote in message...
|
|
Forum: General Discussion
May 24th, 2010, 10:03 PM Posted to microsoft.public.access
|
|
Replies: 2
Views: 530
vba code not working in accde
Make sure that the database is in a trusted location.
Office button, Access options, Trust centre, Trust center settings, Trusted
locations, Add new location
Jeanette Cunningham MS Access MVP --...
|
|
Forum: General Discussion
May 22nd, 2010, 01:34 AM Posted to microsoft.public.access
|
|
Replies: 2
Views: 210
|
|
Forum: General Discussion
May 22nd, 2010, 12:45 AM Posted to microsoft.public.access
|
|
Replies: 2
Views: 210
|
|
Forum: Using Forms
May 21st, 2010, 10:19 PM Posted to microsoft.public.access.forms
|
|
Replies: 4
Views: 747
show 2nd field when combo box choice is made
In the after update event for the combo, you can use code to copy the price
from a hidden column of the combo to the price textbox.
Me.PriceTextboxName = Me.ComboName.Column(2)
For a sample...
|
|
Forum: General Discussion
May 21st, 2010, 06:34 AM Posted to microsoft.public.access
|
|
Replies: 2
Views: 231
blinking form afterupdate
This code requeries the form and displays any changes to the data.
Where are you using that code - is it on a button or some other event?
Jeanette Cunningham MS Access MVP -- Melbourne Victoria...
|
|
Forum: Database Design
May 21st, 2010, 04:47 AM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 1
Views: 613
|
|
Forum: New Users
May 20th, 2010, 09:52 AM Posted to microsoft.public.access.gettingstarted
|
|
Replies: 4
Views: 874
Inventory transaction table - set up
With this part of the answer
Should I put Add and Remove quantities in separate columns?
Yes, without sign, the action determines plus or minus.
That should read
Should I put Add and Remove...
|
|
Forum: Using Forms
May 20th, 2010, 12:11 AM Posted to microsoft.public.access.forms
|
|
Replies: 4
Views: 642
should i hide a form or make it modal
Showing and hiding forms is a very common thing to do in programming.
One catch is that you can't show a form it if isn't already open and
hidden.
So I always include code that tests to see if the...
|
|
Forum: General Discussion
May 20th, 2010, 12:07 AM Posted to microsoft.public.access
|
|
Replies: 2
Views: 154
Table to Form automatically
Probably I should have included this:
Open the form you created and use it to manually edit the values in the
table.
Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
"Jeanette...
|
