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.
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.
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 RelatedI get the feeling I'm really missing something glaringly obvious here but I'm struggling.....
I have a combo box on my switchboard that looks up field txtOfficer in a query and then want it to open up a new form containing only those records relating to the officer name selectedtxtOfficer
The rowsource for the combo is:
SELECT DISTINCTROW [qryMain].[txtName] FROM [qryMain];
and the on click event is:
DoCmd.OpenForm "frmFiltered", , , "[txtName] = " & Me.cmbOfficer.Column(0), acFormEdit
When I select a name from the combo I get a parameter box and have to type in the name to open up the filtered records form. How can I get rid of it so the selection is one seamless process? :confused:
When I open a form, it displays the first record from the table that I defined as it's Record Source. I want the form to open with all the fields blank so the user can begin entering data. What do I need to do to get the form to open without any data in the fields?
Thanks
Rod
I have a form that is used to both Enter & Edit records. There is a "search" button to aid in finding records.
I have been asked to have the form open to a blank record instead of the first record in the table.
Is there a way to do this without setting the "DataEntry" property to true, as this basiclly disables the "search" button.
Thanks
I have one table containing name of restaurant with its address etc. Then i created another table to list out the restaurant workers names and details. Just as an example,
Table:Restaurant
Restaurant name
Address line 1
Address line 2
Restaurant #
Website
Table:StaffContact
Staff Role
Name
speciality
email
phone
I have the main form that has all the restaurant details only. And i have another form containing the Staff information. Please note the two table have a relation and it works well.
Now to make it user friendly(basically easier for the lazy ones), I dragged the staff contact form on to my main form and displayed it as a datasheet(basically a sub form).
Now, my boss does not want users to add/delete on this sub form(datasheet). So,he wants me to create buttons to open new record of staff for each restaurant(new form)
My issue is with opening a new record to enter a new person to the staff list and give them a role as well in form view.The new form has
So i ran a Macro, with open form with Where condition
Code:
[Staffcontact]![Rest Name]=[Forms]![MainForm]![RestaurantName]
But, it does not work .
I have a form that is connected to a table - when I open the form it loads the first record in the table. How can I make it open a blank form, ready to add a new record?
View 1 Replies View RelatedI have a form linked to an employees table. I have a search function on this form which allows you to search for a particular employee.
At the moment when i open my form, it always displays the first record!
How can I make my form open with blank fields instead of the first record showing?
Thanks alot.
Regards,
Amber
How can I force a form to open at "New (Blank) Record"? What I want is when a person opens the database it will take them to a default form (I have figured this part out already) but at the "New (Blank) Record".
View 1 Replies View RelatedHi, I hope someone can help! I have purchased a programme that operates using MS Access. The software loads and functions perfectly on my desktop computer, when I put it onto my laptop, it loads but when I agree to the terms and conditions a switchboard should open but all I get is a grey blank screen with only file, window and help. I did have Nortons 2005 internet suite on it but I have removed that thinking it had something to do with that, restarted my computer removed and reloaded the software and the same happens. I think there is something wrong with the settings on the laptop or some form of script blocking. I am absolutesly exasperated. Please help with any suggestions as I know that the software is functioning and I know that Access is functioning and obviously Access thinks it is displaying everything or there would be an error box. Please help!!
Danni
I have a [Order Central table] that compiles products from four different categories that employees can order from.
Employees using the database will select from four categories on buttons which opens up the order form EX: [Category 1 form].
They enter their order info on [Category 1 form] into a subform sourced from [Category 1 Table] called [Category 1 subform].
Is there a way that they could select the "Category 1" button, which would run a macro opening [Category 1 form] with the [Category 1 subform] having a where condition of 1=0 (or just so that the subform appears blank)?
Hi all,
I decided to create a switchboard using tools---> DB utilts---> SW manager.
i have managed to get this on the front end, altho the first button the contacts does't work properly. when i click it using that i cannot see any of the data that is in the database? but if i go out the switchboard without pressing anything on it. and goto contacts form the data is there?
Wired? or is it something simple i have missed?
Thanks
Shrew
www.dsltech.co.uk/310506.zip
Is there i way so that when you open up your database you can get your Switchboard to open up??? is there a simple box to click to make it do this that i am missing or is it some VB code?
Help please thanks alot
l33tskyline aka Chewstar
I know stupid question. When I open my database I want the switchboard to open automatically, but it doesn't. What do I do to fix this?
Thanks
Biz
i'm creating a database which has several switchboards. i have several tables, each saved in the same format with the table name representing the date of the report, for example table 1 is saved as 100204(Oct 2, 2004), and table 2 is 100904, so on and so forth. I have a text box which a user needs to enter the date of the report they want to look at and i need to be able to open the desired table by date entered. I've had a couple of vb classes but haven't used it in a while. can anyone help? thx in advance.
View 2 Replies View RelatedHi,
Does anyone know if I can just show the switchboard only so that it looks like a program, or if I can use an existing MDB to create an .exe??
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
View 7 Replies View RelatedI'm trying to make a form so that it opens up to a blank/new record. Any tips? Can't seem to figure it out.
Thanks, Jonathan
Hi guys,
I have been running the same database on numerous systems for 5 years and the user clicks on a button and using this code;
DoCmd.OpenForm "Employee", acNormal
Simple !, this always opened this form blank, without applying filters, ready to accept a new employees details.
But now this no longer works, for no apparent reason?
What happens is that it opens with the form fields filled with the first person in the Databases details instead of being blank.
The only thing that could have changed is that i converted the database to 2003?
Any ideas?
Thank you in advance
Please help!
I've done a search of the forums, the results of which have more-or-less caused me to understand (roughly) what the problem might be and how to locate the code which is causing it. Sadly, I am a bit of a Visual Basic virgin, and I am reluctant to wade right in because if I screw up this database I'll have decimated my company's advertising and marketing strategy (mailouts!).
I was trying to make a command button on a switchboard (which I have done before, but not recently) -- and was taking a bit of a trial-and-error approach. I wanted the button to result in the previewing of a set of mailing labels (which the user would susbsequently print after reviewing). One of my first attempts resulted in the button automatically printing, so I "cut" it, and several close-but-no-cigar attempts follwed, all of which I used the "cut" command to dispose of. The last attempt I made resulted in the following message:
"The expression On Open you entered as the event property setting produced the following error: Ambiguous name detected: Bulletin_Board_labels_Click.
-The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure].
-There may have been an error evaluating the function, event, or macro."
I "cut" the button I had just created and thought that might fix it. It didn't. I still got the above message whenever I tried to open either this switchboard or the main switchboard. I tried closing down Access and restarting it. Same message, same problem.
Below is the code from the switchboard in question -- the last few entries are the relevant ones: anything to do with "bulletin board" is stuff I was working on. As far as I can tell there are currently no duplicate queries, reports, macros, etc, named "Bulletin Board Labels" (theres is one query named "Bulletin Board Query", and one report named "Bulletin Board Mailout labels", and that's it.)
The code for the switchboard follows...
Please help me resolve this problem?
:confused:
Jennifer
_________________________________________
Option Compare Database
Option Explicit
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim stDocName As String
stDocName = "All Art Galleries"
DoCmd.OpenReport stDocName, acPreview
Exit_Command0_Click:
Exit Sub
Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click
End Sub
Private Sub Command11_Click()
End Sub
Private Sub OLEUnbound22_Click()
Dim strInput As String
strInput = "help.html"
Application.FollowHyperlink strInput, , True
End Sub
Private Sub University_Bigwigs_Click()
On Error GoTo Err_University_Bigwigs_Click
Dim stDocName As String
stDocName = "University Bigwigs Query (VP's, Deans, etc)"
DoCmd.OpenReport stDocName, acPreview
Exit_University_Bigwigs_Click:
Exit Sub
Err_University_Bigwigs_Click:
MsgBox Err.Description
Resume Exit_University_Bigwigs_Click
End Sub
Private Sub Command13_Click()
On Error GoTo Err_Command13_Click
Dim stDocName As String
stDocName = "Invitation Destination Report"
DoCmd.OpenReport stDocName, acPreview
Exit_Command13_Click:
Exit Sub
Err_Command13_Click:
MsgBox Err.Description
Resume Exit_Command13_Click
End Sub
Private Sub Main_Click()
On Error GoTo Err_Main_Click
DoCmd.Close
Exit_Main_Click:
Exit Sub
Err_Main_Click:
MsgBox Err.Description
Resume Exit_Main_Click
End Sub
Private Sub Help__Click()
On Error GoTo Err_Help__Click
Dim stAppName As String
stAppName = "C:AEAC Mailing list Databasehelp.html"
Call Shell(stAppName, 1)
Exit_Help__Click:
Exit Sub
Err_Help__Click:
MsgBox Err.Description
Resume Exit_Help__Click
End Sub
Private Sub Ref_List_Click()
On Error GoTo Err_Ref_List_Click
Dim stDocName As String
stDocName = "Category/Destination/Receive"
DoCmd.OpenReport stDocName, acPreview
Exit_Ref_List_Click:
Exit Sub
Err_Ref_List_Click:
MsgBox Err.Description
Resume Exit_Ref_List_Click
End Sub
Private Sub Campus_Coverage_Click()
On Error GoTo Err_Campus_Coverage_Click
Dim stDocName As String
stDocName = "Campus Coverage Report"
DoCmd.OpenReport stDocName, acPreview
Exit_Campus_Coverage_Click:
Exit Sub
Err_Campus_Coverage_Click:
MsgBox Err.Description
Resume Exit_Campus_Coverage_Click
End Sub
Private Sub Flyer_Report_Click()
On Error GoTo Err_Flyer_Report_Click
Dim stDocName As String
stDocName = "Flyer Destination Report"
DoCmd.OpenReport stDocName, acPreview
Exit_Flyer_Report_Click:
Exit Sub
Err_Flyer_Report_Click:
MsgBox Err.Description
Resume Exit_Flyer_Report_Click
End Sub
Private Sub Poster_Destination_List_Click()
On Error GoTo Err_Poster_Destination_List_Click
Dim stDocName As String
stDocName = "Poster Destination Report"
DoCmd.OpenReport stDocName, acPreview
Exit_Poster_Destination_List_Click:
Exit Sub
Err_Poster_Destination_List_Click:
MsgBox Err.Description
Resume Exit_Poster_Destination_List_Click
End Sub
Private Sub Currents_Destination_List_Click()
On Error GoTo Err_Currents_Destination_List_Click
Dim stDocName As String
stDocName = "Currents Destination Report"
DoCmd.OpenReport stDocName, acPreview
Exit_Currents_Destination_List_Click:
Exit Sub
Err_Currents_Destination_List_Click:
MsgBox Err.Description
Resume Exit_Currents_Destination_List_Click
End Sub
Private Sub Catalogue_Destination_Click()
On Error GoTo Err_Catalogue_Destination_Click
Dim stDocName As String
stDocName = "Catalogue Destination Report"
DoCmd.OpenReport stDocName, acPreview
Exit_Catalogue_Destination_Click:
Exit Sub
Err_Catalogue_Destination_Click:
MsgBox Err.Description
Resume Exit_Catalogue_Destination_Click
End Sub
Private Sub FlyerMultCopiesButton_Click()
On Error GoTo Err_FlyerMultCopiesButton_Click
Dim stDocName As String
stDocName = "Flyer Multiple Copies Report"
DoCmd.OpenReport stDocName, acPreview
Exit_FlyerMultCopiesButton_Click:
Exit Sub
Err_FlyerMultCopiesButton_Click:
MsgBox Err.Description
Resume Exit_FlyerMultCopiesButton_Click
End Sub
Private Sub InvitatMultCopButton_Click()
On Error GoTo Err_InvitatMultCopButton_Click
Dim stDocName As String
stDocName = "Invitation Multiple Copies Report"
DoCmd.OpenReport stDocName, acPreview
Exit_InvitatMultCopButton_Click:
Exit Sub
Err_InvitatMultCopButton_Click:
MsgBox Err.Description
Resume Exit_InvitatMultCopButton_Click
End Sub
Private Sub CampFlyMultCopButton_Click()
On Error GoTo Err_CampFlyMultCopButton_Click
Dim stDocName As String
stDocName = "Campus Flyer Multiple Copies Query"
DoCmd.OpenReport stDocName, acPreview
Exit_CampFlyMultCopButton_Click:
Exit Sub
Err_CampFlyMultCopButton_Click:
MsgBox Err.Description
Resume Exit_CampFlyMultCopButton_Click
End Sub
Private Sub PostMultCopButton_Click()
On Error GoTo Err_PostMultCopButton_Click
Dim stDocName As String
stDocName = "Poster Multiple Copies Report"
DoCmd.OpenReport stDocName, acPreview
Exit_PostMultCopButton_Click:
Exit Sub
Err_PostMultCopButton_Click:
MsgBox Err.Description
Resume Exit_PostMultCopButton_Click
End Sub
Private Sub Bulletin_Board_labels_Click()
On Error GoTo Err_Bulletin_Board_labels_Click
Dim stDocName As String
stDocName = "Bulletin Board Mailout Labels"
DoCmd.OpenReport stDocName, acNormal
Exit_Bulletin_Board_labels_Click:
Exit Sub
Err_Bulletin_Board_labels_Click:
MsgBox Err.Description
Resume Exit_Bulletin_Board_labels_Click
End Sub
Private Sub Bulletin_Board_labels_Click()
On Error GoTo Err_Bulletin_Board_labels_Click
Dim stDocName As String
stDocName = "Bulletin Board Mailout Labels"
DoCmd.OpenReport stDocName, acPreview
Exit_Bulletin_Board_labels_Click:
Exit Sub
Err_Bulletin_Board_labels_Click:
MsgBox Err.Description
Resume Exit_Bulletin_Board_labels_Click
End Sub
Private Sub Command57_Click()
On Error GoTo Err_Command57_Click
Screen.PreviousControl.SetFocus
DoCmd.FindNext
Exit_Command57_Click:
Exit Sub
Err_Command57_Click:
MsgBox Err.Description
Resume Exit_Command57_Click
End Sub
Private Sub Command58_Click()
On Error GoTo Err_Command58_Click
Dim stDocName As String
stDocName = "Bulletin Board Mailout Labels"
DoCmd.OpenReport stDocName, acPreview
Exit_Command58_Click:
Exit Sub
Err_Command58_Click:
MsgBox Err.Description
Resume Exit_Command58_Click
End Sub
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.
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
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 RelatedI 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?
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.