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've recently upgraded on of my systems from Access 2003 to 2010.
In the past I've always used to the ctrl key and the cursor keys to move and fine tune the position of my controls on my reports. However since upgrading the controls jump about all over the place when I try to move them.
I have noticed that when I've selected the controls and start to move them a little black line appears on the vertical ruler and when I release the controls they seem to move to it's position.
I'm trying to do a new membership database for a local group who take monetary subscriptions. Basically, there's a form for creating a new member, with a few tabs - Contact Info, Payment Info, and one other.
Basically, in the payment tab, i've got a dropo down box to select the individual package from a packages table, another to select the payment term (Monthly, Annually), and a final one to select the payment method. Now in there i've got a list of possible payment methods: Cash, Cheque, Credit/Debit Card, Direct Debit. Now obviouslly, each payment method is going to have different requirememnts for what info the club actually needs. Cash simply needs amount of payment and date of payment. Cheque needs payment amount, payment date, cheque details. Card is obviously going to need the CC number, Valid & Expiry Date, Card Type, CCV Number, etc.
So basically, i want to be able to have the relevant section display when that payment method is selected from the Payment Method drop-down box. What's the easiet way of doing this? Could i create another tab-set inside the payment tab, and then only display the one tab relevant to the selected method?
Request from the higher ups to have several expandable sections in a form. Ideally only the title of the section would show, like when using a DAP, then the user could click and expand out the section and enter data. I tried the Tab option, but they are set on an expansion section.
I have a continuous form that shows the results from a query like:
Red Red Red Green Green Green Yellow Yellow
And I wanted to know if I can some how highlight in a white/yellow alternating color like for instance starting with the three reds being white then the three greens being yellow then the two yellows being white and so on. Maybe through conditional format?
Form with three sections. I have three queries selecting different set of set in a table, I would like to show all three in a form side by side. How can I do this? I use form wizard bit it only uses one query as a source.
I have a switchboard form with a left menu bar similar to windows explore wi th three sections (Configure, Tasks, Print) How can I have each section collapsible like in window explore?
Can it be done through the VBA scripting in MS Access? If so can someone pro vided examples?
Basically I divided each section to three parts one part is the header which is an image and a label (name of section) the second part is the button to click to hide/show the context of the secti on the third part is the text (labels that open other forms) with a background image
something like this http://www.viksoe.dk/code/collapsiblepanel.htm http://www.viksoe.dk/code/screensho..psiblepanel.gif
I have not used access that much, but what I am looking to do is basically have 2 details sections within a report that will have different records in them.
I first used a subreport but that really did not work as intended. It left large gaps in between the records and just plain didnt work.
Here is a image of what I am trying to achieve: hxxp://img379.imageshack.us/img379/9471/accesshelpnx9.gif
As you can see theres two different sections. One is for regular campaigns and one is for extended campains. There is a field in the table that has the extended date. For the compaigns that field should be blank or null and for the extended campaigns it is not blank or null.
Is there anyway to achieve this in Access 2003, if so can you tell me or describe me the steps?
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 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 curious if anyone know's a way to access a specific data section on a tabular form. I'm attempting to have each section update a specific data item based on its position on the form, but am having problems since I do not know how to differentiate between one details section and another on the form. Any help would be appreciated.
I have many reports that are structured differently, many are grouped by semester.
What I do now, is put a button on each grouping of the report I want to email from and use the current semester (Sem) which is also a query parameter to filter the report.
Here is my current code which works fine:
Sub EmailFromReport(rpt As Report, Optional Sem As Variant) Dim db As Database Dim qry As QueryDef Dim rs As Recordset Dim Bcc As String Dim Subject As String Set db = CurrentDb Set qry = CurrentDb.QueryDefs(rpt.RecordSource) 'set query parameters
[code]....
The problem is, I need to be able to filter these queries on other criteria besides the semester.
My first idea was to use if statements to skip the records I don't want. This is messy and the report structures are different so I run into issues when using optional parameters because not all the reports are structured the same.
The best solution I have come up with so far is using a wherefilter parameter, stripping the semi colon off the querydef sql and surrounding the sql with a qrydef.SQL = "SELECT Email1, Email2 FROM (" qrydef.SQL ") WHERE " & wherefilter.
The problem is this, changes the original query, and I can't figure out how to copy a query with db.CreateQueryDef If i do db.CreateQueryDef("tempqry",qrydefSQL), I lose the query parameters.
Is there a better way to do this? If this is the best way, how do you take an existing query and make a copy of it?
I have quite a limited knowledge of MS Access (2007).
My question is; How do you use sections of one table in other tables?
For example: In tbl_One I input a users Name and Age and then say Weight, Height, BMI, etc.
Then in tbl_Two it uses the same Name and Age in tbl_1 but has other information such as Job, Skills etc.
This is not my actual database, however this analogy works, and they must be in separate tables, even though above they could all just be in a single table.
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?
