Very Simple Yet Cant Get It Working...toggle Box Switch

Mar 19, 2008

Hi

Using a toggle box to ask the following question, i have data that contains either OPEN or CLOSED against each record. I tried using the following in the criteria for the specific data to either select all the OPEN records when the box is clicked and i would like to select all records OPEN and CLOSED when it is nto clicked

IIf([Forms]![MEQN_ProdACStn_Picker]![Toggle38]=True,"OPEN","")

This didn't work and a number of other attempts failed as well...

How do i do it in the criteria selection or is it not possible

Cheers

Newbie Jasper

View Replies


ADVERTISEMENT

Forms :: Toggle Switch On Header Of Form

Apr 14, 2015

I would like to create a command button on the header of a form. The button should perform a toggle switch: click once to activate the task and click it again returning original state. I can create the command button to perform a task but do not know how to return to original state. The button should have indicator showing which state is in.

View 2 Replies View Related

Modules & VBA :: RowSource Switch Using Toggle Button

Dec 4, 2014

I have a form that contains a combo box, I used the access wizard to make this combo box select a record from a table of customers and display that record on the form.

The user then has the option to print that record.

This works fine.

I now want to be able use the same combo box but with a different table so I can select Records from a list of suppliers.

Is there a way I could use a toggle button to change the rowsource of the combo box and then use that same combo box to select records from my supplier table.

View 2 Replies View Related

Multiple Toggle Buttons Working Together

Jul 23, 2007

Hi - I have another problem. I hope you can help me out on this one.

Right now, I have 3 toggle buttons to control the visibility of 3 subforms. However, I only want a single subform to show at any given time. So, if I were to select toggle 1 it should give me subform 1, and afterwards if I select toggle 2 it should give me subform 2 WITHOUT showing me toggle 1.

Is there anyway to get the toggle buttons to work with each other?

Thanks,
:)

View 14 Replies View Related

Simple Sql Statement Not Working

Mar 2, 2008

i have an sql statement:

aa = "hello"

Tasklist.RowSource = "SELECT [Tasks].Staff_Name, [Tasks].Project_Title, [Tasks].Percentage_Complete FROM [Tasks] WHERE [Tasks].Date_Allocated < aa ORDER BY [Tasks].Staff_Name;"


how can i make it look the the data i put in "aa" rather than prompt a msg box asking for "aa"?

View 5 Replies View Related

Very Simple Query Not Working....

Sep 15, 2005

we have a main table for tracking pickups....some of the fields are combo boxes with relationships to other tables....one such relationship is units (ml, gallon, ounce, etc)...in the main table everything works just fine....a user enters the location info, the amount and the corresponding units. thus, an example would be a user picks up something from building X, room 101, 10, Gallons.....the 10 refers to the gallons, the user picked up 10 gallons...

now for the query:
i'm creating a query for which i will base a report on...in query design if i just select the above info everything works fine....it comes out on the report as 5 Gallons....however, what i'd like to do is concatenate the two fields so that they take up less space on the report and are more visibly appealing...here's what i tried in query design:
Amt: [amount]&Space(1)&[units]
this does not work....in the units table that provides Gallons as a selection in the combo field, Gallons has a key value of 5.....thus, when i run the query using the above code i get 10 5 - where 10 is the amount the amount and 5 is the key from the combo box...

i've tried bringing in the units table but then i get a type mismatch....how can i concatenate the two fields and show the proper units? this has to be simple but i cannot get it to work... :mad:

View 4 Replies View Related

V. Simple Query, Not Working

Jun 25, 2006

Hi Lads

Hi guys, I want to return all the records which contain information under a particular column heading, hence the statement thats supposed to return all tables where Sector colum is not empty. I am new to SQL and Access so not sure why this simple query isn't working. It is a subform and displays the results in the "details" section of the form below the controls.

I think it could be something to do with the fact that its a subform, but Im not sure about this.

Me.RecordSource = "SELECT * FROM [tblRecordInfo] WHERE Sector <> "" "

any ideas guys? any assistance is greatly appreciated

thanks in advance

View 2 Replies View Related

Simple Query Not Working

Oct 11, 2006

I have a six table database and have a query to show all records,(at the moment) but although i have put 3 records in for testing it only shows the first record. Any help gratefully recieved i'm pulling hair out.:mad:

View 3 Replies View Related

Simple Query/Form Not Working...

Oct 5, 2006

