|
More site info...
|
|
Forum profile page for Forms on http://www.access-programmers.co.uk.
This report page is the aggregated overview from a single forum: Forms, located on the Message Board at http://www.access-programmers.co.uk.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "Forms" on the Message Board at http://www.access-programmers.co.uk is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on Forms:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
222
|
675
|
1,787
|
|
Post:
|
941
|
2,830
|
7,446
|
|
|
Forms Posting activity graph:
|
Top authors during last week:
user's latest post:
Oat-so-simple but i dont have a...
Published (2009-11-25 13:26:00)
Quote: Originally Posted by Kryst51 Bob, if that works, and we don't figure out why it isn't just "working" as is, what are some reasons that could happen? I haven't ever experienced it and am kind of curious. Something would be coercing it in as TEXT. But why, I'm not sure without seeing the actual database.
user's latest post:
Oat-so-simple but i dont have a...
Published (2009-11-26 17:53:00)
Try using Nz() to account for Null values in your "idle" textboxes. =Val(Nz([Quantity], 0)) +Val(Nz([Quantity_In], 0))
user's latest post:
protect a form and allow to add...
Published (2009-11-26 20:28:00)
Quote: Originally Posted by HiTechCoach I hate to have to disagree, but that is not a true statement. spoken like a true hardcore programmer.
user's latest post:
Using the same value in a field...
Published (2009-11-25 12:43:00)
Quote: Originally Posted by Robbieb29 Sorry to be a pain, but now the user is enable to alter the combo box. I need the user to be allowed to add to the combobox, as there will be locations that are not on the list. Did you read post #12 of the thread I have now referred you to on two occasions, this explains how to use the On Not In List event and the On Double click event to allow the addition of new items to the list.
user's latest post:
Re: Oat-so-simple but i dont...
Published (2009-11-26 08:56:00)
I have doen this but like i said before when the text box is idle I.e i havent pressed enter, it is showing #Error until i do press enter?
user's latest post:
Oat-so-simple but i dont have a...
Published (2009-11-25 14:27:00)
I'll be checking this out later, after I get through traffic, leaving work in three mins. woohoo. Thanks for posting it in 2003 format.
user's latest post:
protect a form and allow to add...
Published (2009-11-26 20:08:00)
Quote: Originally Posted by ajetrumpet just remember that you cannot add a new record to a table that is already open. ... I hate to have to disagree, but that is not a true statement.
user's latest post:
Adding, or changing a record...
Published (2009-11-23 07:27:00)
Good Morning Good People: I am happy to inform you that I have solved my Access Database problems - for the time being. I was able to add a new record (Teacher) via the "All Data Objects" and clicking on the record or Form pertaining to what I wanted to accomplish. Thanks for your help Bob Larson. I am sure I will run into other problems, so just the thought process and communications between an expert and a novice, spurrs...
user's latest post:
Assign recordset to combo...
Published (2009-11-23 17:49:00)
Quote: Originally Posted by boblarson You still didn't answer my question about B) - why do you need to populate at runtime since the query had no where clause. 1) I wish to have the latest /updated value 2) In order for (C) to run, this is the only way to create unbound control but load all value at run time through the GotFocus event.
|
|
|
|
Latest active threads on Forms::
Started 23 hours, 13 minutes ago (2009-11-27 15:54:00)
by boblarson
What is the structure of your tables?
Started 23 hours, 44 minutes ago (2009-11-27 15:23:00)
by boblarson
You could set the other text box's control source to:
=Eval([YourTextBoxNameHere])
leaving the square brackets around it.
Then you can enter this:
1/(4*8)
and it will evaluate it.
Started 22 hours, 38 minutes ago (2009-11-27 16:29:00)
by gemma-the-husky
MS have a reasonable inventroy template
Started 22 hours, 38 minutes ago (2009-11-27 16:29:00)
by gemma-the-husky
look at the code in the
HandleButtonclick event
when you click a button, this fires for the relevant number button
eg - the event handler for button7 is
=handlebuttonclick(7)
Started 1 day ago (2009-11-27 14:11:00)
by boblarson
If you are using Access 2007, you shouldn't need ANY code to do this.
There is a setting in the control ( combo box) to show which form to open when adding a not in list item. Once you've set that it will open that form for you and when you add the new value and close the form it will be added to the combo.
Started 1 day, 5 hours ago (2009-11-27 09:34:00)
by boblarson
Nope, sorry it is not going to work. The behavior of Access just simply won't allow it to happen. (I know, I've wanted to do some things like that at times but it won't work).
Started 1 day, 7 hours ago (2009-11-27 07:54:00)
by smig
if you don't know how to use listbox why do you think listbox is the correct way to do what you want.
listbox (and combox) are mostly used to select a value from one table to put in another table.
let's say you want to set an appointment with a doctor - you use the list box to select the doctor you want (from an existing list of doctors), and the other fields to select the date and time.
Started 1 day, 5 hours ago (2009-11-27 09:54:00)
by missinglinq
Quote:
Originally Posted by Payal Patel
That is still not getting it to do what I want.
How is that "not getting it to do what I want?" Is it not opening to the form?
Started 2 days, 1 hour ago (2009-11-26 13:50:00)
by missinglinq
You're making life hard for yourself by opening and closing the form each time you want to add a record, and Access forms have a property that will do exactly what you want!
In Form Design View , goto Properties - Data and set the Data Entry Property to Yes . Now you will be able to enter new records , but you won't being able to view records that existed prior to opening the form ....
Started 3 days, 3 hours ago (2009-11-25 11:10:00)
by Payal Patel Registered User
Hi,
I have a form with a command button to execute 2 queries. Here is the code I have:
Private Sub Command7_Click()
DoCmd.SetWarnings False
DoCmd.OpenQuery "Concat Query"
DoCmd.OpenQuery "Make Table Query"
DoCmd.SetWarnings True
MsgBox "Execution Complete"
End Sub
When I run this through the command button, instead of just running, it opens the tables. Is there a way ...
|
|
Hot threads for last week on Forms::
Started 3 days, 2 hours ago (2009-11-25 12:39:00)
by Kryst51
Are those text boxes number format?
Started 1 week, 2 days ago (2009-11-19 08:25:00)
by boblarson
Quote:
Originally Posted by jcraw42
I have a document with the forms and design view included, but am unable to upload it due to size restrictions (419kb). The forum only allows 100kb uploads.
Did you zip the file? A Zip file can be up to 785Kb.
Started 1 week, 1 day ago (2009-11-20 12:44:00)
by mikerea90 Registered User
Hey all,
Does anyone know how to run an update query on a specific record in a list box upon double-clicking on that record?
Thanks
Started 5 days, 1 hour ago (2009-11-23 13:40:00)
by John Big Booty
You could use the following in the After Update event of Your Combo;
Code:
Me.ComboName.DefaultValue = Me.ComboName
Started 1 week ago (2009-11-21 06:06:00)
by missinglinq
That's not assigning a recordset to the combobox, it's trying to assign an entire recordset to the Value Property of the cbo!
I'm guessing what you're trying to do is have the combobox display the recordset when dropped down, i which case you need to assign the recordset to the RowSource of the cbo.
cboDefectGroup.RowSource = rsTemp2("Description")
Started 4 days ago (2009-11-24 14:26:00)
by froadie froadie is offline Registered User
Hi,
I have a text box that was formatted as currency. However, when I bound it to a field, it lost the formatting. When I go to Format in the Properties box and click the dropdown list, there are no longer any format options available. I'm facing this problem with several different text boxes. Is there any way to get that formatting back? Or any other way to format a bound text box as currency...
Started 1 week ago (2009-11-21 14:37:00)
by GalaxiomAtHome
Add the quantity to the Row Source of the combo but set its column width to zero.
For the control source of the text box;
= comboboxname.Column(x) where x is the column number of the quantity (starting at zero)
However you should calculate the quantity rather than store it. You have a record of the number of items you have for rent. Calculate the quantity on hand by subtracting the ...
Started 1 week ago (2009-11-20 16:40:00)
by Zaeed
in the before update event for the subform have some code that checks the isnull property for the fields..
IsNull(me.textbox1) And isnull(me.textbox2)
then if this is true, run a sql delete command
Started 2 days, 22 hours ago (2009-11-25 17:05:00)
by ajetrumpet
Started 1 week ago (2009-11-21 08:05:00)
by lagbolt
I would start with the tables. Do you have any work done already in this regard?
You'll need an Options table, something like...
Code:
tOption
OptionID
Description
Points
Then maybe a UserSelection table, where the choices a user makes are stored...
Code:
tUserSelection
SelectionID
OptionID
UserID
Not shown is a User table so you can distinguish one user ...
|
|
Size: 37 bytes
