Search results for query: *

Hi, Where would i specify the end location?

Hi, Im new to VB6 programming and wanted to know how i would use a similar function like the sql server substring in vb6. what i want to do is scan a text file in coloumns 19-20 and if it contains the value '10', carry out a specific command. If it doesnt i want to run anothet piece of code...

Does anytone know if its possible to use PHP within .NET???

Hello, I have this error message when i try to open a form. My coding falls over on this line..... Me.Button2.Image = CType(resources.GetObject("Button2.Image"), System.Drawing.Bitmap) Infact even when i comment out this line it falls over on the next line that refernences an image. Here is...

Hi, I just have a quick databinding question. I have 2 forms...... Form1 is my main form containing all the controls i want to bind the results of my query to. Form2 contains a datagrid containing a list of guests in the database. The user can click on a row to select a guest. They then hit...

Hello lBass Here is alittle background on my data..... This is what my 2 tables look like: Menu (MealName(PK), MealCost) -contains a list of all meals provided by the company. Meal Bookings (RoomNo(PK), BookingDate(PK), Session(PK), MealName(PK), MealQty)...

Hello lBass, I have tried both the left and right join. The left join from Menu.MealName = MealBookings.MeanName works fine. I can see all the meals listed on my report even where the meal has not been booked. Thx for detailed explanation above :o) The problem i have is more to do with the...

Hey lBass, Im almost there. I have removed the record selection formula and i have added the formula and created a right Join From Menu to MealBookings The report nopw correctly shows all the maels from the menu table. :o) The only problem i have now is that the report does not seem to be...

Hey Ibass, I have the following record selection formula: {Meal_Bookings.RoomDt} in ({?DateRange}) i tried changing this formula to what u suggested but i get the following message: The result of a record selection formula must be a boolean. What am i doin wrong? This is what i...

I tried this but it didnt work for some reason. Im i right in saying that i set this option by right clicking on the 'database fields' and selecting 'Visula linking expert'. I then right clicked on the link and selected 'linking options'. I tried to select both the right join and the left join...

Hi, I have created a report from 2 tables: Menu (MealName, MealCost) Meal Bookings (MealName, MealQty, BookingDate) The report is supposed to show all the meals and the amount of times they have been booked. between a specified date range. Therefore i want it to show the all the meals on the...

Hi, Just a quick question. Does anyone know how i can display the date that is selected in a parameter field. i.e i have created a date-range parameter and i want to display the range that the user selects on my report. for example. The date this report is for is ?DateRange I have tried...

Hi, I am having problems doin calculations on arraylists. I have 2 Arraylist...... 1) MealTypeArrayList - contains a list of meals chosen by a user. 2) MealQtyArrayList - contains the corresponding quantities required. The index value directly relates to the MealTypeArrayList...

Hi Ibass, I tried to left click on my report and select insert>field object. The problem i have is that the 'field object' is not available in the menu. For some reason the option is greyed out!!! The options i have are: Special field, Text Object, Subtotal, Grand total Summary...

Hello Ibass, How would i use the method u suggested? Im a complete beginner to crystal reports and am just fumbling my way around. I tried looking up running totals in my book and help files but had no luck!! Is this a method via coding or a wizard. Would really appreciate a walk-thru if u...

Hi, This is what i have tried and i cant seem to get the correct value. As the query returns 3 rows for room 1 i get a total of 60 instead of 20!!! The row for room1 has to repeat as the guest has made 3 equipment bookings within that room. Room 2 shows the correct value as there is only a...

Hi, I have created a virtual table using the 'Add Command' when specifying a database. The problem im having is that the data that is returned from the query is causing problems when calculating formula sum fields!! The data is regarding a room that a guest can book and also the equipment that...

Hi, Im trying to write a sql expression but it does not seem to accept any of my sql statements!! this is what i tried.. Select max{Booking."BookingNo"} from Booking Is the something im doing wrong? I want to be able to select a number of values for the booking number that is the highest in...

Hi, I have added a number of textboxes onto a crystal report and i want to somehow bind these textboxes to the result of a query. Is this at all possible?? If it is can anyone give me any pointers about how to do this? thx

Thanks so much for your help Kris. This is exactly what i was looking for. :o)