I have a table filled with computer monitor information (tblMonitorManagement). I had query that uses combo boxes (cboSerialNo, cboRoom, cboDepartment) on a form for search parameters. The query is called qryMonitorManagement_Sub. The results are displayed in a subform (frmMonitorManagement_Sub). This works for both my desktop and also my laptop based forms/queries/tables.

Although this form works when using cboRoom and cboDepartment, it does not work when using cboSerialNo, so I decided to simplify it down to get to the root of the problem...here's what I did.

I created a new form, created a combo box (again called cboSerialNo), and had it look up the serial numbers in tblMonitors. Simple.

I created a query called qryMonitors_Test, added all fields from tblMonitors (not using the * option). I then set the SerialNo field criteria to the contents of the cboSerialNo on the new form. Simple. For now I'm ignoring searching on anything else.

I ran the query with no search parameters before I added the criteria, and it obviously displayed all the records in tblMonitors. Fine.

After adding the criteria (using Build...to prevent typos), I used the form to select a serial number, run the query and get no results returned.

If I copy and paste the same serial number and change the SerialNo criteria in the query to search for that it works fine. As soon as I tell it to search for the combo box contents it returns no data.

This is driving me completely bat-poo. It's nothing I've not done a squillion time before but it just refuses to work. I've got to assume it's a query issue as opposed to a form issue, but things don't get much simpler than this should be!

View 6 Replies View Related

Simple Query Not Working (Filter)

Oct 18, 2007

I have a query that filters two tables. 1) Status 2) Name

The status is 1,2,3,4,5 from an option group on my form.

In the query I have <>3 for the status, whereby I only want records that are status 1,2,3,& 5.

When I run the query with all names it works perfectly, however I am trying to run the query for only a select few names versus all of them.

The problem is I do not know how to select only a few names versus all of the names and make it work. When I try to add names i.e "Doe, John" my Status pulls all records including option 3.

Can anyone help? I do not even know where to start seaching.

Thanks.

Fen How

View 1 Replies View Related

Simple Delte Query Not Working

Oct 25, 2007

Hi Guys,

I've tried searching the forums for an answer with no joy.
I'm trying to create a very simple DELETE query, which I've never had an issue with before.

Basically I have two tables

Dbo_PDRPerson (PersonID, RoleID, PDRID)
tbl_InfoByPDR (PDRID)

Basically I want to delete all records in Dbo_PDRPerson where a corresponding PDRID record exists in tbl_InfoByPDR

My current method:

DELETE dbo_PDRPerson.PersonID, dbo_PDRPerson.RoleID, dbo_PDRPerson.PDRID
FROM dbo_PDRPerson INNER JOIN tbl_InfoByPDR ON dbo_PDRPerson.PDRID = tbl_InfoByPDR.PDRID;

This tells me to "Specify the table containing the records you want to delete"

Any ideas

Many thanks

View 2 Replies View Related

Tables :: Simple Cascade Update Not Working

Oct 29, 2013

I've done this tons of times, so I don't understand what's happening... The title says it all: when I update the ID of one record of the main table, the referenced records on related tables won't update even though they have a relationship between them with the option "Cascade update" clicked.

In the attached database, the main table "Expedientes" is related to table "Actuaciones".

View 1 Replies View Related

None Working "simple Code" On Close Event?

May 16, 2006

I have witten a code in the close event of a "Primary" form that would update a Combo boxe on a "secondary" form only if the "secondary" form is open.
ie:

Private Sub Form_Close()
If Forms!frmEnquiry.Open Then
Forms!frmEnquiry!CboCustomer.Requery
Else
DoCmd.Close
End If
End Sub

This code keeps giving me an error, is anybody has got any idea why?
Thanks in advance.

View 7 Replies View Related

Switch Function

Mar 5, 2008

Hi All,

Some help from cyber space is what I need me thinks :confused:, I am using a switch function in an access query to convert 24 to 624 and 28 to 628 and so on for about 5 entires however there are numerous entries that might not meet my criteria that are errorrs can I just simply place in there a default option if the rest are not made like in a case statement.

I know somebody is going to suggestion placing this in a macor/function but would prefer to not have to do that if possible, but if I do I dot.

Any help greatly appreciated. Come on Cyber Space dont let me down! :D

Cheers,
Tempest
"Life is like a box of choclates you never know what your gonna get"

View 1 Replies View Related

Using Between Function Within Switch

Mar 23, 2014

I'm using the simple test expression below to assign a value of 1 to records with [saledate] between the two dates indicated in the code below and I'm just getting a null result. Can the between function not be used in this way?

