A Question Involving Switchboards
Jul 6, 2005
I have my db set up so that when you load all you see is the switchboard...no menus or tool bars. I have done this by going into startup and disabling them..no real trick there..
I have an option on my main switchboard to exit to design...from there it opens a form for a password, if the password is correct, it closes the password form, closes the switchboard and uses the sendkey {F11} macro function to open my design view for the db....the problem is that my menus and tool bars are not around either...
is there anyway to do a vb command to enable these
View Replies
ADVERTISEMENT
Mar 28, 2007
hello, I have tables which have relationships in them. for example, ID appears within 3 different tables for the same item. How can I set up a query to delete all records with that ID from all of the tables in one go?
Thank you,
JDRasq
View 1 Replies
View Related
Jul 22, 2005
I have a table with a multi-field unique index:
PatientID
TestId
TestDate
Examiner
The problem is, date and/or examiner can be blank until that information is updated. I want those null values to be understood as actual values so that multiple instances of that "waiting to be updated" record do not occur. Is it possible for Access to understand my indexes in the following way?
PatientID----TestID----TestDate----Examiner----(Index)
1------------1---------07/18/05----AD----------1107/18/05AD
1------------1---------[blank]------[blank]------11
and therefore not allow another record like the second one to be added? The ignore nulls property of my index doesn't seem to affect this issue?
Thanks!
Carly
View 1 Replies
View Related
Apr 11, 2006
is there any way to add a button to a switchboard but not have it appearing on every s/b because in design view, it just shows a generic board, how do you edit specific boards?
View 2 Replies
View Related
Oct 11, 2006
Hi all.
I am having trouble creating a switchboard. Im new at this, and get so far, yet the board wont work.
I can get the board up, the buttons are there, when I click on them, nothing happenes.
Please help.
Thanks!
Thee:)
View 3 Replies
View Related
Jan 28, 2005
What is the purpose of a switchboard. I set one up that has options to either go to a data entry form or go to a list of reports. My understanding of a switchboard is that its a screen that pops up with options to go other places in the database. But how? If this is correct than how do I get to a place where I would design this screen(?) and associate the right commands to the buttons. What am I missing here?
View 1 Replies
View Related
Feb 3, 2005
I want to create a switchboard with a field - that I enter a record # in, and it will bounce me to a (already created) report, and then find the specific record so I can print it. Is this possible? I am a beginner with almost not programming experience. Actually I am a finance manager by trade. I have been teaching myself Access so please..please..make your suggestions simple and clear enough that a turnip would get it...Thank you
View 1 Replies
View Related
Jun 28, 2007
I have created a switchboard to view a hours worked report. what I would like to do is be able to have dirrerent buttons on the switchboard to view different hours worked from the same report. As an example one would bring up the report showing only last weeks hours, and another for this weeks hours only, or by person. Is this possible and what are the conditions that I should use
thanks
View 6 Replies
View Related
May 6, 2007
This might be a question that isn't possible, but I have three html pages made in my database, and i was wondering if there is a way to link the pages into the switchboard somehow because then everything would be accessible from one central location?? if you have any answers or sugestions they are greatly appreciated! thanks
View 4 Replies
View Related
Mar 10, 2006
When I added some Access 2003 (Winows XP) machines to our Access 2000 (on Windows 2k)-based database, many of them would not operate some of the Switchboard "buttons" (especially for reports that contained macros). The animation of "click" would operate, but nothing would happen, no form or report would occur like it should.
After several rounds with Microsoft's Access Help guys, here's how we "fixed" it:
1. I deleted all printers from the affected user's computer.
2. I booted into SAFE MODE with NETWORKING, then installed the Windows-based GENERIC TEXT printer.
3. I rebooted into XP and installed the GENERIC TEXT printer there also, for the affected users.
4. I re-installed the usual office printers around our office.
This completely fixed the problem on all XP-based computers. The technician at Microsoft says he cannot explain WHY this works, but I have experienced that it DOES work, so try it if you're having troubles, too. It's some kind of mysterious workaround that "fixes" Windows XP somehow.
View 2 Replies
View Related
Aug 21, 2007
This is the first time ive used the switchboard so hopefully this will be just a quicky!
Bascially i have a main switchboard which has 3 buttons. These buttons all link to different switchboard pages.
THE PROBLEM :- I have labels on the main switchboard and these are all appearing on the consequent switchboard pages. Is there a way of assigning these just to the main switchboard and not the other pages?
Thanks, any advice would be most appreciated!
View 11 Replies
View Related
Apr 22, 2014
I have a main switchboard but because the limit on it is 8 objects I decided to have different switchboards (Main data-entry switchboard, Query switchboard, and Report/Printing switchboard). I can easily add an object on the MAIN switchboard to open the Query switchboard and then on that Query switchboard have a button to go back to the MAIN switchboard but what I would like to do is have each switchboard open in different tabs instead, maybe a macro or "onclick" event needed? Would it be easy to build and customize my own switchboard?
View 11 Replies
View Related
