Search results for query: *

Hello It was the References in the Visual Basic - someone from IT came over to give me a hand but didn't know where it was going wrong, then when I showed them your suggestion he managed to get it to work... so thank you for your help!

I've just tried checking the References in Tools (found that I needed to be in Visual Basic to do this! Is that correct?). The same boxes were checked....

But if the report works OK on my PC (Windows 2000) then how can I have typed an expression incorrectly??! The report fails only on the Win98 machines The query runs OK on both Win98 and Win2000

Hi I have a basic report & query which I've set up in Access 2000 on a Windows 2000 PC. When collegaues try to run the report on their PCs, on Access 2000 and Windows 98, they get the following error: "Undefined Function 'Left' in expression". I ahve checked that the query works OK...

Firstly - sorry, I didn't realise I'd selected the Forms Forum... apologies In my report there is one record per passenger with the fields Booking Reference [BKRF], [NAME], and [CABIN]. The report is based on a query that only pulls records with bookings that have a double bed configuration...

I need to count the number of double beds required on a report. Currently the report is sorted by room number and then shows the people who are occupying the cabin (either 1 passenger or 2 passengers). If I do a Count by either CABIN or by BKRF (booking reference), =COUNT([BKRF]), then it counts...

I need to be able to show total numbers of bookings of twin and single rooms in a report. The rooms have different codes in the field [PKGE], so providing a list of people is no problem (sort by PKGE to get twins first, then singles). How do I count the number of twin rooms? If I do =count(*) in...

My Dad is new to computers and completed one of the free introduction course recently... he says he was shown how to put Wordart into a Textbox, now 6 months on, cannot remember how. I've tried inserting Wordart into a Textbox and into a Table, without success - it automatically is positioned in...

Thanks for your help GF - it did the job for me!

Hi Ken, Thanks for your answer - but I'm new to Access and most of that went over my head! I've managed to launch Excel the basic way: Create a Form in Design View, select Command Button from the toolbox, select the category "Application", then selected "Run MS Excel" - but...

I've designed a form with buttons that link to my reports in a dbase. I need to also add buttons that link to files in Excel. I have discovered how to launch Excel via a button on a form, but I can't get it to open a particular file at the same time. I've tried doing it through Visual Basic but...

Thanks PaulBricker for your help - I applied those expressions to my Report and it works fine! I couldn't find any examples of this in the Microsoft Help pages - so thank you.

I am new to MS Access and I'm having a problem summarising data in one of my reports. The data I have is linked to a Flight Information query which gives Surname, First Name Title etc and the Sex then Class eg Business, First or Economy I have managed to count the number of passengers using the...