Void Of Ideas?
Dec 9, 2004
I have decided to amend a database because my original design was rubbish!!
Why? Currenlty a user selects a ServiceID from a combo:
SELECT tblServices.ServiceID, [ServiceCategory] & "-" & [VehicleType] & "-" & [ServiceType] AS Expr1 FROM tblServices ORDER BY [ServiceCategory] & "-" & [VehicleType] & "-" & [ServiceType];
That produces:
Car-Larger-Wash
I have added a new table to the DB to list car makes and models.
The user will select a car make and model from one field (combo) on a service form.
From the next field they will selct the service to be performed on the selected vehicle i.e. Wash / Vacum / Full Valet
My dilema? I can not think of a relationship for the new table 'tblVehicles'?
Any suggestions?
Should I add a new field to tblServices?
Cheers,
Phil.
View Replies
ADVERTISEMENT
Mar 27, 2008
Situation
My database stores course information for faculty in my department and prints out various reports based on that information.
The 2 mandatory fields in the form are [AcademicYear] and as they create the potential for classes to be added to the curriculum.
Question
Is there a way to add multiple records to the db based on the which year and instructor combinations were use prior?
[I]ex.
2007/2008, prof-a
2007/2008, prof-b
2007/2008, prof-c
2007/2008, prof-d
This represents the 2007/2008 school year where professors a through d taught courses. Is there a way to add records for another academic year so that:
2008/2009, prof-a
2008/2009, prof-b
2008/2009, prof-c
2008/2009, prof-d
appear with just the press of a button?
I don't know if I'm being clear enough. :p
View 1 Replies
View Related
Jul 22, 2005
I need some ideas on this new database that I am creating. I'm creating a database that will store employees clock in and clock out times on a weekly basis. The main table has the following fields: ID, employee name, date, clock in time, clock out time. The employee name field source is another table that has the list of all the employees names.
I need to create a form that will allow the user to easily input the clock in an out times during a week for each employee. The user will pick the employee name from a combo box. Then, on this form, I want it to have all the days of the week (sunday thru saturday) in a column format and in front of each day one field for the date and two fields for the user to input the clock in and out times respectively.
The problem that I am having with this right now is that, the form that I created only displays one record at a time, so it only shows the clock in and out times for one record. How can I get the form to diplay several records at a time so the user can add all the days of the week for certain employee on the same page?
Or is there a better idea on how to create this database?
Thanks in advance,
Earl
View 10 Replies
View Related
Jul 13, 2006
i have get data from the sources i dont know yet but i can either import or link using access and create reports that way and or juts use crystal to connect to the data sources...any ideas?
View 1 Replies
View Related
Jul 18, 2007
Hello everyone.
I have just made up a database for work, it is a basic stores system where people have to book in and out the items to update the quantities manualy. I have a tick box for "on demand" which i have linked to a query for all items on demand etc.
I am just wondering if anyone can suggest any good ideas that would make the database even better, more automatic type things would be good.
We have a demands for which is just a word document I was wondering if there was anyway I could use it someway so that with one click the items that requiring demanding are put onto the form?
i am just looking for any ideas that would turn my database from good to great.
I hope that you can help
View 5 Replies
View Related
Mar 25, 2008
Hello all, glad to be here
I wanted to bounce this idea off the members in the forum, its more along the lines of managing multiple databases rather than individual design.
I am a recent incumbent at a position where there are many individual access database files for the department. (Each DB is unique as are the users, usually) I am trying to flesh out ideas on how to consolidate these access files, so there is one central 'hub', where users could log on, and then select the study or project associated with that particular database, and then the DB be opened for them to begin working, rather than the current system, in which there is a rabble of access mdb files in multiple folders
any ideas are appreciated :D
View 9 Replies
View Related
Dec 28, 2006
It's been a LONG time since I've designed a database, but it's slowly coming back to me. However, I'm still having a very difficult time deciding the most effective way to setup my tables and queries. Here's what's going on.
The database will be used for FFA livestock shows to enter the exhibitors for market classes and showmanship classes. The database also needs to be able to break a pay scale down showing how much each exhibitor is awarded for their showmanship class and their market class. The database that the club had been using had 2 tables (1 for the exhibitor and 1 for the animals being shown). Then they had 10 different queries that sorted the animals into weight groups (ex. Class 1 is weight between 90lbs and 100lbs); and then they had 10 different queries to breakdown the showmanship classes (ex. Showmanship Class is is age between 5 and 7). This is a LOT of queries! Now, the manager wants to be able to have more than 10 classes, which their current database cannot do. He also likes to be able to enter the parameters to manually break the classes. As of now, he is manually going into each query and editing the criteria for each class, but he wants to be able to do that from a form.
So my question is.... is it best to leave this in the "multi-query" form, or is there some way I could arrange all of this from tables or from a couple queries... and also, what would be the best way to offer the option to add a new class?
Any and ALL advice is greatly appreciated!
~ Audrey
View 10 Replies
View Related
Feb 22, 2005
I am trying to find the best way to program a timeshare inventory. Here is the problem, one unit has the possibility of being sold annually, odd or even years. If the unit is sold for just even or odd, I then need the open inventory to reflect the opposite year that is available. If the unit is sold annually I need it to be removed from open inventory totally. Also, If the unit is returned I need it to show-up back in open inventory.
Does anyone have any ideas of how to make this work simply?
View 1 Replies
View Related
May 11, 2005
last ever question, i need a long hloiday
it errors on: theId = ctl.Column(0, v)
Private Sub Monthly_MD_Report_Click()
'Run a report displaying only the records chosen
'by the user in the form's listbox.
Dim v As Variant
Dim Frm As Form
Dim ctl As Control
Dim theId As Long
Dim WhereCrit As String
'If nothing is selected, notify user...
If Me.List101.ItemsSelected.Count = 0 Then
MsgBox "Please select a month.", vbExclamation, "No Month Selected"
'and then scram.
Exit Sub
End If
'Assign form and control to object variables.
Set Frm = Forms!FrmForm
Set ctl = Frm!List101
'Begin building Where string.
WhereCrit = "Expr2"
'Add each selected item to the WHERE string.
For Each v In ctl.ItemsSelected
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
'The first column in the list, holding SupplierID, is hidden.
'See the list's "Column Widths" and "Column Count" properties in
'its property dialog and look up the terms in Help for more info.
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~
'Coordinates: 1st column (0); row v
'where v changes for each round of the loop.
theId = ctl.Column(0, v)
'Tag on to string.
WhereCrit = WhereCrit & theId & " OR Expr2 "
Next v
'Loop ends; selected items are now accounted for...
'NOTE: To better understand what the code is doing, uncomment the
'next line to print the Where string to the Immediate window.
'Debug.Print WhereCrit
'Clean-up the Where string by removing the trailing text.
WhereCrit = Left(WhereCrit, Len(WhereCrit) - 17)
'Test (see note a few lines above).
'Debug.Print WhereCrit
'By default, the Suppliers Report returns all records from the Suppliers Table.
'Here the Suppliers Report is opened using the 'Where clause' to filter it down
'to only the items selected in the listbox.
DoCmd.OpenReport "MD Form", acViewPreview, , WhereCrit
End Sub
View 4 Replies
View Related
Jun 6, 2005
Hi im in the process of starting a small project to be used at work. Basically I want an Access DB which will be used by about a dozen people, accessing it over a network drive. I want them to be able to do the standard create/edit/delete records and wotnot in different tables of the DB and also want some reports and search functions.
In the future I want room to make more advanced things in it.
Would I be best to do this all in Access with forms and reports, or maybe use VB for a frontend or even something else?
Dont have much experience with Access outside of the standard DB records stuff, will security and multi access be a problem with Access?
cheers
View 1 Replies
View Related
Feb 5, 2007
I want to pick everyone's brain on this one, because I'm not sure what I want to do can be done very easily.
I have a database that tracks client information for insurance policies. I'm going to be giving it to other agents, many who are very computer illiterate. One of the requested functions is for them to be able to create form letters from the database.
So, I'd like some ideas on how to do that. Ideally, I'd like for there to be a form that someone could load some letter templates, but also tweak them or even create new ones that can be saved. It would also need to have "merge fields" much like you would in Microsoft Word. Basically since every agent will want to have their own letters, it needs to be easily editable.
Is there an easy way for a computer illiterate person to just select "interest letter," change some wording, and have it merge into a report? Or, is there an easy way for someone to get access to the merge fields if they were to do a Word mail merge? I don't really want people trying to find the right tables/queries amidst all the different tables in the database.
Or, throw out some other ideas. I'm open for most anything. Thanks in advance.
View 4 Replies
View Related
Jul 30, 2007
Hi, ive been asked to provide a solution, for an electronic spreadsheet be sent out via email then returned by customers, once filled in for all the data to be collected onto one sheet that looks like the attached sheet. the easiset way i can see is to not use a spreadsheet but to use a datbase instead and just put it in the desired format, how easy is it to import mutliple spreasheets into correct fields on a dbtable thanks for any input or ideas
Al
View 3 Replies
View Related
Mar 23, 2006
Firstly can i say Hi to everyone on this board amazing I registered today because it took this board 3 search to answer a problem Iv had for 2days now. So big thank you !!
No then Im creating a small website where members are capable of booking the Venue via the website. At the moment my databse consists of
Members_tb with attributes
Member_Id (Primary Key)
USer_Name
Password
Frist_Name
Surname
Address
Email
I am hoping someone from this board can help me by shedding some light as to how they would go about empowering a Member to book the venue for a particular date also taking into note not to book for a date the venue is already booked for.
Any help at all will be so much help. Im just confused as to how i should tackle this issue
View 1 Replies
View Related
Mar 24, 2006
I'm running Access 2000 through Citrix, 20 users internationally from 1 db. I'm working through Citrix network issues to split db with separate FE's for each user.
I have sporadic corruption due to this. But this morning I met a new breed of corruption. I preface this with the fact that I run a bat file nightly to do clean up and compact and repair the db. It verifies the db is not in use prior to running.
This morning we were presented with a hosed db.
The log file said updates ran fine.
In my main table the first record was garbage, including the Auto-num field. I found that my Primary key has lost it's index and references had become unchecked.
Correcting these issues got it running but does anyone have any clue what might have triggered this or even where I should start looking? Please help as I am at a loss.
Thanks.
View 2 Replies
View Related
Jan 18, 2008
Hello Everyone.
I am looking for a good idea; maybe it's just Friday syndrome but I just can't seem to get my brain to wrap around this problem!
Let me start by trying to explain what is happening here. I have a repair shop that works off of quotas. This was a recent change to the way we've always done business so I had to adapt our DB to track this information. I built a table, keyed off product#, and added 12 columns for each month's quota. These quotas are determined about mid-month (I just received Feb08's today).
Up to now, we have always taken this month's quota information and compaired it with our production table, showed just where we were at on all of the products. This worked great. (THANKS boblarson! {http://www.access-programmers.co.uk/forums/showthread.php?t=141418} )
So, now that I have next month's quotas, Mgmt is telling me that everything we produce now will count for next month's quota. Not a big deal, but trying to get my head around how to actually 'track' this is giving me the headaches! We thought doing a 'running' total would work, but things just are not adding up right.
The problem as I am seeing it is that I need to somehow take my current and next month quota but compair that with this month and last month production isn't going to give me accurate results. Not until next month. Once Feb comes around, things will be okay; but then mid-Feb when the quotas come out for March I'll be back in the same boat.
I'm betting that there is a easy solution to this; but like I said, I'm definatly having a Friday Moment here. Anyone have any ideas?
THANKS
AC
View 1 Replies
View Related
Jun 16, 2005
I have a database containing various linked tables and all has been fine for years.
I now have to add some fields to the main table and change some field sizes. I know about the 255 field limit. And I know that an individual record cannot exceed 2K.
BUT, when I simply lower the size of a text field, (i.e., from 40 to 30), I get either the message Too Many Fields Defined or Record Is Too Large.
View 6 Replies
View Related
Nov 6, 2007
I've completed the Relationships on my online store project database and put the tables into a word doc so everyone can view
Does everyone think they look ok? If not, all opinions are welcome!
I've also 2 questions:
1) Should I create a seperate table for Usernames & Passwords?
2) Should I make the CD, DVD & Games table in a single table?
View 5 Replies
View Related
Jul 8, 2005
I'm in the process of recreating a contact manager for a group of salespeople at an office I work for... What I want to do is be able to consolidate all of the contacts in a single contact database on the back end. Then the records will have specific users specified to each record, and what I want to happen is that the users will open up their own database, and they will only see the records pertaining to them, and they can't change who gets the records.
Here's where it starts getting tricky. I want the manager to have access to all of the records, and I want him to select which user's contact list he wants, and it brings up those contacts. I want him to have a combo list on the screen where he can select who gets which contacts, and he can change them throughout the different users.
Related to each of these contacts is a subform, called CALLS... When this button is clicked, any information regarding past calls is brought up, and the user can add information about a call that is made. This checks the previous form that is open to find out the ContactID so that it can open up the corresponding CALLS entries in the CALLS table.
Here's what I did: I created a new contacts form for each salesperson (there are 5 salespeople). Then I had to create a new subform for each salesperson for the CALLS, and then the information will be gathered from the proper subform to the users contact form.
I can do all of the above, but it seems kind of redundant to do this for all of the users, and I'm wondering if there is an easier way to do this. Also, in the future if more salespeople are added and I'm not here for the company to set up the new users, I would like to see if there is an easy way for them to set it up (like adding a new value to a few different spots)...
BTW: One difficulty is that they are already using a previous contact manager (not designed by me) that has hundreds of contacts, but each user has their own separate copy of the contact manager which is just copied and pasted onto their local drive when a new salesperson arrives. I will also need to import all of their previous contacts, and I would like to maintain as much of the original structure as possible to avoid dealing with user compatibility problems.
If you need to see the contact managers, please let me know. Any questions, i will be glad to discuss. Thanks.
View 4 Replies
View Related
Feb 15, 2006
Hi,
I've been using excel to keep record uptodate, but i've got more than 300 people to keep track of, so using excel can limit my db.
i'm new to access, wondering if I can get you advice:
Senario:
A community temple, which i'm a member of, spend alot of time loggin who is donating and how much, with pen and paper - then update the excel spreadsheet i've done for them, don't ask me why they do it, its sort of a tradition. Evenone pays about £5 per family, 1 pound for each person.
I was thinking if each familly had a reference number, everytime they donate, they'd give there reference number and the database automatically updates with new records.
So if Mr simpson , ref 69, pays £6, the database adds 6 new records; Granpa, Homer, Marge, Bart, Lisa and Maggie.
how difficult is this to do?
whats best way to design the tables?
Any help is much appreciated.
View 2 Replies
View Related
Jan 15, 2007
Hello.
I have a fairly complex database with a lot of charts, reports, forms etc.
My problem is that whenever someone chooses to maximize a Pivotchart, a report preview or other things, they usually click the big X button in the top right hand corner and close Access entirely. They don't think to click the smaller x button right below it.
This is frustrating when they just want to go back to the switchboard to performs some other task. They have to restart the database, log in...etc.
I know you can prevent forms and whatnot from being maximized, but I do want them to have that feature for a number of reasons... especially with my Pivotcharts. They are much clearer when expanded to full-size.
Is there a solution to this problem, or do my users just have to be more careful?
Thanks in advance
View 14 Replies
View Related
Apr 13, 2005
I would like to have a combo box that doesn't show the drop-down arrow when the user selects it. You say, doesn't that defeat the purpose of the combo box?
Well, look. In a form I have a datasheet (in a subform) that only displays data, so it is locked from editing. Within the datasheet is a field that contains a combo box with a row source from a linked table, and the control source of that combo box is the primary key. Essentially I'm utilizing the combo box because it is smart, and allows me to display linked data: this combo box contains two columns, and I set the first column's width to "0" so that it would only display the field I want. I didn't use a subform because, in datasheet view, subform fields are not displayed in the linear fashion I need, but instead go hide under the "+" button for each record.
So, even though everything is locked from editing, the combo box arrow still appears when the user clicks on the combo box field, and I don't want it to. It's just misleading to the user. Anyone know how to disable the arrows? Or, if you catch my drift, do you know of another simple solution?
I'm not a keen programmer in case you couldn't figure that out. If you've got any VB tips then let me know.
View 7 Replies
View Related
Jul 22, 2007
I have a form in continuous forms mode...
Each entry is something the user is supposed to check on once and hour and update.
I have a "Last updated" field.
Now() goes into that field every time the record is updated.
I have a querry that will show the users records that are over an hour old.
How can I get Access to pop-up a window or something to alert the user they need to look at something? It would be really nice if Aspect would start blinking in the task bar or something.
Thanks!
View 5 Replies
View Related
