This Is Frustrating!!!
May 30, 2005
I have a form called frmFinanceProposal
on the form is a sub form called "frmFinanceProposalDialogue1"
The main form refers to my subform as "Child845"
On the subform I have a combo box that I am trying to set a filter on in the design grid of the row source
I have tried nunerous options to refer back to another combo box on the same sub form, but am getting no joy in forcing the filter
I have tried
Me!Combo57
Me.Combo57
Forms!frmFinanceProposal!Child845!Combo57
etc etc
Pls help!!!!!
View Replies
Dec 14, 2005
Hi,
I have looked through every book I have and spent hours on this but just cant get it right.
On the "menu" tab, select a customer then go to the "Calls" tab. Within the top subform is the list of telephone calls. In the below subform is the detail of the calls taken.
The problem: When I select a call, the details does not update in the form below.
Anyone willing to take a quick look? many thanks in advance.
Attached db1 (A97)
View 4 Replies
View Related
Jul 28, 2006
Hi Guys,
I'm trying to create a simple form that allows me to enter information about a new customer into my database. I've normalized Addresses into another table. I've attached a stripped down example of my problem to this thread.
Everything works fine when I'm viewing exisitng records, but when I go to add a record, I enter the name and phone number of the company (native to the main form), and go to add the address informaion (native to a subform in the address form), I get a message saying I need a similar record in the Addresses table and I cannot proceed...
But I'm trying to add that record to the addresses table!!
Please guys, whats goen on??!?
View 1 Replies
View Related
Jul 19, 2007
Hey all,
Just found the forum -- love it. I'm hoping it'll help me out with a lot of my problems. I've extensive experienced coding for PDAs, and with other databases or VBA-based programs, but I've just run into a frustratingly simple problem with an Access database I'm building for medical school (I'm a second-year med student).
Here's the situation: I've two linked tables -- e.g., TblNeuroQuestions and TblNeuroAnswers -- in which the primary key in both is the Question # field. I've created a form to easily enter data enter the questions table (question #, question, and 5 answer choices.) What I want to do is have the question text automatically be copied into the corresponding Question field in the TblNeuroAnswers table, so that I don't have to do it manually (the structure of the TblNeuroAnswers is merely Question #, Question, Answer (A,B,C,D,E), and Explanation). In other words, I want the entry of the question data in the main form (the NeuroQuestions form, which enters data in the TblNeuroQuestions table) to automatically be entered in the corresponding Question field of the TblNeuroAnwsers table.
It seems like it should be an easy thing to do; run a simple update query, for example. But I'd like the form do dual entry, so to speak. Any suggestions?
View 2 Replies
View Related
Nov 13, 2006
I am trying to pull my information together for printing and also sending attachments. I have a field whose type is set to memo.
I have created 2 select queries, one pulls all of the information together except for the memo field, the other pulls the OrderID and the memo field. I then created a 3rd select query which merges those two back together (This is the only way I have been able to get this to work in the past).
Now, whenever I run the query, the notes field is trashed... All that is displayed is a few strange Chinese characters and that's it.
Someone please help with this, as it is a very big problem. Thanks!
View 2 Replies
View Related
Nov 30, 2006
been trying for hours to fix a problem. my db was working but now when i open one of my forms it opens with a enter paremeter value box saying
Forms!frmServiceDateSearch.txtSearch
and then the second one saying
Forms!frmServiceDateSearch.txtSearch3
its probably something really obvious that i just cant spot.
any ideas?...they shouldnt and were not appearing.
thanks
View 1 Replies
View Related
Dec 2, 2006
Hi guys,
not sure which section to post this so i hope here is ok...
ive made an input mask for a postcode field. problem is its really annoying having to click the beginning of the field to enter data in the correct area of the input mask. Is there a way to automatically set the cursor to the beginning of the input mask/field when it is clicked?
thanks, James
View 3 Replies
View Related