Search results

Hi NeutronFlux - yes option one , I have found a bit of code to do just that. I have very basic VBA knowledge so its a learning curve but tweaking the code a bit I have part of this working sort of. No PDF output in Access 2003 so using rtf which works ok. Cheers

Thanks for your promt reply David. I had an idea it was going to be complicated, still no harm in trying and I might learn something. Russ

Can't find the answer to this so here goes: I am putting together a DB to register volunterers on an event using Access 2003. The event will run for a number of days and volunteers may take up a number of different roles. I have a volunteers details table I have a Volunteersroles table ( these...

Hi - I have set up a simple database to collect meter readings from users, this works ok but to improve it further I would like to restrict entry between 2 dates i.e. 15th and 19th of any given the month ( readings are then submitted on 20th). I have done a search but can't find anything, would...

The solution came to me overnight and its simple. I just needed to use an update query by referencing the updated table. The ' Update To ' criteria is [tblProducts].[Prices]. I was over thinking this one. Anyway thanks Steve for your suggestion.

Hi - just lookign for a little assistance with an update problem. Not sure if this can be done with a query or if I will need to use VBA. Access 2003 I have 3 tables; Orders Products ProductOrders On my Orders form the ProductOrders are in a subform which uses a Dlookup to insert the unit...

Many thanks for this Dave Really appreciate the help. RussG

Hi - I have done a search but can't find exactly what I need. I have an order database and the product prices need to be updated by 2% from April 1st. I have tested running an update query which works fine, I have also tested the same against futire orders dated from 1st April and the update...

Resolved this, created a seperate query to filter by time and added to my main query. RussG

Yes , definitely Date/Time field with the fornmat set to Medium Time. Apologies this question also appears under the heading Parameter Query, my PC crashed at work when I was posting and I thought it was lost. Thanks RussG

Thanks for your reply. Thats won't work for me. I need to look at a range of dates i.e. 1st - 7th July and return 'Events' that happened say between 1 & 3 pm for each of those days so I need to seperate the dates and times. Thanks RussG Sorry double post, PC went ga ga

Thanks for your reply. Thats won't work for me. I need to look at a range of dates i.e. 1st - 7th July and return 'Events' that happened say between 1 & 3 pm for each of those days so I need to seperate the dates and times. Thanks RussG

I am having a problem setting up a parameter to filter times. My table collects ' event ' dates and times data in separate fields. I have set the time field to 'short time'. In my query I have a parameter to filter dates i.e Between forms!frmDial!date1And forms!frmDial!date2 and this all works...

I am having a problem setting up a parameter to filter times. My table collects ' event ' dates and times data in separate fields. I have set the time field to 'short time' 00:00. In my query I have a parameter to filter dates i.e Between forms!frmDial!date1And forms!frmDial!date2 and this...

Thanks for your quick replies. The DB is at work so cant try anything at the moment. There are odd bits of code in the report, setting the section to 'can grow' sounds like a possibilty. Not back until Tuesday, will try and let you know how I get on. Thanks again. RussG

I have a memo field on a report which is set to grow but when there is a lot of text not all of it is showing. Using Access 2003, any ideas what could be happening? Thanks RussG

I have solved my problem. I created another query to find the max CountOfVisits without including the venue field and then another query where I joined the 2 queries together by joining on the MemNo and CountOfVisits fields. I knew there would be a simple solution............. Cheers

Thanks for your suggestions, I had already tried the Max function and have now had a look at DMax but am no further forward. I can return the max number for the domain but I need the max number for each member. for example my query returns the count of attendances at each venue for each member...

Hi - I have a query to return the number of transactions by each member at various venues. I have grouped by member no and added a count to return the number of attendances by each member at each venue. What I need to do now , for each member, is to filter this further so only the venue most...

Thanks for your message David , this leads me back to my comment in the original post about conflicting advice on this issue. RussG