Search results

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

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