I have a form with a combobox based on a query of a lookup table. If the name entered is not found in the combobox, I want a popup form to open allowing the user to enter a record for this new name in the lookup table, then close. What is the best way to this? A command button? The Not in List Event? A msgbox? I'm not sure.
View RepliesI have a contact dB with 2 contacts (main & alternate). I would like to be able to pull any record containing either the main or alt last name up. Right now the unbound combo box works fine pulling up the first contact name but I need to be able to pull up a record if the second contact name matches as well. I am trying to use 1 unbound combo box to look at both fields (LastName1 & LastName2). Is it possible and how should I set it up?
View 14 Replies View RelatedCan anyone help?
I'm having trouble storing autofilled data from one of my forms and I was wondering if anyone has any ideas.
My data is as follows
tblProducts
ProductID
Description
Nett
tblPurchaseOrders
PurchaseOrderID
PODate
Supplier
tblPurchaseOrderDetail
PurchaseOrderID
ProductID
Description
Qty
Nett
Now I have a standard order entry form which works fine, my problem is with the subform:
frmPurchaseOrderDetail
ProductID
Description
Qty
Nett
On my form Description and Nett are auto populated referencing ProductID but this information does not transfer to the table tblPurchaseOrderDetail. The main problem is that a nett price can occasionally chanege (inflation) but I need to be able to look back to a particular order for audit purposes and be able to see what I paid.
I'm sure there is w way round this, but I've been unable to figure it out. I've gone through loads of different threads on the forum and as a result am sure it can be done, I've also looked at the examples posted by several users, but none seem to approach the lookup quite from this angle, does any one have any idea...sorry for the long post, thanks.
Hi all,
I am wandering if anyone can help me here. I have a form which is linked to a table called tbl_File. Within in this form & tbl_File there is a field called Country_Code. In the Country_Code field the user places a number that corresponds to their country they want.
Now Country_Code & the corresponding country is defined in a seperate table called tbl_CountryCodes.
What I would like to do is in my form once the user has inputed a number in the Country_Code field (it will be a combo box), a label or textbox in the SAME form will then do a search of the corresponding Country name in tbl_CountryCodes and then display it to the user.
Any ideas will be greatful :D
Karv
I have my main form which is connected to my main table - Query 1
I have a lookup table (actually a view from SQL Server) which holds my user name - the username used to login to the database- just one value.
In my main form I have a 'Logged By' field. I want this field to default to my login name when I process a record.
I thought it would be as easy as connecting the lookup table to my main form and then in default value typing My_login.user_name.
Apparently not. It just has the #Name? in there.
Anyone have an opinion on this ?
I can use the =environ("username") in the default value which works to good effect but different users use each others PC and I would like the field to be defaulted to thier database login and not thier windows on.
Please help ! It seems so small and its driving me ceeerazy !
Okay, for simplicity's sake, I have a data entry form.
It is bound to tableData.
Inputs are:
ProductID
Customer Name
ProductID is a combo box.
There is another table called tableProduct. In this table, is ProductID and ProductName.
For convenience sake, when a user chooses a ProductID from the combo box, I want it to lookup that ID from tableProduct. However, how can I do this when everything is already bound to tableData?
Thanks in advance.
Okay, for simplicity's sake, I have a data entry form.
It is bound to tableData.
Inputs are:
ProductID
Customer Name
ProductID is a combo box on the form.
There is another table called tableProduct. In this table, is ProductID and ProductName.
For convenience sake, when a user chooses a ProductID from the combo box, I want a separate textbox to lookup that ID from tableProduct and display the ProductName.
How can I accomplish this?
Thanks in advance.
i am working on a school database, in data base i have create two tables tblAccounts and tblTransaction and a form frmTransaction .
tblAccounts contain two fields
GLcodes
Description
and frmTransaction contain
Glcode
transaction type
debit
credit
date
narratives
in form when i enter a glcode, lookup field match the code from tblaccounts and shows the description in form against gl code.But i am facing a problem when i enter a wrong gl code my form accept it and move to the next field and when i leave blank field of glcode same problem that i am facing, i want that , when i enter a wrong glcode in a form amsgbox will apear that asking for correct glcode.
I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple.
**************************************************
Scenerio:
I have 2 forms. The first form is my main form and the second form is my "popup" form. Both of these forms access the same table. In my main form I have it so people can not enter in a ID so it reduces accidental data entry. Therefore, I created a "popup" box that allows ID entry.
Everything works great except when I close out of the popup form, the newly entered data is not available unless I close the main form and reopen.
Million Dollar Question:
How do I refresh or requery (dunno the correct term usage here) the main form to reflect the addition I made in my popup form. I would like the refresh event to happen when I click the close button on my popup form.
**************************************************
Again, I know this is probably simple, but I cannot find it anywhere or most likely I am blind :cool:
Thank You
I tried all sorts of permutations of the requery command but apparently I'm too dense to figure it out.
Form 1
subform 1 > button to open pop up form
subform 2
subform 3
I'm trying to requery a combo box (inside of subform 1) based on a table that is updated from the pop up form.
On pop up form close, what's the correct syntax for re-querying subform 1?
I'm working on an invoice system for a company and they reqiure notification when an account is called up on a form that has an outstanding invoice.
So I created a query that locates all unpaid invoices, I made a form using that query, and I want to use it as a subform on my main invoice page.
But I'd like this subform to only popup when the criteria is met, that is the name on the subform matches the name on the current invoice called up.
Right now the subform is blank when the criteria is not met, and fields are filled out when they are...but I'd rather a nice big popup that can really get their attention...any idea if this is possible on Access 2000?
Thanks!
I have made a message service in access db using a pop up on timer even.
It works fine but sometimes it does not load. My db is split db and so what ever I am doing, doing on my machines only. So is there any way to check if a form is loaded and if its loaded then do requery.
On opening the form, i want to give a command with Move To command to move to the right upper corner. Is there any such command ?
View 1 Replies View RelatedI'm not sure how to search on this, even in the advanced search. If this has been answered, could you point me in the right direction?
I have a main form AddNewCompany (the infamous tab control that now works - thanks to your combined efforts). On it I have a command button that pops up a form of continuous forms with all the companies in the table (the query calls the CompanyID and CompanyName fields only). I have attached an image of the interface.
This means the user can see if the company already exists and doesn't enter it again. (I'm sure there are more effecient ways of doing this, but this is simple and it works. I also know key fields should be autonumbers instead of text, but I have reasons for doing it this way).
What I would like to be able to do is click on the CompanyID field and have the companies information show up in the main form.
Can anyone see what I am doing wrong?
I have a main form that has a tab control on it. The main form is called frm_AddNewCompanyContacts. It is opened in edit mode. To see if a company exists I use a command button to call a popup form with a list of all companies' IDs and names. I then want the user to be able to click on a commad button on the popup form to take the main form to that record. After an intial post, and subsequent search, I found the appropriate code. This is what I am using for the onclick event of the command button on the popup form:
Private Sub cmdGoToCompany_Click()
Dim rst As Recordset
Set rst = Forms![frm_AddNewCompanyContacts].RecordsetClone
rst.FindFirst "[CompanyID]='" & Me![CompanyID] & "'"
If rst.NoMatch = False Then
Forms![frm_AddNewCompanyContacts].Bookmark = rst.Bookmark
End If
End Sub
When I click on the command button I get an error message:
"The expression On Click you entered as the even property setting produced the following error: A problem occurred while Microsoft Office Access was communication with OLE server or ActiveX Control (I don't have an ActiveX Control).
*The expression may not result in the name of a macro, the name of a user-defined function, or [Even Procedure].
*There may have ben an error evaluating the function, event or macro."
How can I make a button in a pop-up form to send enter key to a text box in another form? Do I need to set focus to the other form first? And how?
View 1 Replies View RelatedI have a 'main' table with a Project_Number that links all the data in my db together. I have another table that uses that Project_Number as a lookup field to connect that tables data to the main data. I created a 'main' form that has the ability to enter data for the 'main' table. I want to be able to press a button and have the second tables form pop up and add that that specific Project_Number. I added the button and went through the wizard process. I then added the linking info through the builder. It works fine if there is already data entered for the project_number in that specific field. but if the field is empty, the popup window doesn't recognize a project_number and doesn't add it to that record. below is what I am using. The project_number in the 'main' table is text and the Project_Number in the 2nd table in a number since it is a lookup field.
Private Sub CongressionalDistrictCmd_Click()
On Error GoTo Err_CongressionalDistrictCmd_Click
Dim stDocName As String
[Code]....
I have two tables - Interviews & Placements.these tables have multiple foreign keys which pull information from other tables (CandidateID,ClientID etc). I have designed queries and forms (datasheet view) which display all the values that I need, For example:
The interview form shows the following fields:
CandidateName;Company;consultant;1stInterviewDate; 2ndInterviewDate;Offer;Accepted
the placements form shows the following fields:
PlacedCandidate;Company;Consultant;PlacementDate;F ee;
This query "qry_Interviews" populates these forms using the foreign keys:
CandidateID from candidates table
CompanyID from companies table
consultant from consultants table
Ideally what I'd like to happen, is when the "accepted" field is updated on the interviews form, the placements form opens as a pop up and is auto populated with the values (CandidateName;Company & consultant).So far I have tried setting the value directly, i.e on the "on Open" event of the Placements form I entered:
Me.Txtcontactname = Forms!ISISnavigationMain!navigationSubform.Form!DS .Name
This does not work. Should I be populating the placements form with the actual Foreign key values rather than the resolved names? Ideally I'd want the pop up placements form to display the actual names rather than just ID numbers.
Hi All,
I have a form that has a combo box and a subform. After a choose the value of the combo box I want to start adding values into the subform, and I want to be able to select the values that are to go into the subform fields. Now I am thinking of using a pop-up subform which shows the values that I can choose from and then as I close the form it will populate the fields of the main subform.
Is it possible and has anyone got a little example of form that can do that. If so can you put it as an attachment to this post.
Thanks
Greg
Hi
All my popup forms come up at the wrong size. I have popup = yes, modal = yes, border = dialogue box settings. I have tried this with both autoresize on and off. One form comes up to small and one comes up to big. I've tried changing the size of the form in design mode, but this has no effect.
Could someone please help me pls?
Thanks.
I have a [frmMain] form which i would like to run maximised.
I also have a button on the [Main] that opens another form [frmAdjust]
in Popup mode, because i do not want this form to be maximised.
The problem i have is that when i return to the [frmMain] after closing
the [frmAdjust] i want to update a subform [subAdjustment] on return.
The Event i would like to use, the Activate event is not fired on return
from a form with the popup property set. The GotFocus event of the form does not
work either.
Which event would i use for this or how could i get around this.
I can't seem to get this to work. I have a Mainfrm with a Subfrm. On the Subfrm I have a field that has to be a concatenation of two inputs. To do this I have created a PopUpfrm for that field that has two list boxes. The user then chooses one from ListA and one from ListB. This populates an unbound field (fldCode) on the PopUpfrm. I need to pass this data to the original field on the Subfrm.
I've tried:
Forms!Mainfrm!Subfrm.Form.Field1 = me.fldCode
and every possible iteration of this that I can figure out.
Any suggestions on how to pass this information back to the Subfrm.Field1?
If I run just the Subfrm, w/o opening the Mainfrm everything works great. I guess I just don't know how to reference that field when it is actually in the Mainfrm.
Thanks in advance
Greetings all!
I am new to access and trying to build a database but having some real issues with the pop up search. Its a database with personal information so I created three forms
1. FrmMain = The initail navigation page which has just buttons and no records. When you click the cmdFind Resident button, it takes you to the second form...
2. FrmPop Up Resident with Record Source: Resident Name (from FrmResident Parking) . This form has 3 controls; 1textbox (Type Resident Name with Control Source: Resident Name from FrmResident Parking), 2 cmd button (OK and Cancel)
3. FrmResident Parking. This form is supposed to open the Resident Info based on the info entered in the 'Type resident txtbox in the pop up form but does not work.
I have been trying to get this work in Design view but no luck.
I created...
A macro: Find Resident with the following properties...
Form Name: Resident Parking
View: Form
Filter name: Left blank
Where condition: [Forms]![Resident Parking]![Resident Name] Like [Forms]![Pop up Resident]![Type Resident Name]
Data Mode: Left blank
Window Mode: Left blank
In summary what I want to acheive is that; when a person opens the database, they get the FrmMain and if they click find resident to main page, the Pop up form comes up and they type in a name then click ok. This then should open the record on a new form (Resident Parking).
I dont have any queries just one table.
I am not good at VB so any help especially in design view will be very much appreciated
I'm sure this is simple and I searched the forum but I was unable
to find an answer so..please help! (btw, newbie here);)
I have two tables with a 1 to many relationship.
I have two forms based on each table.
Table1 has a key field called ECO.
Table2 has two key fields, ECO and ItemNumber.
When I have form1 open I use a button to 'pop up' form2.
Form2 shows only records that have ECO value = to Form1.ECO value.
When I create a new record on form2 I would like to have form2.ECO
auto filled with form1.ECO value. This is where I'm stuck!:confused:
Btw, I cant use a subform, already have too many!
Thanks!
Hi All.
Is there a way show my own popup form instead of the standard "You are about to delete 1 record(s)" when deleting a record?
I have taken a look round and couldn't see that this was posted already......but apologies if it has already.
Frank. :confused:
Hello all, I have edited my question to be clearer as I realize some might not understand what I posted earlier.
I have a form with the source from a query.
I have about 15 fields in my query, but users of the query regulary use about 5 of the fields.
How can I design my form such that on clicking the form, a set of text boxes comes up with fields from the query.
I found a post that I could use something like this in my query but that I needed to create a button on the form that would run the query.
Here is an example of the criteria I put in one of the query fields:
[Forms]![Manager]![Vendor] or Forms![Manager]![Vendor] Is Null
The problem is, on opening the form, I get a Name# error on each of the fields that have criteria in them.
Also, is there a way that I don't need to use a comman button on the form form, just by doubleclicking it will bring up text boxes and then I can put in the criteria needed.
What happens if I don't fill in one of the text boxes, would it only return results when that field is blank?
Please help,urgent.
Thanks again.