Hi All,
I have a macro which runs from a form. The macro just opens up a subform. The problem is that the subform gets opened up in a new window. I have changed the property to modal, but this then still opens up the subform in a dialogue box.
Basically I want to be able to view both the form (top half of the screen) and the subform (bottom half of the screen) on the same screen.
Thanks,
Evan
I am working creating a data entry form. I am using the data entry option in the form properties to do this. However, when I do this, my subforms do not display any information.
Ideally, I would like them to display information when the field linked to the subform is entered on the main form. Is there an option for this ?
Any help is appreciated. Thanks.
I have a problem in reflecting the updated changes on a main screen subform based on a query .These changes get reflected only after closing the access database and reopening it .Tried the requery command. Also made a macro to update the query and run it after the form opens or load but not reflecting change in main screen immediately .I would be grateful if I can get some help on this forumThanks
View 3 Replies View RelatedI have tried to make a login screen, I have also searched for information and tried some of the examples but, I just can't get one to work.
Is there someone or somewhere where I can get information on how to build one step by step in simple easy instructions....(access 2003).
Also, how do you get access to open all the windows, tables, queries etc in full screen mode.
I have expaneded them and shut it down and then reopened it but they still want to open out of full screen mode.
Thanks, everyone has been a great help in creating my first Access program.
I've used Access 2003 to create a database which contains a table linked directly to the "Orders" table on my mysql server. This table holds all of the customer orders placed on our website. I next created a form in access to give me a nice justified view of the orders.
My Problem? The field on the mysql server that holds the line item details for each order is a "Memo" field, and all of the text is formatted in html it appears. When viewed on the form, I see the all of the raw code, and not the nicely formatted text. If i highlight a section of the code from the form, and paste it in a Html editor (Frontpage for example), I see the line items nicely formatted as intended.
Is there a way to get this memo field to display the formatted html text instead?
My access skills are pretty limited, so detailed steps would be appreciated.
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!
Hey there, when a user opens my database, I want the form to enter records to automatically open. Can someone plz help with that... thx
View 3 Replies View RelatedGreetings All,
I'm not sure if this is possible but I've been asked to devise a way of viewing past record entries from an old form on a new form. Our database contains yearly records of student details; each year has a separate form. What my manager would like is that when a student ID number is typed into this year’s form, that old data from previous years is retrieved and placed in the database OR some sort of command button that searches past records for that particular student ID.
Hope that makes sense, I'm completely confused about the whole thing, I'm not sure if it’s even possible...any kind of help will be gratefully received!
I have made a table and I enter data in that table through a form. The form also include two sybchronized comboboxes. When I select a category in one combo box, corresponding items are selected in second combo box. The problem is that when I select the category in the form (with ID+Category Name), it stores only the ID in the table. How can I see the Category Name in the table (which is the control source of the form) instead of ID?
View 4 Replies View RelatedI have a button on my main form that allows me to view one of my reports. In order to view the report I have to close my main form. My problem is how do I reopen my main form when I close the report that I have viewed? Some code that would reopen my main form when clicking on the X in the upper right hand corner of the report to close it?
View 13 Replies View RelatedI have developed on ms access project (MS OFFICE 2010) i am trying to make it online so anyone can open Forms through browser.
Does it possible to make ms access Form online and view in browser? if yes then how?
I have a database with customers/orders etc. I need to create a form or something which will show if a duplicate customer is entered. I know about the duplicate records query wizard, but I also need an easy way to consolidate and delete records. When a duplicate customer is found, move the customers order/s [OrderNumber] to the existing customer and delete the new/latest customer record.
Customers are in tblCustomers, their orders are in tblCustomerOrders, [CustomerNumber] is the joining field.
I was thinking of just a date/time field for [DateCustomerEntered] with default value Now to keep track of the later customers?
I have a form that has a bar down the left side of my form that is right next to the navaigation bar. It has a arrow pointing toward the form. If I click on it nothing happens. Don't know what it is and would like to get rid of it if possible.
View 2 Replies View RelatedHi All
I am looking for a method to shift a small pop-up window around on the screen. I want to avoid the overlap with the help function, which is an external program.
I already tried this code in the form:
Me.Left = Screen.Width / 2.5
But a form does not seem to have the property .Left or .Top.
Does anyone have the solution?
Hans van Vliet
Hi, i have my form open in design view and it includes quite a few fields on a tab. But when i go to open it in form view, the form is just grey and nothing appears on it. Never seen this before, can anybody help?
View 2 Replies View RelatedI 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 RelatedI have a form that is too big to view on one screen without scrolling down, is it possible to shrink it so that I can view it all, similar to the facility in Exel? I have tried the Scale & Resize MDE solution that is suggested in the threads but this only resizes your original to fit other screen resolutions - neat idea but it is not what I want as it still shows the original form nut pro-rata to the screen size.
I am not distributing the app so anything I do local to my machine to get it to work is fine.
Could somebody please tell me how to set the size that my form will appear when loaded, because it's really annoying me trying to get them to appear at the size I want.
View 3 Replies View RelatedHelp!
I have 2 tables with the following fields:
Table1
CustID - (Autonumber/PK)
FirstName
MiddleName
LastName
Address
City
ContactNumber
Table2
CustID
VehID - (Autonumber/PK)
PlateNumber
FrameNumber
ProdNumber.... etc.
Property of all fields in Table2 are set to Indexed(No Duplicates).
I need a warning message form to appear on the screen if User adds a new record of PlateNumber which already exist. Then, automatically shows User who currently owns that PlateNumber.
Thanks!
Sheila
I have a modal, pop-up Form, that I'm using as a dialog box. But, when it opens, I want it positioned on screen in a certain place, but I'm struggling to work out how to do this. What properties do I need to alter/set, to achieve this?
View 7 Replies View RelatedI had the Main Menu open when clicked on access file. I put a autoexc.bat file somewhere. Where? Also how do I get a form to open in full screen again?
View 3 Replies View RelatedI have a form and I have created an event procedure on the "before update" property of the form. My procedure is:
Private Sub Form_BeforeUpdate(Cancel As Integer)
Dim pwd As String
pwd = InputBox("Is the information you entered correct?")
If pwd <> "yes" Then
MsgBox "Record Not Saved"
Me.Undo
Else
MsgBox "Record Saved"
End If
End Sub
the record is not saving under any situation. What do I have wrong?
Need some help on a command which would close any on screen active form. I want to have this Esc key enabled as an autokey to close any screen active form. I know how this autokey thing works but unable to figure out proper code.
thanks
Hello this is my first post in the definetely best Access & VBA forum on the net and i hope i am in the correct forum to ask this.
I would like to know if there is any way in access to change the size of the for my users view according to their screen's resolution.
E.g. i am creting the form using 1280 x 1024 resolution and my users have 1024 x 768 resolution how go i make the form adapt to their res.
Thanks for any replies :D
hi guys,
would someone please tell me if it is possible to locate the form in a specific location on screen, e.g. starting from top left corner or basically have the form open in centre of screen?!
I have created my database in Access and now trying to make the forms appear on screen as neet as possible. I have a main form which is on screen all the time and it should cover the whole screen. I have set the size of the form but everytime i open it it doesnt cover the screen as it does not start from the top left corner!
i also have a few pop up forms which i want them to appear in the middle of screen. how can i do this?!!!
i would appreciate any help or suggestions on alternative soloutions!
Thanks
Apologies if I am covering old ground here but unfortunately I cannot find a suitable solution after searching the forum.
Basically my switchboard on Open includes DoCmd.Maximize so that the switchboard does indeed open on full screen. However, say I then leave my database open and work on a different application on my PC then when I click on my database on the taskbar then the form is not longer full screen.
So what I am basically asking is, is there a way of 'locking' it to appear full screen even if I flick between applications on my PC?
Many thanks in advance,
Paul.