Form Design Tips
May 18, 2006Hi,
Does anyone know of any good sites where they are tutorials etc on how to create advanced functioning forms.
regards
ADVERTISEMENT
Tips Or Hints??
Dec 6, 2005I was just wondering if any one had any tips or insider secrets on how to lower the size of a database and/or get it to run faster and more smoothly. I know you can split it but is there any other way? I'm using alot of macros and going from screen to screen there is sometimes a lag. I dont know much in the way of code but im willing to learn. Any links or advice on code how too's would be appreciated aswell...thanks alot I'd also like to say these posts have helped me a great deal and i cant wait until I am confident enough with Access to help out some other people.
Thanks again
Brad
Query Tips.
Oct 25, 2005hey,
does anyone have any links i could use to read up on queries?
im very new to Access and i want to create some basic msg boxes and commands etc...
thank you.
Kens Tips - Defaults
Jan 4, 2007To set the default values for controls, select the control on the tool bar and press F4. The default value properties list will appear. I like to turn off all of the 3D stuff by resetting some the values like 'Special Effect', 'Border Style', etc. This way I don't have to manually change them after the fact...
Thanks Ken have done this - however when I go off and word with a differant mdb file then come back to the original which I had open when I entered the defaults - the defaults have disappeared.
Any suggestions.
Ta
<Control Tips> Not Working......
Dec 30, 2004I am experiencing an odd thing. The program that I have written in Access when I use it on my laptop the control tips do not work. When I use it on any other computer the control tips work fine, does anyone have any idea what the deal is?
View 1 Replies View RelatedTricks And Tips With Exporting Tbl/qry To Text
Jan 4, 2007This is not a question.
I have recently been playing with exporting a query to a delimited text file and have learned some things along the way. Some of this is bound to be old-hat to some of you. However, I thought that it might be useful to post a summary of what I've learned for the benefit of others, like me, who may face some of the frustrations I've been dealing with.
Firstly, in order to export a query or table to a text format other than the default csv, you need to create what is called an 'export specification'. As has been mentioned elsewhere (http://www.access-programmers.co.uk/forums/showthread.php?t=59828&highlight=export+wizard)on this forum, you do this by clicking on the advanced button on the 'Export Wizard'. Pick the delimiter you prefer, click save as, and save the specification with a name that you can remember.
To use the specification in an export, you use the specification's name as the second argument in the DoCmd.TransferText method. (See access help for more detail)
However, things can go wrong!
Firstly, on some occasions, the export wizard fails to open thereby preventing you from accessing the specifications you have created or making new ones. This happened to me and it turns out that the reason was that some code I was running got interupted at one stage and DoCmd.Setwarnings was set to false when it happened. This prevents the export wizard opening for whatever reason.
The solution is to create a sub that sets DoCmd.Setwarnings to True and run it. (Credit to BobLarson here (http://www.access-programmers.co.uk/forums/showthread.php?t=37696&highlight=export+wizard))
Secondly, you may get an error message saying 'too few parameters...expected #' where the # represents a number.
This problem seems to be caused by using a control in a form as a criteria in a query that you're trying to export.
One solution is to simply get rid of the form references in the criteria of the query (Credit Jon K (http://www.access-programmers.co.uk/forums/showthread.php?t=54237&highlight=export+wizard))
But if you need to keep the criteria reference like I did, the best workaround I came up with was to enclose each reference to a form control in the criteria of the query with an Eval("").
Thus, if I were wanting to use a control called 'mycontrol' on a form called 'myform' as a criteria, I would use Eval("[Forms]![myform]![mycontrol]") instead of just [Forms]![myform]![mycontrol] in the criteria line of the query.
Thirdly, you may encounter an error that helpfully says 'Invalid Argument'.
This is due to the presence of a numerical field in the table/query that has its fieldsize property set to 'Decimal'. This is a known bug with access 2000 and solutions can be found at Microsoft's knowledge base (http://support.microsoft.com/kb/263946).
In my case, I resorted to changing the fieldsize properties to Double instead of decimal, and deleted/re-created my export specification after the change and this solved the problem for me.
I hope this post is helpful for others.
Cheers! :D
Tips Needed: Access Books, Graphs, PDF
Jun 26, 2005Hello,
I am about to start a project where I must link an Access front-end database to an Oracle backend. I have about a year of Access development behind me now, and now here is the next challenge.
What I have to do is create analyses of data and output the data mainly in the form of diagrams (i.e. graphs or charts). I have seen how this can be done with Automation in Access in a book by Alison Balter (Mastering Access 2000 Development), by controlling the Excel object etc.
Here are my 2 questions:
1. I am considering buying another book on Access now, something that will contain more examples/methods for presenting information as a graph with the help of Excel. Should I stick to buying an Access book, or should I look into getting something that is more Excel programming oriented, i.e. something like an “Excel programmers compendium”? Any recommendations/tips to get me started would be appreciated.
2. The users want the graphs that I produce to be saved as a .PDF automatically at the push of a button in the Access GUI. How is this done? Do I need special software, or can I use something like PDFWriter to automatically convert the Excel graphs into .PDF’s?
Thanks in advance for the tips and have a nice day! :)
J
Need Some Tips In Creating Relationship Join Lines Between Tables
May 16, 2005Hi, I am new here and need some help with MS Access97. I am looking for a more convenient way to join tables together. The usual way that I know is to drag the field(s) in one table and drop it in the other table (within the relationship window).
Is there any other way that I can do the same without drag and drop (keyboard instead of mouse)? This is real problem to me when I need to do some modification and have lots of tables scatter across few pages and the vertical scroll of the Relationship window is not working properly with drag & drop technique.
Please help. Many thanks! :)
Queries :: Crosstab Design Is Slow When Opening And Saving In Design Mode?
Oct 6, 2014I 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.
Forms :: Applying Sort And Filter In Form Results In Design Changes To Form
Dec 27, 2014When 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.
Forms :: Design Form That Looks Very Similar To Either Split Form Or Subform
Jun 2, 2014Basically 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 RelatedDATASHEET --- Allow Design Changes: Design View Only DOES NOT WORK
May 18, 2007I 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
Form Design
Sep 21, 2005I 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
Form Design
Apr 9, 2005can 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
Form Design
Apr 10, 2005Just 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 RelatedForm Design!
Nov 14, 2005Hi, 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 ;)
Help With Design And Form
Dec 29, 2004Hi, 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
How To Design My Form
Mar 29, 2006Please 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 RelatedForm / Sub Form Question In Design View
Mar 31, 2006Hello:
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
Form Design Question
Jul 14, 2005If I have a form and seversubforms in tabcontrols where the relationship between the underlying tables to which the forms and subforms are bound is one to many? In other words, once I enter the data for the record on the main form and go to the subform in the first tab can I enter data for , say, 3 seperate records all linked to the same id number in the parent record?
View 1 Replies View RelatedForm Design Questions
Jul 25, 2005I 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
Form Design Question
Oct 25, 2005I am setting up a form for employees to enter data for 'hours' and 'rates' alongside records.
I have nominated the fields as Project, Hours and Rates
In the project field there are subgroups (records) a,b,c,d,e, etc. each with hours and rates applied.
I would like the employees to open up a form and see each unbound record and enter the data for hours and rates alongside in the bound boxes.
i.e.
Field = Project
a) Project planning |Hours| | Rate|
b) Scope |Hours| | Rate|
How do I get the records onto a form as "unbound"?
So far I can only get the fields as unbound.
I plan to have many disciplines i.e. Civil, Mechanical, Electrical, etc. each in a different table with different field headings and different subgroups so will have to make a form for each discipline.
s
s
Access Form Design
May 13, 2006Hi all Its my first time on this forum so please be gentle with me ! I have a list of numbers stored in a field (wieght). I have another field that is the product field. I also have a list of letters (A-D) Now, the weight can be 1kg (through to 20kg) A-D hence four different values in my product field. I need to have a form that the user can choose a letter then enter the weight to show the correct product. I can get a dllookup function to work fine for the fields involved but i need a control to filter the different letter combinations Anybody point me in the right direction
View 4 Replies View RelatedForm Design Problem
Dec 13, 2006Hello,
For the life of me, I cannot think of a way to make this work. :(
I have this continuous subform, and I need to put additional fields onto it.
The easiest way to do this would be to create single record sub-subforms, but
that won't work because Access won't let me put another subform on a
continuous subform.
My underlying tables are as follows: tblA for the subform has a TableA-ID
PK, and a RecordID FK [that's its link to the main table], plus several other
fields to hold information. Table B has a TableB-ID as a PK, TableA-ID as a
FK, TableC-ID as a FK, a Yes/No field and a text field. Table C has TableC-ID
as a PK, and a text field.
When a new record is created in table A, a number of new records are also
created in table B depending on the number of records in table C [with an
append operation]. There are 6 entries in table C, so table B will contain 6
records for every record in table A.
Subform A needs to show these records, but as I said above, I just cannot
think of a way to make it work.
Any suggestions will be very welcome.
Thank you.
Form Design Question
Mar 11, 2007Not sure if this has been mentioned yet (I'm new, so please forgive me if it has...
I am working on a form that tracks more than one TECHNICIAN who has worked on a specific task, but I am unsure as to how I can display multiple text boxes w/out displaying what is in the 1st text box (as with other fields [START DATE, START TIME, END TIME, DURATION]). I am pulling them from a query that captured this data. How do I--->
a. not display duplicates in the other text boxes not in the first row and...
b. how can I adjust my query to show the time duration in decimal format?
If this can be explained in a step-by-step process, it would be greatly appreciated. (Also, if I can attach a screenshot to help explain my situation [how would I go about doing that?], it may speed up the process.
Form Design Protection
May 25, 2007hey,
looking for help with protecting form designs in a database.
We have some people here with enough knowledge to be dangerous.
I need to password protect the design of forms while allowing access to the tables in ACCESS and data entry.
Thanks,
SLH