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 1.77 seconds.
Search: Posts made by: BruceM via AccessMonster.com
Forum: Using Forms June 3rd, 2010, 12:10 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 718
Combo Box Adding Button to edit list items

This is not exactly what you were asking about, but here is a way to add a
new item to the list using the Not In List event (the combo box Limit to List
property is set to...
Forum: Using Forms May 28th, 2010, 08:40 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 628
Toggle button vs Command button

The simplest would be by way of an option group. Just use option buttons
rather than radio buttons or command buttons. You would use one Integer
field where you are now using a separate field for...
Forum: New Users May 28th, 2010, 04:49 PM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 391
One last try

"One more" suggests previous attempts. What happened? If you posted a
question in a newsgroup and were told you should not store the calculation
result, you will be disappointed that I am saying...
Forum: General Discussion May 27th, 2010, 02:04 PM Posted to microsoft.public.access
Replies: 2
Views: 126
tax refund

This is a Microsoft Access newsgroup. I don't know about the tax refund, but
if that is your real e-mail address you will probably be getting lots of new
e-mail now that you have posted it in a...
Forum: New Users May 26th, 2010, 03:17 PM Posted to microsoft.public.access.gettingstarted
Replies: 9
Views: 439
Is it worth it for me to learn Access?

You will be shot down every time you try to sell your services here. Lashing
out at justifiable reprimands only makes you look small and desperate.

Steve wrote:
Code of Conduct for these...
Forum: Database Design May 26th, 2010, 03:09 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 543
How to add record in Subform which is in another Subform

First, those are VBA procedures, not macros.

Why are you adding a new record to another subform? Why not go to that
subform to add the record, since you need to go there anyhow to enter...
Forum: Using Forms May 26th, 2010, 01:56 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 359
Common “Button Block”

Depending on what the buttons are used for, it may be possible to create a
buttons subform, but I'm not sure that offers enough advantages over copy and
paste to justify the possible added complexity...
Forum: Using Forms May 25th, 2010, 05:51 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 339
Displaying Yes/No as Yes or No instead of -1 and 0

Are you saying you have a two-record table as the Row Source of the combo box?
If so, what are the data types of the two fields? To what type of field is
the combo box bound?

Is there a reason you...
Forum: Setting Up & Running Reports May 25th, 2010, 01:21 PM Posted to microsoft.public.access.reports
Replies: 8
Views: 334
hiding control textbox when no data

I often use concatenated values in a single text box or query field. For
instance, in a query:

FullAddress: [CompanyName] & Chr(13) & Chr(10) &
[Address1] & Chr(13) & Chr(10)...
Forum: New Users May 25th, 2010, 01:01 PM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 286
Combine number in a Table field

Is there a connection between the two tables? I agree that there is no
reason to save the calculated value, but for any purposes of combining values
(including calculations) you need to specify from...
Forum: Using Forms May 25th, 2010, 12:47 PM Posted to microsoft.public.access.forms
Replies: 2
Views: 347
Load Image Timing

It would help if you post the code. Is there a connection between the input
box and the image?

In general, you can use DoEvents to allow the code to "catch up", but that
may not be the problem. To...
Forum: Using Forms May 24th, 2010, 04:43 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 367
Having a difficult time with a lookup

BTW, my response a few minutes ago assumes Access 2003 or earlier. For 2007
or later the procedure will differ somewhat, but I do not have Access 2007 in
front of me, so I cannot provide...
Forum: Using Forms May 24th, 2010, 04:41 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 367
Having a difficult time with a lookup

Your question is about basic functionality, not bells and whistles. DLookup
is not the best way to go about this. Unless there is a specific reason you
want to search by number rather than name, I...
Forum: Using Forms May 21st, 2010, 12:19 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 366
Form Open Error Message

For one thing, the Open event is too soon to work with the recordset, as it
has not yet been loaded. The Load event would be the place for DoCmd.
GoToRecord , , acNewRec (or Me.Recordset.AddNew). ...
Forum: Using Forms May 20th, 2010, 07:31 PM Posted to microsoft.public.access.forms
Replies: 19
Views: 597
Setting up tables for grades

I meant to mention that a query based on a table can be used as the Record
Source for a form or report. If tblCourseGrades can be the Record Source, so
can a query based on tblCourseGrades. A query...
Forum: Using Forms May 20th, 2010, 02:05 PM Posted to microsoft.public.access.forms
Replies: 19
Views: 597
Setting up tables for grades

When asking about forms you should always describe the Record Source. Going
back to the table structu

tblStudents:
StudentID
Last Name
etc.

tblCourses:
CourseID
Forum: General Discussion May 19th, 2010, 06:28 PM Posted to microsoft.public.access
Replies: 5
Views: 166
Access hyperlinks ignore file associations

I don't think there was a question about the internet. The OP mentioned
"Windows Explorer", which is another name for My Computer. Perhaps you read
it as Intenet Explorer, or maybe I just missed...
Forum: Using Forms May 19th, 2010, 05:42 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 406
help needed with a combo box

What have you tried that isn't working?

alanb wrote:
sorry quys, still not working, I am just getting more confused.

--
Message posted via http://www.accessmonster.com
Forum: Using Forms May 19th, 2010, 03:57 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 406
help needed with a combo box

That is another way to do it, but "need to" implies it is the only way, which
is not the case. With your approach, requerying the combo box is the only
code, but when I can I prefer to avoid form...
Forum: Using Forms May 19th, 2010, 01:38 PM Posted to microsoft.public.access.forms
Replies: 7
Views: 406
help needed with a combo box

I would use an unchanging number for SupplierID. Names change.

Anyhow, in the After Update event of the supplier combo box, something like:

Dim strSQL as String

strSQL = "SELECT * FROM...
Forum: Using Forms May 19th, 2010, 01:01 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 378
How to prevent form from closing

You could try something like this in the cmdSave Click event:

On Error GoTo cmdSave_Click_Error

If Me.Dirty Then Me.Dirty = False
Me.Contatore = fctAnnoNr(Me.DataChiamata)

ProcExit:
End Sub
Forum: Using Forms May 18th, 2010, 07:25 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 378
How to prevent form from closing

Why fight the built-in Close button? Just set Close Button and/or Control
Box to No, and make your own button to close the form:

Me.Dirty = False
DoCmd.Close acForm, Me.Name

How are you performing...
Forum: Using Forms May 18th, 2010, 12:53 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 378
How to prevent form from closing

It usually helps to post the actual code when there is a question about the
code. Why show them the X button (top right corner, not left, but I assume
you meant that) at all? You should be able to...
Forum: Using Forms May 18th, 2010, 12:08 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 266
Auto number

There is a technique for doing that he

http://allenbrowne.com/ser-26.html

Be aware, if you are not already, that you cannot rely on autonumber for an
unbroken sequence of numbers. There will...
Forum: Database Design May 17th, 2010, 01:07 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 356
designing form for inserting records into separate tables

First of all, you should not be storing the value for DocNo. Just calculate
it on the fly, using an expression such as you have shown as the Control
Source of a text box or as a query field. ...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 05: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.