Search results

@Isladogs - That's it! I can't believe it was that straight forward. Thank you for the tidy up too! I think I must have started down that route as I'd already created a lookup table with the Years.Month values, so I just added the month value and all sorted. Thank you very much, I just need...

Hi all, I need to run some 'age' calculations within an old version of Excel (2003) and the info I have is month and year (recorded age at time of test). I might have 7.6 - child was 7 years and 6 months old. (I do have their DoB) Following the test, their test age is recorded as 6.11 - 6...

@RanMan256 - Ahh, thanks for that, I shall change things around and give this a try. Sometimes I can't see another way through! :banghead:

Hi all, I have created a form with a sub continuous form and a couple of filters at the bottom, a date one and a drop down box so the user can select which date field the filter is looking at. Is this actually possible?! The query behind the subform is built when the form is opened and...

:D Sorted, hopefully might assist others: Public Function validateform(myform As SubForm) As Boolean 'returns true if all required fields have data, or false if not. 'It will also create a popup message explaining which fields need data Dim boolresponse As Boolean Dim strError As Variant Dim...

Holy thread revival Batman! (Just proves the search works!) :D I'm having the Subform issue with this validation check too, anyone have any ideas? I have tried various options to get the subform name, but it doesn't appear to make any difference: Thanks, Matt 'Check for any missing...

OK, I went for a lookup table in the end, couldn't find another way around it. So using: 5.5 1 5.6 2 5.7 3 5.8 4 5.9 5 5.10 6 5.11 7 6.0 8 6.1 9 6.2 10 Then 2 vlookups on the ages to get your calculation, so you might end up with 10-7, therefore I can return "3 months...

Hi all, I'm working on something for a school that holds children's ages in year.month format. Following tests, their 'test' age is recorded in the same format. All they want then is a progress column which calculates the two fields, simple. I'm currently using the following to get their...

Sure. Firstly create a new lookup table (lkdropdowns) as mentioned above. This contains the following fieldnames; Counter (autonumber field) Tablename (Used to select section of message) Fieldname (Used as reference for lookup) Option (The details of the message) Table with only 1 option...

Hi All, I was after a way of building message boxes that could be updated while users are still in the database, here's what I came up with, hope it's of use to someone else; Function aMessage(varMessage As String, aType As Integer, varTitle As String, Optional varGreeting As String) On Error...

=Format(Date()-3,"\#mm\/dd\/yyyy\#")

Is that when it hits, 01/31/2015? Try; Format(Date -3, "\#mm\/dd\/yyyy\#")

Here's how to do it using Outlook, I'm guessing Lotus has something similar. Dim oItem As Outlook.MailItem message = "Enter the subject to be used for each e-mail message." Title = "Email Subject" mysubject = InputBox(message, Title) With oItem .Attachments.Add "YOUR DOC PATH...

You should be able to use; Application.FollowHyperlink strFullPath And the email; DoCmd.SendObject acSendNoObject, , , steve.kirk @ api.com , , "PDF folder location", strFullPath, , True

Hi All, Firstly, I can't actually find where Outlook 2010 stores the published forms, so that might help with this one! This is what I have so far, I guess it'll work when the path can be corrected but just scratching my head at the moment... Private Sub cmdSurvey_Click() On Error GoTo...

I'd add the button to the end of the row, within the continuous form, then you can reference the id for that row when you click the button.

No problem, thanks for letting us know. :D

Try removing the 'Form_Current' section as that's refreshing the 'Lst_Subject', therefore clearing the contents.

Thanks for that Minty, is that just 2010? All seems fine in 2003?! Anyway, I've now added this which has solved the issue. :) strSQLautonumber = "ALTER TABLE _TabReportTemp ADD [TabNumber] AUTOINCREMENT(1, 1)" DoCmd.OpenQuery "qryReport-TabCreate", acViewNormal DoCmd.RunSQL...

OK, sorry. Here is a sample of the code, the table is created and a number of append queries add rows to the table, should be pretty straight forward. When the created table is opened, the rows are not in the same order as stated in the code. DoCmd.OpenQuery "qryReport-TabCreate", acViewNormal...