I would like to add a page to a tab form when a certain button is clicked. I don't want to use the visible/hide solution. So I already found out that this can only be done in design view. I am using the following code:
Code:
Private Sub cmd_StrategyAdd_Click()
DoCmd.OpenForm "Form1", acDesign
Me.tabMain.Pages.Add
DoCmd.OpenForm "Form1", acNormal
End Sub
I am getting the error: Run-time error 2467. The expression you entered refers to an object that is closed or doesn't exist.I am sure the name of my tab form is tabMain.
I am modifying an existing form that has some tabbed pages(subforms) in it and I am wanting to know how to add another page. I have created another subform that I am wanting to add to this main form as another tabbed page.
I am using Access 2003 and have a custom shortcut menu. I wish to add some entries to this shortcut menu dynamically.
Background : I am displaying a list of customer orders and wish to offer the user the facility to filter the search for one item instead of the default of ALL.
The dynamic entries would be the unique order item reference nos. retrived for that particular customer retrieved via recordset . So the menu would show :
ALL ------ Model 1 Model 2 Model 3 etc. ...
How am I able to add these entries to the menu, the selection text will be the filter text I use to report upon.
In Excel, I can dynamically add option controls to a frame on a form using the Control.Add method. Is there an Access Equivalent? I can only find Count & Item as Control. items.
It might have something to do with design view i guess.
I have a database with a form and a sub form it works great. However I needed to add a tab or page to the sub form when I returned to the form view the sub form is there but you cant see anything. change back to design view and its there. I didn't change any properties on the sub form. and If I delete the page I added it works just like it did before I added it. also the sub form is linked to the main form master and child. would I have to link the tab also??
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.
I have 120 tables, each with the same name except 2 identifying characters at the end eg pc_dist_ab, pc_dist_al Each table currentnly has 3 columns. I would like to be able to add 2 additonal columns to each table with one query and was hoping an alter table query where the table name matches pattern would have worked but evidently not.
Is there a way to build some sort of dynamic query to add extra columns to these different tables at the same time?
To save another post I guess Once this is done I would then like to create 1 main table by creating a new table and appending all the files together- again I would prefer to be able to run this once.
I'd appreciate any help/thoughts as to whether this can be done?:confused: Thanks
I coulnt figure out how to reply to a reply. This is a follow up question to a previous post.
I can now create a new column in my access db through my web form.
Here is the script: ALTER TABLE FAQ ADD City varchar(30)
this adds a new column called city. Here is my problem: Every time a user asks a question, that question will be in the new column created. I need the newly created columns to have unique names. I tried creating a form with a text file (to simulate where they type in their question) then post to post.asp. post.asp holds the script. I replaced city with ::T1:: (the variable of the text file), but got an error.
Creating columns dynamically is worthless unless there is a way to make the column names unique.
Can anyone shed some light on this problem for me?
I currently have a Job Management System where the Customer Order Form displays all jobs via a main form and an order details subform. This form is used for inputting new jobs and for viewing existing jobs via links from other reports such as a job schedule or customer orders report. It is always reached via a clicking of a "New Customer Order" Button where the form is filtered to new record or via double clicking on an order number in another screen and filtered via the order number.
I am now in a position where the database is growing too large and I want to archive the data in the Orders / OrderDetails Tables into Financial Years and put them in a separate backend database. However the jobs will still need to be viewed via the customer order form in order for them to be duplicated the following year.
I have created a union query of the PreviousFY and Current Orders to allow the "search jobs by customer" query to work. This works fine, but I now need to make the record source of the Customer Order form dynamic.
I have created a CurrentFY query to feed the form if it is a current job and a PrevFY query if it's from the previous FY.
I have written code to check the OrderDate against the financial year to work out which database the job is from and set recordsource according to that result. This is currently in the OnCurrent event as I also have other code there that checks details of the order to determine if fields should be editable.
However I am finding that when I parse the order data between the forms the "new record" command or the order number is not being retained or checked. If this because I don't have a recordsource set when it opens?
I tried setting the recordsource as the currentFY on open and then do the check but that didn't work.
Is it possible to assign a query to the recordsource of a form dynamically? I assume the answer is yes. Can this action be done when the form is not open? If yes what is the correct syntax to use when the code is in a normal module as a public sub? I tried many possibilities and could not get it to work.
Code: Dim ForNm as string Dim Qry as string ForNm = "PersonalFm" Forms(ForNm).Recordsource = Qry Forms![PersonalFm].Recordsource = Qry [Forms]![PersonalFm].Form.Recordsource = Qry
I have a single form which becomes either readonly or editable or addnew using a circular toggle switch. The toggle switch is activated by a command button and the caption of the command button is used as the display of the mode.
The SetAddModeBt is a separate command button that initiates the add mode. The problem is that various form or field properties when defined on the fly are not stored and they get lost when you open the form again. Look at the code below:
Code: Sub tglEditBt_Click() '------------------------------------------------------------------------------- ' Circular toggle button to change display mode of the form ' ReadOnly - Edit - Add '------------------------------------------------------------------------------- ' On Error GoTo NotFound Dim ForName As String Dim strSQL As String Dim FMode As String
[Code] ....
Here the first two cases fail when executing the last statement saying it is not supported.
I have a list of jobs for a report in which there are multiple jobs per page. When there is a page break in the report some jobs are being cut off and then started on the next page. I do not want any information from a job to be seperated by a page break. I just want a page break to occur after a full job listing. I don't mind if the page is short, just don't want any jobs broken up. Is there a way to accomplish this??? Thanks.
I have two tables that need to be updated in tandem from a single access-page, by entering previously non-existent data. One contains a contractor ID, and the name of the contractor; The other contains details of contracts, with the name of the Contractor selected from a drop-down box that draws its contents from the other table.
I have a data access page with an always visible drop-down box that shows contractors, and if I select one, it displays all contracts entered. This unfortunately means I cannot easily add new contractors, since they have no pre-existing contracts to display the details, and allow entering, and I cannot make the details fields permanently available.
Right now, I can add new contracts to those contractors who have at least one in the system already, but I'm unable to add new contractors. My aim is to have a single page add the contract data, and new contractors. Having a hyperlink open a new page that allows the adding of new contractors is also acceptable, but no coding, please, cause I suck at that...:(
I have small database in ms access which i am using for invoice creation. When invoice is created i save it as PDF. I would like merge another single Page PDF along with the report as 2nd page so end report is 2 page PDF.
Second how can i get 1 PDF from 2 ms access reports.
I have a main form that opens on an autoexec macro.When ever i open up the database the form opens but for some reason it always opens a little way down the page so that you cant see the top and have to scroll back up to the top.
This is rather annoying because i have a tab control and it means you cant click the tabs until you move it back up.
How to design a form for a table based all records to design in a single form without top to bottom list wise and without scroll bars. Need to form design for all record details are will show on a form as side by side only as horizontal list wise.
For Ex. I have attached the screen shot image as per horizontal wise records continues.
to 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#.
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.
I'm working on a pretty serious report (at least for me)...I have 3 sub-reports inside, and the point of this is to use VBA and loop through several conditions (in the underlying queries), and print out in a batch for the user. When I add a page number footer it adds about 3 seconds to the processing time for a 14 page report. That doesn't sound like a whole lot, but when I loop through and process this 12 times, that's a lot of added time for the user...(the last thing I want to hear is it's slow!)
So, would it be faster if I set the page numbers in VBA? What event would I use? On Load?!? Also, how would I find the page number variables in VBA?
My database allows you to log issues (see attached)
An issue will belong to the project, the project may have multiple test plans.
The issue will also be the primary responsibility of a company, and that company may have multiple contacts (people)
Now, i could create a form over the top of each table but then if someone wanted to add a new project, testplans for that project, suppliers (companies) for that project AND new contacts for those companies, they are going to end up going through loads, and loads of forms.
So my question is, what approach would you recommend to create a control panel where they could add these items with the fewest number of page switches possible? (preferably none.