Code:
Hughes Test: Switch([saledate] Between 1/1/2014 And 3/14/2014,1)

View 6 Replies View Related

Using Switch Functions In Expressions.

Oct 10, 2005

i'm trying to use a switch function in a query but i'm unfamiliar with the format a bit. here is what i'm trying to do...

switch([Radios]![Warranty] and [Radios]![HousingWarranty]=true,[Radios]![Change front housing]*(25/60*28), [[Radios]![Warranty] And [Radios]![PortableHousingWarranty]=true], [Radios]![MaterialsUsedPrice1])

basically first statement is condition second is execution. I need to add more but i'm getting an error from this much...if I was doing this in vb.net I would just do if, ifelse, ifelse, ifelse...but...

Thanks,

View 2 Replies View Related

Using Wildcard In Switch Function

Jan 26, 2007

I am trying to use a Switch expression as a column heading in a crosstab query to generate statistics for how much work is done per client (Requester). Each requester is referred to by acronym, so it may look like "DOD/OUSD/FTT/ATA/B", but I want that column to include everything that starts with DOD, instead of listing each instance separately. This is my expression so far:

Expr1: Switch([Requester]="DOD*","DOD",[Requester]="DS/ATA","ATAP")

When I run the query, the column "ATAP" shows up perfectly with all the correct info, but it's as if I never entered "DOD*". Nothing appears, and since I didn't add anything in the Switch function for what to do with other requesters, the second column shows up as <>.

Do wildcard *'s not work in Switch functions? I don't get any errors, but this is definitely not the information I'm looking for.

Is there any other way to include all Requesters that start with DOD in one column?

This is my SQl if that's helpful:
TRANSFORM Sum([Q and D Database].[Word Count]) AS [SumOfWord Count]
SELECT [Q and D Database].[Source/Target]
FROM [Q and D Database]
WHERE ((([Q and D Database].[Out Date]) Between #1/1/2006# And #12/31/2006#))
GROUP BY [Q and D Database].[Source/Target]
ORDER BY [Q and D Database].[Source/Target], Switch([Requester]="DOD*","DOD",[Requester]="DS/ATA","ATAP")
PIVOT Switch([Requester]="DOD*","DOD",[Requester]="DS/ATA","ATAP");

Thanks!!!

View 2 Replies View Related

Switch Function Problem

Jul 23, 2007

Hi guysI have a problem with filtering a query in criteria using either iff or switch builtin function. my codes look like thisLike Switch([Forms]![frmMain]![grpReq]=1,"SysReq*",[Forms]![frmMain]![grpReq]=2,"ACR*",[Forms]![frmMain]![grpReq]=3,"ACSR*",[Forms]![frmMain]![grpReq]=4, not like "SysReq*" or "ACS*")the function works fine except for value 4 highlighted in bold. The query just didnt return the result i want. I suspect its the switch function not liking to evaluate the "Not like" part. I dont know how to go around this as i can only base on the prefix, namely SysReq, ACR, ACSRThank you for your ideas...

View 8 Replies View Related

Switch Board Question

Aug 28, 2006

Greetings!

I wanted to have a switch board available to my users. On the switch board I wanted to have a combo box where the users have multiple choices. For example, if a hotel was offering choices. The choices could be:

Room Reservation
Conference Room Reservation
Catering
Dance Hall
Transportation
Local Guide Information

After they select one of the choices, I wanted to put command buttons on the side that would take them to a form specifically related to the choice they made. So, some of the command buttons might be:

Send an Inquiry
Call
Make an Online Reservation
View information only


I haven't seen any Switch board that has choices so I don't even know if this is possible. If so, I'm happy to try.

Meanwhile.... I've never done VBA or any type of programming. I'm a beginning Access user.

Thanks.
Surfette

View 7 Replies View Related

Switch Forms But Same Record !?!

Jan 7, 2005

Here is an interesting one:



Have 2 forms, (1) Contact Information, and (2) Survey Response

Any Clues on how to set un a button to switch from Form to Form but stay on the same Record!!!! Interesting One!

Apriciate any help/clues/links =)

View 3 Replies View Related

Forms - Switch Between Records (Using VB)

Apr 3, 2006

Hi Guys,

You know on forms, you have those little Left and Right arrows (< >) at the bottom of the form, and you can click on them to switch between records... yeah?

Well, how can I make the form switch between records with VB. Lets say I want a VB script that jumps to the 5th record in the table, how would I do that? Normally you would just click the Left arrow 5 times... but I want to do it with code.

Thanks!

View 1 Replies View Related

SWITCH Problem In Time Field

Jun 26, 2007

I have a query with data grouped by time, with the goal being to combine values for each 5-minute time interval over the course of several months into a single 24-hour period (resulting in 288 records). Most of the time values, when converted to decimals, are between 0 and 1. However, some of the times are actually greater than 1. They still display correctly in time format, but are unable to group with the rest of the times since they have different values.

I need to construct a statement to
a.) Keep the given value if SensorTime<=1
b.) If SensorTime>1, subtract an integer value (between 1 and 4) so it is between 0 and 1 and will then group with the rest of the times

