I have a main form that has 2 sub forms on it - one below the other.
Because I did not like this layout I created a tabbed form on the bottom of the main form (2 tabs) and would now like to move each sub form onto each of the tabbed forms.
I have a parent window which upon clicking on a button will pop-up a child window containing a listbox. The listbox recordsource is a subset of the parent window. I want the user to select a record from the listbox which will load the selected record onto the parent window.
How does one pass argument back from child window to parent window?
From parent window to child window, I used docmd.openform ,,,,,,[argument] and me.openargs in the child window
Hi all, I basically have a long form which requires me to use the right side scroll bar to complete everything.
I currently have a top header area (which is great because it is viewable even as you scroll all the way down).
I'm wondering if Access is capable of having a "side header" (for lack of better words), i.e. on the right hand side have just a few buttons or fields that always stays there even though I scroll all the way down the form? This would work the same way as the header, just on the side instead.
Hello. I have a question that seems simple but I can't get it to work. Any help would be appresiated.
I need a form that will pull the oldest record from one table, allow the user to add a few fields to the record, then paste the record to a different table. when it is done the original record has to be removed from the original table.
I have tried using a append Query, but it moves all of the records at once and doesn't allow data entry on each record. I'm not sure if this would be done by a Query, Form or Macro. I have laid out the nessacary data flow below incase there is an easier way to do this.
Persons A,B, and C enters data into table 1. later person D pulls the oldest record from table 1, reads the data then adds fields to the record and records it to table 2. The information is then removed from table 1. Person D then goes onto the next record from table 1. When person D is done, there will be no data left in table 1.
Any Ideas? or can someone point me in the right direction for help?
I have a continuous form that shows the main fields in my table. In the page footer of the form I have a tab control that has 4 additional fields for each record. I want to give the user the option of “Show Details”. When the user clicks on “show details” I want to move the tab control with the additional fields to the detail row so the user can see them.
I know how to move controls with VBA by setting the Top and Left properties and how to expand the detail size, but how do I move controls from one section on the form to another section on the form i.e. from the page footer to the detail section
I have a form we use for data entry, and not all the fields willhave data in them. When we click the new record button the cursor stays in the field where it was for the last record. We would like the cursor to move to the first field on the form everytime a new record is started. Can anyone help me out here??
i have a form, where a user inputs a account number inputting the account number, then populates all the relevant table fields, into the form for the user to edit.however if there is more than one account, with that account number, how do i get it so they can cycle through on the form?
Is it possible to set a property to allow the user to click and drag an open form out of the Microsoft Access 2010 parent window? Specifically to a second monitor.
I'm trying to make a form with a single text box that will search for the contents of the text box in a table. Once it finds a match, it moves the record into another table. Anyone know how to do this?
I have a form with a subform in it. The subform is actually going to actually have more information and is going to take up the majority of the form. The reason why it's the subform instead of the main form is because of the nature of the parent/child relationship.
Layout-wise I'd like to have the content of the main form in the top left, with the subform taking up the space from the top right down to the bottom. This ends up covering the content of the main form in the top left. I tried using the Send to Back function on the subform but it still blocks the main form.If there's no easy way then I guess I'll just have to have the entirety of the subform below the main form content.
If I have a field in a tabbed form (the form has pages), can this field be moved from a tab to another programatically?
The form is called "ProjectMain". The field is called "Lenght" and the page (form tab) it is on is "specs1". Sometimes I need to have this field in the page (form tab) "specs2"
I have created an access database to track orders through out production. I have also created a form labeled "orders" with a subform where it has all the orders information, customer info and product info. Along with this there are 3 check boxes for each order they are labeled, "Routed", "Pressed" "Finished". I am looking for a macro for when I click the "finished" check box that order is moved to another form to reduce the amount of clutter on the orders form. Is there anyway to do this?
I have a pop-up form that is coded through VBA to open on certain button clicks. I would like this form to always open in the top-left corner of the window. For the life of me, I can't find anyway to specific in access where the form should open when called...
Is there a way to specify this? Or does access simply determine that itself? (arbitrarily it seems...)
I've just created a form and I'm trying to move and size the fields but they seem to be grouped together and whatever I do to one happens to all of them. I select one field and just that field has the orange outline but when I move it they all move.
Hard to see the image but basically, I can't seem to bring the database behind the form to the front to view it when I click on it. I've never encountered this before.
I need to have Access open with a form that does not take up the entire screen and I don't want to see the Access stuff behind it. How can I make just the start up form appear when I open the db?
Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened?
Hey guys, I know how to maximize a form when it opens, but I was wondering if there isn't a way to actually shrink down the Access app window to specified dimensions when it opens the form? I'm trying to write a dimension-specific app, so there is no distortion what-so-ever. thanks!