Was wondering is there a way I could have a button that would give me direct access to a specific form. example. I have design a form for my Ranch and was wondering instead of me clicking on form than add cattle. Is there was a way i could have a button on my database that would when i first open it to automaticly take me to that form.
thanks
Roger
Hello everyone, I am new to the forums. I need to learn Microsoft Access very quickly, but I do not understand a thing! I have a list of features of Access that I need to learn: what they are and how to execute them. Could anybody help me please?
The features include:
Field-type
Field-insert/delete
Query – create using criteria
Record – insert/delete
Sort-simple
Structure – file/table
Objects types
Form – columnar
Form – tabular
Form – header/title
Report – create
Report – query report
Filter
Thanks
I have one table holding lots of different data. That data is all the same, but when it comes to output, it needs to be separated by groupings (which I have defined within the table itself as group 1, group 2, etc)
I was wondering. i would like to do the same thing with forms so that input will be separated easily / visually for the data input. At this point, all I can think of is order ascending /etc, but this doesn't give any visual queues to the user when he has moved to the "next" part.
I don't like the option of just another text box beside it spamming a textbox per record of whats next.
By the way, the form display is continuous, and thats why I want a "grouping" option.
Any suggestions?
Kelemit
I'm having an odd problem with a form. We noticed this since migrating it from adp to accdb.
It's a form with two subforms in datasheet view, that contain data on a certain employee, which is selected on the main form.
If you use print preview before printing, it all prints out fine. However, if you use quick print, it does something weird. If you Pull up Employee A, then Employee B, and do a quick print, it will print the data for Employee A in subform 1, and the data for Employee B in subform 2. It displays correctly on the screen though, and the 2nd time you quick print, it comes out right.
I have recently updated several forms from Access 2003 to 2010.
On the old version I could 'hold down' the forward or backward pointers to quickly scroll through the individual records. Now I have to click each individual record to move one at a time.
Have I inadvertently changed a setting or is the quick scroll option no longer available?
The Quick Style and Change Shape formatting command buttons greyed out. What setting do I need to change to make them available?
View 3 Replies View RelatedI recently made a new version of our database complete with forms, querys etc.. using Access 2010. It looked good and nice, but we encountered an unexpected problem. In all forms that contains memo-type fields quick filter is not working (there is no lists, checkboxes etc..). My users really like quick filters and are understandably irritated. I would understand if this disappearance would affect only memo-type fields, but it affects ALL the fields.
I also know that there are problems with memos in Access 2010. I have tried to make new forms, but every time I add memo fields quick filter stops functioning. I have also tried to change properties, options and what not, but to no use. In older versions of our forms this feature works just fine, but they were made in older version of Access (don't know which since oldest ones are from year 2003).
Television
I have a pretty simple form that includes subform. Subform's table is linked to main form's table with parent/child relation. Connecting fields are main table's ID field and corresponding field in child table. Subform is in datasheet view. This is pretty basic stuff so there should not be any problems, but every time I apply a quick filter in main form it causes data in subform become invisible. There is single row in subform, but all it's fields are empty.
View 5 Replies View Relatedhey guys quick one
when creating a table in SQL how do you set a variable to yes/no i tried the BIT command but didnt like that so is there any other way?
cheers guys
Hey guys, I'm just doing this database and have suddenly realised I dont know as much about MS Access as I thought!
Q.1 - I need to run a query that displays the top 5 records in a table, how would I go about doing this?
Q.2 - In my tables, I have of numerical data like the following...
http://img276.imageshack.us/img276/2695/11ch1.png
is it possible to make a Totals column which automatcily adds up the data in the Fraud, Competition, Loss of data, etc rows? (similar to MS Excel if possible)
HI
I am creating this bloody db and I have created a form and when I open it, it shows, record no one, what I want it to do is open blank ready for a new bit of info to be put in. I know this is an easy one but im sick of the sight of access this week
With thanks
Hello
Great website. Does anyone have any information on the leafs (http://a-cholesterol-diet.com/index.htm). I have been looking all over the place but no one seems to have any information or listings of any websites, any help would be greatly appreciated.
Thx
I have done a little database for someone so they can keep track of available dates for their apartments in Turkey. They want me to add it to their website so people can look for themselves. I know I should join a beginners web design forum, but can anyone tell me how i actually log into a website? I have the wesite address and the password. Thank you in advance Ben
View 5 Replies View RelatedHi all,
I am just wondering why Modules have the name of bas at the start of the name. frmForm and rptReport makes sense but why bas for Modules ?
Thanks in advance,
Mitch.....:confused:
I just joined and wanted to say hi to everyone. Also, I noticed that the forum runs off my screen.
Anyone else notice that?
melanie
Hello,
one of tables requires me to store sickness details, the sickness codes are all unique, they do however start with at least one 0 for example code - 000003 Description Stress. When you enter a code access automatically trims of the 0's to leave a 3.
Is there a way to override this im unaware of?
i am using the following query to make a table. i was wondering if anyone knew a way to have the table be named from data entered into a text box in a different form. so when different people type in different names a new different table will be created. thanks
CREATE TABLE tbalename (First_Name TEXT(20), Last_Name TEXT(25), dob DATETIME, Constraint Employees_PK Primary Key (First_Name, Last_Name, dob));
Bit of a newbie so help appreciated.
The system I have developed lists jobs (as in jobs that staff members need to go and do) in different towns and cities. These jobs are set as active or inactive depending if completed.
I need to run a report that allows the user to find active jobs in a particular town. I have made a query and by setting the status field to a criteria of "active" this ensures that all results in the query are only active ones.
I cannot find a way to allow the person running the search to enter the name of the town that they want. This would then allow the query and then report to list all "active" jobs in a particular town.
I have a table containing all the towns so hope I can offer the user running the search a means to either type the name of the town into a box or even better (to reduce typo's) be able to choose the town from a combo box.
Once the town has been selected, the report will list all active jobs in that particular town.
Thanks
Can anyone
I'm writing a field where it shows a combination of many fields.
For example, when a user types in "abc" in field 1, "def" in field 2, "ghi" in field 3, I will have to combine the three fields into "abc/def/ghi" with slashes in between them. However I don't want to have any slashes at the front or at the back the field.
There are unlimited fields of "abc" "def" "ghi" "jkl" "mno" etc. Any idea how I can write the code? I'm thinking using if statements. Is there other ways I can do this?
Thanks!!
I know I should know the answer to this but if you are creating a query that includes individual fields as well as calculations based on some of those fields, do you select the source field or the query "field" when using the expression builder?
View 5 Replies View RelatedHi,
I have a database showing car details, and need to show all records whose MOT is due within the next 30 days/one month (from today)
It might be similar to my first question.
Thanks in advance
Dan
My Mgrs. have asked me to set up a spreadsheet to keep up with inventory for a certain section of the business. And I figured that in the long run it would be easier to set up a database instead of a spreadsheet. We have specific customers with specific products to keep together; and I have figured out how to fullfill this .... my problem lies with the actual inventory.
The questions:
1) Can I keep an Available tally for all products?
2) To ship out and receive in cargo do I need to make 2 tables or just 1?
I have to keep up with the location of the goods in the warehouse and I'm not sure if I should include that with the product table or a seperate inventory table.
I am not sure if I will be using the database to create 'orders' or what we call bills of lading to ship out the cargo so I'm a little lost on how to keep up with the quantity of each product in the warehouse. There is no 'reorder quantity' or anything like that. I just have to keep up with how much of each product I have in the warehouse. Then I also have to be able to keep track of what is received into the warehouse and what is shipped out of the warehouse.
Does any of this make sense? I'm so confused myself that I'm not sure that I am able to explain what I need or what my questions are without confusing any one I'm speaking with.
Hey guys,
I'm having two small issues with my database. The first is, I can't get my drop-down to display content on the Form "frmSearch" under "Cast".
And the second, not really a problem, more of an inquiry... on the same form, is there a way to set a default value in the "released before..." and "released after..." of "(enter year - xxxx)" and have that value not interfere with the search feature if it is left as default?
Any help would be greatly appreciated. I'm very new to database creation and an eager to learn about these things. Thank you!
I'm importing a rather large CSV file that has many employees, repeated on several lines (one line per day) that contains performance information.
If I want to create a separate table that will contain basic information about each employee (for inclusion on reports), would that be accomplished with a relationship?
I can setup a query to pull up the information by employee name, but I of course receive more than one row since on the import an employee can be listed several times (multiple rows).
The two tables would not share any data, I just want a setup so when a report is generated and a specific employee appears, this information is generated with it. Thanks :)
But not easy for me, as its been years since ive done this kinda stuff. I got a field called 'CreditCard#' in a table called Customer. The data type of this field, i've set to 'Number' but how do i format it so it only allows the user to enter in a 16 digit number?
View 2 Replies View RelatedHey all. I've got a field that I'd like to put a paragraph or so of text into and I'd like to just click on that field and have an arrow open up a box with all the text for easy viewing... (i hope this makes sense). Anyone know how to do this? (I'm sure it's easy if it is doable) thanks!
View 4 Replies View Related