i have created a form based on a query and basically the form comes up as a whole page spread and i would like it to just come up as a small form instead of a whole page. i think i go into properties and then choose the actual form but i just need to know how to make it so its small.
Hope this explanation is adequate
Thanks
Nicholas
I've taking the time to create a complicated Form in Access, and would now like to have it accessed through a browser. Using the Northwind Orders from as an example, is there an easy way of making that from available through a browser without having to re-design it in InfoPath or a Data Access Page?
View 2 Replies View RelatedOK, I have 3 fields in my table: First Name (FNAME), Middle Name (MNAME), and Last Name (LNAME). The table is named EMPLOYEES and I need to make an expression that will give me an employees full name (LNAME, FNAME MNAME) in that structure.
Now I created a new Query which included the three names, but I cannot figure out how to do the expression for the full name, it keeps giving me errors.
I tried using the builder and doing basically:
[LNAME] & ", " & [FNAME] & " " & [MNAME]
That gave me an error saying it contained incorrect expressions or something. I also substituted + for &, and "AND" for &, and still got those errors.
I only have one report where the name format needs to be like this, and thought I could use a simple query to collect the data and format the name. If anyone can help me it would be greatly appreciated.
Thank You!
Ive just started creating the table..and Ive put fields like name/address etc as text but there are a few fields that need you to select an option...so i want to use the "lookup wizard" to create a listbox or combo box dont know which is best.. BUT the problem is when I select lookup wizard it says "unable to start lookup wizard. The lookup wizard doesnt apply to fields of this data type".
Why does it say that?
I have one-page forms which print a second page, blank except for a block of grey shading at the top. I have tried moving the content of the form up but that doesn't eliminate the second page. If I look at print preview, every second page of the entire database shows up as blank, regardless of where that happens to appear in the record.
View 2 Replies View Relatedto automatically create a second, third, fourth... page depending on how many characters are in the narrative. The only other thing needed to be changed is the page# of Page#.
So right now my form looks like below
CAD#
Person name
Charge
Narrative
"
"
"
"
"
"
"
"
"
"
"
"
"
Officer name date page # of #
Thanks in advance.
Matt
Hi All
I have added the Allen Browne Calendar 2k control to my form.
My form consists of 4 pages. On pages 2 and 3 I have subforms and on page 4 I have Personal data. Page 1 is general data and the Calendar is on Page 1.
What is happening is that the Calendar is also being displayed on my 4th page, in the same position as page 1. When I try to move it, cover it or delete it from page 4, it is also gone from page 1.
Any suggestions please?
Many thanks
Tee :(
I have a form with six tabbed pages on it. Since data entry follows in a logical order I would like to put a command button on the bottom of each page (subform) that can be used to go to the next page. What I am going to though? If i put a command button (open form) then it opens the whole form not as a subform on a tabbed page. if I try and put a command button (open page) then it will not let me enter the page number. Hope that makes sense! Any ideas
View 3 Replies View RelatedI am having a problem with making a textbox visible on a form if a checkbox is checked on the same form. I have done research on this site and have written the code below, but I am getting a Syntax error, see yellow highlight.
- My checkbox is named: Case is a Readmission from WRCA IP to WRCA IP
- My textbox is named: Date of Current IP Admission (I have defaulted this textbox to not visible).
Here's the code I have written:
Private Sub Case_is_a_Readmission_from_WRCA_IP_to_WRCA_IP_Clic k()
If Case is a Readmission from WRCA IP to WRCA IP =true then
Date of Current IP Admission.visible=true
Else
Date of Current IP Admission.visible=false
[Code] .....
This is probably a stupid question but could you please tell me how i can set up a form in access to look similar to the one in the attached picture?
View 4 Replies View RelatedI have a form which I need to make read only. On Access 98 it used to ask how I wanted to open and view the form in edit mode or view. I cant find this option in 2003 anyone got a quick answer? Many Thanks
View 6 Replies View RelatedI am sure the solution is pretty easy but this problem has stumped me for a good few weeks.
I have a simple Excel spreadsheet with a column for town and a column for the price to deliver to that town. An autofilter allows the user to select the town, which will then display the price.
I want to add this feature to an Access database but am struggling to implement it into a form. Does anyone have any ideas?
Many Thanks
Steve
Okay, I'm pretty new at access. I have made tables for medication samples and sign out. I need some help in making a form to input and "sign out" meds.
I made the tables and allowed the wizard to create a form for me but I have some tables that don't show a relationship, and am not sure what to do.
The two forms I want are a data entry form that will enter the med, dose, lot#, exp. date, and number of samples for sign in, and, a form to enter date, patient last and first name, med, dose, lot #, expiration date, #of samples given, clinic and practitioner. I have attached the tables I made, can someone review and see if I messed up somewhere???? Thanks alot, I'm all for making our work lives easier! Robin.
In my DB I have a table of Member Names. It consist primarily of the key field MemRecNum and Last Name. I use a combo box to select the MemRecNum but show the Last Name in the box.
Further on down the form I either need to relate a guest to this member or his wife. There is a checkbox which identifies whether the name in that field is a guest or a wife. However, I would like to make it so that when I check the checkbox (yes) the last name of the member automatically appears in the field. I use this statement in the control: =IIf([Wife1]=Yes,Members!MemLastName,""). Since the recnum is what is stored in this table, when I use the above statement, I get a #name? error. Any Ideas? Thanks Jeff
Hi,
I am looking to create a matrix like table in a form. It would be used for accessing the capability of Project Managers for a recruitment company. On the X axis there will be different industries (ie IT, Finance etc). On the Y axis there will be different categories (like strategy, applications etc). Then I will need some kind of drop down box to link it all together and give each person a score out of 5. So for example somebody could have a score of 2 for their Strategy knowledge in IT Companies but a score of 5 for their Strategy knowledge in Applications etc...
Does anyone know if this is possible and if so any help on how to construct this would be much appreciated,
Many thanks in advance, Alex
I have a report which includes several subreports. There will be times when a subreport prints partially on one page and completes on the next. I don't always want to break to a new page with this subreport. However, I would want to break to a new page if the subreport cannot fully print on the current page.
View 3 Replies View RelatedI have a form that shows a companies engagement with our company. If someone wants to edit the details of that company (address phone number etc...), they click the "edit" button, which then opens a form where edits can be performed.
After the edits are done, the user clicks a save and close button which runs docmd.runcommand acCmdSaveRecord, and returns to the companies engagement form.
When I return to the company engagement form, I would like to see the companies information reflect the changes that I just made. Currently, I can only do this by exiting the form and re-opening. I have tried using Me.Requery in the OnGotFocus, Activate and Current events to no avail.
I should mention that I have a company combo box with multiple columns that are used to display address, postal code, etc... in textboxes on the same form.
I have a report that lists states and cities within the states. When a state name happens to be at the end of the page the individual cities appear on the next page with no State heading. I solved the second page problem by setting the "repeatSection = Yes" in the Section Header (though I haven't shown that in the example below).
But the previous page (which just shows the State Name and no cities looks dumb. Is there some sort of solution.??
(Actually I would also like any State that continues to a next page to not just have the state name but something like
" Colorado (Continued)" Is there anything I can do in VB to make a page break if the section is going to print but therer isn't enough room for one detail line?
This is what I currently see
Alaska
Ancorage
Prudo Bay
California
Whittier
Anaheim
Colorado
------------------------Page Break ---------------------------------
Denver
Pueblo
Colorado Springs
Deleware
Dover
-------------------------------------------------------------------------------------------
Thanks !
If I have a report and it has controls (labels representing column titles) in the page header. Now when I print the report - if it happens that the last page has no detail records - but there is text boxes and so forth in the report footer. Is there a way to not display the page header on the last page?
I have a report where the last page shows the page header - and the field/column labels on the page header - but for which there is no detail records left to display - on the last page. There is report footer information that should display. It just looks weird because the field/column labels show at the top of the page - but there is no data remaining to print under them on that last page.
I am working on a project at school and need the form to fill the whole screen with no task bars has anyone got any quiries plz
View 1 Replies View RelatedHi there, i have a database i am setting up with 4 tables and am trying to think of the best way to input new data into it. All the tables are linked and its all based on printers. When a new printer is brought if it exists in the database then thats cool it just needs a Printer number assigned to it and the database will do the rest looking up printer model and what cartridges it requires. But if u add a model for a HP printer for example you need to add the model number to the tblink and create new cartridges and use the cartid to link the modelID i hope u get the picture!? lol there is a pdf i have created using onenote with screen dumps and comments about what i need it to do. If anyone has some advice or help it would be very greatful! Thanx mike
View 1 Replies View RelatedIn the attached DB I have a form that has a combo box which enables you to select an employee and all the employee info is then pulled based on the selection. I want to make changes to the info in the form and have the changes update the correct employee on the table. Currently the from will not let me make changes to the info and the table seems to add new lines rather than updating the corresponding line.
View 8 Replies View Related;) Hey everybody,
I am working on a database used in recording device characteristics/test information. The main table of information has dozens of columns for test/part detailed information. When inputing the data for each specific test, many of the info. details are repeated when testing say 20 devices of the same part all at once. Rather than retype every piece of detailed information in every field, everytime, is there an easier way? Does anyone know of a way to make specific fields copy/paste the previous record's information in the fields automatically when a new record is created? Please, if anyone could help or has ANY ideas, let me know...
Thanks
gunwax
Hi All,
I have a data access page needs a filter by a dropdownlist, the dropdownlist used is a html control and I use javascript to filter the data programmaticlly in the onchanged event of the control.
MSODSC.DataPages(0).Recordset.Filter="AppID = 3";
My problem is, when this statement runs, the page refreshes. But I don't need the page refreshes, it set the dropdownlist text to the default text, not the value user select. The browser is IE7.
How can I stop the page refresh itself?
Thanks and Happy New Year!!
I have a report that should only show 1 page yet I have 2 and one is blank . I cannot find out why?
View 3 Replies View RelatedI'm making a customer survey database. Also be aware I'm not proficient with access.
All the customer information is being imported from an excel spreadsheet. That will include ServiceRecordID, ServiceDate, TechID, CustName, ServLocation, PhoneNum, and DeptID.
Another table will include records for answers to 5 questions that will be asked by a manager on the phone. That table is called TblQuestions. This table will also have ServiceRecordID to go with the answers.
What I'm trying to do is create a Form that at the top has a box for ServiceRecordID. I'd like to be able to type in the Number for that ID, and then all the information shows up on the form for that specific ID. And below all that, fields to add the answers to TblQuestions for that specific ServiceRecordID.
The reason I'm doing this is because the manager will get a report with the customer information that needs a follow up call. So I want them to be able to call up that information on the screen with the ServiceRecordID number, and also be able to add in the information that they get back from the customer with the questions that will be asked.
I don't know why I'm having so much trouble with this. But I'm not experienced with access or VBA both.