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 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!

This end user here is getting this error everytime that she trys to start the program. MICROSOFT ACCESS CAN'T BE STARTED Microsoft Access was unable to initialize the Windows Registry Rerun Microsoft Access or Microsoft Office Setup to reinstall MA. The program needs to have Access 97 and she...