Search results for query: *

Thank you, I will give it a go!

Hi, problem is I am not sure what to do with this code and I need to include it in a query. I have the straight forward DatDiff working but this counts all days and I need to take out weekends. Most of the coding examples don't seem suitable for queries. Thanks, Viv

Hi, Please can anyone tell me if there is a simple way to find out the number of working days (Mon-Fri) between 2 dates without having to use a form? I need to know the total working days and would like to be able to include it in the query criteria. Any help greatly appreciated, Viv

Hi, Thanks for your suggestions....managed to get it working using the Mid function.

Hi, I am using a database which has a field called start_time in an Interview table, this is type: Date/Time. The problem is that data shows like this in the query result: 01/01/1900 10:30:00 I would like to extract only the time part but this doesn't seem to be working. Any ideas so I can...

That was really helpful, thank you. :)

Hi, I have a form which you can use to drill down for more information by clicking on a particular field. This works fine but the cursor doesn't make it obvious that this is a link. Is there any VBA that can be used to make the cursor change style when over the link field? Many Thanks

Hi, Thanks for the suggestion. I just tried this but unfortunately it changes all records again regardless of whether they meet the condition or not.

Hello, I have 2 fields on my form called 'MembershipNo' and 'Status'. I would like the 'MembershipNo' to turn red and bold when the 'Status' is not 'Live'. I have done this but it changes ALL 'MembershipNo' fields to red regardless of what the status says. I have the following code: If...

Hello, I have a field called Age which is calculated when a date of birth is entered using the code: Me!Age = DateDiff("yyyy", [DOB], Now()) + Int(Format(Now(), "mmdd") < Format([DOB], "mmdd")) The problem is that this field does not update automatically when the date changes. Is there a way...

I would have to write 8 update queries and have a to run them all, I just wondered if there was any other way around it? No such luck! Thanks, Viv

Hi, Yes the balance for each member is a field in the Member table, the fees are in the fees table and the calculations are performed in VBA on the member form. I can't change this design now as we have members entered and as it would have been a 1 to 1 relationship between Member and...

The database has a form called Member, when I created the form I selected 4 fields from the two Fees tables linked using the Membership_Grade, as the total amount payable by each member is made up by 1 fee field or adding 2 of the fees fields together. To work out the total amount there is a VBA...

Hi, I have done this and it appears the new database is in 2000 without me having to convert it. Everything imported ok and all the VBA is there so fingers crossed this solves my problem. Many Thanks!

I have made a copy of it and saved it elsewhere but the option is still missing, is this what you meant? Thanks, Viv

I created a database in Access 2000 and had to convert it to 1997 so that other people could use it straight away. We have entered in all the data (several thousand records) and now I need to make some changes as we've discovered missing/too short fields etc. I have tried converting it back to...

Hi, Every time I click on a command button or enter data that affects calculated fields I get the error 'Module Not Found', if I click Ok it opens up Microsoft Visual Basic. This started happening after I entered a record it said was violating the PK then closed it without saving the record and...

Hi, Every time I click on a command button or enter data that affects calculated fields I get the error 'Module Not Found', if I click Ok it opens up Microsoft Visual Basic. This started happening after I entered a record it said was violating the PK then closed it without saving the record and...

Hi, 2 issues I need to find out about: 1) I have a database which will need to store members details that all have a unique MembershipNo, the Primary Key. There are over 4,000 members already existing with their own MembershipNo, I have to insert these into the member table (from a...

Thanks, got that sorted too...I've managed to contain all the calculations in the VBA on AfterUpdate and Enter etc. Thanks for you help!