Search results

Hi I wonder if I anyone can help me. I have a number of queries to calculate the Date a call is due excluding weekends. This works by 1. Adding three days to Date. 2. If Day is Saturday or Sunday then add extra days. 3. If End Date is Saturday or Sunday then add extra days. While this...

Hi all I had a fully working database that I decided to clean up by standardising naming formats etc. I have changed the tables names and changed all VBA links etc to the new table names. This all appears to work fine. The database is still doing exactly what it should be doing. The only...

Thanks Rural Guy. JC3

Why don't you like them? JC3

Well Super Complicated to me. I have setup two queries as follows, Query 1 The function of the query is basically as follows. 1. If Field 1 is blank do nothing. 2. If Field 2 is blank then Add 7 days to Field 2. 3. If this falls over a weekend then Add another two days. The expression I...

I do at the moment, but I could effectively halve my number of queries if there was an easy way to solve this. JC3

Hi Rural Guy I am not a SQL user, normally try to stick to Queries and simple VBA. As an example I attach a note of the two SQL queries. The only difference between them is which Form the OverheadNo is taken from. When I combine them in the third query then it always asks for the Form which...

Hi there, I have a query to update data to a table which takes the account ID from the form and updates. This works fine as is. The problem is that the update can be made on several different forms and was wondering whether there was a way to conditionally select the ID in the query based on...

Hi there I was just wondering if you ever managed to find a solution to this problem since I am currently trying to do the same thing?

Theoretically yes. But in an ideal world I would want the oldest Update to be record 1 and the Latest Update to be the last record with the SubForm opening on this record. Does this make sense?

Hi I have a MainScreen Form in my Database which links to a subform giving a note of the Updates on the account. I have set this up as a Single Form with Navigation Buttons to move through these. All of this is fine except whenever you open an account it always shows the first update for the...

Thanks Thanks for the help people. I will give these a bash. Thanks much. JC3 :D

Hi all I am new to Access and have just designed a new database and was wondering if anyone could help with a few questions. 1/ I am setting up a Macro to send an e-mail on the change of a form. When the e-mail is generated by Access I get a message from Outlook stating that "A program is...