Search results for query: *

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

Hi, I am wondering if there is any way that I can send a keystroke from Business Objects to microsoft access? I use a macro in access to open BO reports, which have a macro in Document_open to automatically refresh, save and close the report. I then click OK on a message box in access to start...

You're a star, I'll let you know if I have any problems. Thanks again and have a good Christmas. Simon

Hi, I am using BO 5 and need to know how to setup a macro to do the following things when a report has been opened: Refresh the report, Export as a text file, Save the report, Close the report. I need this to autorun, but have no idea how to do this. Many thanks for your time, Simon