Value >=1000 If Checkbox Checked
Aug 5, 2005I've been scratching my head all night, can someone tell me why the attached query doesn't work?
Thanks,
Sup
ADVERTISEMENT
Show Textbox When Checkbox Checked
Feb 8, 2006Hi
I've searched the forum for my problem and the closest i got was this and it doesn't help that much
If this is the code you can put on click for a checkbox to hide a textbox.
If me.YourBoosterCheckBoxName = -1 then 'need the shot so hide the other textboxes
me.TextBox1.visible = false
me.TextBox2.visible = false
'etc....
else
end if
How do you make a code for a checkbox to SHOW a textbox?
Forms :: How To Hide A Tab If A Checkbox Is Checked
Jan 10, 2014My tab name is SPA and it is the third tab in my form. I want to hide it if the AddToSPA checkbox is checked. This is what I have but I'm getting error 'Compile error: Method or data member not found"
Code:
Private Sub Form_Load()
If Me.AddToSPA = True Then
Me.SPA.Pages(2).Visible = True
Else
Me.SPA.Pages(2).Visible = False
End If
End Sub
General :: Open Certain Website After Checkbox Is Checked?
Jul 17, 2013is there any way to open a certain website after checkbox is checked?
View 1 Replies View RelatedForms :: Open Another Form If Checkbox Is Checked?
Apr 7, 2013I am trying to write an IF statement as a macro on the OnClick property of a checkbox and can't get it to work. Basically, if the checkbox is checked (for Yes) I want it to open another form. (The checkbox is a field on a subform on a form).
I haven't even gotten this far yet, but I would also like the IF statement to include an AND somehow....in other words I want the IF statement to basically say if the box is checked for yes AND the offer status field ="Accepted", then open another form. If either is False, then I don't want it to do anything except display a message box saying they can't initiate a contract is both conditions aren't true.
Check A Checkbox If Not Already Checked And Vice Versa
Nov 6, 2011I am trying to create a medical records inventory. We have physical charts which each have a barcode and I have a scanner. The idea is to have employees who want to check the chart out scan their barcode (on their badge), scan the chart's barcode and leave.
I have a table called tblCharts with the fields: ID (primarykey which is also the chart number), a checkbox, Employee ID, Date, and Time checked out.
I have Employee ID linked to my tblEmployees that simply has a listing of the employee ID's and first and last names.
I don't care about keeping a record of who has had the chart in the past.
I just can't figure out how to tell the checkbox to be checked (to indicate the chart is out) when a number is added to the ID field (via scanner).
So here's how it would go:
Scan the chart's barcode which would populate into the ID field. Search to see if the record with the same number is already existing, if not create a record. IF it does exist, check to see if the checkbox is checked. If it is checked then the chart is being checked back in (so uncheck the box). If it is not checked to begin with (still in), then check it out and associate the employee's scanned barcode with it.
Displaying A Running Total Of Times A Checkbox Is Checked
Nov 12, 2004Dear All:
I have a form with a checkox. Is there any way to keep a running total on the form to display how many times a checkbox has been checked?
I am clueless on this one, any help is most welcome.
Regards,
Dion
Forms :: Textbox To Perform Dlookup If Checkbox Is Checked?
Sep 9, 2013I have a text box on a form, currently it performs a dlookup for me. I want to change it so that it only performs the Dlookup if a checkbox is checked, but otherwise will display the text that's in an unbound text box.
Not 100% this is even possible, but hoping so. So far I have in the textbook:
=IIf([CHECKBOX]=0,DLookUp("TABLE","FIELD","ID = " & [Text57] & ""),[TEXTBOX])
The dlookup works fine by itself, it's just making it conditional that's causing me problems. I know it could just be a small problem with the way I've written it, or it could be a bigger thing with me not understanding the way IIF works.
Forms :: Checkbox To Return All Of Yes Values For Column When Checked
Jun 25, 2014I have a checkbox that when checked returns all of the yes values for the column but I want it so that when it isn't checked, it doesnt search for this criteria at all, is there a way of doing this? I tried option buttons too but I wasn't sure of how to go about it.
View 13 Replies View RelatedForms :: Making Textbox Visible On A Form If Checkbox Is Checked On Same Form
Aug 30, 2013I am having a problem with making a textbox visible on a form if a checkbox is checked on the same form. I have done research on this site and have written the code below, but I am getting a Syntax error, see yellow highlight.
- My checkbox is named: Case is a Readmission from WRCA IP to WRCA IP
- My textbox is named: Date of Current IP Admission (I have defaulted this textbox to not visible).
Here's the code I have written:
Private Sub Case_is_a_Readmission_from_WRCA_IP_to_WRCA_IP_Clic k()
If Case is a Readmission from WRCA IP to WRCA IP =true then
Date of Current IP Admission.visible=true
Else
Date of Current IP Admission.visible=false
[Code] .....
Deleting Records That Have Been Checked Or Adding A Record After A Checked Record
Jul 20, 2005Hi,
I was wondering how to delete records that have been checked (through a checkbox) in a form...
Also, I want to add a record after the record that has been checked. I only want this ability to add records available if only one record is checked. Otherwise, if more than one record is checked, the "Add Record" button would be disabled.
Any help would be much appreciated.
TIA.
Problem Using Access 97 On 100/1000 Lan
Nov 14, 2005Hi,
I Had A Program Using Access '97 Which Is Currently Running On 10/100 Lan With No Problem, When They Changed The Lan To 100/1000 Even If We Copy The Database To Another Node And Tried to Open It Gives Error In Index Or Unrecognisable Database Please Help Other Programs Like Excel, Word Are Working Properly. Currently switched back to 10/100 LAN and the same database opens without any problem. Is it because of the transfer speed?
Need To Insert Blank Rows If Record < 1000
Mar 24, 2005Hello all!
I have a database that needs to post records that are joined from three different sources into a table. The query is done, and I get about 1,489 records out in 4 different states.
What I need to do is make a table with these records. Furthermore, it must be separated by state, whereas if there are less than 1000 records for each state, it must insert blank lines until it reaches then next thousandth (sp?) row (i.e. 1001, 2001, etc.), and then start posting the next state.
For example, AZ has 420 records. There has to be 580 blank lines before the query can start posting the next state, CA. At row 1001, CA starts posting, but there are only 200 records for CA so there must be another 800 blank lines before moving on to CO at row 2001, etc. etc.
Anyone have any ideas on this? Thanks!
Tables :: Adding 1000 Semi Blank Records With Sequential Numbering
May 21, 2013I've received a database that is a digitized population register from the 19th century. All adults have been entered into the database, but all children are missing.
Every person has a unique number that corresponds with the original source (this variable is called 'no', this is not the autonumber primary key thing). Instead of searching in the original source which numbers are still missing, I would like to add the missing numbers (with no additional information, because I still need to type that in).
For example, the table now looks like this:
no - name_last - name_first - occupation etc
1 Smith Henry baker
2 Smith Mary
5 Williams John butcher
6 and so on
So 3 and 4 are missing.
How can I add these missing numbers automatically?
Queries :: How To Get Only Yes Checked Box
Aug 13, 2013I created a table (contains ID, Name, almost 20 yes/no checkboxes).
I need to create a query where i specify the ID and it returns the id, name and all the yes checkboxes.
What I got is all the check-boxes yes and no.
Checked Out With These Check Boxes
Oct 15, 2006Hello Folks.
I can't seem to figure this one out in a continous form. I have checkboxes where I can check them. If I check any of them, I would like to disable another check box. All this works, but what it does is it disables/enables the check box in ALL the rows, instead of just the current row.
I have attached a sample of my setup. Any help/insight would be appreciated.
If Box Not Checked, Gray Out Next Field
Feb 27, 2008I have a form that has a check box. If the box is checked then I would like the next field to be available for data entry, however, if the box is unchecked, then I wish for the next field to be grayed out and not available for data. I suspect that it is a simple bit of VBA, but I am not fluent in VBA and need help everytime, I find something new. Thanks for all your help.
Regards,
Alan
Checked Out With These Check Boxes
Oct 16, 2006Hello Folks.
I can't seem to figure this one out in a continous form. I have checkboxes where I can check them. If I check any of them, I would like to disable another check box. All this works, but what it does is it disables/enables the check box in ALL the rows, instead of just the current row.
I have attached a sample of my setup. Any help/insight would be appreciated.
Exporting Checked Boxes Into Excel
Oct 14, 2004Dear All:
I posted this question before but I did not include the right information. (Many thanks, Mwalts)
I have created a form with checkboxes. I wish to export data to excel on only the people that are checked.
To export is not the issue. I have created a query to list only the people that are checked. The control souce of the checkbox is called graduated. When I go into the datasheet view, the people who are checked are represented with a -1.
In regards to the design view of the query, what text or value do I place in the critera field to list only the people that are checked?
Any help is greatly apprciated.
Regards,
Dion
Calculate Data If Check Box Is Checked
Oct 19, 2004I have a user input form to enter traffic counts. There is a subform within that form that shows the total. I want to have a check box which, if checked, will multiply the data in the box by two. I have tried building expressions, macros...nothing worked. Dont know what I'm doing wrong. Any idea?
View 9 Replies View RelatedCounting Checked Checkboxes In A Report
Nov 1, 2004I have a report, where some features are listed as checkboxes. I'd like to have all checked checkboxes counted at the end of report. I've created text field. What shuold be the command in it ? (to count only checked boxes).
Thanx for any help
Queries :: Set Bit Field To Default Checked?
Jul 11, 2014I have a query that simply pulls back each tenant from a tenant table. Each row has a bit field that I use for check box's. This check box is true or false depending on the balance they owe. I currently use it to print off late reports and people that have this field set to true have a check box that auto populates on my datasheet.
I copied the query but I want to change it a little. I want to be able to show all tenants, but I want the bit field to show on my datasheet defaulted to checked for everyone (even if the table shows false) so that I can print all tenants without having to check the fields that are false in my table.
I tried to create an expression instead of using the bit field, but I no longer have the option to make that column into a "Check Box" under Lookup-Display Control.
Modules & VBA :: Checking Whether Checkboxes Have Been Checked?
Dec 17, 2013I'm trying to write some simple code to see whether two check boxes (named cbM001 and cbM011) have been checked and if so, then send out an error message. So far I have tried:
If cbM001 Is False And cbM011 Is True Then
MsgBox "M011 cannot be selected unless M001has also been chosen."
Exit Sub
[Code].....
With this I get "Run-time error 424: object require"
Automatically Update A Field When A Box Is Checked
Jul 22, 2014I'm fairly new to using Access for any serious purposes. I'm trying to replicate some database functionality I setup in Salesforce and just trying to clear few core concepts in Access.
I'm messing around in the Contact Management template and I'm wondering how I can make it so when so when a yes/no checkbox field (called "Active") is ticked a date/time field (called "Last Date") is automatically set to today's date + 60 days.
In Salesforce I would create a Workflow Action triggered by an if Active = true statement, with a Field Update something like TODAY() + 60.
I can tell I need to create an After Insert/After Update Data Macro but can't quite figure out what to put in.
Read Only Message When Archive Prop Is Checked
Jun 6, 2005I get the 'this is read only you will not be able to make changes, etc..
whe I open my database. How do i fix it? No one else is in making changes.
Check Box Is Checked Depending On A Data Field?
Nov 9, 2005I have a data field (status) that is either Graduated, Terminated, or Current. I also have a report that has a check box representing each (such as a check box for graduated and another for Terminated etc).
I am trying to get the report to read the status and check the appropriate box in the report.
I have tried this in the control source of the checkbox
=IIf([status]="terminated";True;False)
but this does not work
I have also tried this on the OnOpen
If [status] = "terminated" then
termcheck = true
else
termcheck = false
end if
end sub
But this does not work either - what am I doing wrong :confused: