Search results

Hello, If any of you can help with the following query, i'd be most grateful as I'm new to access. I've got a database which logs and tracks calls coming into the building on a daily basis. On an average day, the same customer may ring more than once. So when I enter their name on the entry...

Thanks very much for your response Jack. That now works a treat ! Natasha.

I have a form in my DB which shows the following : Date From(listbox), Date To(listbox), Country(combo), Area(combo). Once data is selected in these fields, a report is run based on a query. On occasions, I would like to run the report for all area's or all countries, so I have added (all)...

Thanks for that. As it happens, that's exactly what I'd decided to do anyway. As an extra though, On there, I have a link to a utility I use to backup my main database. On this utility, I have to browse in the path the my database. Is there a piece of code I can use to ensure the backup...

Hi All, Not sure if this is possible or not, but here goes. I have about 5 databases that I use at any point during the day. Is there any way of setting up a very basic Database or form, which will have links to all my other databases on it. So If I click on Button 1, it will take me to the...

Hi Anauz, I wonder if I could trouble you for a copy of the sample Db. It is exactly the sort of thing I've been looking for for ages now. Thanks. My e-mail is Natasha_Parker111@yahoo.com Thanks. Natasha. x

Hello, Can anyone please help me ? I have a form in my DB which has a combo box on it, giving a choice of areas (London, Leeds, Liverpool etc) Whichever value is chosen from this box, the relevant data will appear on the report. However, what I'd like to know is, is it possible to show the...

Hi Pat, Many Thanks for your response. I have done as you suggest, and it almost works. What now happens is as follows : I have date/time (all in one box), then I have an hours between box and a minutes between box. Lets say box 1 is 01/01/01 09:00 and also box 2 is 01/01/01 11:30 the...

Hello, I am using the datediff function to find the number of hours between two dates. However, if possible I'd like to calculate the minutes as well. i.e my code is TxtBox3.Value = DateDiff("h", TxtBox1, TxtBox2, VbMonday) Obviously, I know the problem is due to the "h", and I've looked at...

Hello Everyone, I wonder if anyone out there can help me please. I have a form, which has 2 combo boxes on it(lets say country and city - obviously each country having x number of cities e.g. France => Paris, Bordeaux, Nantes etc etc) Once you select the country, you then select the area. 4...