Controlling Changes To Combo Box
Jan 17, 2007
I have a form. In it is a status field that can be:
NEW
SENT
CREDIT
COLLECT
CLOSED
When the item is created, it is given a "NEW" Status. And there is a command button on the form that can change the status to "SENT". However, based on external factors (email received or system report examined) the user can manually change the status to the CREDIT, COLLECT or CLOSED. Now, I want to make sure that then can't change the status manually to "SENT", only the system is allowed to do that via the command button.
How can I allow them to use some of the allowed values, but not others?
David
View Replies
ADVERTISEMENT
Jun 29, 2005
Is it possible to control the data of a subform by making selection in a combo box?
View 2 Replies
View Related
Apr 21, 2005
Hi,
I'm v.new to Access so do excuse my ignorance.
I have a form with a combo-box with the following values:
Trust, Course, Overseas, GP
When Trusts is selected I'ld like frmtrust_sub to appear.
When anything else is selected I'ld like frmnontrust_sub to appear
Once the data has been entered in the subform the user would continue back to the main form.
I'ld like the subforms to remain hidden until needed, if possible so as not to confuse users.
I’ve copied this piece of code and have tried pasting it into the “after update” event procedure but I get this error message
“the link masterfields property section has produced this error “Ambiguous name detected: Type_afterupdate”
Private Sub Type_AfterUpdate()
Option Compare Database
Sub ShowSubform()
'Save unsaved changes to currently open subform
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
'Display appropriate subform based on Type chosen
If Type = "Trust" Then
frmtrust_sub.Visible = True
frmnontrust_sub.Visible = False
ElseIf Type = "GP" Then
frmnontrust_sub.Visible = True
frmtrust_sub.Visible = False
ElseIf Type = "Course" Then
frmnontrust_sub.Visible = True
frmtrust_sub.Visible = False
ElseIf Type = "Overseas" Then
frmnontrust_sub.Visible = True
frmtrust_sub.Visible = False
ElseIf Type = "Other" Then
frmnontrust_sub.Visible = True
frmtrust_sub.Visible = False
End If
End Sub
Private Sub cmdClose_Click()
'Close form
DoCmd.Close
End Sub
Private Sub Form_Current()
'Call subroutine to display appropriate subform based on template type
ShowSubform
End Sub
Private Sub Type_AfterUpdate()
'Call subroutine to display appropriate subform based on template type
ShowSubform
End Sub
Any help would be greatly appreciated
thanks
Barry
View 1 Replies
View Related
Oct 6, 2014
I have a project database where I keep track of the work in progress on monthly bookkeeping for our clients. I have a form where I use a ComboBox to select the client and another ComboBox to select whether a sales tax report must be filed Monthly, Quarterly or Annually. I have 17 CheckBoxes one for every month, quarter and year-end. I want the selection in the sales tax reporting ComboBox to trigger which CheckBoxes are available to check.
That is, if "Monthly" is selected in the ComboBox, then only the 12 monthly CheckBoxes are available to check (the 4 quarterly and 1 year-end CheckBoxes will be disabled). If "Quarterly" is selected in the ComboBox then only the 4 quarterly CheckBoxes are available to check. Of course, "Annual" is the third option. The disabling of CheckBoxes must be on a record by record basis. "Monthly" could be selected for one client (one record) and "Quarterly" for another client (another record).
View 14 Replies
View Related
Jun 16, 2005
Hello All,
How would I run a procedure in DB2 from DB1?
View 3 Replies
View Related
Jan 5, 2007
Hello,
Dont understand what is controlling these decimals. I dont need any decimals for this database. The currency is talking bout money in 1000's and the probability is whole numbers.
Here is where I cant get the decimals to stop:
http://img80.imageshack.us/img80/3685/untitled2pl2.png
http://img77.imageshack.us/img77/6276/untitled3pa6.png
http://img208.imageshack.us/img208/2047/untitled3lk8.png
I have tried different things but no luck...anyone have any suggestions.
Thanks.
View 10 Replies
View Related
Jan 12, 2007
In a simple access table, I have the follwiing:
Data type: Date/Time
Format: mm/yyyy
Input Mask: 99/99
It restricts me to enter 2006 for instance. It converts to 2007. I want to be able to enter any year. Please help. Thank you.
View 2 Replies
View Related
Dec 10, 2006
Howdie y'all
I need a few pointers wrt the relationship between a form and its subform.
I have the following form:
http://i88.photobucket.com/albums/k193/bernmc/Misc/DefaultStaffingscreenshot.jpg
Top part of the form is for adding/editing etc.
The subform is based on a query. The two are linked on the 'week' value.
Now, this is what I want to do:
The user must not be able to edit data in the subform (so should I use a report instead... but then will I be able to do 2...).
Selecting a row in the subform should cause the whole form to go to that record so that the user can then modify info in the fields of the main form.
I don't know VB - the only code I've used is gleened from searching these forums (a great resource, so I'm learning slowly), so I'll need a bit more than 'Do a wrzmitchigob on the bleedlethrop'!
View 10 Replies
View Related
Mar 27, 2008
My report has the Section's Footer.
Each time the section runs, it will take up a different amount of space.
I have already run all the code, to move all the different controls to the top (and be invisible) when they are not needed.
So to the best of my knowledge, I have no controls sitting in the lower part of the section.
The last thing I run is:
Code: Me.S123.Height = Me.S123.Height - 300
s123 is the name of the Footer SEctions. The idea is that it gets progressively smaller.
This is all running in:
Code:Private Sub S123_Format(Cancel As Integer, FormatCount As Integer)
All the other things work.
Here is a sample of it all..
Code:If Me.txt2 = 0 Then Me.a2.Visible = False Me.b2.Visible = False Me.a2.Top = 0 Me.b2.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End IfIf Me.txt2 <> 0 Then Me.a2.Visible = True Me.b2.Visible = TrueEnd IfIf Me.txt3 = 0 Then Me.a3.Visible = False Me.b3.Visible = False Me.a3.Top = 0 Me.b3.Top = 0 Me.box.Height = Me.box.Height - 300 Me.S123.Height = Me.S123.Height - 300End If
This runs through 8 different numbers.
as I said, all the other things operate properly. They get hidden and move.
Any thoughts?
Thanks.
View 3 Replies
View Related
Feb 6, 2006
Hi there,
Is it possible to control a lighting system from Access using a combination of VBA code or Active X add ons with some specialist hardware and cabling attached to the PC, etc ?
To be more specific, I've designed a Snooker Hall Management program and want to be able to turn the lights on over the Snooker table when you start a game in an Access form...My application has 8 tables but could be expanded obviously.
I'm happy with the Access side of things (first attempt at a real world solution, etc) but to be totally polished a hardware interface to control the lights would really create a 'wow' factor...
Any help or direction would be greatly appreciated :)
Regards
dazza61
View 4 Replies
View Related
Mar 30, 2006
Developing in Access 2000. The mouse roller button moves to the next record in a form. Does anybody know how to trap the roller button? Setting me.cycle to 1 prevents the same happening when you tab from the last field but does not stop the mouse roller ball.
Any help greatly appreciated.
View 2 Replies
View Related
Jul 6, 2006
Hi again!
This time I'm having some problems finding a way to determine the output of a scroll-down menu (or in my danish version of Access called "combination-box").
In the menu I can choose between a number of names from a table. But when I select the name and press the "OK" button that stores the data, only a number (and not the choosen name) is written in the table. How can I get the output-value of the drop-down to be the choosen name???
Please give me a simple answer and a simple solution... I'm a total newbie!!
// JR
PS. Mike, feel free to reply... I kinda like your style:-)
View 2 Replies
View Related
Jan 25, 2007
Can i set the physical dimensions of the MS Access main window from code, like when I open my first form?
My main development computer has a massive big screen, but I mainly program for 1024x768 screen. When the database appears on my screen I'd like to resize it bigger as I see fit, but have my code open it to a 1024x768 sized screen when it opens on someone else's computer.
View 2 Replies
View Related
Feb 2, 2015
I have one form "Products" that I have a button on which opens up another form. The second form lists a different number of lines depending on how many items are in a group.
The problem I am having is that I can not make the second form shrink or grow depending on how many line items I have in each group. Currently, I have to make the form as large as the most possible lines I could have (which is 19) but sometimes I might only have 5 lines in a form.
View 6 Replies
View Related
Jul 20, 2015
I have spent the better half of the afternoon researching how to accomplish controlling a bold font in a string I am building and sending to Excel.
Code:
' set text for safety hazards and controls
Concretetxt = "Concrete Demolition & vbCrLf & Hazards - dust, flying debris and skin Irritation. & vbCrLf & Control - Respirator, goggles, gloves, inspect equipment prior to use."
Excavationtxt = "Excavations & vbCrLf & Hazards - Damage to underground wires, collapse, falling materials/equipment. & vbCrLf & Control - Ensure utilities have been marked and hand dig when in close proximity, shore properly, Keep clear when lowering materials."
This is a sample of how the strings will build. I will select a task like Concrete Demolition and string it together with other tasks I would like "Concrete Demolition" in bold with the blurb following it then the next task would follow with a bold heading.
My thought is now that it may be easier to control by putting this data into a table instead of building the strings.
View 2 Replies
View Related
Oct 10, 2014
I am trying to figure out how to control a navigation tab with a checkbox. I have a database for my fire dept and the check box is called "deceased". When a member passes away, the active box gets unchecked and deceased gets checked. Under the member subform, there is a tab, navigationbutton19, that is called deceased also and under this tab all their burial information is stored. What I am trying to do is, if the checkbox is not checked, I want the tab to be enabled = false.
View 1 Replies
View Related
Jul 5, 2013
So I've got a form:
- A set of unbound controls filters (using a dynamically-built WHERE statement) a subform in datatable view.
- A set of bound controls displays the currently selected subform record; the two reflect one another.
- A set of unbound checkboxes at the bottom allows the user to change which fields are displayed in the subform.
Turns out, all of this makes for a pretty big form. Some of the users have screens that will not fit the full form due to resolution settings, physical size, aspect ratio, etc. Whatever the reason, the result is one or both scrollbars appearing on the form.
The issue is this: Whenever the filter controls are changed, the form's Current event runs (because the After Update events for the filter controls all change the main form and subform's Recordsource). But the Current event causes the form to requery (or refresh?), meaning the focus returns to the control with Tab Index 1 (a "Home" button near the top of the form).
Thus, the form tends to "jump around" a lot when users are determining the records they want displayed.Is there a way to avoid this?
- Can I prevent the "Home" button from getting the focus during those times?
- Alternatively, can I set the position of the scroll bars so the user doesn't see that jumping around every time a control is updated? I found some interesting ideas that worked for continuous forms, but mine is a single form, so bookmarking methods won't solve my issue.
View 7 Replies
View Related
Jun 26, 2013
I have several forms that are set to open on a new record. I'm finding that while I'm working on the design of these forms I'm creating alot of blank records. This makes me think that when users start opening these forms, they may end up creating a lot of blank records as well. I think this is happening because there are controls on these forms that have default values set in them.
Is there a way that I can control how and when an actual new record is created from a form? I was considering using a particular field as a trigger, once it has a value, the record is created. If it is null, then the record is discarded. If I make a certain field a required field in the table, will that prevent a record from being created without an error message?
View 11 Replies
View Related
Dec 18, 2014
I am running Access 2010 on a Windows 7 platform and attempting to write a simple database for a local charity, and whilst I have basic skills in Access I would not put my level higher that enthusiastic amateur.I have a couple of fields, one called 'Income' which is a simple currency field. The second field is called Frequency and is a combo field where the user can choose from Weekly; Monthly; Quarterly; or Annual.
The database user enters data taken from a survey sheet which captures the income of an individual along with the frequency of the payment.The requirement.I would like to create a calculated field which gives the annual income.
Example:
Income = $5,000 Frequency = Monthly
the calculated field would return (5,000 x 12) = 60,000
Equally
Income = $1,000 Frequency = Weekly would return (1,000 x 52) = 52,000
View 2 Replies
View Related
Apr 25, 2015
I have developed a Kiosk interface for an insurance database application. I have turned off the Ribbon and most controls. I would like to be able to turn on document tabs when I generate a report in view mode. If there were document tabs at the top the user could just get rid of the window.
If I turn on the document tabs each windows that is present is under a different tab until they navigate backwards.
The other option is to always print the report but would like to view it first.
View 3 Replies
View Related
Jan 30, 2007
I want to have a MS Access 2000 database open, load a Form with various option buttons on and get Windows Media Player to play a MP3 music file. However, when I click a option button on the Form I want the music to stop.
Any ideas of code to do this?
Regards,
Dalien51
View 1 Replies
View Related
Jan 30, 2008
I have a nice chart that hasd done what I wanted it too.
Now I want to make the amount of X-AXIS data variable. Typically this would be 64 points. If you look at the datasheet, I can manually set the number of points by making sure the row selector is "raised".
Now that's say there is only 16 points of data to control. I can plot that those points but the chart is still 64 points wide with no data for points 17-64.
How can I, through code, prevent points 17-64 from plotting and thereby expand the graph horizontally larger and not display those null points?
I have tried a number of things including:
objDataSheet.Row(17).Delete
Graph_Data.Range("A1:A16:)
etc...
Nothing I have tried has worked. Is what I need to do possible?
Thanks much.
View 2 Replies
View Related
Oct 20, 2004
I have been trying to make forms open scrolled to the top and have had very little success.
I found a function on the following site http://www.lebans.com/SelectRow.htm that works great as demonstrated and when I attach the following code to a text box the form scrolls to the top.
Private Sub Text98_Click()
Dim lngret As Long
lngret = fSetScrollBarPos(Me, 1)
DoEvents
End Sub
What I am trying to do is have the form scroll when it opens but by attaching the above code to the form's on_open event there is no effect.
What am I doing wrong.
Any ideas
View 5 Replies
View Related
Jul 7, 2014
I'm currently making a form to display employee info in a nice fashion..
Anyway I have the employee photo displayed in an image control.
I want to be able to apply some tricks to the borders to make it look better. To do that, I need to make the width property equal to the width of the actual image while the height is restrained
To know what i mean check this : [URL] .....
View 6 Replies
View Related
Dec 2, 2013
I have a Form to Display Projects that has a SubForm displaying Sub-Projects related to them. The main Project Form has a Combo Box which allows a user to select a ProjectID to display. The SubForm has a ProjectID Field as well. When the Project ID is selected in the Main Form, only the appropriate Sub-Projects are displayed in the Sub-Form.
On the SubForm, there is a Field named ActionID, which uses the following VB Code to limit the availability of the Fields in the SubForm that apply to Dates. If the selected Action is Install, only Install related Dates should be available. Likewise, if the selected Action is Remove only Remove related Dates should be available.
Code:
If Me.ActionID.Column(1) = "Install" Then
Me.AssetInstallMonth.Enabled = True
Me.AssetInstallYear.Enabled = True
Me.AssetRemovalYear.Enabled = False
Me.AssetInstallMonth.Locked = False
[Code] ....
Everything seems to work as expected until there is more than one Sub-Project is the SubForm and they do not contain the same Action. In these cases, it appears as if the Sub-Projects in the SubForm are not being treated as individual records. If Sub-Project is Added or Modified to have an action of "Install", all records are treated as Install Records (only Install related Dates are available), regardless of their content.
Is there a way to update the properties for only the row that has been selected?
View 5 Replies
View Related
Nov 21, 2013
I have two tables linked to each other in one to many relationship. Instead of auto number, the date and shift (Text) is being used as the primary keys (Composite Primary Key). Here is the tables structures,
Payouts Table:
Date: Primary Key
Shift (Day or Night) : Primary Key
Bills Table:
Date: Primary Key
Shift (Day or Night): Primary Key
Autonumber: Primary Key
The tables Payouts and Bills has one to many relationship. One payout row can have many bills. The problem is that I want to start the Autonumber in bills table everyday from 1. As date and shift are different for every day so even if i start bills from 1 everyday, it wont make same primary key. I can do it manually but I want to make it automatically.
View 4 Replies
View Related
