Misc is a value or an item in the drop-down combo box.
Show is checked for the field in the query. I completely scaled everything down to just two tables and one field in a new db, trying to simplify for troubleshooting , so there is only a possibility of one field to show in my scaled down version.
From what I can tell all the VB libraries are there in the references.
Going to zip to scaled down where...
Ciara9
Last Activity: Aug 18 '07, 03:28 PM
Joined: Jul 11 '07
Location:
-
I am getting the same error message as before when I put the SQL code via copy/paste. I did change it slightly - since I have removed all my white spaces from my field names in order to lose the brackets such as [profit code] in the code - to simplify things.
When utilizing the Query Design Grid, I put the below string of code - please note I also change the cbo name and made it static with the other naming coventions:...Leave a comment:
-
Yes, I am using SQL view in Design Query mode.
In both instances of the two last data strings recommendations , I still get the same error message:
Invalid SQL statement; Expected 'Delete', 'insert', 'procedure', 'select', or 'update'.
Thanks for hanging in there with me. :)Leave a comment:
-
Thanks for the reference.
The answers to the others:
1. Copied and pasted this:
"SELECT tblLettersOfCre dit.[Profit Code] FROM tblLettersOfCre dit WHERE (tblLettersOfCr edit.[Profit Code] Like ’" & Me!cboProfCode. Column(3) & "'");
And I get, this error message: Invalid SQL statement; expected 'Delete', 'insert', 'procedure', 'select', or 'update'.
...Leave a comment:
-
I do have a subform in my form for comments. And I will try to say this without being misleading. Here it goes. :) So - yes. However, this subform writes to tblcomments. The idea is to pull up an account in frmLOC, enter info in the comments in the subform and write each comment to a new record in the tblComments table. tblComments is then related to another field in tblLOC to pull in all comments into each account displayed in the form, frmLOC,...Leave a comment:
-
Yes, the scenario is exactly as stated. I have changed the combo box to cboProfCode to clarify. When I entered the data string in SQL in the Query I got syntax errors. I played around with the quotes marks and finally removed them because no matter what I did, I still got syntax errors. This is what I currently have. Profit Code is the 4th column in tblLOC.
With the string of code below, I am now getting the error message...Leave a comment:
-
I am sorry that I have confused you, and I am still trying to sort thru your answer. I wish I could do a screen print that would be so much easier. :)
Let me see if I can explain this and I am going to use Profit Code as an example.
TblValues are only stactic values where I have listed about nine field names with values under each that usually will not change. This way if there is a change to one of the fields later,...Leave a comment:
-
Let me clarify, I am confused. Sorry.
Two tables: tblvalues and tblLetterofCred it
In my table, tblvalues, in the Column named Pro1Code, the value Misc is listed as the 10th Value. The user selects Misc from the combo box and then it writes to the column or field named Profit Code in tblLetterofCred it.
using your template here:
WHERE (((tblLettersOf Credit.[Profit Code]) Like Me!YourCombo.Co lumn(1))...Leave a comment:
-
The one that works, (data populated originally in table via text field in a form):
SELECT tblLettersOfCre dit.[Date Received], tblLettersOfCre dit.[Profit Code], tblLettersOfCre dit.[Profit Region], tblLettersOfCre dit.ProfitText, tblLettersOfCre dit.[LC Number], tblLettersOfCre dit.Applicant, tblLettersOfCre dit.[Transact Amt], tblLettersOfCre dit.[Process Type], tblLettersOfCre dit.[Transact Type], tblLettersOfCre dit.Rush, tblLettersOfCre dit.[Date...Leave a comment:
-
If you are saying run the query and see if the results are what I am expecting while working in design mode - then when I put in simple criteria such as:
Like "Profits5"
under one of the fields that is typed in by the user, then I get exactly what I expect. If I remove that, and then put the same type of criteria for one of fields that was populated via a combo box:
Like "Misc" ...Leave a comment:
-
Criteria in a Query Being Ignored When a Field is Populated by a Combo Box
I have a table of static values that I am acessing from another table to populate combo boxes. Next I have a form where this information is selected by the user and updates directly to the table. Everything works fine. I can create simple queries and reports with no problem as well as update the data. If I try to add any criteria, even as simple as using "like" to identify a value in a field of the table that has been populated by the... -
Thanks for the info. I was wondering if this was a viable option. :)Leave a comment:
-
Thank you. I will check it out.Leave a comment:
-
What I would like for them to search for would be only one field and unique; however, the search and replace functionality appears to be pretty much open to all fields. From experimenting with it, whatever field you click on prior to pressing the search button is the area it filters for on the entire table. That's why I wanted to at least turn off the replace capability and force changes thru the fields on the form.Leave a comment:
-
Thanks for the feedback and information.
Sorry, it's hard communicating when you are typing sometimes. :)
What I am trying to achieve is the ability to search for a record in a table on the same form where the data is entered. Once the record is retrieved, then I would like for the user to change the data by accessing the fields on the form. I am afraid if they use the replace feature, then they may globally change...Leave a comment:
-
Sorry but forgot to mention that I am placing this on a form and using the 2003 version. Thanks again.Leave a comment:
-
Disable Replace in Search and Replace Command Button
I created a command button using the record navigation feature, find record. Does anyone know how to turn off the functionality of the "replace" tab that gives the user the ability to replace the data in a table? I would like to give the user the ability to search and recall a record with the search feature in order to locate a record for editing; however, I do not want them to have the ability to replace any data. Any information would... -
Thank you. That worked just fine. :)Leave a comment:
-
Problems with writing data to 2 table using 1 form
I am using Access 2003 and have 2 tables. One has customer information in it (such as name,dates,amou nt, etc...) and the 2nd table is more of a Comments table (displays username, time and date, and the actual comments) about the customer account. I would like to have one form that gathers all this information; however, I would like it to write the data to 2 different tables. The form I am trying to use is based on the customer information table....
No activity results to display
Leave a comment: