Search results

Thanks for the input guys. You are certainly making me focus on what I am trying to achieve. When I started the database 10 years ago I never envisaged having clients hanging around for more than 3 to 4 years and I didn't appreciate the issues involved at the time. I'm not an IT techie just a...

Hi Newman, Thanks for your post. Yes that is another possibility and I have tried it that but there is a fairly serious performance hit going that route as the word application loads up, especially if a colleague has the same record open which is quite often the case. Thanks... Sprocket

I have an Access 2003 database split FE/BE. Back end is on a server - local front ends. One table is causing problems - or to be more precise one field. This is a memo field that is becoming full and hitting an overflow problem. The data in this field is notes about various discussions held over...

Thanks Lagbolt - that is exactly what I needed. I take on board your point about putting the message creation scheme on the visit form and now that I am able to write back to the appropriate record I will certainly be moving the button over. Many Thanks... Sprocket

I have a main form with a sub-form The main form (frmStudentDetails) is bound to the "Students" table The subform (subfrmVisits) is bound to the "Visits" table e.g. each student can make many visits. I also have a button on frmStudentDetails, which opens a linked form (SMSdata) that is used to...

Sorry KeithG - I didn't realise I had posted twice - didn't mean to. I make brief notes related to each visit but instead of having a notes field in the "Visits" table I have put this field in the "Client" table and called it "Continuous Notes". This way when I bring up a client I can see all...

Simon_MT, Thanks for your response but I do not really understand what you mean when you say a serarate file - do you mean a separate table? If so what field type do I use to hold and dislpay the data. My reading of the manuals and help files appears to state that the "memo" type field holds...

Hi, I have a multi-table database in Access 2003 - the problem I have concerns just 2 of the tables the rest is fine. Table 1 Client Table 2 Visits The client table records the client’s personal details - name, age, gender etc. The visits table records the date of the visit and a series of...

Hi, I have a multi-table database in Access 2003 - the problem I have concerns just 2 of the tables the rest is fine. Table 1 Client Table 2 Visits The client table records the client’s personal details - name, age, gender etc. The visits table records the date of the visit and a series of...

I think this might be a case where you could use the OpenArgs expression to get the second form to open with a value established on the first form. This is what the Access/VBA help file says about it Determines the string expression specified by the OpenArgs argument of the OpenForm method...

Answer found Dear All, I put up a post a little while ago - I have finally worked my way through this problem. I thought I would share the result back with the forum in case it is of use to anyone. Here is the resulting code which now works fine. ' 1. When you select the person from the...

Thanks for the suggestion Pat. BUT could you kind of point out how/where to use your query instead of code. It kind of looks simple, which is always good but I don't see how to get it to pop up a warning message. By the way it is only if the last appointment was missed not any previous...

Hi Everyone, I have a problem finding the last record in a recordset, which I am realy having problems getting my head around. I have a form - Client with a subform to book further appointments. On the main form is a combo box to select the client - this populates the subform which shows all...

Hi Folks, I know emailing from Lotus Notes has had quite a few airings but this is a new twist. I have been sending emails with SNP attachments for a couple of years without any problems. However, our IT people has seen fit to change/upgrade our mailboxes to version 6.5 so that staff who hot...

Allan57 Absolutely brilliant This combined with your previous post works like a dream. There is always an easy way to do these things is is just finding it that is difficult. Perhaps I don't ask the question in quite the right way first time. Thanks to all who contributed, I have learnt so...

Allan57 Absolutely brilliant This combined with your previous post works like a dream. There is always an easy way to do these things is is just finding it that is difficult. Perhaps I don't ask the question in quite the right way first time. Thanks to all who contributed, I have learnt so...

Hi Folks... Sorry to bring this up again but I am still looking for a solution to this problem. Regards... Sprocket

KeithG Hi KeithG - yes using sendkeys will work up to a point. Using ALT + TAB to cycle with the last application. see code: If GetCountOfWindows(hWndAccessApp, "QuickAddress Pro") = 1 Then SendKeys "%{tab}" Exit sub However, this fails if I step out of Access to - say...

allan57 Thanks for your pointer - I have copied the relevant code into my database and added the following to my proceedure If GetCountOfWindows(hWndAccessApp, "QuickAddress Pro") = 1 Then MsgBox "Please use the instance of 'QuickAddress Pro' that is already opened." Exit Sub This...

Hi Folks. I have exhausted my search capabilities on this and can't find an answer - maybe I'm asking the wrong thing. Hope someone can help with this, its driving me mad. I'm using Using Windows XP and Access 2003 What I am trying to do is use a third party post-code finder to complete...