Search results

Hey, i have some code that launches outlook. It used to work, however it now gives me an error along the lines of.. Run-time error '-2147417848 (80010108)' Automation error The object invoked has disconnected from its clients. here is my code Option Compare Database Option Explicit Public...

posted the wrong link sorry.. this is the one i meant http://support.microsoft.com/kb/101374

hope this helps http://msdn.microsoft.com/en-us/library/ms234874(vs.80).aspx

Yeah sorry to be snappy, bad week. this is my resulting sql query. SELECT tbl_Change.Title, tbl_Change.Initiator, tbl_Change.Change_Nature, tbl_Change.Change_Type, tbl_Change.Status, tbl_Change.Primary_Location FROM tbl_Change WHERE ChangeNumber IN (SELECT ChangeNumber FROM tbl_Tasks WHERE...

yeah well it took me about 3x the time that it would have taken if somebody had thrown a bone.. My only choice was to battle on and tear my hair out until i made it work.. The only problem is that I don't know if my solution is the best option. Thats why I posted a message. I was seeking...

nvm, figured it out

Its Access 2003. Each task is an individual record with a unique id. One of the fields in the record is the Change Number, which is the unique id for the Change Table.. There is no reference in the Change Table to the Tasks assigned to each Change. i.e. Task table Unique ID --- ChangeNumber...

Ok this is harder than i thought, unless im missing something I have a table; that tabe contains records relating to Changes. Each change contains an Initiator (change table) Tasks (taks table) and Impacts (Impact table) Im currently building a search form that will filter out only the...

ok, that sounds good, thanks for that

Is it possible to have the contents of a form center themselves when the form is maximised? At the moment if I hit maximise, the form background just extends down and to the right (see attatched picture) What i'd like is for everything to stay in the center of the screen.. is it possbile?

Hi, i have a txt file that i wish to import, and transfer some of the information to a table. This is the form that the file comes in 39 55d3aaad(-) OK 3.0 0{0|0} name1 41 dc2c8c55(-) OK 3.0 0{0|0} name2 42 5e1dbb34(-) OK 3.0 0{0|0} name3 43 18d7785f(-) OK 3.0 0{0|0} name4 what i want...

Good. I thought that was the case, however 'higher ups' are trying to tell me otherwise. Just wanted a second opinion.

Hi, can someone explain to me what requirements there are for a server that holds an Access backend file. Does that server require Access? It will simply be holding the backend file, nothing more. All workstations will have Access.

If i have a string such as bob, allen, tim, frank etc, what code would i use to split that up into individual words, and put the words into an array. I know you would basically navigate along the string and breaking at the ' , ' but im not sure how to do it in VBA Cheers

What are the licence requirements in order to use the Runtime?

Let me explain agian. Someone opens my database. The click new Change. This opens a blank form, they fill out all the required information, and hit save. Based on the information on the form, certain people are notified of the submission, and they are required to view the submission and...

dk, If a user loads this form it requires a tick of approval. This is required so that the task defined by the form can progress. In the event of the user making a change to the form and then clicking approve the form needs to beable to respond to this change and reset the approval process...

Wait.. got it... the expression had to be Form_frm_Change!frm_Change_Modified = True

Hmmm, it seems to have an issue in finding the form :s this is my code: Public Function modify() Forms!frm_Change!frm_Change_Modified = True End Function Thats right isn't it? frm_Change_Modified is a checkbox. modify() is located in a Module

There is about 25 controls. I'm currenty experimenting with creating a Macro that does what i want, and then set each control to that macro. Unsure if this is wise, but its a lot less coding.