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 20 of 20
Search took 0.07 seconds.
Search: Posts made by: Trini Gal
Forum: Database Design June 2nd, 2010, 04:48 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 5
Views: 10,042
Posted By Trini Gal
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: 10,042
Posted By Trini Gal
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: 10,042
Posted By Trini Gal
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: 204
Posted By Trini Gal
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: 67
Posted By Trini Gal
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: 67
Posted By Trini Gal
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: 73
Posted By Trini Gal
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: 81
Posted By Trini Gal
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: 73
Posted By Trini Gal
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: 65
Posted By Trini Gal
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: 81
Posted By Trini Gal
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: 95
Posted By Trini Gal
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: 95
Posted By Trini Gal
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: 95
Posted By Trini Gal
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: 464
Posted By Trini Gal
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: 464
Posted By Trini Gal
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: 464
Posted By Trini Gal
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: 78
Posted By Trini Gal
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: 78
Posted By Trini Gal
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: 49
Posted By Trini Gal
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...
Showing results 1 to 20 of 20

 
Forum Jump

All times are GMT +1. The time now is 12:46 PM.


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