[QUOTE=Scott Price]
Thank you for the help but some how my db got currupted so now i have to rebuild the portions I was not able to recover. I will use our conversation as guide once I begin rebuilding. Thanks for all the help I appreciate it....
ali3n8
Last Activity: Dec 5 '07, 08:55 PM
Joined: Aug 20 '07
Location: Orlando,FL
-
[QUOTE=Scott Price]Almost there! Try this:
[CODE=sql]
SELECT tblnotes.[Notes ID], tblnotes.[Notes 1], tblnotes.Custom erID FROM tblnotes WHERE tblnotes.Custom erID = Forms![YourCustomerFor mName].[YourCustomerIDC ontrol][/CODE]
Regards,
Scott[/QUOTE
Here is what my code looks like now:
[CODE=sql]SELECT tblnotes.[Notes ID], tblnotes.[Notes 1], tblnotes.Custom erID
FROM tblnotes
WHERE...Leave a comment:
-
I created the sep. query and here is the sqlview is this what I want:
[CODE=sql]SELECT tblnotes.[Notes ID], tblnotes.[Notes 1], tblcustomerinfo rmation.Custome rID, tblcustomerinfo rmation.First, tblcustomerinfo rmation.Last
FROM tblcustomerinfo rmation INNER JOIN tblnotes ON tblcustomerinfo rmation.Custome rID = tblnotes.Custom erID;[/CODE]Leave a comment:
-
Ok kew i understand that, Here is whats happening everytime I add to the query my search function no longer works here is the sql info for my query what do I need to add to it? Currently this query is associated with tblcustomerinfo rmation.
[CODE=sql]SELECT tblcustomerinfo rmation.Custome rID, tblcustomerinfo rmation.[File Status], tblcustomerinfo rmation.[File status Reason], tblcustomerinfo rmation.[Contact Number], tblcustomerinfo rmation.First,...Leave a comment:
-
What do you mean by "[customeridcontr olname]"? Im assuming the field name for my customerid? To be honest im not really understand this portion. I can make simple queries but this seems a bit out of my scope. I hate to ask this but if you could spell this out to me it would be much easier. And also I dont use the customerid on my search form on firs,last,zip,s tate,contact and verification.
Thank youLeave a comment:
-
Actually it did work im just a dee dee and had mispelled somethings in my code. Thank you much I appreciate it.Leave a comment:
-
Here is how my search function currently work. My frmsearch list its results in a subform. I have it set to were when I click on the field [first] it will open the record and populate it into the form that the information was collected on. On this form I have a button labeled add/view notes. So i would like to see this work using my current method which is search record, click on first name to open record in form, when i click add view notes I would...Leave a comment:
-
[CODE=sql]SELECT tblcustomerinfo rmation.Custome rID, tblcustomerinfo rmation.[File Status], tblcustomerinfo rmation.[File status Reason], tblcustomerinfo rmation.[Contact Number], tblcustomerinfo rmation.First, tblcustomerinfo rmation.Last, tblcustomerinfo rmation.Spouse, tblcustomerinfo rmation.Street, tblcustomerinfo rmation.State, tblcustomerinfo rmation.City, tblcustomerinfo rmation.[Zip Code], tblcustomerinfo rmation.Apartme nt, tblcustomerinfo rmation.[CC...Leave a comment:
-
Thanks for all the help Scott, If you could assist me with the query on this I would appreciate it I havent been so succesful with it. I have a search form which uses a query called qrycustomerinfo rmation. The form looks up the following fields:
[First]
[Last]
[Verification]
[ContactNumber]
[Street]
[City]
[State]
[Zip]
When I use this search form it pulls the record just...Leave a comment:
-
Thank you I tried your method and it does work to the extent that it shows the follow up date on my report Im just still not able to pull a report via date range Ive entered this into the critera row for FollowupDate to >=[forms]![frmReport]![txtDateFromfoll owupdate] And <=[forms]![frmReport]![txtDateTofollow update] I am using a form to enter my date ranges. Unfourtunately I have still been unsucessful in achieve a date range for this paticular...Leave a comment:
-
I have tried entering the formula in the criteria field for the query also, is this what you were speaking of?Leave a comment:
-
Double Click on Name Field to show record
I am using a search form that list records in my database. On the list that shows the records that have been found I have a field called First. When I double click on this field I would like to open that record in the form it was inputed on. I have been partially succesful doing this by using this code:
DoCmd.OpenForm "frmcustomerinf ormation", acNormal, , "[First]='" & Me("First") & "'"... -
I have gotten date range to work on several of my reports just one specific one is giving me a problem. Im running the report from a query called followup. When I run this report it comes up blank in order to get data to appear on it I have to switch the report to design view and enter an expression which I will get to. The Fields that I have on this report are:
Followup - Date/Time which has a default value set as =DateAdd("m",3,[Order...Leave a comment:
-
Blank Report
Hello, I have db and I am attempt to create a report to extract specific information from it. Im running the report from a query called followup. When I run this report it comes up blank in order to get data to appear on it I have to switch the report to design view and enter an expression which I will get to. The Fields that I have no this report are:
Followup - Date/Time which has a default value set as =DateAdd("m",3,[Order... -
Ok it does prompt me for mydate. But this is causing issue with other functions in my db. I have a search form and now when I open that it prompts me for my date first before I can begin to use a search form. I am assuming that I need to create seperate query for the report rather than running the report from the query I use for my search form. Am I right by saying that?...Leave a comment:
-
Worked like a charm. Thank you so much I appreciate the help. This has by far been one of the most helpful forums that I have been a member of. Thank youLeave a comment:
-
Im curious is it possible I am getting this error because I am not saving the record before I enter the notes?Leave a comment:
-
Yes I did insert it into the sql view.
Thank YouLeave a comment:
-
I did that and it did not prompt for any date?...Leave a comment:
-
So Im getting to the end of this I just created a test entry in the db and i still get the error "You cannot add or change record because a related record is required in the table 'tblcustomerinf ormation'. If you like I can email you a copy of what I am creating.Leave a comment:
No activity results to display
Leave a comment: