Form Design Questions
Jul 25, 2005
I have attached a copy of an excel sheet that my company has been using since the ice age. I would like to set up an access db, so as to eliminate the multiple files and make it easier to create new orders, rather that saving as a new file name all the time. However, does anyone have an idea of how I could use this same format for order entry? I need to ease our sales staff into this new idea and don't really want to disturb the form they have been using forever.
Thanks for any and all suggestions,
Chad
View Replies
ADVERTISEMENT
May 24, 2007
I am trying to build a db for the office I work at. And I have a few questions about how I should design it.
1. My vendor number should be an autonumber, but it has a relationship to the vendor name on a report. I cant create a relationship btwn text and autonumber.
2. Right now I have 3 main tables. Vendor, builder, and job. All of this is for the marketing aspect of the business. But I want to include other aspects, like collections and payroll. Should I add columns to the jobs table, or create a new table? For example, on the jobs table, I already have job info like details on the job and who referred it to us. Should I add invoiced amount, amount collected, etc., or create a table called collections to store all of this info? Im really confused about this.
View 4 Replies
View Related
Apr 20, 2005
I'm having design questions for complicated business logic. I have 4 tables, Author, Plan, Analysis, and Report. 1 or many authors can write 0, 1 or many
Plans, Analysis or Reports. And a Plan, Analysis and Report (all 3) can all have a 1 or many authors associated with it. So thats the first many-to-many. To make things worst, a Plan, Analysis, or Report can have 0, 1, or many Plan, Analysis, or Reports associated with it. In other words, a Plan be associated with a 0, 1 or many Analysis or Reports. An Analysis can be associated with 0, 1 or many Plans or Reports. A Report can be associated with 0, 1 or many Plans or Analysis. So I have 4 entities with all many-manys between them.
So by following traditional rules I would have 4 tables with 6 linking tables (author to plan, author to analysis, author to report, plan to analysis, analysis to report, plan to report). Is there a way to combine multiple linking tables into one or two linking tables shared between the 4 tables. Say one linking table between from author to plan, analysis and report and another linking table between plan, analysis and report? Any clarification would be greatly appreciated. If I had schema view like in access that would give me so much help. Thanks in advance!
View 1 Replies
View Related
Jul 30, 2007
Hi,
New to forum. Beginner/Intermediate Access Experience.
Here is what I am trying to accomplish:
The database i am creating will basically need to have a user check-off a list of Fire Extinguishers that he has checked, on a monthly basis. For example, the user will enter a date, and then a form with a list of all the extinguishers will pop up, and he will place a check mark by each one. When he enters the check mark, that date will be stored so that we have a history of when each extinguisher was checked and by whom (using initials or something)
Currently, my design is simple, something like this:
tblUser
pkUserTableID
fldUserName
fldUserInitial
fldINSPECTIONDATE
tblExtinguisher
pkExtinguisherID
fldExtinguisherNumber
fldExtinguisherManufacturer
fldExtinguisherType
fkUserTableID
My question is this:
-Am I going down the right track with the 2 tables?
-Do I need a third table to Store the Historical Data?
-I am not quite sure how to layout the form so that all the extinguishers are listed.
I know these questions may seem vague, but any help would by highly appreciated.
thank you.
View 4 Replies
View Related
Mar 5, 2008
hi everyone,
as a network engineer, it administrator, etc etc people expect to know absolutely everything about pc's. so here i am.....
a company whose network i look after are using excel spreadsheets on a weekly basis to take orders, wages, running costs etc from their remote sites (currently about 20 sites)
the spreadsheets are accessed via terminal services and are moved via a script at the end of the week so the remote site doesn't have access to the old records and replaced by a new sheet. so lots of spreadsheets floating about.
you can imagine how hard it is to pull past records & compare etc.
now, i'm new to databases and have order a book to gen up on the subject. the sites should only be able to edit the last 7 days of records but be able to see the last years. i can see how a query and subforms can achieve this etc.
each site shouldn't be able to see the other site's records and the head office should be able to run reports etc on each site or as a whole.
i can narrow the time down that everybody is accessing the data. the sites may grow to 50+ but the head office is unlikely to have more than 5 people access the dabase at the same time.
my question is..... (access 2007.... can't see any user security).....
am i better to do an individual database (all exactly the same apart from name, titles etc) for each site that sits in their individual folders via terminal services? then let the head office access each seperate database via linked tables?
my thinking for the above way was security (they can't see each other) and resilience (1 database gets corrupted, the others are still workable) and speed (only a few users accessing each database)
the downsides are obviously the amount of files although this is nothing compared to the excel files at the moment.
any ideas or help would be appreciated.
thanks
louis
View 3 Replies
View Related
Oct 18, 2005
Hi All,
I have finished up a database that I will be using to store code snippets. But I have a couple of nagging questions that have been bothering me.
http://img63.imageshack.us/img63/7752/untitled1cg.jpg
In the right hand portion of my dialog I use a subform to display key words for the code. Is there a way to turn off the column and row headers for the form? Also is there a way to have a transparent background for the subform?
In order to add key words I need to open up another form, enter the words there, close that form and then select them from this dialog. It would be nice to be able to add keywords from this form. FYI, there is a many to many relationship between the key words and the code.
Is there a way to show just my dialog when the database is opened and not the rest of the Access application space? I have unchecked everything in the startup options already.
The last thing is I would love to be able to format the code section so that certain pieces of text are formatted. I am going to start messing around with the some of the free rich text controls but is there an out of the box solution that can handle this task? I was thinking about formatting the code in html and then displaying the html. Is this possible from within Access?
Thanks all,
Steve
View 3 Replies
View Related
Sep 27, 2005
1) HOw can I move a record from one talbe to another when a specific drop-down option is selected. Example: a combo box with "Active"; "Pending"; "Closed" I want all closed recoreds in a table just for closed records to reduce clutter. They're not going to be referenced often if ever, we just want them so we have them if we do need them.
2) How can I prevent changes to the design of a form/query/report/etc.
View 3 Replies
View Related
Dec 21, 2004
I have a form that I am working on. I have enabled queries to be run by selecting on command buttons. All of my queries have a year field. I want the user to enter the year in a text box and then run the queries based on the selected year. I do not want any of the data in the queries to update except for the year field. I am not sure how to link the text box that I put on my form to my queries and get everything to update correctly.
If anyone could give me advise I would appreciate it.
View 1 Replies
View Related
Feb 9, 2005
I am trying to figure out how to count the number of Yes's and No's on one record to produce a score. There are 39 total questions and each question gives the user a choice of Yes, No, or N/A. Each record will need to have a score attached to it. I appreciate all the help I can get.
View 7 Replies
View Related
Jun 28, 2005
Hi,
On a continuous form, i have discovered how to enable/disable fields by checking/unchecking a box, but is there a way of enabling/disabling the fields for only the relevant record and not for all records?
Also in a continuous form, i would like no further record additions after the first record until a button is clicked on. Is this possible?
Mant thanks, in advance.
Lampy
View 3 Replies
View Related
Mar 30, 2006
Hi all, i got a problem which i hope you guys will help me on. I created several forms, the main form with command buttons that leads to other forms where users can key in their conditions for queries, i.e. parameter forms
After building the SQL string using createquerydefs
i use the code:
DoCmd.OpenQuery "Requests_open_module", acViewNormal
to open the query.
all these is assigned to a command button on click event. however when i click on the button in form view, the query result appears in a window behind the parameter form instead of on top of it.
so i tried:
DoCmd.OpenForm "weekly_open_requests_result", acFormDS, , , acFormPropertySettings, acWindowNormal
where weekly_open_requests_result is a form linked to the Requests_open_module query. And i get the same result, upon clicking, the form appears at the back instead of on top.
finally i went to the weekly_open_requests_result form and enabled popup in properties window and it worked! however...it doesnt have "File" which i need as the user upon looking at the result, needs to export it to excel.
so what is wrong here? or is there any code that i can use to make the exporting to excel automatically; i will need the form to prompt the user for a name and directory to save to.
View 1 Replies
View Related
Apr 28, 2005
First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
please advice.
thanks.
View 3 Replies
View Related
May 4, 2005
First quetion
how can i make some form to be with two frames, one is the navugation tree and the second one is a frame that is changing akk the time, which means the navigation tree is not changing ever.
i am trying to build somthing like asp with two frames and a record set and i dont know how.
the second question i have is how can i put an html frame in a form? i have some link to sme web site in my database, andd i want this data base to be open inside the form of the access and not with my browser in a new window.
please advice.
thanks.
View 1 Replies
View Related
May 26, 2006
Hi all..
I am using the following search function to search my database:
Private Sub cmdSearch2_Click()
Dim strLastName As String
Dim strSearch As String
'Check txtSearch for Null value or Nill Entry first.
If IsNull(Me![txtSearch2]) Or (Me![txtSearch2]) = "" Then
MsgBox "Please enter a value!", vbOKOnly, "Invalid Search Criterion!"
Me![txtSearch2].SetFocus
Exit Sub
End If
'Performs the search using value entered into txtSearch
'and evaluates this against values in strStudentID
DoCmd.ShowAllRecords
DoCmd.GoToControl ("LastName")
DoCmd.FindRecord Me!txtSearch2
LastName.SetFocus
strLastName = LastName.Text
txtSearch2.SetFocus
strSearch = txtSearch2.Text
'If matching record found sets focus in strStudentID and shows msgbox
'and clears search control
If strLastName = strSearch Then
'MsgBox "Match Found For: " & strSearch, , "Congratulations!"
LastName.SetFocus
'txtSearch = ""
'If value not found sets focus back to txtSearch and shows msgbox
Else
MsgBox "Match Not Found For: " & strSearch & " - Please Try
Again.", _
, "Invalid Search Criterion!"
txtSearch2.SetFocus
End If
End Sub
Which i got from here: http://www.databasedev.co.uk/text_search.html
Question #1
I have my own record counter setup at the bottom of the form via this:
Private Sub Form_Current()
'Inserts current record number and total number of records
Me.txtCurrent = Me.CurrentRecord
Me.RecordsetClone.MoveLast
Me.txtTotal = Me.RecordsetClone.RecordCount
End Sub
I would like to have this show how many searchs were found. I really don't
care about how many entries at this point... but if you do a search via
lastname for "johnson" I have 15 right now.. I would like to let the end user
know their are 15 enteries with the last name "johnson"... how can I do this
if it is possible with what I have setup..
Question #2
How do I get the search lastname field to go blank after I hit the
search button??
Thanks
R~
View 14 Replies
View Related
Apr 20, 2005
1st of all let me say hi (newbie on this forum)
2nd: i started doing access about 3 weeks ago. and 90% of my knowledge goes to this forum. ur just great guys (or woman, if any here). cograts. (well to brag a bit, i made a form, subform table on it, can use checkboxes to filter data on the table (4 checkboxes), can add open a new form and add the data while the table subform is refreshed,etc... and like i said, i got it 90% from this forum). Who's da man?? YOU ARE!
3: my problems:
a) i want to either:
- change a face (pictucture) on mouseover or onclick
- use a picture for a button and change it on mouseover or onclick
b) i want to set a default size for my forms. now the problems are:
- the unists are in centimeters (or inches). i want pixels. screensize is in pixels so it's easier to adjust the form that way. i know that if i type for ex. 400px and move away it is converted to px, but is displayed in cm. any way to use px as default display units?
- the form has the size of the whole window instead of just the grid. what's the trick? (i mean if i say 400px, the grid is 400px. but if i have a gray area 200px more (design view), then when the form is opened, it will be 600px). huh?
c) can i get rid of the scrollbars if i don't need them? and they will auto appear when needed.
Thanks for the answers. And again, even if i don't get any, this forum is by far the best. (well for access anyway ;)
d) is there a "mailto" function i can run with onclick [command button]?
Bye for now
Josh
(oh you can reply here or by mail: joshlyman_slo@yahoo.com)
View 5 Replies
View Related
Oct 6, 2014
I have had to use my first crosstab queries.
I now understand that when opening and saving crosstab queries Access (2010) runs that query to ascertain the column names. Unless you hard-code them. Running the query takes at least 20 minutes.
I have hard-coded where I can, but one report takes arbitrary dates so I can't hard-code them.
I believe that turning off AutoCorrect might make a difference to whether the query runs - but I don't want to turn it off.
View 6 Replies
View Related
Dec 27, 2014
When I'm applying a sort and filter in a form, Access is updating the Filter and Order By properties of the form, so that it is possible to re-use in conjunction with Filter on Load and Order By on Load properties. However, a consequence of this is that when the form is closed, it prompts the user whether they want to save the design of the form. I want to circumvent this as I don't want to re-use the sort and filter and I don't want to be prompted to save the design of the form.
Although I can circumvent this by closing the form using a method that doesn't prompt for saving, the additional complication here is that the form in question is in the Navigation subform of a Navigation Control. Hence when I click on a another Navigation button, it (not me) closes my current form and hence prompts me whether I want to save the design of the form (if I have been sorting and/or filtering). I can't see how to circumvent this and the prompting is resulting in unacceptable usability.
View 2 Replies
View Related
Jun 2, 2014
Basically I need to design form that looks very similar to either Split Form or Subform. I have attached a print screen of what I roughly need. The form is split into two parts. In the first/top part there are some List Box/Date fields that act as filters to the bottom form, so the bottom form displays only records that match values in red. The second part of the top form has some field that require input from user and then these records are added to the bottom form. I was trying to use both Split Form and Subform and none of it is working,I have attached an example of database and this form would be based on data from Query1.
View 5 Replies
View Related
May 18, 2007
I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout
Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line
Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)
Thanks
Rahul
View 1 Replies
View Related
Sep 21, 2005
I have set up a form that picks up reports from my database.
The structure of this form is:
Select Company Code Unbound
Select Report Drop down list of reports linked
Year and Period
*** The company code refers to 5 different company codes.
The report is then linked to a select query. Criteria has been written into company code field:
Company code
[Forms]![frmMissingClientCodes]![cmpcode]
If I select company code then a report and then type in my year and period on the form I receive a parameter box which asks me to enter company code.
Does anyone know why this is occuring and to prevent this?
Thanks
Paul
View 4 Replies
View Related
Apr 9, 2005
can somebody help with my forms please,
check them out and let me know of any improvments to be made.
PASSWORD IS THE USER NAME!!!
SAMPLE IS IN ACCESS 2002 VERSION.
Thanks
Dean
View 2 Replies
View Related
Apr 10, 2005
Just wondering if any one can help. Ive create a table of parts, and each part has a home line. Now the problem is each home line has different characheristics. So im wondering is there a piece of code that will prompt the user to enter a part number (through a query I know!) and then depending on the Line number open up a form that will have the predefined charcateristics.
View 1 Replies
View Related
Nov 14, 2005
Hi, I was wondering if I could display the information in a table in a list style on a form that wil appear at startup!
Hope you can help, Tobi ;)
View 2 Replies
View Related
Dec 29, 2004
Hi, i am hoping someone can help with designing a form for this structure or even have suggestions on changing my design. A nutritionist has 3 types of people (whom she sees seperately from one another) on a regular basis, they are clients, doctors and business contacts. She wants all 3 types of people in the database and want to track appoitnments with them. She has many doctors, clients and so forth. I created tblPerson so a person can be all 3 roles if they wanted to. I was informed that she has some doctors that are clients. But i am stuck wwith creating a form for this design. I want to be able to have a combobox so i can look up and fill the information based on my selection, but for the main table(tblPerson) i only have the name and gender, nothing else that is unique to identify a person, so i am out of luck if 2 people have the same name. As you can see the main table has an autonumber primary key the has a 1 to 1 relationship with the 3 role tables. If anyone has suggestions, let me know. Thank you very much. This is what my design looks like.
tblPerson
fldPersID, autonumber, PK
fldFirstN, text
fldMidN, text
fldLastN, text
fldGender
tblDoctors
fldPersID, Long, FK
ClinicID, FK
Specialty
Email
etc
tblClients
fldPersID, Long, FK
DOB,
MaritalStatus,
Occupation,
HomeAddress,
etc
tblContacts
fldPersID, Long, FK
BusinessAddress,
Website,
Description
etc
tblMeetings
fldMtgID, Autonumber, PK
fldMtgTime, Date/Time
fldMtgEnd, Date/Time
fldMtgLoc, text
etc.
tblAttendees
fldMtgID, Long, FK
fldPersID, Long, FK
fldReason
Joso
View 9 Replies
View Related
Mar 29, 2006
Please help me in designing my form. I have an application that I need to design the form around. i have set up my tables and relationships. I want to have a main form with subforms. I need a push in the right direction. I can't attach my app nor my db for you to view, since they are too large though.
View 5 Replies
View Related
Mar 31, 2006
Hello:
I have a main form and a large sub form that covers alot of the main form fields. My question is when I'm in design mode, the sub form blocks the fields I need to edit. I've tried setting the sub form "sent to rear" and the fields "sent to front", but this does not seem to solve the problem. So I end up dragging the sub form
off to no-mans land and then place it back. Is there way to say hide the sub form in design view and then unhide it.
Thank you
dmh
View 7 Replies
View Related
