Search results

ok Thanks. Is there a way that you could give me some example? This is what I am doing.... Private appAccess As Access.Application strWhere = "(dbo_UPR30300HSE.AUCTRLCD = '" & txtATCode.Text & "')" Set appAccess = New Access.Application appAccess.Visible = False...

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

hmmm. Ok ... I got it working.. It was missing a reference... It was just strange. Thanks for your help! John:D

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

GREAT! VAL() worked Great Thanks!!!!

Is there a way to make a string field into a value field in a query? John-

CANCEL THIS POST! I have figured out what I was doing. john-

I got these 2 queries that I am working on and I need to join them both together. Here is my delema. 1. First Query has a total of 13 Records cause it has a certain criteria in it that says select the record with this type of deduction code. 2. Second Query has the main database and has...

Hmm First.. How would I know how many pages are in the report? Second.. I would not know the totals unless I program it in everytime that they run the report. John-

I tried forcing a page break but it still does not look good at all... and the MIGHT WORK didn't but that is expected. John-

Thanks Thanks pitou I got it working!!! Thanks for the advice! John- :cool:

On My Page Footer I have a field that says PAGE TOTAL and then on the Report Footer I have a field that says GRAND TOTAL. Every time that I run the report it gives the Grand Total first instead of the Page Total. How can I switch it around? John-

I get this error message on my Report before I run it. "Multi-level GROUP BY clause not allowed in a subquery" :confused: Here is my query: PARAMETERS [Beginning date] DateTime, [Ending Date] DateTime; SELECT dbo_UPR30100.GRWGPRN, dbo_UPR30100.EMPLOYID, dbo_UPR00100.SOCSCNUM...

How could I print out data that is on the main form and then all the records that are on the subForm? I tried using a Print command but I can not find out how to do it. John-

It is FIXED!!! http://support.microsoft.com/default.aspx?scid=kb;en-us;q216311 John-

Is there a way that I could put a total amount for a page in Access? For Example: Page1: 6,500 - Displayed on page 1 Page2: 3,500 - Displayed on page 2 Page3: 5,000 - Displayed on page 3 Grand Total: 15,000 I tried using.... =SUM(AMOUNT) in the page footer and I get nothing... John-

GREAT! Thanks! I can not believe that I never noticed that. John-

This is what I am trying to do. I have this program that a few endusers have. They have a shortcut to this application and when they want to do some work on it they go into the program. Is there a way that you can have it automatically startup with the main form? I hope that I explained it...

I was wondering in the Query department... Is there a way that I could have this.... SELECT dbo_UPR30100HSE.GRWGPRN, dbo_UPR30100HSE.EMPLOYID, dbo_UPR00100HSE.SOCSCNUM, RTrim([LASTNAME])+', '+RTrim([FRSTNAME]) AS Name, dbo_UPR30100HSE.CHEKDATE, (HRSWKD = TotalHrs > 520 THEN "520" ELSE...