Search results

Thanks Dave. (Gemma) I need the function as it calculates the number of WORKING days between the dates. Your input has been very helpful Pat

Hi JANR and Dave(Gemma the Husky) JANR I already have the function ...Thanks. I was looking for a way to use it in a query. Thanks to you both for your help I have used the following line in my query (which seems to work): NumofDaysLeft...

Hi Gemma, Thanks for your speedy reply, the first argument needs to be todays date, the second argument is a field in the table). If the End Date (second argument) is less then Todays Date (first argument). I dont want to call the function I want the value to be zero. I am struggking with how...

On a form I call a Function to calculate the number of working days remaining between a due date and now. ( I have a field in the underlying table that I can use to store this value, but dont know how to populate it to keep it up to date). The value is displayed fine in the single form. However...

Thanks The open arguments solution is exactly what i needed. I have never used that before so again thank you very much Pat

Mr B Thanks for your reply. I need option 2. When form2 is opened from form1 I need the tabdepts displayed. When form 2 is opened from other forms it needs to open at tab 0 as you mention in option 1 of your reply. Pat

Hi All I have a command button on form one which opens form 2. (works ok) Form 2 has tabs on it (one called tabdepts) Is there a way to open form2 with the tabdepts displayed. Note: Form2 is not open at this point. Thanks Pat

Thanks for the code Works perfectly

I use the same principle. This forms allows the user to edit the data in the main form. I was trying to add the subform to the tag in this form to make it easier for the user. I originally had a seperate form for the user to edit the subform data. I cannot save the data for each tab seperatley.

No the data is only saved when the user has made any changes to any of the tabs. The user can move from one tab to the other making as many changes as they want. then click on save button to make changes permanent. Following your question I have just run a test. I added data to the subform...

I have a form which consists of several tabs. The data for the form is selected by using a combobox to select the required record 2 of the tabs have a subform on them (each subform links to a different table which have their own add and remove buttons), the others contain data from the main...

If a field on a tab linked to the main form is changed on a form. Will the subform on a tab linked to it become locked. That appears to be what is happenning in this case.

hi guys The code updates the main record on loading which is fine. If i now click on one of the other tabs and amend a value then return to the exemptions tabs, the subform is locked. ie i cant add or remove another exemption. (this is done by selecting an exemption id from a dropdown), but...

Thanks guys, i am new to sql, taking out the quotes worked. PS sorry for causing a discussion. Galaxiom I do not know how to use the codebox again sorry Pat

Hi All Table relationships: the table FOIRequests is linked to the Exemptions table via a link table in a many to many relationship FOIrequests: PK intFOIRequestsID Link Table: intFOIRequestsID intExemptionID Exemptions Table PK intExemptionID The main form opens and...

For anyone looking for a solution to this problem: Here is an answer from another member. (qrySearchByExemption is the name of my origiinal query as detailed above) Step 1: Create a query as follows: SELECT Count([intFOIRequestID]) AS RecCountAll FROM [SELECT DISTINCT intFOIRequestID FROM...

Wis Thank you so much for your reply. Your solution is so simple. I have spent days trying to resolve this problem. You are a STAR................... Thanks Pat

Thanks for the advice. Made the changes you suggested an now get the following error syntax error in FROM clause qrySearchByExemption referenced in the above sql has parmeters from a form in it. Will this be the cause of the origianl error? If so any ideas on how to resolve it Pat

I think so, see below. Dim db As Database Dim rs As DAO.Recordset Dim SQL_String As String SQL_String = "SELECT Count([intFOIRequestID]) AS RecCountAll FROM [SELECT DISTINCT intFOIRequestID FROM qrySearchByExemption]. AS RecCount;" Set db = CurrentDb() Set rs = CurrentDb.OpenRecordset(SQL_String)

The SQL below is taken stright from the SQL view of the query. When trying to use it as an SQL statement I get the above error: Set rs = CurrentDb.OpenRecordset(SQL_String) SQL_String = "SELECT Count([intFOIRequestID]) AS RecCountAll FROM [SELECT DISTINCT intFOIRequestID FROM...