A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 7.53 seconds.
Search: Posts made by: Jeanette Cunningham
Forum: General Discussion June 5th, 2010, 04:45 AM Posted to microsoft.public.access
Replies: 4
Views: 1,871
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: 1,880
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: 2,121
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: 8,939
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: 8,939
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: 322
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: 569
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: 569
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: 317
Form just opened doesn't see data entered in previous form

Make sure you save the data just entered in the first form before you open
the next form.
On the button that opens the next form, put this code before the code that
opens the next form.

If...
Forum: General Discussion May 28th, 2010, 08:42 AM Posted to microsoft.public.access
Replies: 3
Views: 309
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: 466
"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: 466
"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: 462
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: 303
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: 327
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: 164
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: 439
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: 147
What is the system name for the version of Access?

Here is the rest of the code you need if you are using
Public Function GetAccessVersion

This will work across multiple versions:

'These declarations go at the top of the module in the declaration...
Forum: General Discussion May 22nd, 2010, 12:45 AM Posted to microsoft.public.access
Replies: 2
Views: 147
What is the system name for the version of Access?

This will work across multiple versions:

Public Function GetAccessVersion(Optional db As DAO.Database) As String
'Purpose: Return full version information for the msaccess.exe file.
'Argument: ...
Forum: Using Forms May 21st, 2010, 10:19 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 384
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: 170
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: 339
Filter Form based on OnClick from Text Box of another form

Dim strWhere As String
strWhere = "[JobNumber] = " & Me.[JobNumber]
Debug.Print strWhere 'for testing only
DoCmd.OpenForm "NameOfForm", , , strWhere


Note:
If the job number field is a number data...
Forum: New Users May 20th, 2010, 09:52 AM Posted to microsoft.public.access.gettingstarted
Replies: 4
Views: 430
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: 372
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: 105
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...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 04:29 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.