I experimented with a SWITCH function but I'm not sure how to specify "1<SensorTime<=2." I think the current language will subtract up to 10 from numbers less than 1 (-1 if less than 2, -2 if less than 3, etc.). Here's what I have so far:

SELECT Sensor3.SensorDate, Switch(Sensor3.SensorTime<=1,Sensor3.SensorTime,Sensor3.SensorTime<=2,(Sensor3.SensorTime-1),Sensor3.SensorTime<=3,(Sensor3.SensorTime-2),Sensor3.SensorTime<=4,(Sensor3.SensorTime-3),Sensor3.SensorTime<=5,(Sensor3.SensorTime-4)) AS Expr1, Sensor3.SensorTime, Sensor3.Volume, Sensor3.Trucks
FROM Sensor3
WHERE (((Sensor3.LaneName)="NB1" Or (Sensor3.LaneName)="NB2" Or (Sensor3.LaneName)="NB3"));

Can anybody suggest a way to subtract the correct integer value from each time to get a number between 0 and 1?

View 11 Replies View Related

IIf And Switch Issues With Yes/No Column Criteria

Jan 8, 2008

I have a combo box that selects a record on a form.The combo box is based off of a query and I want to be able to filter a field on the query that the combo box is being populated by.The problem is that it's a yes/no field I want to setup criteria for and I haven't been able to get an IIf or Switch statement to work correctly.The issue is that I want to filter the combo box from either two separate combo boxes and a check box or from a group of radio buttons or a combination of the two.The idea was to have a drop down with a list of enrolled members. The second drop down would requery the first one and would allow you to select a class. The third drop-down would allow you to select, "All", "Students", or "Teachers". The check box would then allow you to view archived members who have a "Yes" in the Graduated column of the query.The class drop-down I have figured out fine on how to filter. The issue lies within the selection of a member type. I tried using radio buttons for "All", "Students" and "Teachers" but the problem was when I built my IIf or Switch statement, I couldn't figure out how to make the "All" values not put any criteria into the query. My statements looked like below:Switch([Forms]![frmHome]![fraFilterSelect]=1,"",[Forms]![frmHome]![fraFilterSelect]=2,No,[Forms]![frmHome]![fraFilterSelect]=3,Yes)IIf([Forms]![frmHome]![fraFilterSelect]=1,"",IIf([Forms]![frmHome]![fraFilterSelect]=2,No,IIf([Forms]![frmHome]![fraFilterSelect]=3,Yes,"")))Neither worked out. Essentially I am trying to set criteria for a Yes/No column, and I can't get it to work correctly.I am requerying after update of the radio button option group and/or the combo box filter.Any ideas?

View 6 Replies View Related

Forms :: Switch Value Based On Condition?

Aug 9, 2014

Is it possible to create a VBA on the AfterUpdate() that flips a value based on a condition?

For example, if in a text box (Gender) there is a value of "Male" and in a combo1309 the value is "No", can Gender be switched to "Female" automatically?

Code:

IF Me.combo1309 = "No" Then Me.gender....

View 1 Replies View Related

General :: Switch Off Compact On Close

Dec 25, 2014

I am using Access 2010.

Under options, current database I have DESELECTED "compact on close"

Still all my databases are compacting on close. How can I prevent Access to compact on close?

Problem is that we work under Citrix and sometimes things happens with Citrix that they have to reboot all the servers.

The databases tries to close and compact and don't get enough time, so I get mdb copies.

Besides I recently had only the compacted database1.mdb while my file Name.accdb was gone, so again the compact was wrong.

View 3 Replies View Related

Forms :: Switch Board Manipulation

Nov 18, 2013

I know that i was discussed a lot but now it's about accexx2010.

I need to have more than 8 items on my switchboard but can't find any code for that in VBA.

I'd rather not use the option of building a regular form as switchboard.

View 14 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved