Search results for query: *

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

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

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

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

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

Hi, I am looking to find out how to create code to make a command button affect the value of 1 field in a table for EVERY record rather than just the one being shown. I have a field called BALANCE that I would like to be increased for every record when a command button is clicked on the form...

Hi, I have a form which contains the fields SUBSCRIPTIONS, VAT and TOTAL_BALANCE. The VAT field is worked out using the value in the SUBSCRIPTIONS field and the total of the 2 is shown in TOTAL_BALANCE. The problem is that the VAT is more often than not using 3 digits after the decimal point...

I have a main form called Member with a subform called Member_Payments Subform linked by the Primary key MembershipNo. The subform shows all payments made by the member currently shown on the Member form. A field called Running_Balance on the Member form needs to show whether a payment has been...

I have 3 tick boxes that affect the value in a text box on the same form called Subscriptions_Balance. They all work individually but not together. Is there a way to write these so they work together as both the Direct_Debit and Reduced_Subscriptions need to know whether the EC_Through_Igem is...

My database contains a few tick boxes that affect the value of a text box on the same form. Direct_Debit is the name of one tick box that reduces the total by the amount shown in a text box called Direct_Debit_Discount and displays this in a text box called Total. Has anyone any suggestions...