I have searched the forum for questions similar to mine, but they all seem more complicated than what I need... and so I am getting a little confused with it all!
I would like to create a "GoToRecord" field in which people can enter a name which then take them to that record (stored in my "ClientName" field) on the Main form...
Can anyone help?
Tx!!
frederique.
I'm having trouble getting my subform to go to new record from a main form.
How would I go about making a command button(new record) on a main form link to a subform.
Example: After clicking on command button I would like my main form and subform to go to new record.
Thanks,
Michael
I have the following code in my VB:
DoCmd.GoToRecord , [Response Tasks], acGoTo = [Response_ID], "08"
This is not working however.... The table name is Response Tasks, the Column name is Response_ID and I am trying to pull the info from the one named "08". What am I doing wrong in the procedure?
Thanks in advance
Hi All,
I have a subform in which users kan edit a field. Some contain more than 100 records. After 'an edit' the code save the adjustments in the table. Then the subform automatically jumps to the first record, but I want it to go to the previous record which they just edited. Is that possible? Here's the code so far:
Private Sub Afgehandeld_Click()
If Afgehandeld.Value = 0 Then
AfgDatum.Value = Null
DoCmd.Save
Me.Requery
Else:
DoCmd.OpenForm "formulier5"
End If
DoCmd.Save
Me.Requery
End Sub
Hi there I currently have a DB with a ton of records. What I want to do is have a search box pop up when the user presses a button on the main form. When this search box comes up there is a list box with all the records. The user will then double click a record on the List box and it should appear on the main form. However this is not happenening. Here is my code for the double click in the list box.
Private Sub List3_DblClick(Cancel As Integer)
On Error GoTo Err_List3_DblClick
' Open the info form based on the selection in this listbox.
Dim strFormName As String
strFormName = "complaints"
DoCmd.OpenForm strFormName
DoCmd.GoToRecord , strFormName, acGoTo, " caseid = " & Me![List3] (I think this is where the error is)
DoCmd.Close acForm, "frmLookup"
Exit_List3_DblClick:
Exit Sub
Err_List3_DblClick:
Someone please help!!!
thanks
MsgBox Err.description
Resume Exit_List3_DblClick
End Sub
Hi,
I have a subform on a tab control. How do I go to the last record of that sub form?
If I use the original form (not as a sub-form), the following code works, but when in the tab control I get an error that "blah blah Form is not open"
Any suggestions? Thanks
Code:DoCmd.GoToRecord acDataForm, "Stock Transfer", acLast'works when main form, but not as subform =/
Hi there
I am making a form that has been set up to have a number of tabs so I can have more then 1 page on the form.
One of the tab pages is used as a search form.There is a couple of textboxes and a listbox where the results end up
What I am trying to do is have a double click set up on the listbox so I can double click the result I want and have the forms ID goto that record.
Its a bound form. The primary key is called PersonalID and its bound to a txtbox called txtPersonalID.
this is my code but its not working
Private Sub lstSearchResults_DblClick(Cancel As Integer)
Dim strPersonalID As String
strPersonalID = Me.lstSearchResults.Column(0)
DoCmd.GoToRecord acActiveDataObject, "PersonalID", acGoTo, strPersonalID
DoCmd.GoToControl "pgePersonalInformation"
End Sub
When I try run the code I get an error 2489. saying The object 'PersonalID' isn't open.
What am I doing wrong?
Can anyone help out
TIA
i have a listbox that manipulates records on another form but in case i click on one of the records in the listbox that doesnt have any corresponding record in the other form then instead of it saying that it cant locate the record i would like the form to go to a new record....
i've been trying at it but cant get it right...
plz assist... anyone.
On a Single Form with a sub-form I have set up the typical navigation buttons using the DoCmd.GoToRecord, ,acx where x = Next, Previous.
These navigate through the sub form records. I only want to navigate through the master records.
Extensive searching did not turn up the answer. There are many articles on moving through the sub-fom but nothing about just the master.
hi
could you please tell me what action will be happned when this both statement executed..
DoCmd.GoToRecord , , A_NEWREC
SendKeys "%N", True
Form ahse defines these statement as well.
Option Compare Database
Option Explicit
hey,
i have a form that keeps a record of my telephone enquieries at work..
i want to place a button on this form so that, whenever i have successfully dealt with a call, i can click this button and the record will go to a NEW "Logged Calls" form...
how can i achieve this?
p.s i am very new to programming etc...
thanks in advance!
johnny
When user submits record on form, by pushing the arrow to move forward to new form, or back to previous ones, I would like to ensure that they have met a specific criteria in some fields.
How can I catch this without using VB Access? I can use VB Access, but would like to know how "normal" users would force form validation.
Much appreciation for lesson.
-Mike
Hello
Im sure is is a simple problem but its driving me mad,
I have a form with 2 sub forms in it which are tabbed across the top of the form. When I open the form it displays everything fine accept it cuts off the two tabs at the top of the form and I have to use the the side scroll bar to view them. Small problem but not for people new to the database as they wont know they are there.
Thanks in advance
Daz
Private Sub btnConfirm_Click()
On Error Resume Next
DoCmd.Close acForm, Me.Name
End Sub
Private Sub Form_Unload(Cancel As Integer)
Dim password As String
password = "closeme"
If enterpassword <> password Then
Cancel = -1
MsgBox "Incorrect password!", vbExclamation
End If
End Sub
It works except if I press the confirm button with no text entered into the box it'll act as if the password is correct, wheres the simple error?
I have a table that contains a pricing list of two columns, one with the name and the other with the price, i have locked the name so it can not be changed therefore only letting the user change the price. Is there any way that you also stop the user sdding any more records to the form and therefore the table??
Thanks in advance...
This is probably v. simple but is doin me head in.
I've got a form based on a query containing three figures (currency). I want a total box that will add the 3 up. On the query I've created a field called Total with the following:
Total:sum([Text1]+[Text2]+Text3])
When three figures are in it works fine. If one of the figures is not there it displays #Name. I could get the fields in the table to automatically display 0, but if a user deletes off the 0 I'm stuffed.
Where am I going wrong?
Recall.
I am trying to create a form with close to 30 fields to be entered.
There are several fields that I would like to use a combo box for drop down options.
The key to this is to force people filling out the forms to select a valid entry.
My questions are:
1. With the Combo Box, how do I enter my selected information.
2. How do I point the information in my form to a new table so all of the information in the form can be stored in one centralized location.
Derrick
:mad: it sound really stupid but I am having problems on open.
I have a main input page for the database I am creating but when I open it up it brings up previously inputted data.
Any ideas on this?
I have a table filled with computer monitor information (tblMonitorManagement). I had query that uses combo boxes (cboSerialNo, cboRoom, cboDepartment) on a form for search parameters. The query is called qryMonitorManagement_Sub. The results are displayed in a subform (frmMonitorManagement_Sub). This works for both my desktop and also my laptop based forms/queries/tables.
Although this form works when using cboRoom and cboDepartment, it does not work when using cboSerialNo, so I decided to simplify it down to get to the root of the problem...here's what I did.
I created a new form, created a combo box (again called cboSerialNo), and had it look up the serial numbers in tblMonitors. Simple.
I created a query called qryMonitors_Test, added all fields from tblMonitors (not using the * option). I then set the SerialNo field criteria to the contents of the cboSerialNo on the new form. Simple. For now I'm ignoring searching on anything else.
I ran the query with no search parameters before I added the criteria, and it obviously displayed all the records in tblMonitors. Fine.
After adding the criteria (using Build...to prevent typos), I used the form to select a serial number, run the query and get no results returned.
If I copy and paste the same serial number and change the SerialNo criteria in the query to search for that it works fine. As soon as I tell it to search for the combo box contents it returns no data.
This is driving me completely bat-poo. It's nothing I've not done a squillion time before but it just refuses to work. I've got to assume it's a query issue as opposed to a form issue, but things don't get much simpler than this should be!
i have created a form based on a query and basically the form comes up as a whole page spread and i would like it to just come up as a small form instead of a whole page. i think i go into properties and then choose the actual form but i just need to know how to make it so its small.
Hope this explanation is adequate
Thanks
Nicholas
I am making a simple tabular form to use as a subform in another.
The form has a cbo box (cboItem_Name)
Quantity (txtQuantity)
Price (txtItem_Cost)
Extended Price (txtExtended_Price)
Selecting an item in the combo puts the price in txtItem_Cost. Default for Quantity is 1. Control Source for txtExtended_Price = [txtQuantity]*[txtItem_Cost] and gives me my extended price.
I have a control in the footer of the form called txtSub_Total. It's Control Source =SUM([txtExtended_Price]).
This Sub Total box generates the #error.
Can anyone tell me why? Do I need to do some other magic with my txtExtended_Price control instead of a simple calculation, like I have?
Thanks for any help you can give a novice.
Im not that expert in access programming, still have some more learning to do. anyway, my goal is to make a simple login form with a database of its users. How do I code it. The structure of my form is it has 2 unbound txtbox and 1 command button. A user will input its username and password then when the command button is clicked it will validate the user table if the data encoded is in the database. Thanks hope u can help me.
View 5 Replies View RelatedI have a form, where the users choose a name from a pull down box and enter the date and other information. The pull down box has more than 100 names. The information such as the name, date, etc. gets stored into a table. It is fine if a certain name appears more than once on the table. I want to create some code, where if I click a button, it counts how many times each name appears in the table and outputs this information. I want the output to have the name in one column and the number of times it appears in the second column. Any ideas on how I could do this. I am very new at access and VB. I would appreciate your help. Thank you. (Basically I want to see how many times each name has filled out the form)
For example,
smith 3
doe 4
bell 8
Hello. I'm trying to design a simple database for a bicycle recycling charity. I hit a brick wall when realising that I had never before attempted to update a record. :eek: Until now I've just used Access to add new members to a bus user's organisation.
If the shop takes delivery of 20 tyres, I need to add 20 to the current stock.
Is it possible to achieve a simple Form that adds to or subtracts a quantity from current stock, or do I have to learn some access programming?
I've looked through some textbooks and can't find a simple update solution.
Thanks for any suggestions. :o
I am trying to update the value in one field (RUS Prop Class Document) of a form based upon what is selected in another field (RUS Prop Class Code). I plan on this being a hidden field so I was creating an after update expression in [RUS Prop Class Code]. My problem is that the value returned is the very nice and working query but not the value of the query. I'm missing something that I think is simple but cannot figure out with my limited resources and late hours.
Here is what I have for the after update expression in [RUS Prop Class Code]:
Private Sub RUS_Prop_Class_Code_AfterUpdate()
[RUS Document].Value = "Select [tbl_List of RUS Classifications].[RUS Prop Class Document] " & _
"FROM [tbl_List of RUS Classifications] " & _
"WHERE [tbl_List of RUS Classifications].[RUS Prop Class ID] =" & Me.[RUS Prop Class Code] & ";"
End Sub
Thanks ahead of time
Hi... I searched quick, didn't find anythign, but you guys are so responsive... :D
Question:
Part 1. On TimeSheet form, I want to click to "create new job", and the Jobs Form opens, at a new record. Currently it opens at record 1.
Part 2. I foresee that when I return from the modal job form, the old form (timesheet) would not have updated the combobox to show the jobname I just entered.
I guess this is what subforms are, because I keep reading about them, but dunno what they are.
Thanks
-Reenen