Newbie-Creating Pages Within A Form To Break Up Information
Apr 26, 2007
Hi! I'm a newbie and have very very basic understanding of Access...I'm running a small group of about 19 members that is expected to grow within the next two months to 11 more members...
I haven't been able to find a freeware club/membership database so having the fun of creating my own.
I used the "membership database" that microsoft offers and I figure out (very easily) how to do the page breaks, but I tried to add an option on the top of the form to goto page 3 and have access take my viewer to "page 3" of the form...
I've looked at the coding for page 1 and 2 that is already in place for the form where member info is enter, but it's just over my head and hoping someone can help me figure out how to build an event that when someone clicks on page 3, it will take the viewer to the "third page" of the form for additional information I hope to add.
Is is possible to create a form that is 4 pages in length? After info is entered in first two pages I would like to print out all 4 pages to pass on to another person.
I've created a report based on a query that shows me the jobs that have been added to tblJobs between two selected dates.
The report works fine and displays all the information I need, however other than being sorted by day of the week i.e. Monday, Tuesday, Wednesday etc. The records just run on one after another.
I want to create a page break, so that a full week is shown on a single page before then forcing a new page when it moves in to the next week.
is there anyway you can create one form which updates all the information in multiple tables. I need to create one of these to make the navigation of the database more easy, so if anybody could help me it would be much appreciated.
I would like to create a custom theme for my INPUT page, however within Access 2003 I only have the option of about 20 predefined themes. I want to insert my companies' logo onto the INPUT PAGE.
What I would like is to save a template, like I have done in REPORTS, so that when I build a INPUT PAGE I can select my own theme to use, based upon my companies' logo, type face et al .,
Welcome, i am making a database project for manufacturing purpose. I have made tables in MS Access and connected them with MySQL (ODBC). I have created data access pages for employee to access data to database. I have copied these page to my locale appache server and it works as a web page. I could(employee) insert data from a web page to MySQL tables, but now I want to make some reports and templates(made in Access!) be accesible from web page for managers. Graphs made in access too.
I will look like this: User will log in on a web site, when he log in as a manager there will be available reports and graphs(data from MySQL) that I made in Access. Data Access pages made in MS access <2007 work perfectly, can I make the same thing with reports, graphs, templates? I mean save them as a dynamic web page with links to databace?
I have a form with information on it relating to several linked tables. I would like this information to be duplicated in the tables and a new autonumber assigned.
Is there a way that I can do this by clicking one button and the autonumber will automatically generate a new number keeping the rest of the information in the form and updating the tables with a new record?.
I need to create buyer and seller invoices within my access 2003 databases, my sister in law runs an antiques auction house and I'm working on a database to capture all their information.
I've created a 2 queries (a buyer invoice and seller invoice), show all unsettled items with the relevant item information and fee's.
However, I would like it to automatically allocate an invoice number, and store the information back to a table (seller and buyer ID, total number of items on the invoice, total fee etc)
I'd like store the invoices as well, so within the customer record form, I can include a box showing a list of the buyer invoices on one side and seller invoices in another (not all customers are buyers and sellers).
Once I've issued an invoice, can I automate it to show that item as then as invoiced?
Can the invoices be editable at all?
When they come in and settle their account, I also need to feed this information back in as well.
Can i arrange an invoice for seller's particularly, to show all sold items, and the fee's associated with them
Returned items as well as any associated fee's with them?
I have been looking at the Northwind example.
I see how they have an orders details table and orders table, I could replicate this.
I could have an Buyers Invoice table and Buyers Invoice Details table, but how do I generate an invoice, pull the next Invoice number from my (currently blank) invoice table, and pull in the outstanding items for that buyer for that specific auction date (I have a query), and then populate back information from the invoice?
I like the fact that their order form is editable, do any changes go back to the query, that then populate the invoice when you click print invoice?
I need to be able to (at the end of the auction) pull all items from my item log, for that buyer, and print them an invoice, automatically saving all the invoice details back into my database.
I need be able to automatically flag the items in my items table, as invoiced and pull the invoice number in?
I can see how all the Northwind tables, queries, and forms relate to each other and subforms, but I'm not sure how to actually create an invoice, get invoice number, merge with my query, and then feedback in.
When I click on the command button to create a New Record and then type the customer details in the Main Form and the Order Details in the Subform, the information is not retained
i.e. when I close the Form and then re-open the Form the orders details are not saved but the customer details are.
When I re-enter the order details the information is retained this time, everything seems work ok second time round!!
i have been trying to create an employee database to record:
1. Name , Address 2. Telephone 3. Date of birth 4. employee ID# 5. Emergency contact -name, address, telephone 6. Photograph 7. Other pertinent information related to employees
So far I have incorporated the contacts database forms into my new database but I am unable to link the forms into one form that will incorporate all the information needed. Is there an existing employee database that I may edit to suit my purposes?
I've built a PostgreSQL database for some ecology data and am trying to use MS Access 2010 to make a front-end for it.
I've created a form to display site data; it includes such fields as site ID, site name, county, state, landscape, etc. (There are more, but if I can get the idea down with a couple of these, I should be good to handle the rest). One can click through the form and see 14 pages of site details, which is fine because there are 14 sites.
What I want to do now is make a search form in which one can enter values for site ID, site name, county, etc, and somehow get the pages of the display form that match those values. It's not terribly important to me how that output looks - whether it's a list of matches that allows for clicking on a match and showing just one page of the display form, or whether it's a filtered subset of the display form pages that one still clicks through to view them all.
if there is code to write, where do I type it? Do I start my search form by making a form with the search fields as values, or is there some other way? How do I make those search fields into search boxes rather than display boxes?
I am using the "Tab Pages" on a form. On one of the pages I have a subform. If I'm doing a routine in VBA regarding that subform, do I need to reference the Tab Pages object as well as the form and the subform?
Can anyone help me on this? I've just started a database in Access and I've created a form with vertical scroll bars. The problem is that when I use my mouse wheel to scroll down the page, it doesn't! It just cycles through the records...
Is there any solution to this? I'm ripping my hair out here!
I'm probably being really really stoopid and I bet it's just an option I have to set, but I really don't know!
I have a 2 paged Form. frmCustomer (page1) and frmCustomerOrderHistorySub1 and frmCustomerOrderHistorySub2 (Page 2)
On customers form I have a command 'Customer Orders'. When clicked focus is set to 'Page 2'. Page 2 should (and does) display ALL orders placed by the Customer currently being viewed on Page 1.
Problem: frmCustomerOrderHistorySub2 ONLY displays the details for the first order?
If you select the second order then the order details do not update?
I hope the attcahed DB will explain all?
I have spent a good few hours on this. Happy I got most of it to work unaided, could do with a nudge on this final issue.
I have a form that looks and prints exactly as I want it to, except for two little things. These things are extra pages. They don't appear on the print preview, but they always show up on the printer and on the pdf file when I email it. One page is blank and the last page has "Page 1 of 1" at the bottom right corner of the page. I would always limiting the printing to one page.
I have a form in datasheet view, and I am wondering if it's possible to specify "pages" with a set amount of records per page.Think like the search results of Google, you get a huge number of results, but only so many are displayed per page.
I have been asked to create a database very quickly for a small group that needs to scan multiple pages into an Access 2007 form. They they would like all scanned documents to be converted to PDF and stored on a shared network folder which can be accessed by their group. I have tried several ideas posted but, I have been unable to get any to work correctly. Any sample of working database that the scanning portion is working? I am so involved with other projects right now that I just don't have the time to create a scanning process on the database.
I need to make my form prompt me for an account number and have the fields in the form populate with any data that the tables contain for that account number.
If there is no account number in the table like that, I need it to make a new record.
So I read through about 50 posts trying to find one that resembled mine, but unfortunately I couldn't.
What I am trying to accomplish is this:
I would like to set up a database for reservations of meeting rooms at my place of employment. My experience with Access is very limited, and I find myself getting stuck. What is making things difficult for me is the fact that I would like to set up the interface so that people with absolutely no Access background could still use it. This means I am using the calendar tool for people to input the date of their reservation and giving them a command button to submit. That part works just fine, however, I am having difficulty in making a query that works through a form so that people can use the same calendar set up to inquire what reservations have already been made. I also am having a hard time with figuring out how to limit people from double booking rooms (i.e. i don't know how to limit just the time, and not the date or room). I would appreciate any advice on how to get this project started, so that I can move further along and be back on here to ask more questions when I get stuck again. Thanks in advance for your help.
Hi! I just found this forum and is exactly what i was looking for!:D
Anyway, i am a new access developer and i am currently starting to get around. I have a question. I been working on this database for a few weeks and when i created any subforms, fields or buttons some sort of wizard would pop-up and and walk me through setting all the properties and so on. For some reason thats not happening any longer. It just creates the field or button and thats it. So i have to right click, properties and so on but the wizard thing(or whatever is called) was easier. The harder stuff that i dont know how to do was easy. Does anyone know what i am talking about?
New to Access programing and need help please. I have a main form that requires the input of a building #, this takes the primary key spot for all records. On the main form is a monitors field which calls up a form titled Resource Monitors and allows me to input primary and mutiple alternates information. My questions is, how do I get the Resource Monitors form to automatically look at what record (building) is currently open in the main form and automatically adjust the Resource Monitors (building) field to match. I have created a 1-to-1 releationship between the building field in both forms, and created a subdatasheet in Resource Monitors that correlates the entries from both forms. What is my next logical step to make this work?
I have designed the database i wanted but now i want to link the fields from a access form to a pre designed template i designed in both microsoft word and pdf. When a user types the information in and clicks preview the information typed in access field will match the field in the template any ideas or software programs that do this.
I'd like to display several rows of data (records) on a Form. Each row has 4 fields. One of the fields (field name is Description) could contain up to 150 characters. So I would like to be able to display the first 40 characters of that field and have a "scroll bar" for that field so the user can scroll thru the remaining Description for that row (record) .
Hi all. I am fairly new to access and am trying to do something that shouldn't be that hard. I have a simple form with one text box and a command button on it. I have the command button set to run an update query.
My problem is that when I enter data and press the button, I don't know how to get the entered data into the query?
I know this is simple to do, but since I am new to access, I can't figure it out. Does anyone have a simple example or step by step details that they can share with me?
I am a newbie to Access or any database for that matter. So please be gentle. I'm in the process of writing an automotive invoicing database and have gotten stuck early in the game. On my form I have Qty1 - Mat1 - and Amt1 fields placed from my database. In Amt1 I would like to typein an amount and have it multiplied by 15% (.015). I fiddled with the "On Enter" in the Amt1 property box but got nowhere. Can someone help???
What I would like to do is create a list box that will only display the information from another form that is related to the current form.So I have a form call Equipment Catalog and that form is related to Equipment features 1 to M relationship and the Equipment Features is related to a Features form M to 1.
So what I want to do is display all the related equipment features in a listbox that is related to the current PK of that form.So if there is only one feature on one form the list box will only display that one item however is there is 6 features on another it will display all 6.I have been trying SQL and Queries but I still can't get it to work.
