Search results

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

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

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

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

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

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

Hi - I have read conflicting advice on this so wondered what members of the forum would recommend. I have a multi user DB , no more than half a dozen users. DB will be FE/BE and I have set the DB to compact on close. Obviously if another user has the db open this process won't complete. Are...

I have been developing a catering order system at work. A demo version has been in test and initial issues sorted. The users are very happy with the way it works and though far from perfect it does everything they asked for and then some. Basically, each order for refreshments/food creates a...

Sorry - duplicated post.

Hi - little bit of assistance needed. I have a report that groups on Dept then ChargeCode then Codegroup. I have sub totals for each Chargecode. Because 'Labour' is charged separately I want to have a total for all 'Labour' costs which are then deducted off the grand total i.e. Total of...

Hi - Hoping someone can help. I have a main order form which holds orderID , customer details, date etc I plan to add a subform which contains the ordered items , much like the Northwind order form. On my subform, because there are so many products I have added a cascading combo box, so I can...

Hi - Looking for some help which I suspect will be something obvious. I have a form that is based on a query, I am using the query as a record source so I can filter the form by a date range. On the form I have 2 combo boxes which use 'Lookup' tables to get their values. On the form-when I...

Hope someone can help. I picked up the code below from the forum. I am trying to allow a user to 'lock' the record they are viewing so other users don't work on the same record. This code would seem to do everything I wanted. problem is I can't get it to work. I get an error on this line...

I added a Search lookup Combo Box at the top of a form. This worked fine until I changed the Forms record source to a query. Don't quiet understand why this doesn't work now. Is there another way to achieve the same function. Thanks RussG

Hi - I used the wizard to create a search combo box on my form, i.e the selected item in the combo finds the associated record and fills the form. This works fine, however I have created a macro to open the from in Read Only mode and in this mode the Lookup combo does not work. When you make a...

I was wondering if anyone had any experience of integrating a product like QuickAddress (QAS) into an Access Database to aid the completion of address details. Thanks RussG

Hi - I have used shared workbooks successfully on our network before , but I now have a couple that although set to 'shared' , open in read only mode when already opened by another user. Not sure what is happening here, I have checked they are still set as 'shared'. Anyone have any ideas? Cheers...

Hi - about to dip my toes into what could be a fair size project (or me anyway). This is to develop a db/application to manage a departmental development plan. One thing they would like - and I am doubtful if it is possible - is to place bullet points within a field - this would be a field/table...