Filter A Form By Switchboard Item
Apr 5, 2006
:( I am using a switchboard in my database, I have 3 forms using the same query,formats,etc but the 2 of 3 have filters. My question is how can I filter the form when I click a button in the Switchboard.
I tried to do
docmd.applyfilter
but when the form is open nothing happens.
And I also use the Form_Switchboard!Itemnumber = 2 but the only number it can see is with 0 value.
Please help me. I just don't know how to catch the field from Switchboard. Please help. Thank you so much.
View Replies
ADVERTISEMENT
Sep 14, 2007
So here goes :)
I have made this example database to show you my problem, I have 2 tables here:
1. "items" table that works like warehouse listing items in stock and has these fields:
ID autonumber
Example name TEXT
Sold Yes/No
2. "sales" table has these fields:
ID Autonumber
Example name created using Lookup in Design view
I created Query called "sales Query" that I use to enter data and my problem is I need only to be able to enter items that are not checked in "Items table".
In other words I need to be able to select in the query dropdown items currently in stock.
How to solve this the easy way? I tried using criteria "False" but dropdown still lists checked items WHY?
View 5 Replies
View Related
Aug 18, 2006
I have a form that simply lists the items:
DEPARTMENT_NBR and DEPARTMENT_NAME
In the table: DEPARTMENT_TBL
When I edit the field DEPARTMENT_NBR and it is in error (must be between 01 and 99) I want to put out a message in a MSGBOX and SetFocus back on the DEPARTMENT_NBR.
I coded the MSGBOX with vbokonly and then DEPARTMENT_NBR.SetFocus, but after the message displays and enter is hit for the ok the cursor jumps to the DEPARTMENT_NAME on the current line. Is there a way to get the SetFocus to work properly on repeating items like this? I can never seem to get them to perform the same as they do on non-repeating items.
Thanks for your help.
HERE'S THE EXACT CODE:
If IsNumeric(DEPARTMENT_NBR) = False Then
If DEPARTMENT_NBR <> "00" Then
MsgBox "DEPARTMENT NUMBER must between 01 and 99.", vbOKOnly
DEPARTMENT_NBR.SetFocus
GoTo DEPARTMENT_NBR_EXIT (exits the paragraph skipping other checks)
End If
End If
Also, is there a way to look at a specific item in a list like that? IE. I want to reference the 3rd row's DEPARTMENT_NBR. Thanks.
View 4 Replies
View Related
Nov 26, 2012
How can I create a "Filter Button" on a form and filter my records? I create a textbox on a form and a filter button on the right. Then I click the filter futton, the filter function will search/match the content in the box through the datasheet. And then the results of the filtering will be pop up on the split form datasheet.
View 3 Replies
View Related
Aug 1, 2013
I have placed a filter button on a form as a filter and written the following on-click event procedure:
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdApplyFilterSort
Me.Filter = "ACCOUNT_DO_NOT_EMAIL = 'HS'"
Me.FilterOn = True
When I click the filter button I get a blank message box titled 'Microsoft Access" and an OK button, when closed the filter works perfectly.I have checked this procedure in other forms and it works without showing the blank message box.The only difference with this form is that its control source is a union query.
View 10 Replies
View Related
Apr 23, 2013
I am using Access 2007. I have had an application running now for about 1 year and now getting an error when user opens the database. (Have one for front end and one db for backend)
Here's the error message:The form name Switchboard is misspelled or refers to a form that doesn't exist.Also, multiple users are accessing the database at the same time.
View 3 Replies
View Related
Nov 21, 2006
I am working on a database that will be an addition to an existing one on the company server. However, to make the overall layout not so complex and allow room for other additions in the future, I'd like to keep the databases separate. This will also ensure more efficiency, integrity and troubleshooting overall.
I have the original database with the name of "Cell MFG Screen" that contains a switchboard. I am now creating a db to keep track of manufacturing waste (which will also be on the same server when completed). That switchboard is called "Cell Waste Weight". Again, I want to keep these db's separated from one another as well being able to add future dbs. Now, what my plan is to make up a one db that consists of only a switchboard that will be used as the main switchboard to be able to navigate to other dbs that are located on the server.
Does anyone know how this is done?
Thank you in advance for your help,
~Kilch
View 10 Replies
View Related
Sep 7, 2005
Hi, I am creating a database and was wondering how I can hide items that are on a switchboard based on username or the workgroup that the user is in. I have five items on my switchboard and I dont want some users to be able to see the fifth item when the log on but when the admin logs on he should be able to see everything that is on the switchboard. Also how would you be able to open a form in add mode so that the previous data that was added isnt shown. thanks
View 4 Replies
View Related
May 25, 2006
I have successfuly made a switchboard that links to a form and pulls the data accurately. I made a smaller database here and now when I pull up the form it does not contain the data that is in the table. If I enter new data in the form it saves but when I close the form it will not come back in the form later. It just stays in the table. How do I get the data to stay in both places 100 percent of the time.
Are there any tricks to showing all the data better in the forms so people dont half to click through data with buttons at the bottom for info?
View 2 Replies
View Related
Aug 19, 2005
I have created a form with all the buttons that I need and the have designed it way that I want. I have chosen to have it open upon startup. However, It is not maximized. How can I get it to resize to the windows max?
thanks.
View 5 Replies
View Related
Jul 14, 2006
I have the switchboard form in a database but need more items in the switchboard then is allowed.
Does anyone know how to change the number of allowed items on a switchboard.
Thanks
View 6 Replies
View Related
Jul 15, 2006
i created a form that works as a switchboard. is there a way to put a password on one of the comand buttons that links to another form
View 3 Replies
View Related
Aug 31, 2006
hi, i have a memo field, and on my form the control for that field is called
'pickup'
what i want on my form is a tick box button..
when the user clicks that button..
the words (O/S) appears inside the pickup control..
eg.
If I enter an address in the pickup field.. like so...
LHR - Terminal 1
then when the user clicks the box.. i would need the field to update as
LHR - Terminal 1 (O/S)
so really it would have to add a space and then the (O/S)
how can i do this?
View 5 Replies
View Related
Nov 14, 2005
If its possible, can i have a querie that lets the user find a specific record, say based on flight number or flight date (for an airport) right from the switchboard?,
I can do this within the main form, but ir returns the table view of the record, which i dont want, i would like the form view of it? This possible
Thanks
View 4 Replies
View Related
Feb 27, 2006
I have made two main menus, one for admin and one for users, I want to turn these into switchboards. When you open a form asking you to log in opens if you supply the right password it opens another form depending on your access rights depends which menu it opens, it all works perfectly but I want a home button, i.e. close all open forms, which would close the main menu, so I need to turn the main menus into switchboards, I have tried searching this place and I have also tried google although I may aswell have stuck my head out an open window and shouted for help!
Any way any help much appreciated
Regards
View 4 Replies
View Related
Nov 13, 2004
Hi there
I've been playing around with creating a switchboard. At first, I saw a form appear in the forms area called switchboard. but now it's gone. I have a switchboard marked as Default under Switchboard Manager, I can see that a table has been created called Switchboard Items, but it won't open on startup. (obviously, because there isn't a form which I can point to in the startup box)
Any idea why the switchboard form is not being created?
Thanks
Sunil
View 1 Replies
View Related
Nov 18, 2004
Ok, quick question.
I am using a switchboard to open my main form, 'frmJobLog'. This main form has a tab control with four tabs. How do open the form to the 4th tab using a command button on the switchboard?
Thanks in advance.
View 4 Replies
View Related
May 19, 2005
Hi pals,
I have the following problem.
I have a form that runs a query from 5 tables linked via odbc.
The thing is that the result is showed ok.. but when I tried to edit an item in grid, I can't do it. (get that noisy bell).
I realized that if i only use one one table, I can edit ok.. but If I use more than one, I can't.
Any solution to that??
Thnks
Mariano
View 1 Replies
View Related
Oct 11, 2006
I am having trouble calculating a field in a table and on a form.
I have the following Tables
CUSTOMER: Customer No, Name, Address, City, State, Zip, Discount, Phone, Fax, Contact Person.
ORDER: Customer No, Order No, Order-Date, Delivery-Date.
ORDER LINE: Order No, Product No, Quantity Ordered,
line-item-cost
PRODUCT: Product No, Description, Price, Product Image.
I need to calculate the line-item cost and need it to update every time the user enters a new Quantity ordered on the ORDER LINE form.
I know its (Quantity Ordered*Price)-(Price*Discount) and I did this is a query and it worked but I need it to update in the form and update in the table not the query. I have tried everything (Macros, Queries, and Formulas) and I just can not get it to work.
Does anyone know how to do this?
Thanks
View 1 Replies
View Related
Feb 26, 2014
My main form has a list box - user selects an item in the list box for editing. The selected item displays in a text box on the subform where the editing is to be done. User than makes corrections to the text box and clicks a button to save the changes. I have all of this working. But I can't figure out how to update the main form on this save button.
What is happening right now is the main form is not updating at all and the original selection in the list box is still highlighted. If I click within the list box, the list box updates with the correct entry.
What I need to happen is when the save button is clicked, that the listbox updates and the selection in the list box is deselected and then set focus on another text box that is on the main form.
(I was doing this as 2 separate forms and the edit form opened after the user selected the item and clicked a button (kept the first form open but not visible and based the text box on the list box) This worked but again when the user saved and returned to the first form even though I was able to setfocus to the text box, the list box kept the selection highlighted.)
View 3 Replies
View Related
Jan 14, 2013
I am trying to augment my database to have a price list. Because I wanted the price list to be of record and saved, I used a form with a subform. The main form taking the price list header info price list ID, price area, and date and putting into tblPricelist) and using the sub form to table to load the actual price list info (product, price) and putting into tblpricelistsub.
What I am trying to do is to be able to bring the entire price list as it is and be able to update (or not) the price of all or some of the items and then have it save as a new entry into the tables. I am trying to do this without having to use a sub form and lookup every product all over again (500 products).
Is there a way to do a query to bring up the entire price list, turn that into a form, and then be able to update the prices that would in turn create another entry into the price list and pricelistsub tables?
View 13 Replies
View Related
Aug 3, 2012
I have a Multi-Item form and would like to do some math and change formatting on some fields depending on content of data in each row. From what I can tell, the on Load even only lets you do something with the first row and does not execute the VBA code for any following row. I don't see any way to trigger the VBA code on a row-by-row basis as the form is being painted.
Any technique to do this or do I have to go to some other form type to do some dynamic formatting?
View 3 Replies
View Related
May 30, 2006
Just curious. I'm trying to set up a switchboard to guide users to the right place in my database. I would like to have one button on the switchboard to open a standard form with all the infomation in it already. and then I would like to have a button to open a form that is blank and then adds to the previous form I mentioned.
Any help will be greatly appreciated.
View 2 Replies
View Related
Dec 1, 2005
Have a question on the switchboard choices I've always wondered about. Why are there only "Add" and "Edit" modes to open a form from the switchboard? I see many, many times when you want to allow a form to be opened in "readonly" mode to page through records but not allow edits or additions. Why does Access NOT have "Readonly" as an option?
View 2 Replies
View Related
Oct 7, 2004
I accidently deleted the switchboard form from an Access database. The switchboard manager is still there as is the Switchboard table. Can anybody advise me on how to get the switchboard form back, please?
View 2 Replies
View Related
Mar 15, 2013
I would like to have the Switchboard I created open when the database is selected. I used Tools/Startup to set this up. It works to a point. The database window opens and THEN the Switchboard opens (on top of the database window). There are some who I wish not to see the database navigation window). Also, is it possible to OPEN the switchboard again when a Form is closed?
View 1 Replies
View Related
