I have a switchboard that points to other switchboards (sub switchboards so to speak). I'm looking to change header title depending on what I group on that switchboard. However, when if I change one of them I change them all. Example: The main switchboard has a header of "switchboard". I have a sub switchboard that I would like to name "Report Switchboard". If I do that it changes all of them, not just the one that I want. Any thoughts?
Thanks in advance.
Eddie.
P.S.
In looking through the forums for this answer I found this awesome thread about to jazz up a database. Thanks to any of you that put suggestions on there.
hello, I have a main switchboard that has a button which opens another switchboard, the button is labelled (has the caption) “Reports” but the trouble is when this other switchboard opens the button on here also has the name “reports” but I want it to be named: “open employee report” and if I change the name of the button on the other switchboard it changes it on both switchboards :mad: , anyone know of a way around this?
I 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.?
I 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.
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.
Hello all, Is it possible to add logos and headers to mdb tables. This is required because the tables are to be printed out and presented. The database itself is manipulated through java swing, so I would like the table to be ready to print out when opened. Any assistance is greatly appreciated.
I am attempting to create my first crosstab query in design view. Adding a simple row and column header and one value, I always get the error message 'Too many crosstab column headers (454)'. What am I doing wrong? Here is the SQL:
TRANSFORM Sum(Forecast.QTY) AS SumOfQTY SELECT Forecast.HECI FROM Forecast GROUP BY Forecast.HECI PIVOT Forecast.QTY;
How would I go about creating a datasheet style form with 'sort by' headers
for example:
I could create a form with a list box sorted by 'name' by default. If i wanted the same data to appear but sorted by 'Address' or 'Phone Number' how would I go about this?
Many databases give a datasheet view of the data where you can sort by clicking the appropriate header... how could this be achieved in access?
I have a report that has category, subcateogry and districts.
I can get the first part of the report to work as I want it like so:
Category FruitSub Cateogry Apples OrangesMeatSub Cateogry Pork Chicken Now is where the fun starts. I want next to each of the subcateogries a count of districts, but I want to name of the districts to be at the top, and the counts to go underneath - here is 2 lines to show what I would like.
Category District Name FruitSub Cateogry 2Apples 3Oranges0 The red text "District Name" would be 4 different districts, going across with the counts under the related districts.
I can not get the districts to show up at the top of the report next to cateogories, and go across with all of the districts, it keeps on wanting to list them underneath each other.
All reports that I have seen have a "set" header, not one created on the fly according to a database.
Is this possible to do, and if so, can someone point me in the right direction?
My report has a header that contains "Shipped-From" and "Ship-To" information. I only display this on the first page of my report by using some code in the Page Header section. The problem is that the field names of the detail section are also in the header. This means that from the second page on the field names are absent. What can I do to include the field names in all of the pages - but the "Shipped-From" and "Ship-To" information only on the first page?
I'm using Access 2003. I have a report that I've set up with 2 columns. Unfortunately the Page Header won't print the headings for both columns. I looked on the Help screen and it says the information below. I assume this does not apply to the Page Header section? When I try to use a group header, all I can get is a header for every single row in the group. What am I doing wrong?
Repeat a group header in another column
Open the report in Design view (Design view: A view that shows the design of these database objects: tables, queries, forms, reports, and macros. In Design view, you can create new database objects and modify the design of existing objects.).Double-click the section selector (section selector: The box on the left side of a section bar when an object is open in Design view. Use the box to perform section-level operations, such as selecting the section.) of the group header (group header: Used to place information, such as group name or group total, at the beginning of a group of records.) to display the property sheet.Set the RepeatSection property to Yes.
I have an access 2000 database and i want to make a cross tab query with 2 column headers but access doesnt allow thatI decide to make the inverted cross tab query and its okbut now i want to use this in a report but invertedex product type client1 client2 client3 a 1b 2c 3 product a product b product c type 1 type 2 type 3client1 client2 client3
I can't get my choices to display--only the Headers. In the selected field I choose combo box and choose the table to look up in the row source. The data columns are first in the table and their ID is last, but I only get the Header to display in the box. If I deselect header, I get an emply list
There are actually 7 columns in the look up table (the eighth is the ID) and 10 rows of possible choices.
Column Count: 7 Headers: Yes (or no doesn't matter) Bound Column: 1 (changing doesn't matter) Limit to List: No (so I can add)
What am I missing in the properties setting?
Also, can I use one of the columns in the look up table as a primary sort on a report? Or will it see the whole string of columns as one?
I am using Access 2000. I have created a command button on a form that when pressed, it exports a file to Excel using the TransferSpreadsheet command. It exports names, degree type, graduation date starting in cell A1. It works well.
What I wish to do is this: Can I have this data exported starting in cell A5 instead of A1? AND in the export cell A1 will have "College", A2 will have "School" and A3 will have "Dean".
I am trying to import an Excel spreadsheet into an Access table and running into a snag. Since the spreadsheet doesn't have column headers, I keep getting Run-time error '2391' - Field '0000000' doesn't exist in the destination table ... my table name.How can I import the data from a spreadsheet so that it ignores the fact that there is no column headers?
Here is the VBA/Module:
Option Compare Database Dim myCheck Function WebRegistration() DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tbl_TruRewards Web Registration", "R:DEPT-BRCONSUMER LENDINGVISACardholder ActivityWeb Registration_TruRewards.xls", True, "Web Registration!F8:R50000" End Function
So I'm using the same field in a query, price. But I need it listed twice in the table it creates, one as cogs_mfn, and the other as cogs_afn. The problem is that since the field that the data is coming from is exactly the same, the caption remains consistent, whether one or the other. I've tried to create separate expressions, but that doesn't work either.
What I have noticed, I maybe wrong, the record is a available for the "group_header" section closest to the detai section, in my case, "Client_GroupHeader". However, I need information in the record to format goup header information in the "Customer_Groupheader" and "State_Groupheader. Can anyone help me with this.
Ok I have a function that imports some spreadsheets into our db (it's a timer/scheduler on another db)> The file coming from oracle discoverer originally. Can't figure out in that 4i version how to remove the headers.
What could I add into my code in the function to import only the data and not the column names/headers? I can provide code if needed?
I built a form that will allow each page header to take the info needed depending on who is using the data base. I seem to be having a problem having the Logo uploaded so that it can be used. Since I am new to Access, my only example would be like a web page. use the location of the picture in the code and it pulls it up for each page associated. I guess this would be 2 questions. How do I add to my form the upload of the graphics and how do I get the reports and forms to pull that picture into the header every time.
I was wondering if a list box can be made so the header of each columns is clickable.. so you can sort by that column either alphabetically or numerically?
I'm working with several different source datasets. Mostly this are TXT files.
When I import the data in a new table with a specification, I want to validate if the dataset is the correct dataset be validating the headers in the source data.
I have created a table with the headers, that consists of 92 columns. Below 3 example columns of the header data:
Now I want to check during the import of the imported data has a line in it that is equal to the data in the table headers. If not, the import stops and informs the user that the data set is not correct. This to prevent that incorrect data will be inserted into the database.
Some extra information: The data is import into the database via VBA DoCmd.TransferText into a new created table, using an inport specification.
If the data is okay, it will be appended to an existing table that is being used to process the data further. After that the import table is being deleted.
