Forum: Database Design
June 2nd, 2010, 04:48 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 5
Views: 17,303
Hyperlink datatype
I updated teh code to:
Private Sub Ctl2009_REPORT_Click()
Dim myFile As String
myFile = Ctl2009_REPORT.Value
Call GoHyperlink("V:\Engineering\_Data\Engineering\FCC-CLI-320 Info\2009
Filings\FCC...
|
|
Forum: Database Design
June 2nd, 2010, 03:38 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 5
Views: 17,303
Hyperlink datatype
Hello Jeanette,
Thanks for your reply. After posting I found that information and tried it.
I have the following code on the On Click Event:
Private Sub Ctl2009_REPORT_Click()
Call...
|
|
Forum: Database Design
June 1st, 2010, 06:59 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 5
Views: 17,303
Hyperlink datatype
Hello,
I'm not sure if what I'm doing is right because my user keeps getting the
error "Unable to open V:...... .pdf. Cannot open the specified file."
My database is still Access 2003, I haven't...
|
|
Forum: General Discussion
May 11th, 2010, 03:43 PM Posted to microsoft.public.access
|
|
Replies: 4
Views: 239
Storing Back End on a Terminal Server
Hello,
I'm almost done with the database I created for approximately 5 users using
Access 2007 and verified that all the users have been upgraded to 2007. I
intend to split the database, store...
|
|
Forum: Using Forms
August 3rd, 2009, 05:56 PM Posted to microsoft.public.access.forms
|
|
Replies: 2
Views: 111
Checking for Blanks
Never mind, I figured it out. I was SetFocus to a command button.
"Trini Gal" wrote:
I have a form with a close button with the following code.
Private Sub btnCCRClose_Click()
On Error...
|
|
Forum: Using Forms
August 3rd, 2009, 02:58 PM Posted to microsoft.public.access.forms
|
|
Replies: 2
Views: 111
Checking for Blanks
I have a form with a close button with the following code.
Private Sub btnCCRClose_Click()
On Error GoTo Err_btnCCRClose_Click
Dim ctl As Control
For Each ctl In Me.Detail.Controls
If ctl.Tag...
|
|
Forum: Using Forms
July 23rd, 2009, 03:27 PM Posted to microsoft.public.access.forms
|
|
Replies: 2
Views: 107
SetFocus
I am so sorry, for some reason, I kept getting an error that my question
wasn't posted so I kept trying. I just noticed that the posts did in fact go
through and I have multiple posts of the same...
|
|
Forum: Using Forms
July 23rd, 2009, 03:24 PM Posted to microsoft.public.access.forms
|
|
Replies: 3
Views: 117
SetFocus
I'm not running any other code. Also, I'm sure, its not going to Current_CHL
at all, it just goes to New_CHL. The dept. that I'm building the database
for wants to limit the users access to...
|
|
Forum: Using Forms
July 23rd, 2009, 02:53 PM Posted to microsoft.public.access.forms
|
|
Replies: 2
Views: 107
SetFocus
Hello,
I have a form with a combo box and two text boxes. Depending on the
selection the user makes I want the cursor to move to one of the text box.
Action (combo box) Current_CHL (text box)...
|
|
Forum: Using Forms
July 23rd, 2009, 02:48 PM Posted to microsoft.public.access.forms
|
|
Replies: 0
Views: 91
SetFocus
Hello,
I have a form with a combo box and two text boxes. Depending on the
selection the user makes I want the cursor to move to one of the text box.
Action (combo box) Current_CHL (text box)...
|
|
Forum: Using Forms
July 23rd, 2009, 02:11 PM Posted to microsoft.public.access.forms
|
|
Replies: 3
Views: 117
SetFocus
Hello,
I have a form with a combo box and two text boxes. Depending on the
selection the user makes I want the cursor to move to one of the text box.
Action (combo box) Current_CHL (text box)...
|
|
Forum: Using Forms
June 11th, 2009, 02:46 PM Posted to microsoft.public.access.forms
|
|
Replies: 6
Views: 173
Selection from List Box to Text Box
Douglas,
Thank you so much for taking the time to explain to me the steps.
The code worked great. I only have one question. As I scan through my
records, the "spots" that were highlighted in the...
|
|
Forum: Using Forms
June 10th, 2009, 09:51 PM Posted to microsoft.public.access.forms
|
|
Replies: 6
Views: 173
Selection from List Box to Text Box
Douglas,
Thanks for answering my post. Where would I put this code? I'm not sure
what the code is doing, can you explain a little for future reference please?
Thanks.
"Douglas J. Steele"...
|
|
Forum: Using Forms
June 10th, 2009, 06:27 PM Posted to microsoft.public.access.forms
|
|
Replies: 6
Views: 173
Selection from List Box to Text Box
Hello,
I have a multi select list box, and I would like to have each selection the
user selects to show up in a text box separated by commas. I have read
enough and I know that its "Evil" to...
|
|
Forum: Database Design
June 9th, 2009, 03:26 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 24
Views: 568
New Database - Primary Key
Thank you all for all of your information. I really learned a lot from your
post and they cleared up a lot of questions I had about the Primary Key.
Thanks Again.
"Bernard Peek" wrote:
In...
|
|
Forum: Database Design
June 5th, 2009, 08:58 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 24
Views: 568
New Database - Primary Key
Bernard and Armen,
Thank you for answering. Honestly, I have read so much about why I should
and shouldn't be using the AutoNumber, that I just didn't use it and used the
DMax function instead. ...
|
|
Forum: Database Design
June 5th, 2009, 07:34 PM Posted to microsoft.public.access.tablesdbdesign
|
|
Replies: 24
Views: 568
New Database - Primary Key
Hello,
I've read a lot of the threads referencing Primary Key and I need a little
help. I'm creating a database for my company to track changes to channels.
This database will be accessed in...
|
|
Forum: Using Forms
February 25th, 2009, 01:18 PM Posted to microsoft.public.access.forms
|
|
Replies: 2
Views: 107
Help with Catching Duplicate Before Update
Allen,
Thanks for your response. I'll give it a try and let you know.
"Allen Browne" wrote:
Suggestions:
1. Use the BeforeUpdate event of the *form*, not of a control. At the time
the...
|
|
Forum: Using Forms
February 24th, 2009, 04:13 PM Posted to microsoft.public.access.forms
|
|
Replies: 2
Views: 107
Help with Catching Duplicate Before Update
I have the following code:
Private Sub LOCATION_BeforeUpdate(Cancel As Integer)
Dim varADDRESS As Variant
If Me.NewRecord Then
varADDRESS = DLookup("[ADDRESS]", "LEAKS FOUND",...
|
|
Forum: Setting Up & Running Reports
October 16th, 2006, 09:46 PM Posted to microsoft.public.access.reports
|
|
Replies: 0
Views: 76
Application-defined or object-defined error.
Hello,
I'm using Microsoft Access 2003. I have a report with 5 sub-reports. I
tried to insert a 6th one and I received the above stated error.
Can anyone tell me why this is happening and how...
|
