I have a problem with a text box. If I show you how the output looks, you'll hopefully be able to help me sort it out.
Output looks like this:
'To facilitate the full and final payment of £0.00 ;on behalf of Royal Mail Group into
A SMITH'sbank account'
As you can see there's way too much space between each text box so is there a way that Access can shrink the box so that the big space doesn't appear? I would've done it all in one text box but some of the text needs to be bold so had to go in a different text box (or does it??!!).
I have a column which contains "text digit text" as "AAA 222 BBB". The numbers of letters or digits can vary.
I need to SELECT the column which contains digits in a specific interval. For Example I have "DFS 673 JKK" "A 3454 LJLJ" "SD 854 JKLJD"
I need to SELECT the column which contains 600 < Digit < 700 the result of the query in this case would be "DFS 673 JKK" because 673 is between 600 and 700.
So i have made a query which filters the text you type in your text box on a form. This is working great, but then this morning I had some records that contain some blank fields. My query does not show those records even if they contain the same text that I would type in my search form.This is my expression in my query of one column:
Like [Forms]![searchform]![Qprojectomschrijving] & "*"
Hi, How can I make the data in a textbox on my form automatically entered as the search criteria in a query. So say the box says Mike Johnson, can I make a command button (That I can eventually subsititute as the actual box) that puts the Nma emIk Johnson into a search query and brings up all the information on him from the database?
I have a table with a rather unfriendly field. This is legacy data so it is not possible to alter the way data was input.
The file contains text in the following way.
Word1 Word2 Word3 Word4 etc...
The number of words is not constant throughout the column.
What I would like to do is split this field, so that i get each Word in a new column, ie if there are 4 words in the field, i could run a make table to give me a new table with 4 new columns, each containing one word.
I am thinking about splitting the text at the spaces. that would work very well for me.
i have a form. i made a query , and i can see the query (there are 2 fields , and i want to see one of them) only in a subform , but i want to see the query in a simple textbox.
I am trying to make a courses registration database. I have 3 tables; tblContacts [ContactID], [FitstName], [LastName] [Etc..] [Etc..] tblCourseRegistration [RegID], [ContactID] [CourseID] and tblCourses [CourseID], [RegID], [CourseName], [StartDate], [AvailablePlaces] I have created a form called Test1 that displays The CourseID, CourseName, StartDate EndDate and an unbound textbox called PlacesLeft. I would like to display in this text box the number of places that are still available on a particular course. I've written a querie that counts the CourseID's in the course registration table this works ok but I want it to place the value in the PlacesLeft text box. Then I can do a simple calculation based on the PlacesAvailable textbox. Anyone any idea how to do this My querie reads SELECT Count([CourseID]) FROM tblCourseRegistration WHERE (((tblCourseRegistration.CourseID)=(Forms.Test1.Co urseID)));
I tried another method which includes a command button that when clicked tries to run the following Dim MyRS As ADODB.Recordset, strSQL As String
Set MyRS = New ADODB.Recordset strSQL = "SELECT Count([CourseID])FROM tblCourseRegistration WHERE (((tblCourseRegistration.CourseID) = (Forms.Test1.IDNo)))" MyRS.Open strSQL, CurrentProject.Connection, adOpenKeyset, adLockOptimistic
If MyRS.NoMatch Then Me.PlacesLeft = "" Else Me.PlacesLeft = MyRS.Fields(0) but Access (Ver 2000) does not like the noMatch and shows it as an error. I would be very grateful if someone could show me how to sort this out!
Quantity Product 80 F2 1.25" Fiberglass Sucker Rod 60 F2 1" Fiberglass Sucker Rod 80 1" coupling 60 7/8" coupling
what i am trying to do is multiply the quantity by 37.5 if [Product] equals one of the items that are sold by the foot and leave the other items the same
I have had a look at quite a few threads, but cannot find what i need. I am looking to show a command button if the value typed into the text box equals one of the values in the query. I understand how to show/hide a command button due to another post, but it is getting this to happen IF the text box matches one or more of the values in the query.
I have txtCustNo as the text box to type a number into I have qryCustNo as the query name i have cmdFindCust as command button
Should i have the code under the "after update" part of the text box also?
I am having problems with query results appearing in a text box. The query is filtered by two combo boxes on my form. The query works fine and gives me the correct results when I run it by itself and enter the required info.
These are the two control sources I have used for the text box (without the quotes, of course): "=qtotRecords!CountOfLast_Name" and "[qtotRecords]![CountOfLast_Name]"
Maybe including my query will help. The two control boxes on my form are cboSchool_Name and cboSeminar. This is my query:
SELECT Count(tblMain.Last_Name) AS CountOfLast_Name FROM tblMain WHERE (((tblMain.School_Name)=[Forms]![frmAdd]![cboSchool_Name]) AND ((tblMain.Seminar)=[Forms]![frmAdd]![cboSeminar]));
Could someone tell me how to put the out put of a query into a textbox in a form. I have asked this question on a couple of other sites but I still cant figuer this out.
I am a beginner so please make and easy explanation.
I have a form which allows me to search between two dates by using two text boxes. The code for the query behind the text boxes is:
Between [Forms]![name of my form]![name of text box1] And [Forms]![name of my form]![name of text box2] and it works great. However, I was wondering if it was possible to use the same two text boxes on another form running from the same query, or would I have to make another query for the other form? I have tried to use "or" in my statement, eg.
Between [Forms]![name of my form]![name of text box1] And [Forms]![name of my form]![name of text box2] Or Between [Forms]![name of my 2nd form]![name of text box1] And [Forms]![name of my 2nd form]![name of text box2] but when I try the text boxes it says "Enter Parameter Value".
Hi guys! I'm working on a project where I need to be able to use 4 different text boxes as parameter query. I need to use this boxes dynamically, could be text1 and text2 and text 3, or could also be text1 to text4, and/or text1 and text2. Here is the code I'm using right now, but it is not working. I placed this in the Criteria for field EmpID
Can anyone please give me an Access 2000 VB module that will concatenate [Portia - 1 query.text1] with [Portia - 1 query.text2] and type the result in textbox [Alltext]? Thanks.
I have a form with a text box and a query that has a criteria or [FORMS]![ThisForm]![ThistextBox]
Is i enter say "apples" in the text box then the query shows be all records with the criteria of apples. If i enter "oranges" it shows me all records with a criteria of Oranges, however if i enter "Apples" OR "Oranges" it return nothing
Why I can use multiple items in a criteria.
I have tried IN("Apples","Oranges") too and nothing works.
Hi, I've performed a search using a SQL statement which is based upon the results of two combo boxs.
Combo66.RowSource = "SELECT Product_Id FROM Product WHERE (Name_Suffix='" & Combo60.Value & "') AND (Name_Family='" & Combo56.Value & "');"
There will only ever be one result, I can display this result in a combo box without problems but I would like to display it in a text box. Is this possible?
I'm very much a newbie to Access so any help would be greatly appreciated.
I have a database with a query that returns a list of printers. This is created by finding all the printers in the database that take a perticular cartridge by code. Sample below.
PrinterName ----------------- Some Printer 1 Some Printer 2 Some Printer 3 ETC
What I want to do is take the results from the query and convert it into a single line of text and place it into a column of a table related to that cartridge code.
So if say the cartridge code '12345' returns a list of printers such as;
printer 1 printer 2 printer 3
I want to take this data and turn it into a line like this;
printer 1, printer 2, printer 3
I then want to take this new line and place it in a column called Desc in another table relative to the original cartridge code.
table should look like this after query. BEFORE: CartCode | CartDesc | Price | Desc 12345 | Something here | 10.00 |
I'm trying to set-up a database that will allow the user to navigate around by clicking but having a bit of trouble.
I was wondering if there is anyway to capture the text that you click (if you make it a hyperlink or something) so that you can use it as the parameter in a query or something?
I want to create a query where the field being reference is an employee ID in a purchase orders table.
I have a sperate employee table with all the employees in and the employee ID in the other tables is set so that it displays the name in the forms.
I would like to set the query up so that when i type the name into parameter query or search form it is not looking for the employee ID number but the employee name that is typed?
I have some code that creates a dynamic "Append To" query. The problem is that when the code is run it creates the query but generates a Data Type Mismatch error. I have tracked this down to a [clientnumber] field which is formatted as text in both the main database and the one the Append to query is updating.
The client number appears as a criteria and this works for finding the client's record but it will not append it unless I enclose it in quotes. When it's in quotes it works fine.
Can anybody give me a clue as to how I can include, in the code, a formatting command that makes the information inserted into the criteria field appear enclosed in quotes. Or-
Perhaps explain why the problem exists when both fields are formatted the same in both the main table and the Appended To table.
HI! Can Anyone help me with this? I would like to put query results(one column) into one text field? Is it possible that results could be in such textfield separated? Thanks in Advance
I made an database with all addresses. When persons live in an appartment, then the field "busnummer" will be filled in with a number. When they live not in an appartment, the field "busnummer" is empty.
In a query, I made an expression and filled the expressien in field (in the query):
Expr3: IIf([Busnummer]>0;"bus [Busnummer]";"")
When "Busnummer" is greater then 0 THEN write the text "bus" and the value of the field right behind, else leave the field empty.
The result of the expression above is: "bus [Busnummer]"
I have already tried the following: Expr3: IIf([Busnummer]>0;[Busnummer];"")
The result of the expression is the number I filled in in the database. Now I want to have the result: bus and the number I filled in... :)