General :: Created A Switchboard With Multiple Buttons
Jul 24, 2012I've created a switchboard with multiple buttons. I need to have one of the buttons "upon click" to open up a picture or video.
View Replies
ADVERTISEMENT
Forms Created From Starting A New Switchboard
May 13, 2006This is probably elementary, but I'm entirely lost. Here's my issue:As most of you probably know, when first creating a switchboard in a database will automatically create a form based on it.Somehow I managed to delete that form, and have no idea how to make a new one with the same default switchboard format (where command buttons are automatically generated, and there's a default title label with the shadow effect, etc.)I thought I might try to just delete the switchboard and create a new one so that another form would be created, but it won't let me delete the switchboard!If I understand correctly, I have to create a switchboard without any other switchboards already existing for Access to create a related form for me. Any suggestions?
View 6 Replies View RelatedChanging Switchboard Buttons
May 11, 2006When I made this database years ago, I had little to no idea of what I was doing. My switchboard works by mouse clicking on each number button, but is there a way to go back in and add to the on click if I wanted to hit the actual number of that button? IE: if I wanted number 6 instead of clicking on the button just hitting the number 6 on the keyboard. Thanks
View 1 Replies View RelatedForms :: Switchboard Will Not Allow More Than 8 Buttons On It
Jul 22, 2014 I'm trying to create a switchboard through which one can access data entry forms. Now there are about 13 of such forms but I've put only 3 here for simplicity. The idea is to have a button (on the main switchboard) represent each category but I understand the switchboard will not allow more than 8 buttons on it? I guess that by the end of the day, I will probably have two secondary switchboards for these 13 buttons. I created the main & secondary switchboards (the second is called "This is the Look I want"). A button called "TheOtherBoard", on the main switchboard, should take me to "This is the Look I want".
1) I don't like the way the Main switchboard looks and decided to create the secondary switchboard with the look I prefer but it duplicates anything I do. How can I fix this?
2) when I double click on the main switchboard, the secondary board (with colourful buttons) opens. Should be the ugly one first!
3) Also, since I manually added the buttons & stuff, I think I'll need to link them with the forms.
Why Wouldn't Switchboard Buttons Work?
Feb 18, 2007I suppose I am hoping for a simple answer here when it could be a myriad of things but fingers crossed.
I have a database - split back end, front end both files under 4000kb. It is sitting on a server.
On some computers it will open up to the Switchboard (so I have ruled out access (as in security access) problems) but the command buttons on the switchboard are all inactive. This only happens on some computers (so a person can sign on to one workstation and all is OK and then move to the next and the above happens). There are not multiple sessions open all at once - maximum probably 3.
Any ideas???????
General :: New Objects Created Don't Appear In Navigation Pane
Oct 30, 2013I'd like to count the number of objects in my DB to check if I'm running into the 32,768 object limit. I'm experiencing unusual and disconcerting behavior, and all the normal corruption repair techniques aren't working. I've imported all the objects into a new database container, decompiled, compact & repair, and nothing works until the I delete some objects (forms, reports, queries, etc).
New objects created don't appear in the navigation pane until I close and re-open. Also, changing a query type from select to append doesn't result in the icon changing in the navigation pane.Code seems to run fine and everything else appears OK, but I really can't continue development until this issue is resolved. I fear continued development may lead to further corruption.after 20 years, this application has grown, I use a variety of techniques to get the size of the application. Currently:
1. 201,200 lines of code in 910 modules, reports and forms.
2. 544 forms
3. 328 reports
4. 3,617 queries (yes, I know, but it's so much work)
5. 450 tables (about half are linked)
I always thought, without thinking too deeply, that the number of objects in the spec refers to the number of reports, forms, modules, etc. But, now I'm wondering, do they also mean all the controls on the forms, and or the fields in the tables? What do they mean by objects.
I used Point Limited's translation modules recently to extract all the label and caption text for a French language translation project and it pulled out something like 21,000 individual controls, and, combined with this issue, I'm beginning to wonder...
General :: Need To Change A User Created Menu
Aug 6, 2014I have a database that was created in Access 2003. I'm using this MDB in Access 2010.I need to change a user created menu. The update involves changing an existing entry and adding a new menu item. The menu looks like:
Project
Time Entry
Time Spread
I need the "Time Spread" to change to "Time Spread Daily" with a changed macro name. After that a new menu entry is "Time Spread Monthly". This menu will run a new macro that will display a form.I think the only way to do that in 2010 is to use VBA.
General :: Fill In Date Automatically When New Record Is Created
Dec 18, 2012I would like to have a date control on a form filled in automatically with the current date when a new record is created (the date would remain as is unless changed manually). I've tried programming it in VB but, being a newbie, have not been able to come up with anything that works. I'm not even sure how to trigger an event to do it just the one time when the record is created.
View 2 Replies View RelatedRound Buttons Or Oval Buttons Instead Of The Normal Square Buttons
May 30, 2005Hello everybody,
I’m new here and I have a question for you..
Is it possible to place round buttons or oval buttons on your forms instead of the normal square ones?
Greets,
Tom
General :: Capturing And Saving User Name Who Created And Updated A Record
Jul 20, 2012I have taken the Access Tasks template and modified a bit. It now captures and saves the time and date a record is modified. The database is on a network folder and is shared among our team users.What I would like to do next is make it,
1- capture and record on my Tasks table the user name of who created the record by using the fOSUserName() function. I have the table fields "Created by" and the VB code in a module. This would happen only once when the record is created.
I would also like to do this with the machine name for which I have the module too. fOSMachineName()
and,
2- capture and record the user name of who modified a record. For this I also have a field in my task table "Last Modified By" and i hope i can use the same fOSUerNmae() function.
I got to the point where I put an unbounded text box with the =fOSUserName() in it and it does show the user name but how do i get to record to my task table?how the template removes the tasks that are completed from the task list as soon as it is updated to completed? how can I make this happen with a cancelled option after I add it to the drop down list?
General :: Cannot Open A Database Created With A Previous Version Of Application
Oct 22, 2012I am trying to open a MS Access Database which was made in MS Access 1997 or MS Access 2000, at the moment i am using MS Access 2010, i cannot open the database or link the tables.i do not have MS Access 2000 anymore.
View 1 Replies View RelatedSwitchboard Link To Multiple DB's
Sep 13, 2004We have a switchboard that we have created for a database. We would like to link from this main switchboard to the switchboard in another database. If this is possible and if someone could help accomplish this I could sleep at night and move on to my next hurdle. Thanks in advance. Paula
View 1 Replies View RelatedMultiple Command Buttons
Jun 25, 2006Was woundering if the was a way to habdle multiple command buttons with one procedure. I have done a little VB.Net and I remember that you coud use one sub to handle multiple buttons using the handles key word. I was wondering if Access could do that. What I have is 37 command buttons named cmdView1 through cmdView37 all I really need is the number that prefixes the command buttons name. I know how to pull out the number but I can not figure out how to use only one sub procedure for all 37 buttons. Any help is appreciated.
Frank
Multiple Toggle Buttons Working Together
Jul 23, 2007Hi - 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,
:)
Multiple Buttons On A Main Form
Dec 19, 2006Hi All
I have a main form which displays some basic info aboute a site. I would like to be able to place multiple buttons down the right side of the form. This would be similar to having a seperate column which is not affected by the number of records on show. I have considered placing them in the form header but think a column down the side would look much neater.
Any help would be much appreciated.
ChrisD
General :: How To Change Path For Switchboard
Apr 3, 2013I have copied our company access database onto my lap top and linked the front end to the back end. My problem now is that when I open the switchboard it is looking for the data and tables on the G drive, this was where it was on our server. How do you change the path for the switchboard.?
View 10 Replies View RelatedDoCmd.SendObject Used In Multiple Email Buttons
Dec 28, 2007Have found some code that originated from this forum, and have modified it to suit my needs. There's one form with all the information, that has multiple buttons and subsequently multiple functions to generate emails, with each button/email to generate a different format and content. The first use of a button works fine, but trying to use the next button right after does nothing. If you exit the form and re-enter, you can then use the next email button, but that's a pain and the users won't like that. Can anyone help? I've pasted a sample of the code that is being used below, it's duplicated and changed slightly for the other buttons. I currently have the button linked to a macro that does other things like saving, and setting dates and then running the function.
Thanks,
Don
-----------------------------------------------------------------
Public Function AckEmailNew()
On Error GoTo Err_cmdMailTicket_Click
Dim varTo As String '-- Address for SendObject
Dim stText As String '-- E-mail text
Dim stSubject As String '-- Subject line of e-mail
Dim stTicketID As String '-- The ticket ID from form
Dim strSQL As String '-- Create SQL update statement
Dim errLoop As Error
varTo = Me.ClientEmail
stTicketID = Me.STSITicket
stSubject = "Ticket/numéro de référence: " & stTicketID
stText = <<My text goes here>>
'Write the e-mail content for sending to assignee
DoCmd.SendObject , , acFormatTXT, varTo, , , stSubject, stText, -1
On Error GoTo Err_Execute
Exit Function
Err_Execute:
MsgBox Err.Description
Resume Exit_cmdMailTicket_Click
Exit_cmdMailTicket_Click:
Exit Function
Err_cmdMailTicket_Click:
MsgBox Err.Description
Resume Exit_cmdMailTicket_Click
End Function
Multiple Email Buttons One Access Form!!!
Aug 1, 2006Hello to all the Users!
I am new at Access and new to programming.
I have created an Access form that has four labeled control buttons each one with an individuals name. I have the corresponding code:
Private Sub Email_PersonOne_Click()
DoCmd.SendObject acSendNoObject, , , "personone@yahoo.com", , , "Work Request", "A new work request has been submitted."
End Sub
When I have one button and one code the email function works. I want the users to be able to select one out of four people who they want to notify upon completion of the form. So I have four buttons and changed the email address and the names on the buttons but now none of the buttons work.
The code is on the same page separated with just a line between each section.
Does this make sense?
Any input would be greatly appreciated.
Thanks in advance for your time and help.
Sincerely,
DebraF
General :: Use Hyperlink Command In Switchboard Database
Apr 17, 2015I have a number of databases in my system and I created a database that only has a switchboard form in it. This switchboard form has links to all of the various databases I have created and opens their default input form. This works fine but now I wish to place a button on the switchboard to run a report that is located in one of the databases.
I tried to use the hyperlink command in the switchboard database but that will not show me the information in the other databases only the switchboard database. I assume I have to link the databases and create a connection to the other database and its report.
General :: Change Switchboard Items For Different Users
Oct 8, 2014I have two versions of the switchboard items table. (A2003 switchboard). I have a login form, and I want to be able to change the switchboard items for different users
so I have code that does this
close the switchboard,
copy the new switchboard items table
reopen the switchboard
And every time, it says it cannot copy the table because the switchboard items table is in use. The code in the switchboard opens recordsets, and I have quadruple checked that they are closing correctly, after use. The switchboard itself is bound to the switchboard items table
I have just tried something different which is to manually close the switchboard - and then I CAN copy the tables.
Might the code be atomic in some way. The switchboard does not release the locks until the code completes?
I thought about it, and got round it now, by just copying the data from the new table to the master table, rather than trying to copy tables, but I am still curious.
General :: How To Add More Buttons To UsysRibbons
Sep 11, 2012I need to add extra buttons to the code I already have for my ribbon. Do I need to change more than the code in UsysRibbonsor do I have to make changes to BasRibbonCallbacks also? I need to create maybe 3 extra buttons. Current code below (I had to alter the microsoft address to be able to post here)
UsysRibbons
Code:
RibbonXML
"<customUI xmlns=""h t t p://schemasdotmicrosoftdotcom/office/2006/01/customui"" onLoad=""onRibbonLoad"">
<ribbon startFromScratch=""true"">
<tabs>
<tab id=""tabHome"" label=""Home"">
<group id=""grpAccounting"" label=""Accounting"" visible=""true"">
[code]...
General :: Error Reading Switchboard Items Table
Jun 26, 2013I have two options on the main switchboard page and when I click on the second option it goes to a secondary page that gives me 3 options with the third option being to return to the main screen. When I select that option it does go back to the main screen but then on the main screen it shows the return to main screen option as well and when I select it.... it says " There was an error reading the switchboard items table." But I want the main screen to only show the original two options only.
View 1 Replies View RelatedModules & VBA :: End User Form - Linking Multiple Toggle Buttons
Mar 11, 2014I have built a end user form with multiple toggle buttons with "Yes/No" properties. I am wanting to link the buttons together, so if all have been selected/pressed it will read "pass" in a text box, but if even one is not selected it will read "fail". I was successful with the programming for one but not sure how to link them.
View 2 Replies View RelatedModules & VBA :: 1 Function For Multiple Buttons / And Using Arrays For Button Colors
Mar 4, 2014Question 1:
I am attempting to make a macro to pull information based on a clicked button to provide information to another form. While my example below will be rudimentary, I am attempting to create so that it can be applied to 450 buttons, hence the need for it to be a macro and not simply code per button.
For example if I have 3 buttons, captioned: red, green and blue. If I click on the blue button, it will open another form with a text-box that will say 'blue'. Likewise, if I click the red button the text-box will be changed to 'red'.
In the code below the section that I need to change is: Command1.Caption. Using this data I can pull from the one button to create the value, but I need it to be based on an OnClick or something in order to pull the value from the right button.
Example:
Function Macro1()
On Error GoTo Macro1_Err
DoCmd.OpenForm "Form2", acNormal, "", "", , acNormal
Forms!Form2!Text0.Text = Forms!Form1!Label0.Caption
DoCmd.GoToControl "[Text2]"
Forms!Form2!Text2.Text = Forms!Form1!Command1.Caption
[code]...
Question 2:
I am trying to use a query to change button colour on the basis of values stored in a table.What I want to do is change the button background after comparing the button name to the same variable in a table, and determining another variable.
IE:
Button1, Button2. In table: Button1, Val = Y, and Button 2, Val = Z
Pseudo Code:
Array: From Button1 to Button2
Query for Button1 against table
If Val = Y, Button1.background = red
Else if Val = Z, Button1.background = blue
Else Button1.background = black
End if
General :: Frames And Toggle Buttons For Criteria
Jun 17, 2014I have a frame on a form with 2 toggle buttons in it - i want to be able to toggle the buttons to set criteria for a query which i can load as a report from clicking a button - is it possible to do with IFF? or is there an easier way - is it possible to have the report as a sub-report on the form and it to change when i toggle the buttons?
View 3 Replies View RelatedTables :: Created Multiple Tables In Database
Feb 19, 2013I have created multiple tables in my database and now for some reason it keeps telling me it can not find a few of my existing fields.
View 5 Replies View Related