I put a print command button on a form and found that it actually prints the form, pretty much as seen.
What I actually wanted was to print a report which takes all the details of the current record shown in the form, including subforms and tabbed pages.
That way, a user could navigate to the record by any one of several different fields (contract number, project title, project number, and various other ways projects are identified in the organisation I work for) and get a snapshot of the entire project for reference without having to print a report for all 250+ projects and then looking for the project of interest.
Hi there, I have created a form containing contact details for a 100 or so different people/companies. I want to have a button that will allow me to print an address label for the current displayed record (e.g. when I find the company I wish to contact in my form I wish to click [Print Label] and then get this company's address printed on my label). Have some programming experience but not sure how to go about this in access?
Also as an aside question, is it possible for me to display a list in my form instead of individual records. What I mean is that I would have Name, Address, etc as titles accross the top and then would have a list of all records below these. Then I could click on a record to get more detail and also click on one of the titles to re-order the data by this field?......I know these are pretty big questions but a pointer to somewhere with this info or a sample app doing something similiar would be great. :)
how to hide the the 'Details' section in my form when viewing it in Split Form. I tried to use
Code:
Private Sub Form_Load() Me.Detail.Visible = False End Sub
but that just makes the Details section look blank, as oppose to not having it there at all.
have only the Form Header and Datasheet visible in the Form View of my form. Similar to the 'Contact List' form in the Contacts Template that comes with Access.
I have got a form with summarised data (of records) on view for people to look at. (this is a continuous form). For each record I would like to have a button that displayed another form with more details on it. So by pressing the button opposite a particular record it would take the Id value of the record and open another form (with more details) at that particular record.
I would be very interested in seeing this done with a macro if possible but beggers can't be choosers!
I have a couple of identical databases in Access 97, they have lots of forms. My users use the two different versions of this database, but linked to different sets of data depending on what they are doing.
I distinguish between the two versions by making the background colour of the log on and Switchboard forms different. It would be nice if I could cause the background colour of the other forms to match the Switchboard without having to go through and change each form individually.
Can someone please give me a clue as to how this can be done?
I know using Me.Detail.BackColor = RGB(100, 100, 255) would work, but I can't see how to a) get the RGB values from the Switchboard.
I am fairly new to access. I have searched high and low for help on this particular topic. Its something pretty simple, I just don't know exactly how to do it.
Basically, the user will have a client selected from the main form, when they hit the button to go to another form which has details on services done on that client at a specific date, i want the new form to have the clien'ts ID present and a fresh record present in which I can enter the date of visit, what was done, recommendation, etc.
Right now its popping the new form open with the client, but it displays the last record that was typed in that new form. Does anyone have any suggestions or ideas on this?
I have stumbled through making a few new forms and tables for my new job, and have done alright so far (even if it takes me forever to do so), but there is one thing that keeps tripping me up. I just cannot figure out how to do it, even by looking at the designs and properties of other tables/forms.
Part of my form requires me to input location details. A table is setup with every City, State and Zipcode for usage on the form. Our old form was designed to auto-fill (is that even the right term?) the City and State fields upon entry of a Zipcode. These are all coming off the same table, and it works on our old form, but I cannot seem to replicate it on the new one.
I have 2 other issues with the form, and they are also both related to this auto-fill/auto-lookup hangup. Another table is set up with employee IDs, and their corresponding Last name, First name and Middle Initial. I'd like to be able to type in the ID and have the next field automatically enter the corresponding name. Similarly, I need to enter certain other data, and I would like the next field to fill in a short description of said data.
Can anyone help me or point me in the right direction? Like I said, I've pretty much made everything else work by learning from the designs of other tables/queries/forms we have, and by trial and error. But this final hitch seems insurmountable.
I have a query with the fields employee_name, shiftname, shiftdate and have set it up so that 2 input messages boxes popup allowing the user to input a shiftname (a,b,c) then a shiftdate. from this query i have created a form, but instead of having 2 message boxes popup on screen before the form is loaded is it possible to have 2 input fields on the form (one for shift date & one for shiftname) that allows the user to enter into these fileds whenever they wish provided the form is open and all the records bellow change matching the employee name with the corresponding shiftname & date?, any advice would be great.
I have two combo boxes in the form header and command buttons in the form detail. The combos allow the user to select either a customer or a prospect, then the command buttons open forms that only show records pertaining to the customer or prospect selected. Combos are "4Custcbo" and "4Proscbo".
1.How do I change which command buttons are available depending on whether the user has selected a customer or a prospect? Do I use two different subforms or is there a better way?
2.How do I hide the other combo box once the user has selected either a customer or a prospect?
I have a Lost/Found property database which we use to keep record of the lost/found property and it is working fine.
As per our organization's policy, we keep the item(s) for up to three months in which if it gets restored to the owner then fair enough otherwise after three months the item(s) can be claimed by the "Finder". But for this very purpose we issue the Finder with a "Claim Receipt" which he/she should bring in when claiming for the item(s) after three months period. Therefore, It's just the right time to upgrade the database to a more professional level.
The database has one table and two forms.
One form (LostFoundForm) is visible to the user in which they enter data, this form has two sections; Item(s) & Finder's details and the second section is about Restoring details.
However the second form (ClaimReceiptForm) is hidden to the users (for manual data entry) and has only one section which is exactly the same as the first form's first section, i.e., Item(s) & Finder's details. This second form takes the data automatically from the first form because the table behind them is same and fields are same (please see attachment). Up to here it's all working fine.
I would like to introduce a Checkbox or a CommandButton in the LostFoundForm which when we click should pull up a msgbox asking "Do you want to print the receipt for this item(s)?" with a Yes/No option. On clicking "No" it should, obviously, settle down but on clicking "Yes" it should print the "corresponding record" from the ClaimReceiptForm.
I prepared students details in access, but when i look the form view students particulars looks automatically (like name, age, weight and address). But what i need is students details has to come after I enter the name.
I want to place a button on my form that will let users print a .xls form to gather data on. They will use this form to enter the data into the database. I can create the button to open the .xls form but the user would then need to click the print button in excel. I am trying to eliminate a step for the user.
If this requires code please be very spacific as I am not familiar with it.
I would like to be able to print a specified form when a new record is added to my database.
I have an add form which can be filled in, and there is an "Add" button at the bottom of the page, when this is clicked, I want the record to be added but also a specified form to be printed named "frmKitChecklist".
As I am a VB noob I do not know the code to do this, please could someone help me!
I got the command buttons to print the reports I wanted from the forms. I now have a data entry form (data entry = yes). I would like to print a report from this form. All I get are blank fields. I think it may be a problem in the Where condition on the Open Report function.
I am using: [Forms]![complaintentryform]
The completed form contains all data I want on the report. I have tried printing it from the table, but I get blank fields there as well.
I just had a problem with a certain form:On Form1, I have a check box called SELECT. When I select any one record, the report I get is blank. I need to select one more record to get a print out of the first one. To print any two, I must select those two, plus an additional one. So it is always the number required, plus one.
I have been on numerous topics on this site and managed to pick up bits here and there to get my db to work as I would like with the exception of the print report button.
I can preview the result in a subform of the search that I have done, and it is this I would like to print – not sure what this should be as you can search on numerous criteria.
Hi... being extremely new to Access, i am sitting here frustrated as anything trying to make this work. I will attempt to explain what I am trying to do.
I have a form that has a combo box in it. This combo box references a table and pulls in the data depending on the company that is selected. What I am trying to do is add a print button on the form, so that the users can print off an address label. Now I can use the normal print report feature and this prints of the entire report, but what i would really like is the print button just to print the fields I want and not the whole thing. The fields I want to print are.
I've been sent a form which retrieves company information divided into 4 tabbed sections. Really need to print all this off but can't even print the tab which is showing - it only prints the part of the firm outside the tabbed area (company name and number)
Would be really grateful for an idiot's guide on how to do this! Reluctant to provide a link as it's confidential information.
I have a form which records the progress of a complaint investigation. There are 3 reports I would like to run from this form using command buttons. They are report_long (shows all activity) report_short (summary) and logsheet. The primary key is complt#. How do I ensure that the complaint being printed is the complt# I have on the form?
Please bear with my ramblings, but I’m not sure what you may find relevant.
I am currently doing work for a service company where the employees are required to wear the company’s uniform. When someone joins the company they are required to purchase their own uniform. After a year, the company buys the replacement uniform. Each year on the anniversary date, the employee is given their annual evaluation. At that time they are given a requisition to go to the uniform supplier for new uniform articles.
Each item in the uniform has a life span. For example, shirts and pants are replaced each year, winter coats and spring/fall coats are replaced every three years, caps every two years etc.
I have a form which lists the item no., description and cost of each item and when they are due to be replaced. For example Winter coat last replaced on 2003/11/10, replacement date is calculated to 2006/11/10 When this employee has his evaluation this November, he will be entitled to a new winter coat. The calculations are done by clicking an option button beside the item on the form. Clicking replaces the issue date with Date() and adds three years to the issue date using DateAdd for a new replacement date. Clicking the button also indicates that the item is to be replaced.
NOW, I have all this working.
What I would like to do is find some way of printing the requisition from this form before closing it. Something along the lines of:
If Option1 is yes Print this item on the requisition Endif
And do this on every item on the form, if it’s yes, print it on the requisition, if its no ignore it.
The option buttons are not part of the underlying tables or query only part of the form.
If I’m doing this backwards, please let me know. I’m well ahead of my deadline.
I've got an unbound form that view records indvidually and I'd like to create a report that when the end-user selects the Print Record Command button it will print all the employees information for his review and if changes my admin's will make the changes. What code would i use to do that with a message prompting them are they sure? I also would like a cmd button to print all records for annual review. Any input will be greatly appreciated...
I know how to print out a copy of a form that has no sub-forms as part of it. For those of you trying to do this, open the objects menu and click on Forms. Right click on the form you wish to print and save as a report. Open the reports menu and print the form. Suggest you eliminate colors or your ink supply will run out quickly.
Anyway, I am looking at trying to print the form with the sub-form showing as part of it. It is only for presentation purposes to show the End Users what the form will look like and ensure that all requirements are met. I could do a print screen but that only works if the form is smaller than the screen.
