Search results

I am having this problem and I am thinking that I need to convert the data. Data: 7,300.00 600.50 400.40 What I am getting: 7,300.00600.50400.40 What I need is: 8,300.90 What I am doing is: [SessPDm] + [InterimPD] + [DistTravelAmount] I have Access 2000. Any help would be great.

How can I run a macro in VB that the macro asks for a parameter. How could I pass along the parameter to the macro? This is how I am doing it... With appAccess.DoCmd .RunMacro "ApHistry" .RunSQL "UPDATE APHistory SET..... "...

How can you add a variable from VB to an Access Reports Page Header? Any suggestions? John-

I am getting this error: Syntax Error in date in query expression '((APHistory.POSTEDDT Between #01/01/2003# AND #11/31/2003#))' Can anyone help me with this? John-:confused:

In my visual basic application I am accessing my Access macro. I set the Warnings Off. But, there is this parameter that needs be to be passed. So when I run the macro, the parameter does not come up and errors occur. How do I over come this? John-

VB to Access - Password Protected DB. I am trying to connect to a Access 2000 DB from Visual Basic 6.0. Is there a way that I can pass in a password for the end user that would not have to type it in? This is how I am accessing it: Private appAccess As Access.Application Set appAccess =...

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?

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?

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

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-

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

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

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

This might be an easy answer or maybe a difficult one, depends on how you look at it. I am working on Visual Basic Application and I am calling an Access 2000 report within VB 6.0. Some computers need to have both versions of Access 97 & Access 2000. On the computers that have just Access...

I am getting this error on the end users computer. "FUNCTION NOT AVAILABLE.. RTrim(dbo_UPR00100MBR.LASTNAME)+', '+RTrim(dbo_UPR00100MBR.FRSTNAME)+' '+RTrim(dbo_UPR00100MBR.MIDLNAME)" Can anyone tell me why this is not working? I also tried just using TRIM() and that still does not work. I...

Can you tell me what is wrong with this code... =IIF([DFC] => 11000 AND [AGE] => 50,"12000", (IIF [DFC] => 11000 AND [AGE] < 50, "11000", [DFC])) I keep on looking it over and can not see it anywhere. It tells me.. "You May Have Entered In A Comma Without a preceding value or indentifier".