Modules & VBA :: IE Automation - Radio Buttons (Tick Yes)
Sep 2, 2013
I'm trying to tick "Yes" to a radio button which are side by side on a web page (Yes and No). The HTML is below and the VBA I'm trying to use is:
ie.Document.all.Item("newsletter").Checked = "0"
I've also tried
ie.Document.all.Item("newsletter").Checked = "True"
ie.Document.all.Item("newsletter").value = "True"
ie.Document.all.Item("newsletter").value= "0"
<table class="form"> <tr> <td>Subscribe:</td>
<td> <input type="radio" name="newsletter" value="1" /> Yes
<input type="radio" name="newsletter" value="0" checked="checked" /> No
</td> </tr> </table> </div>
View Replies
ADVERTISEMENT
Jul 30, 2005
I have a table and a form called patient demo. It displays last name first name and address city state zip. I created another table and form called insurance as radio buttons i have the following self, spouse, child, other. It also displays last name first name address, city, state and zip as text boxes. what i want the radio button to do is when i click self it will copy all information from patient demo to insurance form. I tried to do this several ways but every time i change the information in the insurance form it also changes the patient demo which i dont want it to do because i want to edit that box without changing patient demo. any ideas.
View 4 Replies
View Related
Oct 18, 2007
Hi all,
I'm somewhat new to access and I'm having a small problem. I have create a web based form via Frontpage 2003 using the access database wizard. In one part of my form I have 6 different options (radio buttons) for a user to select. I want the user to be able to select "multiple options" that apply not just one which is all it is doing right now. How do I change this to allow multiple selection? I opened up my results table and went into the design mode and I can't figure out where to allow multiple selections. Thank you for any help you can provide.
Mark
View 2 Replies
View Related
May 1, 2006
Hi all
Just found this forum, looks great!
When a control like a check box or radio button is on a form, how can you make the size of the actual control bigger? When changing the size in Properties, it only increases the size of the black border.
Thanks
Rich
View 1 Replies
View Related
Mar 10, 2006
I have a database with 1 main form. This form has a bunch of lookup tables that are being displayed in comboboxes on the form.
What I want to do is create another form that has a series of radio buttons that when selected show the specific lookup table which can then be updated/modifyed.
I am unsure where to start. When they select one button I need the table to open "sub form?", "List Box?", and then when they choose another table the first should close and the next open etc. I want all of this to be done within 1 Form.....
Any thoughts?
View 1 Replies
View Related
Feb 28, 2007
I added an Option Group / Radio Buttons to my form.
I named a few.
My question is no how to I test and run code based on the button that is selected.
If this then that?
I just am confused here.....if it was a txtbox I would say
If txtbox = ? then
End If
View 1 Replies
View Related
Feb 25, 2013
I'm trying to build a database of car dealers while using Access 2010. They only sell three types of cars. Once the user select which car dealer they want to look at, I hoping to populate three radio buttons based on values from the database. From what I've read, it seems that the radio button, while using the option group wizard, that the radio buttons are meant to populate a database field, rather than having the database record populate the radio button.
how to do this, so that I am able to show three radio buttons in my form to show which three types of cars this specific car dealer sells?
View 5 Replies
View Related
Apr 18, 2015
I have been writing a database for a medical facility. Currently, I have a box to check if a patient in the database is admitted. What I would like to do is create two radio buttons: one to admit and one to discharge.
When the patient is discharged, I want the data in some of the fields on the form(s) to clear, but not all the fields.
I realize the I will need some scripting here.
As an example: the fields for Unit and Room number will clear upon discharge. As well as fields for diagnosis and informed consent signature located on another form within the same table.
View 3 Replies
View Related
Aug 18, 2006
I am using an Access database for a foreign language dictionary project.
One of the forms I use is populated by a query (qryLemmaTable) to retrieve information from tblLEMMA.
This form works precisely as I intend it to work, but there is a glitch on it that is driving me mad.
The form in question has an option group with 11 radio buttons that correspond to the parts of speech associated with each word in tblLEMMA.
When I click on the button optAdjective I apply a filter and the only records that are displayed are adjectives. (The same applies for Nouns, Verbs, Prepositions etc.)
Here is the glitch: even though the radio buttons apply the filter correctly, no “black spot” appears in the button. Other signals on the screen let me know what word type is selected, so I can accomplish what I want, but I want the “black spots” too!
Perhaps this will be a clue: For each radio button I use the following code in the GotFocus event.
Me.FilterOn = False
Me.Filter = "wordtype = 'A'" ‘(or N, etc)
Me.FilterOn = True
And this for the Lost Focus event
Me.FilterOn = False
Thanks for the help.
View 3 Replies
View Related
Oct 29, 2013
I have a form called frmBillingExport. On that form i have a button called cmdExcel that when clicked exports all the records to excel.
On the form i have a sub-form called subfrmBillingExport and in that form there are lots of fields and one of them is a tick box called blnInvoiced. The subform is also in datasheet view.
Its also worth mentioning that the subform runs off a query that displays the values based on criteria provided on a previous form.
What i want to do is when you click cmdExcel I want a window to pop up to say "Are you sure you want to invoice all of these bookings?" with buttons for Yes and No. On the Yes click i want it to tick the blnInvoiced for all those records and then only export it so i assume take whatever code is suggested and place it before that export happens.
View 1 Replies
View Related
Aug 7, 2015
I'm opening a second database (db2).
Copying the structure of a db2 table to db3.
Populating the table in db3 with a subset of records from db2.
I've gotten as far as opening the db2 and copying the table structure. Can't figure out how to run the query using execute rather than docmd.openquery.
Code:
Dim appAccess As Access.Application
Set appAccess = New Access.Application
appAccess .OpenCurrentDatabase "DbPathString"
'copy the table structure to dbQn, overwrites any previous with same name
[Code] ......
View 4 Replies
View Related
Aug 2, 2013
I'm trying to add a value from access into a combo box on a web page. I can get the combo box to refresh, but not add in a value..The HTML for the combo box is
<tr><td align="right">Campaign: </td><td align="left"><span id="LogiNCamPaigns"><select size="1" name="VD_campaign" id="VD_campaign" onfocus="login_allowable_campaigns()">
<option value=""></option>
And I've been using
ie.Document.all.Item("VD_campaign").focus
To refresh it (works great)
And attempting to put a value into it (which is an option in the combo box)
ie.Document.getElementById("VD_campaign").Value = "201 - Campaign-1"
But nothing happens - not even an error
View 1 Replies
View Related
Jul 31, 2015
I get the message "The expression On Click you entered as the event property setting produced the following error: Class does not support Automation or does not support expected interface"
I receive the message on a PC running Windows 7 Professional using the Access 2013 Runtime. This pc does not have Access 2013 installed.On my pc, I do not get the error. I have Access 2013 installed and run Windows 7 Professional SP1. The "code" which gives the error is as follows and is invoked by clicking a button on a form
Code:
MsgBox "1"
Dim rst As ADODB.Recordset
MsgBox "2"
Set rst = New ADODB.Recordset
MsgBox "3"
[code]....
The error takes place after Msgbox "2" and before Msgbox "3".The strange thing is that I can run without a problem a sophisticated software package on the pc which gives the error, using Access 2013 Runtime. This package I converted from Access 2003.
View 3 Replies
View Related
Aug 1, 2013
I have just started to develop a database that will export data directly into a word template. I have used Word automation quite a lot but I'm new to trying to automate Word from Access.
It's going OK at the moment, I have got the db to open up the template, write data and then close. My objective is to add the data to multiple tables within word. So I have created several tables in my word template and then tried to select these tables and write to the them. Everything is thing for the first table but for any other table I get an error message saying that the member of the collection doesn't exit i.e. the table isn't there. I select the table using:
Code:
objWord.selection.tables (2).select
I then used:
Code:
objWord.selection.tables.count
To show how many tables were in the document and it doesn't matter how many there are, it always says there is 1 table.
why it can only see 1 table and what I can do to get around it?
View 2 Replies
View Related
May 14, 2015
I have programmed a letter using automation to Word VBA. The letter works like a mail merge so it might cycle thru several records when it runs. I've separated each letter in the document with a section break. I'm having a problem with the header. I've successfully added a header, but when it moves to the next record, it replaces the header in the entire document with the current record. I want each section to insert data from that record. How can I fix this? Below is a sample of my code (note: the linktoprevious doesn't seem to work either).
x = 1
'Create Header
With ActiveDocument.Sections(x)
.Headers(wdHeaderFooterPrimary).LinkToPrevious = False
.PageSetup.DifferentFirstPageHeaderFooter = True
[code]....
View 1 Replies
View Related
Jun 2, 2014
I am running Office 2010 but at one time also had Office 2013 installed on my Windows 7 64 bit OS PC. The first attachment (AccessProblem) shows the error message that I get when it hits the
Set olApp = CreateObject("Outlook.Application")
line. I get the automation error - library not registered error. The second attachment (Access2Problem) shows the references that I have.
View 2 Replies
View Related
Nov 19, 2013
I developed a finance tracker database for tracking project revenues and costs (forecast and actual amounts). I have a form where we enter a new Work Order in the DB. This Work Order form has a continous subform where we create all the billing periods needed for the life of the Work Order. Once the billing periods are created (opened) we can then add our revenue and cost forecasts for each period. We have a Billing Period lookup table that has our billing periods with their respective start and end dates (which usually begin around the last week of a month and end about 3 weeks into the next month).
For the purpose of this question, lets say we only enter the required WO_Number and WBS_Code (Composite key) and the Work Order Start_Date and End_Date. I want to click a button to runs some code to automatically create all the billing periods for which their start and end dates fall into the Work Order start and end dates.
For example, say a Work Order starts on 5/1/2013 and ends on 7/31/2013
The billing period dates in the Billing Periods lookup table are as follows:
May-13 ---> 4/22/2013 - 5/19/2013
Jun-13 ---> 5/20/2013 - 6/23/2013
Jul-13 ---> 6/24/2013 - 7/21/2013
Aug-13 ---> 7/22/2013 - 8/18/2013
Then we would need the following billing periods created in the Work Order subform:
May-13
Jun-13
Jul-13
Aug-13
I don't even know where to start on this. Is it possible to automate this process with the setup I have? If so, how would I structure the VBA code/logic to use the billing period lookup table and create entries in the subform for all the billing periods that fall into the duration of the Work Order.
The attached DB is a stripped down version with only the tables and forms needed for this problem.
View 2 Replies
View Related
May 30, 2005
Hello everybody,
I’m new here and I have a question for you..
Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?
Greets,
Tom
View 2 Replies
View Related
Jun 19, 2013
I would like to have 3 buttons on a form. When clicking Button1, Button2 and Button3 should be shown and Button1 hidden. When clicking Button3, Button2 and Button3 should be hidden and Button1 shown.
How can I do this when it is not possible to manage the object being clicked? I tried the following which did not work because of managing an object clicked is not allowed.
Code:
Private Sub Button1_Click()
Button1.Visible = False
Button2.Visible = True
Button3.Visible = True
[code]....
View 3 Replies
View Related
Oct 30, 2013
I have a form I use to search for clients when I hit a command button, using surname etc. I'd like a yes no button to pop up rather than the clunky ok button route I currently have. I'm a beginner with VBA and most this I've gleaned from internet.
If there are matching results, everything is fine. If there are no matching results, I've managed to get my desired messagebox come up by using the code below in the onload event of the resulting search results form, however the yes no buttons do nothing and the results form loads blank as though no records were found.
I'd like Yes to send users to the client input form, and No to return them to the search form.
Private Sub Form_Open(Cancel As Integer)
If Me.Recordset.RecordCount = 0 Then
MsgBox "Do you want to add a new Client?", vbQuestion + vbYesNo, "No clients found"
Select Case intanswer
Case vbYes
[Code] .....
View 9 Replies
View Related
Apr 9, 2014
I'm trying to alter the look of my menu Menu Image.JPG. Depending on the User's Permission setting from the Table PermissionTable.JPG.
If they do not have permission for a company then, i want it to be hidden from the menu?
View 9 Replies
View Related
Feb 26, 2015
I have a form called departments . one that form i have 5 buttons. I want this form only to open when some logs onto the database . The buttons represent each department ...
1. sales
2 purchasing
etc etc
Is it possible to assign a password to those buttons so each department has security to their own form ...
View 8 Replies
View Related
Aug 8, 2014
I did a search and found this thread, and the only problem i encounter is the min max buttons are gone though it was set up as both enable, how to show those buttons.
[URL] ......
View 1 Replies
View Related
Jul 11, 2014
To briefly explain my database; it is a bespoke referral management system within a hospital. Each record on the database contains patient demographic information, as well as information on their referral (i.e. date of referral, date of assessment, date of commencing treatment, discharge date etc.) Therefore, the same patient will appear multiple times in the database, with each separate record corresponding to a unique referral pathway.
The database forms are split to show patient information at the top, with referral information shown in a subform. I am trying to add navigation buttons to the subform that will allow the user to scroll through the referrals corresponding to the patient currently displayed on the main form.
Each patient has a uniquely identifiable number associated with them, and so it seems straightforward enough in my mind to have a button that will search for the record in the database where the patient's number matches the patient number of the current record, and where the referral date is minimum (for "First Referral"), maximum but less than current (for "Previous Referral"), minimum but greater than current (for "Next Referral"), and maximum (for "Last Referral").
View 5 Replies
View Related
Mar 17, 2006
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
View 2 Replies
View Related
Mar 17, 2006
Is this possible? I can't seem to find this q anywhere here so I thought I'd post.
I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey.
Is there anyway to change this? I right-clicked and tried changing it to white through the properties but there's nothing there that does this.
:confused:
View 4 Replies
View Related
