Flo100
Last Activity: Mar 19 '08, 05:53 PM
Joined: Jun 29 '07
Location:
-
Adding selected records from a populated recordset to an empty recordset
Hi,
I have a recordset which I have populated with a query.
I have an empty recordset.
I would like to take value of a field in every single record, which is a string.
Search if the 4rth letter of the string is an 'a', and if yes add that record to the new recordset. Finally i want to output the resultset onto a report.
I need some help please. -
Image compression and comparison
I have two images. one is a CAD diagram and another is a scanned picture. They are not in the same scale. The CAD diagram is my original. I need to resize the scanned picture to the sme scale as the CAD diagram and compare to find out how these both differ.
Please help me find a strategy to program. Should I use Matlab or VB? What is a better approach to the problem? -
populating combo box both with a query and value list
Hi All,
I have a combobox that I am populating using a query but after that I also want to add just one item at the beginning or the end of this list. Is it possible?
-Florence -
I got it. My first mistake was in the [QUESTOR Run tbl] the field [Project ID] did not have a space meaning it was [ProjectID] and there was a single quote missing after 7.3
My mistakes were silly. sorry about that. And thank you very much for helping....Leave a comment:
-
I just tried like what you described above. it still gives me the same error....Leave a comment:
-
Yes I did, Infact I tried icluding the full name for each field like :
INSERT INTO [QUESTOR Run tbl1] ([ID], [QUE$TOR Version Name], [Project ID], [Cost Tab], [GROUP], [Item], [Quantity], [Unit Rate], [Cost])
SELECT [QUESTOR Run tbl].[ID], [QUESTOR Run tbl].[QUE$TOR Version Name], [QUESTOR Run tbl].[Project ID], [QUESTOR Run tbl].[Cost Tab], [QUESTOR Run tbl].[GROUP], [QUESTOR Run tbl].[Item], [QUESTOR Run tbl].[Quantity], [QUESTOR...Leave a comment:
-
Thank you very much. I used the same and now it gives me a Run time Error 3079: The specified field '[Project ID]' could refer to more than one table listed
in the FROM clause of your SQL statement. Where is the mistake? I am talking data from one table [QUESTOR Run Tbl] into [ QUESTOR Run tbl1]....Leave a comment:
-
INSERT INTO statement in Access
Hello,
I have a table [QUESTOR Run tbl] and a duplicate table [QUESTOR Run tbl1] whose definition is smiliar to T but is empty without any values and also no primary key. my task is to
insert into QUESTOR Run tbl1 some values from QUESTOR Run tbl
I used the following Query:
INSERT INTO [QUESTOR Run tbl1][ID[, QUE$TOR Version Name[, Project ID[, Cost Tab[, Group[, Item[,... -
Thank you. I got the jist of your idea....Leave a comment:
-
I have multiple updations to be done on same field....Leave a comment:
-
Query:
SELECT [Q].[QVN], [Q].[PID], [Q].[CT], [Q].G, Sum([Q].C) AS Cost
FROM qryP INNER JOIN [Q] ON qryP.[PID] = [Q].[PID]
GROUP BY [Q].[QVN], [Q].[PID], [Q].[CT], [Q].G HAVING ((([Q].[QVN]) Like '7.3'));
This is the query whose record set i want to edit. I want to edit values of [Q].[CT] in which there are fields like Drilling 1. Drilling 2, Drilling 3....so on, which i want to make just "Drilling"...Leave a comment:
-
I got the answer:
I will modify query definition every time user selection changes. I can open the results of the query in a recordset and then modify the recordset as follows:
Sub test(strQuery As String, strField As String)
Dim db As Database
Dim rec As Recordset
Set db = CurrentDb()
Set rec = db.OpenRecordse t(strQuery)
Do While Not rec.EOF...Leave a comment:
-
Create and Update a table
I have a form with a combobox on it. Based on user selection, I want to create a new table in the current database, define it and update it with values from a query, which again is based on user selection.
Can somebody please help me? Thanks a lot. -
Refreshing Subform and the results displayed
I have a subform on a main form. I want the subform to display result from a saved query "qryMain" on button click event. Now in another button click event I modify the definition of qryMain. I want the subform to refresh the results displayed to reflect the current definition of the query.
I can do a Subform.ReQuery maybe but I am not able to do it and I think because the subform has kept the qryMain open it is not able... -
My main problem is that the table structure is not proper and I need to work on it as it is given. But I figured out how do it. I simply created each subquery as another query. Thank you very much for your help and concern....Leave a comment:
-
Refreshing results displayed on the subform
I have a subform that i created in a main form, which I am using to display results of a query. There are different controls on the main form that make a query. The subform, so has to display the related results. There is a button click event in which I am making the query. I donno how to refresh the subform so that it reflects the results of modified query.
Please help. Thank you. -
Is my intention in joining three queries into one not right?...Leave a comment:
-
My actual query should look something like this:
Select Q2.[QUE$TOR version name], sum(Q2.[Cost]) from (Select [Q] .[QUE$TOR version name],[Q].[Cost Tab], sum([Q].[Cost]) as Cost FROM [Project Run tbl] as [P] INNER JOIN (Select [P].[Project ID],[P].[Onshore only] FROM [Project Run tbl] as P INNER JOIN [QUESTOR Run Tbll] as Q ON [P].[Project ID]=[Q].[Project ID] GROUP BY [P].[Project ID],[P].[Onshore only] HAVING [P].[Onshore only]=yes)...Leave a comment:
-
Syntax error(missing operator) in query expression [P].[Project ID]=[Q].[Project ID] (Select [P].[Project ID],[P].[Onshore only] FROM [Project info Tbl] as P INNER JOIN [QUESTOR Run Tbl] as Q ON [P].[Project ID]=[Q].[Project ID] GROUP BY [P].[Project ID],[P].[Onshore only] HAVING [P].[Onshore only]=yes)
This is the error....Leave a comment:
No activity results to display
Leave a comment: