Recent content by masterkale

Hi, Bascially i have a calendar set up in my DB. The issue is that i now have 2 ways of where Bookings can be made. So what i need to do is get the data from both tables and fill the month calendar form to view. Is there a way that i can merge 2 queries? At the moment i have a single query...

Hey, Nana Thanks for the response. I ended up manually coding a Right Click menu that deletes then i can trigger what ever i want after wards... :) Thanks for your help. Cheers

Hi, Sammy You lost me there with that. You should be able to set the combo box to a query like this. Select foodID, FoodName, FoodPrice from food Well something like that anyway. In VBA columns start off at 0 not 1. So if the combo box actually has 3 columns like above, it is actually column...

Hi, Banana Ihavnt heard of these.... what do they do? >>BTW, any particular reasons why you aren't using BeginTran, CommitTran, Rollback? I cant seem to find the after delete trigger.... have looked on the net any help would be appreciated. Cheers Tristan F

Simply make the Combo box have more then one column and set the column widths to 0. Ounce you have done that click on the combo box go to afterupdate event. go into the vba then you would type something like this depending on your db. txtcost.value = cmbfoodsale.column(2) Cheers Tristan

Hi, Banna Thanks for your response. Unfortunetly it seems after confirm delete hasnt deleted the data yet. Form update isnt triggering... I feel sad. lol, 4 + hrs ive spent on this. Maybe im doing something wrong. I have a normal transactions form with a datasheet sub form, when i delete on...

Hi, Basically I have a transactions form, i have a trigger for after update. For the form which executes some query's and gives you the total. But the real issue lies in when i do a DELETE, because i cant get it to trigger the sub routine which stores the quereies calculations to run. So my...

Why dont you add another field in called quantity and default the value to 1, so then if they have more then 1 "Coke" they can just rverse tab back or go back and change it to the amount the cusomter is buying. I dont know exactly how you have set this out. But i would most likely do the table...

Ok. Normally you have a subform(normal form view). You can only scroll through the records up and down... What i want to be able to do here is scroll through them horizontally. So the records go across instead of up and down. Cheers Tristan F

Hi, Basically as the title says. Im trying to make a form where the sub forms records scroll across horizontally instead of vertical. Is this possible if so how? Cheers Tristan F

thanks guys... I will check it out brian... Cheers Tristan

Thanks. Sorry for my ignorance, but how would you structure so you get a column that has, dd/mm like this > day(mydate)/month(mydate). Would access handle that properly..? Im just aunable to test now, will check when im home tongiht... Cheers Tristan F

Hi, I was wondering is there a way to only QUERY day and month? dd/MM ? The issue is i need to build a report that has all the accounts opened within a certain month/time period. BUT its not year specific so i would need for instance. 01/02 to 28/02 dd/mm dd/mm Note: The date stored in...

Hi, Guys Im just wondering what the maximum number of simultaneous connections to an ACCES 2007 DB over a network,(obviously a mapped drive). I apologize if this is a double post.... Cheers Tristan F

Thank You Verry Much....