I've got two tables in Access. The first contains 300 column headers running from top to bottom, i.e:
Title
First Name
Surname
..
..
The second table contains the corresponding data entries for 1000 customers running from left to right, i.e:
MR Trevor Smith ....
MRS Mary Jones ....
Ideally i'd like to append table 2 to the bottom ot table 1 so the correct data field is under the right column header but I can't do this. Is there a transpose style funtion in access which will mean I can convert table 1 to run from left to right instead of top to bottom?
change to this format serial_no (these two columns will have new headings) 95x45 100 1 95x45 500 2 95x45 1000 0.9 96x15 100 3 96x15 500 0.1 96x15 1000 0.5
My task is to allocate Tasks to People for any/every day of a single week. There are up to 100 different tasks and about 1000 people to choose from but a typical allocation would involve perhaps 200 people. I have successfully used a form that presents a persons Name at the top of the form, and shows, for each Day: whether they are available, a combo box to select Tasks from a predefined list and a Time when they should start the Task. A report easily prints this by Name, without any transposition, and it is great for each person to see Task they have to do on which day and the time they should turn up. However, when it comes to supervision on each day, the manager wants to see a layout with column headings Task, Time1, Day1, Time2, Day2, . . . Time7,Day7 with a list of Tasks with assiciated Names for each of the days. One of the threads presents a solution that uses Dlookup to fetch the data but I believe that worked because the size of the data was determinate.
I have had to create a cludge using a subform/table to store the data as Task, Day1Name, Day1Time etc, using some VB routines, but the user has to take great care, for instance when a person is allocated a different task, the user has first to select a different line on this second table. It is even worse when the allotted task has to change or is deleted. The info is bound to be inconsistent.To sum up, there are only 7 days, not a perpetual calendar, but tasks and people are many and varied.
I have a database which is use at busy times to run the delivery side of our Floristry business. The orders are entered,assigned to a delivery area, address labels printed. When it comes to delivery day orders are selected from the list ticked off then printed a make a list for the driver.
It was built using Access 97 when it first came out. Since then the software was upgraded to Access 2000 many mods have been made each year to improve the performance and the number of things it can do. It now has about 15 tables and a lot of queries. Not being an expert with Access a lot of the design has been on a trial and error basis. Put it another way the main form has many hidden fields to make things work behind the scenes. But it does most of what I want it to. I have now go to the point where the main query is saying that I can't add any more features because I have to many fields in it.
So the time has come to look at re building it for a number of reasons.
1. It is a stand alone database on one Pc.......... I would like to have it on a network to 3 or 4 Pc's around the shop. 2. Some of it needs to be redesigned to take out my ( it might not be the way a designer would it but it does work) type bits. 3 I would like to be able to use the system for all orders received on a day to day basis. So it will need to be used by other people.
My question today is Should I be looking to rebuilt it using Access 2003 + the extra software so that i can run it on more than one PC.
Or would it be better to wait few months till Acess 2007 comes out and start from scratch.
I am trying to determine what version of Access is being used from a file that I obtained from a user. Everything I clicked on does not say what version of Access is being used. The extension name of the file is .MDB. The original version of the file I am accessing was created in 2001. Thus would you tell me how to verify what version of Access I am working with?
Will Microsoft ever consider making another RAD program similar to Access that supports the .Net framework?
Just think of an IDE of a RAD program similar to Access that has a full set of toolbox items already built in .Net that supports all of the functions / options that Access currently supports in its forms, reporting etc. and have the ability to interface with all of the .Net database engines... :cool:
All of the session from PDC content is also available online to anyone, for free, for six full months. For more information, refer to this blog post http://blogs.msdn.com/mswanson/archive/2005/10/24/484434.aspx. There are a few sessions that are interesting from the Access perspective:
OFF307: “Access 12”: Developing Collaboration Solutions with “Access 12” and Windows SharePoint Services “v3” Speaker: Clint Covington – Broad overview of many new features. http://microsoft.sitestream.com/PDC05/OFF/OFF307.htm#nopreload=1&autostart=1
OFF201: “Office 12”: Introduction to the Programmable Customization Model for the “Office 12” User Experience (Part 1) Speaker: Jensen Harris – explains the philosophy behind the new UI and the ribbon changes. http://microsoft.sitestream.com/PDC05/OFF/OFF201.htm#nopreload=1&autostart=1
OFF302: “Office 12”: Developing with the Programmable Customization Model for the “Office 12” User Experience (Part 2) Speaker: Savraj Dhanjal – explains how to customize the new UI. http://microsoft.sitestream.com/PDC05/OFF/OFF302.htm#nopreload=1&autostart=1
OFF310: Windows SharePoint Services: Developing Collaboration and Tracking Applications Speaker: Mike Morton – explains many of the changes to WSS that can be used while building Access applications with WSS link tables. http://microsoft.sitestream.com/PDC05/OFF/OFF310.htm#nopreload=1&autostart=1
OFF417: Visual Studio Tools for Office “v3”: Creating Office Application Customizations Speaker: Andrew Whitechapel – details around how to develop managed task panes and addins for Office including Access http://microsoft.sitestream.com/PDC05/OFF/OFF417.htm#nopreload=1&autostart=1
OFF415: Windows SharePoint Services: Developing Custom Workflows Speakers: George Hatoun; Pravin Indurkar – details about workflow that can be used while building applications with WSS. Access will have hooks for working with WSS workflow. http://microsoft.sitestream.com/PDC05/OFF/OFF415.htm#nopreload=1&autostart=1
Last, if you don’t read the blog post, know that you can right-click on the speaker video, choose Play Speed, then Fast to watch the presentations at a higher speeds.
Enjoy!
-------------------- Clint Covington Lead Program Manager, Access Microsoft Corp.
I'm recently starting a new job and one of my tasks is to clean up their Access 2000 database. After looking through it and realizing how much crap there is in it, I was thinking about starting a new one for them from scratch. I was wondering if there are any pros/cons to redeveloping the database in 2003 verses 2000. Its a pretty small company with usually about 6 people concurrently working on it throughout the day.
We recently experienced network issues here at work. Now I need to make sure the current version of the MS Access application is running. Is there a version compare component with MS Access? Does anyone have a recommendation on software that will work well with MS Access 2003?
HI, Im new to this, so I need some help if you can on the subject of upgrading a database created using access 1.0 to the latset version of access, can this be done ? Many Thanks
I have an mde database originally created in Access 2003. Will I be able to open it in Access 2007?
(I ask because this mde file was originally created in Access 2002, and wouldn't open in A03. We had to track down the creator and get her to resend a new mde file that was 03 compatible. Are we going to run into the same problem after the next upgrade?)
I haven't used Access in a few years and am trying to replace an Excel spreadsheet with Access.One field in Excel looks at the prior record, if they are the same it doesn't update the current record. The excel command is: If($Y3 = $Y2, 0, sumif($y:$Y, $Y3, G:G)). Is there any easy way to do this with a query?
Hi, My database consists of some personal data and a photo of each person. I am trying to include these photos when I browse the database via ADP. I have found instructions how to do so at Microsoft website (article ID: 285820) Link for it: http://support.microsoft.com/?kbid=285820 The problem is I cannot make it !!!!!!!! Where exactly should I paste the VBscript in the page code to execute displaying of the photos??????? I am happy to send you the head portion of my page code if anybody knows where to paste it.....
I have a date field on one of my forms that gets populated automatically when a new record is created. I also have a subform on the form that lists the tasks that still need to be accomplished this month. Some problems have popped up as people got new computers with new versions of Access:
Access 2002(10.6501.6825) SP3 - No problems. Access 2002(10.6771.6817) SP3 - The Date field isn't recognised on a new record (#Name?), but it's fine on the old records (displays date). Access 2002(10.6771.6825) SP3 - The reminder subform is blank (white), as if it doesn't exist, but the date field works fine.
Any ideas why this might be/how to fix?
Thanks! This is really frustrating. If it didn't work for anyone, I would find a way to fix it, but because it works for some people, I don't know what to fix...
I have developed an application and packed it into a runtime version. However, in the runtime version the shortcut menus do not work. The reason why I want the user to have that possibility is that the application has two hyperlink fields and it is much easier for the users to be able to browse to the documents instead of typing each link with all the errors that might give as well. Any help would be appreciated.
I have a table with one field and 83 records. I need to transpose this one column to 83 columns, so I would have a table with 83 columns and one row…. Is there any way to do this? Appreciate Maryam
Is it possible to transpose the subform data set. I have a subform which lists alleles. There are a variable number of alleles in the subform, which is linked to a second subform. Each allele has a size and a frequency.
It is listed in a tabular format, but the default is top to bottom layout. Is there anyway to display this left to right?
I have a table with one Field and 83 records. I need to transpose this one column to 83 columns, so I would have a table with 83 columns and one row…. Is there any way to do this? Appreciate Maryam
