Search results

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

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

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

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

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

Hi All, I have a little puzzler here. I'm creating and building a local table using 30+ queries, all in vb. On my development machine it all works fine. It's now been reported by 2 users that the output has become jumbled up! (Each row is added by going through the vb code, added one line at a...

Hi, I'm trying to monitor a few fields and record who updated them together with the old and new values, so far, I have this; This does work ok, I was just wondering if there's a way of refering to the current field, rather than having to specify 'me.NPW.oldvalue' etc. Cheers Matt Private Sub...

Hi All, I'm building the below query based on a selection made on a form, as I know Access does some interesting things with dates, I already swap the month and day around in the vb if the month field is >12. This 'appears' to work fine and produces the query below. The issue I'm having is that...

Hi all, Is the above possible? Basically, some clever soul has used coded fieldnames but then added a description telling you what the field contains, and I need to return this description. Can it be done? Cheers Matt

Hi All, I've put the following Function together to clear out unwanted bits before exporting as csv. I was just wondering if there's a way of holding the table names together with a total count of each item replaced? I wasn't sure if these were stored and could be returned?! Suggestions...

Hi All, We have a template application form which gets issued out to potential employees, one of those has come back to us saying it doesn't work. They're on Word 2010 and it's been created in 2000. It basically tries to open but fails on one line of code; Private Sub Document_New()...

Hi All, I have the following query field with criteria and I need to be able to transfer the same to SQL but I'm a little stuck! :banghead: On the form is a drop down where users can select whether they want zero clawback records displayed or not just a yes/ no dropdown. Field - IncZero...

Hi All, I've put together an SMS sending form which works fine on my full version of Access 2003 but on a users Runtime version they receive an error. :confused: The error is -2147012867 / WinHttp.WinHttpRequest Does anyone know if this function is/ isn't available using Runtime? Here's the full...

Hi, We have a notes sections which includes an OLE object for attachments (Word docs). Only this morning it's decided not to allow 'display as icon' and adds the document directly into the form, whether the box is ticked or not. (Which means it can't be either read or opened in Word.) Any ideas...

Hi all, A brief rundown; We have an Access db which I've recently added a 'recycle bin' feature where previously deleted records (over 5 tables) can be restored by a super user. This db has also a bigger brother where the BE data tables are on SQL 2005 Express. The problem; This feature isn't...

Hi, I'm sure we've done this many times before, but it seems to not liking it this time. We're exporting an Excel list and opening a Word mail merge document, this bit works fine. When the user then closes Word we have a little dialogue message box to confirm the printing was all ok, if they...

Hi All, I have a security module, sample of which is below, I'm considering opening this up to 'super users' so they can adjust the functions their users have access to. Case Else 'Default security setting CommandBars.Item("Adv").Enabled = True...

Hi All, I'm trying to transfer an old acc query across to SQL, but I'm having a few issues, here's what I have so far; I'm trying to build a 'mailname' based on the 2 clients associated with a case, ensuring that 'Mr' goes first. SELECT MIN(dbo.client.Title) AS t1, MIN(dbo.client.Forename)...

Hi All, Please see a section of my code for a security module I'm building. I'm having problems with showing a specific menu bar, one of them works fine, but even through the other is setup the same it just doesn't show. They've both been created as a 'Menu bar' and the same options have been...

Hi, I've been trying to get the below to work on a list 42000+ id's and it does work fine on the first 156 lines, no problem, returning as expected. When I try and copy the formula to line 157 it just freezes...:confused: The below was taken from MrExcel site I believe...:o 'Vlookup Multiple...