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 5.32 seconds.
Search: Posts made by: Linq Adams via AccessMonster.com
Forum: Using Forms June 5th, 2010, 09:30 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 1,925
SubForm, or something Else?

Larry's advice here is, indeed, reflective of the advice given by evey
experienced developer in Access that I know of! Your statement

"I have Chosen (big Grin) to utilize the new Multivalued...
Forum: Using Forms June 5th, 2010, 12:54 AM Posted to microsoft.public.access.forms
Replies: 4
Views: 2,103
Tab Order

"if a change is made in either a check box or text box, when tab is pressed
again, the focus goes to the first field of the first record"

Unless this is some weird type of form corruption, it...
Forum: Using Forms June 4th, 2010, 01:34 AM Posted to microsoft.public.access.forms
Replies: 4
Views: 1,830
status validation help

OK, if the user inputs an Amount then they must enter a "Date" in order for
the database to accept a
Complete "Status." What if an amount is not input, can the status "Complete"
then be acceptable? ...
Forum: Using Forms June 4th, 2010, 12:02 AM Posted to microsoft.public.access.forms
Replies: 4
Views: 366
Sum error on continous subform

Is [TicketWeight] an entered field or a calculated field? Aggregate Functions
don't work against calculated fields, you have to run them againgst the
expression used for the calculation.

If A + B =...
Forum: Using Forms June 1st, 2010, 05:17 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 341
Replace "assign the null value" message

You can use the Form_Error event. Here's an example for a
single error, in this case the one you cited, I believe.

Private Sub Form_Error(DataErr As Integer, Response As Integer)

Select Case...
Forum: New Users May 25th, 2010, 06:34 PM Posted to microsoft.public.access.gettingstarted
Replies: 7
Views: 284
Filtering Records

A query. when opened, is only going to display data in what you're calling a
"datasheet" view. To have the data displayed as a "form" view, as John said,
you need to "design a form in continuous...
Forum: Using Forms May 25th, 2010, 12:28 AM Posted to microsoft.public.access.forms
Replies: 3
Views: 325
Provide Help/Tutorial Form

Actually, you'd have to use a whole lot of labels, as labels have a 2,048
character limit.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message...
Forum: General Discussion May 24th, 2010, 08:48 PM Posted to microsoft.public.access
Replies: 2
Views: 176
Combo Box Issue

I think we need to see what code you have in the OnChange, OnClick,
AfterUpdate events of the combobox to figure out what's popping the error.
You're there and can see your code, but we're here and...
Forum: Using Forms May 22nd, 2010, 02:09 AM Posted to microsoft.public.access.forms
Replies: 1
Views: 395
trigger an event by changing pages in a tab control form

Your problem is that you have to select the Tabbed Control, not an individual
page.

The event to use is the Tabbed Control OnChange event. Here's an example:

Private Sub...
Forum: Using Forms May 21st, 2010, 10:18 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 378
show 2nd field when combo box choice is made

Set up your combobox using the wizard and include the fields you need, from
Left-to-Right.

If in the Combobox they appear as

Product Price

the code would be

Private Sub...
Forum: Using Forms May 20th, 2010, 08:19 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 334
crash on form with two subforms

You say that the back end is SQL (although you don't say SQL what) so I
assume that the database is split.

Does each user have a copy of the front end on their individual hard drive?
Multiple users...
Forum: Using Forms May 19th, 2010, 06:48 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 365
Conditional Format Not Working

What did your expression look like in Conditional Formatting? The correct
syntax should be

[Critical] = "High"

just like that, with the square brackets around the control's name. Then set
the...
Forum: Using Forms May 19th, 2010, 03:40 PM Posted to microsoft.public.access.forms
Replies: 8
Views: 369
Create datasheet in MDE

The whole point of an MDE file is to prevent users from making design changes,
which is exactly what you were attempting to do. You'll have to follow Doug's
suggestion.

--
There's ALWAYS more than...
Forum: Using Forms May 16th, 2010, 01:49 AM Posted to microsoft.public.access.forms
Replies: 5
Views: 294
forms

You're sitting in front of your database, we're not! If you want us to help
you'll have to do a much better job of telling us about your form!

Is there code in the Form_Open or Form_Load events of...
Forum: New Users May 15th, 2010, 12:09 AM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 293
Newbie Access Programer

With your background, you also need to keep in mind that Excel VBA and Access
VBA are not the same language! Some functions are available in both and some
aren't, and some with the same exact name...
Forum: Using Forms May 14th, 2010, 11:31 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 346
Creating forms from queries

What is the EXACT message that you receive? There is nothing that inherently
prevents the Access Form Wizard from creating a Justified Form from a query,
but the Wizard will choke if there is an...
Forum: Using Forms May 14th, 2010, 10:02 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 288
enable/disable text box based on 3 combos

Text is a Reserved Word in Access and is, in fact, the name of a textbox
property, and

Me.Text.Enabled = True

may confusing the Access gnomes! I'd modify the name of the textbox.

Also, your code...
Forum: Using Forms May 14th, 2010, 09:37 PM Posted to microsoft.public.access.forms
Replies: 4
Views: 298
Trying to use DLookup

You should also note that

Number

is a Reserved Word in Access, and field's name should really be changed to
something else. Sooner or later it may cause a problem.

--
There's ALWAYS more than...
Forum: General Discussion May 13th, 2010, 08:46 PM Posted to microsoft.public.access
Replies: 1
Views: 78
Setting

This newsgroup is dedicated to users of the database creation program, MS
Access, not to "access" in the general sense. You need to find a more
appropriate newsgroup/forum.

--
There's ALWAYS more...
Forum: New Users May 13th, 2010, 08:32 PM Posted to microsoft.public.access.gettingstarted
Replies: 17
Views: 531
F- in Access

Steve , please go and play in heavy traffic! This site is not to eb used to
hawk your dubious skills, as you've been told hundreds of times!

--
There's ALWAYS more than one way to skin a...
Forum: Using Forms May 13th, 2010, 07:42 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 474
How to enable New/Delete record button when a form opened?

Are we talking about when the form or the subform or both have focus? Are
these forms based on tables or queries? If queries, can you delete or add
records if you open the queries independent of the...
Forum: Using Forms May 13th, 2010, 06:56 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 281
How to get one field to update based on a selection from a drop do

Private Sub YourComboBox_AfterUpdate()
Me.TextBoxName = Me.YourComboBox.Column(X)
End Sub

where the X is an integer designating the column of the combobox you want to
populate the Textbox. This...
Forum: Using Forms May 13th, 2010, 03:30 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 391
cant type more than 11 numbers

Ronaldo has hit the nail on the head here. Following his advice is the way to
go.

As he has suggested, a field that contains all digits but isn't used for
mathematical operations really should be...
Forum: Using Forms May 13th, 2010, 03:26 PM Posted to microsoft.public.access.forms
Replies: 6
Views: 474
How to enable New/Delete record button when a form opened?

This would seem to indicate that your forms are now Read-Only. What
modifications have you made to your forms/database prior to the problem
arising?

Also, what version/service pack of Access are you...
Forum: General Discussion May 12th, 2010, 02:43 PM Posted to microsoft.public.access
Replies: 4
Views: 105
Expression

Amen to everything Arvin said! Also, you have a typo

Amt [MumDays]*[DailyRent]

MumDays should be NumDays. Whether this simply is a typo in your post here or
a typo in your expression, I can't...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 10:30 PM.


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