Search results

Are there any Access programmers in Finland interested in some freelance work on a small company database? I can forward details to anyone interested.

Brtilliant, thanks. Easier than I thought ... sometimes the answer is just staring me in the face ... !

Is it possible to have a specific form to open automatically whenever an Access Database is opened for the first time? How ..? Thanks ... Steve

Mousemat, I checked your file, but it does not actually email a graphic created in the original report, at least not when I added a graphic in using insert object or insert picture in report, save, and then run the form. Do you know any trick to actually send the graphic that is saved with the...

Will do .. thanks a lot ... :)

Hi Shay, I checked again, and the only thing I could find that was different was that your form source was "Hotels Qry" and mine was something different, a table called "Booking Details". M calculation is now in a sub-form, not a form. Do you think either of those 2 factors could be causing...

Hello Tay, Thanks for that. I didn't write the code, so I am not sure ... I don't think there should be any data differences, though with regards the code, I'm not even sure how to check. Hopefully Shay knows ...

I wnet through all the field names etc and triple-checked all items same as the text form that did work - there were a few minor differences which I corrected - mainly that I was putting a value in "Contol Source" where you did not. I then put back the whole code and got a NEW error message ...

Hi again, I cut some of the code text as you suggested - now giving below - it made the same error - I checked all the names etc and they seem all OK ... : Public Sub CalculatePrice() Dim TotalCost As Integer, ThisDate As String, NoDays As Integer, i As Integer, rst As Recordset MsgBox...

Hi again Yes, sorry, I had just RoomTyoe in there, though had cmbHOtelName etc for the others ... Now, I out the dates in again and got an error message that we got before, so I KNOW we are near the finish line! Error was that there was a "Missing Operator in Query Expression" Code I have is...

Hi Shay, So nearly there with the price calculation thing - I transferred all info over to my main database and made the tables, changed the names etc. I put in some text dates and got the following : Compile Error : Method or Data Member not found. Checking the code, it stopped at...

Hi Shay, So nearly there with the price calculation thing - I transferred all info over to my main database and made the tables, changed the names etc. I put in some text dates and got the following : Compile Error : Method or Data Member not found. Checking the code, it stopped at...

Thanks Shay, Will work on this, and hopefully just let you know that is all worked fine! ;)

Hi Shay, It works !!! I calculates correctly for different room types and also over the price range .... THANK you sooooo much for that! You are a GENIUS! Now ... just the small matter of taking the code etc over into my "real database" .... it will eventually appear as a sub-form to a...

I am not sure if this was the cure, but I went to my Windows control panel, and changed the default date to / instead of . ie, 23/06/03 instead of 23.06.03

Hi Shay, Yes, it now gives the Hotel ID .... AND : I get a price!!! You are correct, it does not take into account the Room Type. but ... now the error has gone. Are we getting there ?!

Thanks Shay, for your time again ... its very weird it works on your machine and not mine! Anyways ... the Hote Name comes up, not the Hotel ID ...

First, I should mention that the form you made DID work when this other person had amended the code to check the Day of the Week, such If day is Saturday Price = 50, if Sunday Price = 45 etc. Then it worked! So, it does actually function, just that when we work on the dates it doesn't ! I...

Hello Shay, I changed the date format as you suggested : Set rst = CurrentDb.OpenRecordset("SELECT [HotelPrices tbl].[Price] " _ & "FROM [HotelPrices tbl] " _ & "INNER JOIN [Hotels tbl] ON " _ & "[HotelPrices tbl].HotelId = [Hotels tbl].HotelID " _ & "WHERE ((([Hotels tbl].[HotelName]) = '" &...

Hi Shay, Thanks for the red marks - actually it was just my typo in the original code as I had to type it off the error message box (it would not copy and paste) and missed those 2 punctuation marks ... they are in fact there on the original. The actual code where there erro appears is (and...