The jet database engine does not recognize 'tblComments.re fSAR_ID' as a valid field name or expression
Can anyone tell me what am I doing wrong here?
This is the query in question:
Code:
SELECT tblBalance.SAR_ID, tblComments.Comment FROM
fd1
Last Activity: Jan 17 '11, 07:42 PM
Joined: Sep 13 '07
Location:
-
jet database engine does not recognize...
I have a query that works fine when it's run on its own but when it's included within another query it breaks the other query and I get the following error:
The jet database engine does not recognize 'tblComments.re fSAR_ID' as a valid field name or expression
Can anyone tell me what am I doing wrong here?
This is the query in question:
... -
Lost data from table
Hi All,
I just encountered a weird problem. I opened a table in an Access 2003 db in design view and added 2 new columns and saved it. After opening it, I realized that one of columns called "Date Created" (default value set to Now()) just dissapeared and got replaced by a column called Gen_Notes with some random numbers in it.
I went back in design view and tried to add the column "Date Created" again but it wouldn't... -
I'm running the code above as a .vbs script so I guess I am using it outside Excel vba. So what's the alternative? running the code in an Excel macro?Leave a comment:
-
kadghar, I tried it but still got an "unknown runtime error" on the same line where Borders property is used.Leave a comment:
-
Excel vba
Hi everyone,
I'm getting error when running the following vbscript that formats an Excel sheet. It complains that object doesn't support the property "Selection.Bord ers".
Is the code for adding borders correct?
...Code:Dim objXL Dim boolXL Dim objActiveWkb Dim filePath filePath = "C:\Test.xls" Set objXL = CreateObject("Excel.Application") -
Disregard, I figured it out:
Code:IIF(tableB.date1 Is Not Null, tableB.date1, tableA.oldDate)
Leave a comment:
-
Update query
Hi All,
I have an Update query that updates bunch of fields in tableA from another tableB. For one of the fields (a Date field) in tableA I woud like it to be updated only with a non null value, meaning if the new value from tableB is null, do not update. I tried to use under 'Update to' the following expression:
but it didn't work. Any ideas?Code:IIF(tableB.date1 Is Not Null, tableB.date1)
Thanks -
Substitute "tblJobHours.Mo nth Is Null" with "Forms!frmRepor tInfo!Combo2 Is Null" and "qryStaffName.S taffName Is Null" with "Forms!frmRepor tInfo!Combo11 IS Null" and see if it works....Leave a comment:
-
Add "Or Is Null" to the Criteria.
Ex:
[Your message here] Or is Null...Leave a comment:
-
Thanks ADezii, exactly what I was looking for :)Leave a comment:
-
Distinct records
Hi All,
I have a table with 2 fields: 'Ver_Number' and 'Delivered_Date '. Both fields are not unique. There's over 100 records in that table.
How can I write a select query to select distinct 'Ver_Number' from its duplicates that has the latest 'Delivered_Date '
Thanks -
The legend I have currently has text like 'Sum of...' and I would like to change it to something more descriptive....Leave a comment:
-
I did that, only thing I found is the Record Source which has the table name where data is coming from. When you create a chart using chart wizard, in the chart properties, there is a RowSource field that contains the query behind the chart. I need to change the text in my legend box and from what I learned, the only way to do it is to tweak the RowSource query for the chart....Leave a comment:
-
RowSource for pivot chart
Hi All,
I created a pivot chart using Auto Form Pivot Chart. I'm trying to get to
the RowSource query behind my chart but can't seem to locate it. I need to change the
legend text. Any ideas?
Thanks -
I cannot move the Title to the Plot Area, I can only position it top,bottom, right or left. I'm using Access 2003.
There has to be a way in code to insert string text within the Plot area....Leave a comment:
-
Add text to a chart
Hi All,
I created a pivot chart in my Access database and was trying to figure out a way to add some text within the Plot Area of the chart. Is there a way to add a label in that area when in Design view?
Thanks -
Never mind, I just had to use Mid() instead of Mid$()Leave a comment:
-
Data Type mismatch error
Hi All,
I'm getting Data Type Mismatch error when I run the following query:
Both "Definition " and "Descriptio n" are of type text.Code:SELECT tbl1.Definition, tbl2.Group FROM tbl1, tbl2 WHERE ((Mid$([tbl1]![Definition],6)=Mid$([tbl2]![Description],9)));
-
Thanks mlcampeauIt, it worked now after adding the condition for date1 in the WHERE clause which was missing in your code.
I like the fact that I have 2 sets of code to work with, that way I'm able to verify results....Leave a comment:
No activity results to display
Leave a comment: