Recent content by simonjackson79

Thanks Mute, that seems to have solved it. I talk to myself because I like dealing with a better class of people.

Hi, To run a particular piece of code in my database I need to be able to have the "Microsoft ActiveX Data Objects Recordset 2.6" reference ticked. However it does not appear in the list of references available to me. Any solutions? Thanks in advance Simon I talk to myself because I like...

Thanks Bob, that worked a treat, just what I needed! Si

Hi, I have a macro setup up that imports a text file "All CLA ever.txt" and creates a table from it. Is there anyway that I can add a text field called "Key Worker" to the table using VBA? Many thanks in advance, Simon

Just to make the point that I had an old 486 DX4-100 running 98, so it certainly isn't the processor. Get Partion Magic, that should be able to merge your unused space with your allocated disk space and give you access to the full 8 gig.

Hi, A friend has had a huge problem with his pc when he has requested remote assistance from me via MSN messenger. Once it connects, the speed of both pc's decreases quite dramatically. Now this might sound reasonably normal, however a quick restart once disconnected and my pc runs normally but...

That's great, I can get this whole project finished today now. Have a star 'cos you are one!

Hi, I am in the middle of designing a statistical reporting form with queries and reports that are based on dates entered within the form. I have virtually finished but I have one remaining problem and need some assistance. I need to make a text box automatically calculate a date that is ten...

I just realised something else. How do I delete a table from another database? The reason is this: I have created a database that will need regular updates, I need to be able to email these as the database is in another part of the country. The problem being is that I want to basically send out...

I need to automate exporting tables from one database to another, I have tried to use a macro, but you have to specify the database you are exporting to within the macro. Is there anyway I can have it so it will ask the user which database it is to be exported to?

Hello again!!! I know I'm being a real pain today, but I'm sure this is the last thing I need to know. I have setup a form with the fields [Unique ID], [Surname], [First Name] and [Date Of Birth]. What I need to know is what code to add to a button so that it searches on the data entered and...

That's what I suspected, oh well nevermind. Thanks for confirming that for me. Si

Is there any way to import a word document into access so I can use it as a report? Or will I have to go via the 'bookmark' route?

Your are an absolute star, so I think I'll award you one!! Thank you very, very, very muchly. Si

Hi, I'm having a problem with a form control. I am creating a database that deals with sensitive information. On the client record screen which only displays information i need to use a control that changes colour dependant on the answer of a yes/no field. The field cannot actually display the...