Forms :: Getting Error After Using Switch Board Wizard

Nov 2, 2014

I use the switchboard wizard to set up a switchboard. At the moment my main switchboard has 3 items and they are all set to 'open form in add mode' and they all point to the same form at the moment (which does exist).

When I try to go to form view of the switchboard I get the error 'The control name label1 is misspelled or refers to a control that doesn't exist'. Behind it I can see the form in form view and I can see there are the 3 menu items I would expect but when I close the error dialogue and the following 'close macros' dialogue' it goes back to design view. In design view I can only see one menu item (which seems to be a text box rather than a label) instead of 3. I changed it to a label but it didn't work.

View Replies


ADVERTISEMENT

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

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

Error Message Displays When Trying To Close The Form/switch To Design View

May 4, 2006

I have a form with a subform in it. On the main form, I have a combo box with a list of program numbers to choose from. Once one is selected, the subform displays all the unpaid invoices under that program number. This part works fine. The problem occurs when I try to close the form, switch to design view, or scroll the subform to the right. Basically, the error message says that the record can't be saved because it would create a duplicate value in the index/primary key. However, this form is used to display information only. I have disabled the edit, delete and addition abilities, so I can't figure out why it thinks I am trying to change or add a new record. Any help would be appreciated.

I figured it might make things easier if I included a copy of the database, so here it is.

The form is called SETR, and the subform is AllInfo subform.

View 1 Replies View Related

Access 97 - Error When Using Report Wizard

Jul 16, 2007

Hi all,

Using Access 97 :( to create a fairly simple database for a couple of users.

When setting up a report using the wizard, I am given an error message of "No Current record" when I try and Finish the wizard.

I have re-installed Access 97 - which I thought would have most definatly fixed the problem - but doesn't seem to have done the trick.

Any thought are welcome?

Thanks, Neil

View 8 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

Forms :: How To Switch To Correct Record When Switching Forms

May 7, 2013

I have a form called "Customer Details", on that form i have child forms, including one that has a schedule on.. so far everything seems fine, am able to get it to pull data correctly to the correct fields.. etc

I'm using 1 main table for all of this called "Cases"

Now the problem is, when i i click a button to print (this works so far), it opens another form and then fills in all the textbox's, however this is where i've got the problem, as it always seems to pull the data from the first record, not the record that i'm currently on..

so for example, if in the customer details, someone looks up "joe Blogs" using the navigation search and then wants to print it, by hitting the print button .. it should open another form, fill in the boxs and print "Joe Blogs", however it's always doing "Joe adams" - 1st Record

View 2 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

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

Forms :: Navigation Control And Switch Between Tabs

Jun 16, 2015

I'm using a navigation control with 3 tabs. I would like to open a specific tab after the user login. I tried this but it does not work:

NavigationControlName.Tabs.Item("tabNameToOpen").S etFocus

I have tried:

Me.NavigationSubForm.SourceObject = "FormName"

then the form change but the tab selection no!

View 14 Replies View Related

In/out Board

Jun 21, 2007

Hi all
I have been asked to build an in out office notice board that will keep track of all employees in the building. we use windows server 2k and I would like to record in/out in an access / sql database.

Any one know how I could go about this. Thank
Paul

View 2 Replies View Related

Append Example And Clear Clip Board?

Dec 3, 2006

Hello all, I am new to the site and have found so much useful information and examples but one thing I haven't found yet. I am interested in knowing can someone post up an append example. Here is what I am trying to accomplish. I have a database with two tables. The fields are identical and I can vew either one with ease. The problem is I would like to be able to copy the information from the current table to the second one with a push of the button. I can create a button with the help of the wizard that copies the record but it only copies the record to the current table which I have open.

Another thing is when I try to close access, I notice I always get a messagebox asking me about the information that is copied on the clipboard (due to me trying to copy a record). Is there a way to supress this message so people won't see it.

I know this alot to be asking and I just got here but I will be sure to help out other members when I have the knowledge of the program.

Thank you all for reading this long post!

View 2 Replies View Related

Forms :: Using The Wizard To Add A Command Button

Jan 2, 2014

Working on a form and when using the wizard to add a command button or a txt box the wizard gives it a funny name like command989. Im wondering why? Where does this default come from and why is the number so high? There is no way anywhere near that number of command buttons on this form.

View 4 Replies View Related

Can't Save Forms Created By Form Wizard

Jan 2, 2006

guys hello
i'm having a very weird problem i'm using access 2003 and when i'm creating a form using the wizard for the forms i can't save him i when i'm pressing the X button i'm getting the dialog to save the form and promted for the form name but it doesn't do anything and the form do not closes , when i'm creating forms by manual this problem doesn't appeares . i'm already (uninstalled and installed ) * 5 office , installed windows again , deleted the office dir , deleted the shared office directory cleaned the registry installed another version of office and no effect . i would appreciate any help thanks.
Igor

View 3 Replies View Related

Forms :: Query / Report Wizard On Nav Form?

Jul 8, 2015

I'm working on a db for work. On my Nav form, I have two tabs- each tab has cmd btns that open up different search or data entry forms. I also have a few reports that can be opened based on a query I created.

The last thing I want to add is a control/button that opens the query wizard so the user doesn't have to navigate to the "Create" tab of access. The reason behind this is that one user may not know how/where to find the query/report wizard.

Is there some VBA code or Macro I can create to add this functionality to a button ("Create New Report" or "Create New Query".)

I'm using Access 2010.

View 5 Replies View Related

Forms :: Using A Lookup Wizard To Select Multiple Entries From A Table

Jul 14, 2015

I am trying to create a lookup wizard to record the number of people who attend a regular event. I have a table recording the names, surnames and DOB of registered members and a number of other tables for regular events we hold. Previously people have been manually adding the names of attendees and of course there have been inconsistencies in the data. I want them to look up the names from the table of registered members. I have been using the lookup wizard, but it is only displaying the first name in a string. I need it to display id, first name, surname and DOB in a table. I also want to be able to type in the first letter and then pick from the list.

View 5 Replies View Related

Forms :: Form Wizard Not Displaying Table Field Names

Apr 25, 2013

Access 2007 Pro.Attempting to use a query and a table to populate a 1:N form/subform using the Form Wizard. The wizard will not display the field names of the query.

View 2 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 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

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 7 Replies View Related







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