Search results

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

Hi, Guys Im wondering is there a way to stop access saving fields automatically... Example you open up a form eg.frmEmployees (it has the employees details on it) You click in the address and change it but it was for the wrong person. You click close and IT SAVED IT AUTOMATICALLY :( Cheers...

Hi, Guys I'm building a simple time sheet database for a friend of mine. I know that im going to have trouble checking there amount against the tax table and taking there tax out to finalise the amount they would actually get. So basically im an intermediate access user, how would i get the...

Here is a calendar database that has multiple entries for each day.... Can't sort the entries by tiem on each day... if someone can figure this out and change it would be much appreciated... This was originally another guys calendar but was a little messy with the table, query, form namign...

Hi, Does anyone know how to use a rich text box in an ms access report and do formatting like 1 word bold the next one not and next line paragraph etc... Or how do i load a specific query in to a word document... The same as a report if you know what i mean... I need to have bold formatting...

Thank you for the post was exactly what i was after...... There isn't a shorter way by any chance though...??