I have 2 tables 1 called current 1 called previous
I have created a form to view the details of the current table.
This table has all our current users and when one leaves I want to be able to move them across from the Current to the Previous table. Ideally I would like a button to do this.
Does anyone have any examples of code to do this behind a button.
I am a real beginner with access etc so be gentle.
Basically I have a Customer Form, which I have a New party button on it,this button opens up the party form to a new party, what I would like it to do is open up a new party but make the new party for the customer I had selected in the previous form.I have tried the GoTo macro's but cannot seem to get it to work.
I am thinking on clicking the button it will need to get the Customer ID, and then open the party form, create new party, and paste in the Customer ID, which then updates the Name - Date - Address - Company Fields.
I have a button on a form which calls a module to show a calendar form. The user picks date and time, and saves it. The calendar form closes and adds the date and time to a text box on the initial form.I want to save the record so that the underlying table/query is updated, but it's not working. The record is not saved until the initial form is closed.Here's the form vba...
Code:
Option Compare Database Option Explicit Private blnFlag As Boolean, blnSaveIt As Boolean Private Sub btnDelete_Click() On Error GoTo Err_btnDelete_Click
I have a continuous form in which I put a command button for each record called "detail". I would like to click on the "detail" button and make it open another form containing all (and only) the info on this record.
At first I refused to use an "id" to link both forms, but finally I added the "id" in the table... however still does not work.
continuous form: "04 - GASTOS_BUSQUEDA" id field on continuous form: "Gastid"
pop-up (details) form: "GASTOS_EDITAR" id on pop-up (details) form: "editar_id"
This is what I have tried on the "click" properties of the "details" button field (called "btn_editgs"):
4) Private Sub btn_editgs_Click() On Error GoTo btn_editgs_Click_Err Dim strWhere As String strWhere = "[editar_id] = " & Me.Gastid DoCmd.OpenForm "GASTOS_EDITAR", , , strWhere btn_editgs_Click_Exit: Exit Sub btn_editgs_Click_Err: MsgBox Error$ Resume btn_editgs_Click_Exit End Sub
I would like to create a command button on my form that copies values from 5 fields in the current record into a new record leaving all the other fields blank except for the new record ID.
The fields that contain the data that I want copied into a new form are:
I currently have two forms: frmE_SAFind and frmE_SAOrder
frmE_SAFind shows results from a query including fields [txtIDPO] and [dtmDate] Example: IDPO Date btnOpnFrm 6543 2/1/05 btnOpnFrm 5681 1/1/05
frmE_SAOrder shows order details including [txtIDPO] and [dtmDate]
I have a open form command button set up on [frmE_SAFind] that opens [frmE_SAOrder]. Is it possible for me to modify its properties so that when the open form command button is clicked, the order details in [frmE_SAOrder] will represent the order that the user is selecting via the btnOpnFrm command?
Example: If I click btnOpnFrm for 6543, [frmE_SAOrder] will show me PO 6543 details.
Hopefully I made myself clear enough to understand. Thanks for your help!
table 2 (form2) Reference (fK) workbook reference (PK) auto number
Table 3 (sub form within in form2) Reference (FK) workbook reference (fK) data Reference (pk) auto number
Each table is a form that is linked via the keys. On form 1 i have a button that is to open the form2, which it does but every time i open the form a new record is added. Why and how do i prevent this.
Then what i want to do is add a button for a new form on table 2 form but use the same reference as the record as presently displayed. How do i add new record using the same Reference but new workbook Reference?
:rolleyes: Hi this is my first time using this forum, I hope someone can help. I have a form 1 and I want to open another form to display data specific to the record showing in form 1.
I have done this many times successfully but now I am getting an error msg "The sepcified field '[UnitID]' could refer to more than one table listed in the FROM clause of your SQL statement.
I have tried everything but cannot solve this one. Any suggestions?
I am really struggling with this. I have 2 tables, 1 called Current and 1 called Previous. Each table has all my users current and previous. I want to add a button in a form that when you are viewing a certain record you can click the button and its moved from Current to Previous.
I have seen some posts about ammend queries and I am confused as to what they are and how to use them. I would prefer some code but which ever way is easiest.
I am a real novice with access and programming and woul appreciate some help from you lot
I was wondering if anybody could help. Up until yesterday, whenever I placed a button on a form a box would popup giving me the option to make the button open a form, a report a query or close the form. For some reason this wizzard has now disappeared and I would really like to get it back. Does anybody know how I could do this
I created a form that lets the user choose specific criteria, through a combo box, to run a report that houses several subreports. Each combo box is referencing 4 queries needed to run the report.
=[Acctmgr_renewed_detail]![RenewalMonth] And [Acctmgr_begbal_2005]![RenewalMonth] And [Acctmgr_cancelled_sum]![RenewalMonth] And [Acctmgr_renewed_sum]![RenewalMonth]
The form also includes a command button to preview the report. However, when I click the command button, the prompts for parameter values for the report popup again, when it should just print the report. Below is the code attached to my command button:
Private Sub Command2_Click() Me.Visible = False DoCmd.OpenReport "Acctmgr_monthly_activity", acViewPreview DoCmd.Close acForm, "valarie" End Sub
Is there something I need to add to my code? If so, what? Any help would be much appreciated.
Hi... being extremely new to Access, i am sitting here frustrated as anything trying to make this work. I will attempt to explain what I am trying to do.
I have a form that has a combo box in it. This combo box references a table and pulls in the data depending on the company that is selected. What I am trying to do is add a print button on the form, so that the users can print off an address label. Now I can use the normal print report feature and this prints of the entire report, but what i would really like is the print button just to print the fields I want and not the whole thing. The fields I want to print are.
I have a form that is loaded through a hyperlink from another form. On this form I have placed a command button which closes the form (DoCmd.Close) I have also used the full syntax including form name and no save prompt. When i close this form using the command button I get a request for two paramter values that are used in queries in this form (I don't want this to happen) when I click the close button on the control box "X" this doesn't happen also it doesn't happen if I use file close. This problem only occurs on some of the slower machines in my workplace, any suggestions would be greatly appreciated. The is one combo box on the form in question which is set to run a macro after update, this macro requeries the 52 list boxes on the form.
I have a form and I have placed a "Filter by form" button in it. Now I would like to create a second button that applies the filter (same funtions as the funnel icon on the toolbar. I tried using a macro with a command but when I click the first button and the form is ready to accept my criteria for the filter both button are greyed out. The only way I could apply the filter is through the toolbar. Any way of doing this second button?
I currently have a button that holds a delete command. When the button is clicked, a MsgBox pops up and ensures that you want to delete (yes and no); Yes deletes, No cancels.
Now I need to change it around a bit so that it is more secure. I would like add an 'authorization' code (password). When the msgbox appears, I would like it to have a text box where the user needs to enter in the password, if the password is correct then it would delete, if wrong then cancel.
I need help. I finish my contract tomorrow and this is all I have left
I have a form where I set the record Nav and Record set to NO and placed buttons on the form to navigate through the records in the form from the tables. I would like for the next record and previous record buttons to have the pop-up say "you have reached the final record", not you can not go the the specified record. It just sounds a bit confusing for some people.
I am building a database to track employees. I have a form to input the personal information and want to close this form and open a new form to input the employee's training information. I have a cmd button to open the Training form for the individual, however I can not make it close the employee input form.
I'm trying to create a search form with drop down boxes to select criteria.
I would like a "Clear Form" button that removes any data on the form to start a new search with. I have the following command in an "on click" event. But when I use this, it does clear the form. But from then on out, I get no results from my form. Even submitting the form with every entry blank, I get no results, when I know I have data in the form. I verified with my tables that the data in them didn't get deleted by using the code to clear the form.
From what I know, this should only clear my form, not cause it to mess with results after it's used to clear the form once. I've even deleted this line of code from my database itself and I still get 0 responses back when I search.
Any ideas what I'm doing wrong, or is there a better way to clear a form with a button to click on?
Hi everyone, I am trying to create a button on a form that will export only that record. On the command options I do not see there being an option to do such. Can anyone help? Thanks
I have created a query that has the info for a quick search. What I want to do is create a form that I type the last name of my customer and then click a button that opens the query and filters out all records that don't match the criteria I enter. I want the button on the form to do both. Is thie possible? If so how? Please Help. Very much appreciated
I have a form which is used in the Data Entry mode. I have a button on it called SUBMIT which closes the form. Of course in actual fact, as soon as data is entered on the form, it goes into the relevant tables, even if the form is closed without using the SUBMIT button.
I want the SUBMIT button to actually work like a submit button, so that no data entered in the form is actually entered into the underlying queries or tables UNLESS the SUBMIT button is clicked. Is it possible to do this?
Alternatively, if there could be a MACRO or something so that if the form is closed in any other way, the data just entered is deleted.
i am abit confused.. i have a save button on my form.. this is where field validation occurs and where the closeForm statement is (at the end). I need to keep the form's "X" button enabled.. how would i go about doing this exactly.. can i keep what i currently have (in the cmdSave_click event) and in the form_close event i can maybe have if me.dirty then... call my cmdSave_click event?.. Else.. closeform. Is this the right way to go about it??.. if so.. will my formClose statement (in my cmdSave_click event) be alright?
I have a database with a Main Menu Form, containing a Button that loads my main data entry form. When the Button is Clicked portions of the data entry form that is loading shows through the Main Form Background (e.g. portions of the navigation bars, and portions of the boarder on the form that is loading.)