Hi,
I created a sub-form using the wizard; however, I can't get it to view as Calumnar even when I move its text boxes about and change their order. When I run it, it always show as a datasheet!
Any suggestions will be very much appreciated.
Bee
Ive been using the form wizard, with columnar but I find it squishes up some of the words, and doesnt use the whole screen width, is there a way I can change this? and is there anywhere that you can download more styles?
Any thoughts would be awesome.
Cheers Ezy
ok, i have a few design requirements and am unsure as the best way to approach the situation..
here is the basic layout of my tables..
http://www.londonheathrowcars.com/bait1.jpg
i will basically need a form with the following layout
http://www.londonheathrowcars.com/bait.jpg
you enter the date at the top of the form.. and then all the records you enter will use that value as the job date..
also.. the customer name and number will need to be entered in this form.. and the customer id will have to be registered to the job in the job table..
can anyone suggest where i should start with regards to creating a subform.. a query.. etc??
when a record is open in my form, i want a button that says.. send email confirmation..
this will then transfer particular fields to an email template and send the email
how can i begin to understand how to make this work
How to hide the layout of subform in main form?
View 3 Replies View Relatedok, someone please clarify this for me..
i know about normalisation and data redundancy..
therefore i will lay out my database like so..
job id
job date
job time
job id
driver id
driver id
driver name
driver phone
job id
payment id
price
etc...
this is all fine..
in the most straightforward situation, you create a form based on a table...
now if i create a query with fields from all the tables.. eg..
job date, job time, driver name, price
if i create a form in the basic way, you cannot add fields from several tables (in the direct sense i mean, forgettin the use of subforms.. etc)
if i create a form based on the query, will this allow me to add as many fields, and most importantly from as many tables, as i wish.. choosing only the relevant ones for that particular form..
will everthing automatically link with the job id if my user fills in this form..
if this is the case then i can see my self making one large query.. with all the relevant job details, and then using a tabbed form to separate them.. is this a common practice.. is this the correct way to go about things?
Export Query Data with Formatting and Layout Using A Button On Form Before Or After DoCmd.TransferSpreadsheet
View 4 Replies View RelatedI seem to be having an issue with a split form I've been working on. I created this split form on Monday and it was working just fine but today, I have added a couple minor text boxes. Since then, I can view the form contents in Design View but when I switch to "Form View" or "Layout View", it's all gone minus the logo in the top left corner and the title for the split form.
View 12 Replies View RelatedHow to hide the layout of subform in Main form?
View 5 Replies View RelatedHow can I see what they will finally look like while I am formatting them? All the views on offer (form/layout/design) are all displays within the the context of the access programing screens, with other windows and menus and ribbons etc. I want to see how it will look full screen. I know I can change a lot of options, change to the form as a default to open with, resave, reopen and then reverse it all but that's not really any good for doing every time you make a minor change.
View 14 Replies View RelatedI have made an unbound check box, named "myckeck" in a form which shows data from a table in tabular layout.
1- When I check one check box, all check boxes are checked. How can I solve that? I mean I want to check or clear check boxes independently.
2- I made a text box, named "jobdate" to sow todays date automatically upon checking a check box.
Code:
Private sub mycheck_afterupdate()
jobdate = date
End
But this is not working and checking a check box does not make anything to happen.
3- Then I made this expression in the default value of "jobdate" properties:
iif( mycheck = true, date(), null)
This not working either.
My form was working fine but when I added an extra tab it started showing as completely blank in design view. When I deleted the tab I had added I still was left with the same problem!
I've attached an image of the form properties. I want to use the form to enter data so it needs to show even if there are no records.
I had read that it could be if there is no data but typing data in the tables hasn't worked either.
I have subforms that are datasheet view, if the user rearranges the coloumns, or resizes etc , I would like to save what they have done so it is as they left it next time they open up the screen.
This works fine with an mdb (all my forms are set to close acsaveNo).
However in an mde this doesn't work.
Can I get this to happen in and mde.
(A button that saves a layout change would be fine for my purpose)
Thanks
Paul
Hello Everyone,
I'm pulling my hair off with this situation. I have an excel file that was given to us by the payroll department of our company, but my manager doesn't like the layout in which was given to us. I've attached a sample of the file, the file has two sheets the first one is how the original file looks like and the second sheet "final look" is how my manager want the file to look.The original file is pretty big, it's for 33 different employees and it contains 93,500 rows. I think it will take forever to do this manually, any ideas would be really appreciated.
Thanks,
Pablo
I had a couple of forms go corrupt in one of my databases this morning, which has around 50 or so tables in it. I repaired the database by creating a new db then importing all the db objects from the original and the 2 corrupted forms from yesterday's backup.
However, the relationships table is now a disorganized mess. Is there some way to import the layout of the relationships table from the original db or am I stuck with manually re-arranging?
Hi all,
How should I do if I want to display my records in Report by 3col x 5row instead of 1col x 15row.
I have an issue with a database layout and I am not sure which is the best way to proceed.
The problem is in an invoice part of a db . When a service is delivered, say 2 hours of a technicians time, it has to be assigned to a particular tech. No problem when there is only one tech however there could be two or more techs who have helped to supply this particular service and the time ( and income) needs to be divided up between them. However the invoice can only show one item the ie total time taken to deliver the service ( quite likely to be a fixed cost for a particular service ).
Possibilties I have considered are: to have a number of fields in the invoice detail table , one for each tech, however I would have to assume a maximum number of possible techs per job and also there would be a lot of redundant fields and trying to analyse how many hours each has worked would be painful.
Each tech could be assigned a code ( single number or letter ) and these could be stored in a single field . The code would then have to be manipulated to work out how many techs worked on each item and how much each had worked. Again this is rather messy.
I think the ideal would be for each tech to have their own table where each time an service was invoiced which they helped delivered the appropiate percentage is assigned but I cant quite see how to do this.
Any ideas or examples gratefully recieved
17099Good Morning
I was wondering if someone can please assist/advice. I am currently a bit stuck and feeling like I am walking into a dead end the whole time.
I am currently creating a DB with the purpose of Capturing Potential Candidates provide them with an ID. Fill in their basic details Name Surname, submit to a report, which I will then export, email to them, they will fill in the outstanding information requested, send it back and will import it back into the DB with my various queries to run searches on candidates for placements.
My only problem is that I have quite a lot of fields...
So I Decided to Create 4 Tables
In each table I am using the same ID for a person so should be a 1 to 1 Relationship.
1 General Information
2 Info Relating to Skill
3 Work History
4 Qualifications.
I have all of these separate tables due to the fact that with all the records in one i exceed my 255 table fields allowed
But then if I decide to create a query so I can run some of the details i get errors because there are to many fields. Even if i run one on the other. My last one will still have to many fields.
Basically I am hoping someone can just assist in what would be the best way for me to lay out my tables. And what would be the best to link these tables.
Is it better to have all the records horizontally, or as a one to many with duplicates.
Please find attached a copy of the tables. I would really appreciate any advice
Regards
Is there a way of putting the checkbox to the right of the text other than dragging it over?
View 1 Replies View RelatedI have this very important question, I dont know how to do it but I am sure Access support this and it is doable.
I have the following recorset:
Name LeaveType LeaveDate LeaveYear
Frank Annual 25/06/2007 2007
Frank Annual 30/04/2007 2007
Frank Unpaid 11/09/2004 2004
James Unpaid 04/03/2006 2006
James Unpaid 19/09/2006 2006
Meco Paternity 17/12/2004 2004
Meco Paternity 18/12/2004 2004
Meco Annual 02/07/2006 2006
Paolo Annual 25/06/2007 2007
Paolo Annual 12/06/2007 2007
Paolo Annual 24/06/2004 2004
I want the data to be shown in a report as follow:
Name: Frank
Leave Type200720062004
Annual200
Unpaid001
Paternity 000
Name: James
Leave Type200720062004
Annual000
Unpaid020
Paternity 000
Name: Meco
Leave Type200720062004
Annual010
Unpaid000
Paternity 002
Name: Paolo
Leave Type200720062004
Annual201
Unpaid000
Paternity 000
I WILL HIGHLY APPRECIATE IF SOME ONE HELP ME DO THIS VERY IMPORTANT TASK.
REGARDS,
I am working on a complex database to store Business information as well as specific into about that Business... here is the tricky part...
The individual companies are sorted by Business type (i.e. Computer Software Companies, Child Care Providers, Commercial Building Contractors, etc.) and each Business type needs to hold a simi-customized set of information (i.e. Commercial Building Contractors needs Total AZ Billings for Commercial Bldg., $ Awarded for Completed Contracts, % of Work Subcontracted, No. of Local Employees, and Areas of Specialty). I will refer to each type of information as a Category. Each Business Type has between 4 and 7 Categories. Within a Business Type there are between 10 and 30 companies listed. There will be just over 200 Business Types listed within my database structure, as well as around 100 unique types of Categories.
Primarily, I need to be able to query and format each Business Type, to include the Companies information as well as each Category that is associated with the Business in a flat spreadsheet style layout.
Now, I intend to create a unique report (if needed) for each Business Type as needed to customize the look (i.e. column widths and any other special formatting needed) of each Business Type,
Here is where I stand currently with this project…
I have 4 tables,
1. Business (it includes basic contact info that is common to all business)
2. Category (is basically a list of all possible categories)
3. BusinessCategory (a Many-to-Many relationship container that links the BusinessID to the CategoryID and includes the corresponding Value)
4. BusinessType (a list of business types that a business can belong to)
This structure seems to work in that it can handle the customization of categories for each Business within a BusinessType. The problem I am running into with this structure is creating a query to handle the data and create a “flat” table for a BusinessType with each Business and it’s categories.
It may be that I can use this structure to do what I need done, however I think that there must be a better way to structure my data to work the way I need it to work. I really appreciate your input on this!
I have designed a few databases for my work. I have been recently assigned a new one that has me a little stumped. I am looking for some suggestions as to how to go about this.
Essentially, we have a training department that does training in the various aspects of the job. In the various classes, the "students" take a midterm exam to gauge the level of retention of the training midpoint in the class. Then at the end of the class, they need to take a final exam.
My department director would like the "students" to be able to take the exams using Access, since 99% of the questions are either multiple choice, yes/no, true/false, or fill in the blank, and Access would be able to "auto-grade" the tests, essentially.
I am at a loss, basically, as to the layout. The "student" information table would be the easy part. I am unsure of how to create the tables that would have the questions, depending on the class and whether it is a midterm or final, with the answer choices attached.
Any suggestions?
Hello everyone.
Im just wondering if anyone can find any problems with my table layouts or relationships are anything else?
The ER-D can be found here:
(URL address blocked: See forum rules)=17320&d=1178117475
Thanks, Ant...
Views show design view, datasheet view, pivot table view, and pivot chart view. Where did layout view go, and how do I replace it?
View 3 Replies View RelatedHey all.. Been out of the Access loop for quite some time now.. Last project I did was in Acc97, about 5 years ago! Been working on SQL Server and web programming lately...
Anyway, I have a project that needs to be done in Access XP. It is a basic resource allocation DB. Listing of employees, projects, and time associated with those projects per Employee. I want to keep this normalized, and so I have this basic table layout..
tblEmployee -- Has EmployeeID, name, etc
tblProject -- Has ProjectID, name, etc
tblEmployeeProject -- Has EmployeeID, ProjectID, year, month, hours
tblWorkingHours -- Has an autoNumber ID, Year, Month, Working Hours, Holidays, business days
Basically, the tblWorkingHours has 12 entries per year, Jan-Dec.
The tblEmployeeProject is where I have the meat of my data.. If an employee(1) is assigned to a project(123) for 20 hours a month for 3 months(Jan-Mar 2008), then there will be 3 rows in there.
EmployeeID - ProjectID - Year - Month - Hours
1 - 123 - 2008 - 1 - 20
1 - 123 - 2008 - 2 - 20
1 - 123 - 2008 - 3 - 20
This seems to make sense to me, and seems to be normalized. However, I cannot seem to create an updatable query on this layout... I would like to pick a project, and then a few employees assigned to that project, and then enter in the hours for each employee, for any of the 12 months I need. The problem I'm having is that I cannot seem to get an updatable query out of this layout. The only way for me to get a listing of all employees attached to a project, and then all months for the year, regardless of an entry in tblEmployeeProject, is to use a Cartesian Product type join on tblEmployee and tblWorkingHours. And then do an outside join on tblEmployeeProject. However this is obviously not updatable.
The only other option I can think of, is to prefill the tblWorkingHours table with 12 entries per year, however this seems to add unnecessary data in the database. At that point, I might as well create a table that has 12 columns, one for each month.
Sorry for the long-winded post, but wanted to try to get all my points across. Any help would be greatly appreciated! Thanks all.
Hi there,
I have a warehouse table that lists a stock code with the last 12 periords closing balances in a record.
I would like to write a query that just shows each stock code with only one month per record and has the openning and closing balance for that month.(the closing balance of one period is the openning balance of the next period).
So the Table currently looks like this
StkCode....Whouse....12.....11......10.....09..... .08.....07
1111.........TZ..........100....200....300...400.. ...500...600
I would like it like:
StkCode....Whouse....Period....open....close
1111.........TZ..........12.........200.....100
1111.........TZ..........11.........300.....200
1111.........TZ..........10.........400.....300
1111.........TZ..........09.........500.....400
1111.........TZ..........08.........600.....500
I haven't worked with access for years and can see how to do this in my head - i just can't figure out what to write. Any help would be greatly appreciated.