Search results

........ I looked at the references and it looks fine. Both computers are the same. John-

This is a strange error. I can not believe I am having so many problems today. When I am running this query on my computer I have no problems. So when I run it on an end users computer it does not like this statement. RTrim([ADDRESS]![CITY])+', '+RTrim([ADDRESS]![STATE])+'...

SQL Database - Insert - Access Database??? How can you run a query to grab data in a SQL database and then insert it into a Access Table?

I got it! Actually ... I just found the solver! Thanks!

Is there a way that I could do an normal query inside of an insert query? Do you understand what I am asking? John-

When I link to an ODBC it uses my Network Login ID, instead of an assigned Login ID. How can I give it an Perminate Login. My login on my network is: jmcgover I want it to use the administrators: sa How can I get this working?

ARGH!!!! Since last Thursday, I had no problem running any linked table in Access from my computer. Now I am getting this RETARDED ERROR: Connection Failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for user '(null)'. Reason: Not...

... It works now.

Can anyone tell me what is wrong with this statement that I am using on Reports? =IIf([JOBTITLE]='GRM', ([Salary]-[InterimPD]-[SessPD]+[DistTravelAmount]) –[TaxShlt] – [MedTaxShlt], ([InterimPD]+[SessPD]+[Salary]+[DistTravelAmount])- [TaxShlt] – [MedTaxShlt]) The error message I get is... "The...

nope... That option did not work. This is what the error said. Connection Failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login Failed for user '(null)'. Reason: Not associated with a trusted SQL Server Connection. To view the error please...

I get a user 'null' error. When I do this... * = Errors on this line. sSql = "DELETE FROM dbo_MemberMaxNonMetro" * CurrentDb.Execute (sSql) When I run the app. it works fine. But when I run it on the end users comp. It errors out. We have the same DSN Setup and everything else...

On the Query I used this function: NZ((GeneralAmount),0) = 4325.25 I want it to be formatted on the report as = 4,325.25 So I set the textbox on the report as Format = Standard But the format option does not show up at all. Has this happend to anyone else? John-

Thanks..."The_Doc_Man" I tried on what you said to try and it works out great. Thanks for all your help! John-:D

CODE: strValues = "(((dbo_UPR00100MBR.EMPLOYID)='" & Me!txtMNumber & "'))" DoCmd.OpenReport "YearEndStatement", acViewPreview, , strValues END CODE: ------------------------- ERROR: it says that: The Specified field 'dbo_UPR00100MBR.EMPLOYID' could refer to more than one table listed in the FROM...

thanks! Thanks OPENGRAVE! It works.. Nice UserName!!!!!

On that image as I have shown. The Query called Main is the main query that I am running... I am using TEXTBOXES. I would need to use the TEXTBOXES and then click on an enter button to run the query... strWhere = "(dbo_UPR00100.EMPLOYID BETWEEN '" & txtSEmpNum.Text & "' AND '" &...

I am experiencing a lot of problems with XP lately. It even shuts off my computer while I am on the internet and then it re-boots me. There is alot of fixes for XP. They shouldn't have released it with getting ALL the bugs out of there. For your question. No I haven't.

I have this query in access that has multiple queries in it. How can I put a condition on the VB side so I can call the Access Report with the condition. There is this one query which is the main query called "Main" that all the other queries run from. I want to select a range of Employee...

I linked up my table through my SQL server. Everytime that I click on the table I get this message... ODBC--Call failed [Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect sytax near '.'. (#170) I get that message EVERYTIME that I click on any table that I linked up. Please...

THANKS! You Rock!!! Thanks a million. it works now!