Search results

are you using the ruler to set tabs Hi Are you clicking on the ruler at the top of the page to set your tabs? Because you should be able to set as many tabs as you want in any position you want simply by clicking the ruler, then jump from tab to tab with the tab key. Also I am not sure if...

Thank's Mstef Hi Mstef Thanks for your link. I had a quick look and it looks like they are talking about office 97. At home I am running office 2000 with access 2000 and that works ok. At work I'm running office 2003. I'm wondering if this dll may be to old to install into office 2003. I...

Hi Everyone Ive created a database using the file system object that creates folders, moves files from one folder to another, etc. This works perfectly on my home pc, but when i try to install it on the server at work I get the following error message:- Runtime Error 429 Active X component...

Another Quick Idea Hi Another idea might be to add a number field at the start of your table, then give each record a consecutive number when you type them in. You can even add the numbers in the order you want to an existing table, after you have added the new number field in design view...

Very simple example without embedding This sample database uses: 1 Table with 1 Field 1 Form with 1 text box linked to the field in the table and 1 image frame The folder in the zip file is called images and contains both the database and 6 pictures. The folder path should be C:\images I...

A cheap and cheerful solution Here is an old fashioned BASIC way of doing it, it might not be pretty by todays standards but it will do the job and I think you will understand it. Just for practice and to keep it simple I have only used 2 fields (1) Create a Table with 2 fields: Name Field...

Re Colour Hi Suepoo I don't think Bob was referring to you. Regards Tony :p :p :p

Re American Forum Is http://www.access-programmers.co.uk Really an American Based Forum? :rolleyes: :rolleyes: :rolleyes: Tony

Re search box Hi (1) Open your database (2) Click Tools (3) Click Options (4) Click Edit/Find (5) Check the general search radio button, click OK (6) Open the search box with your button (7) In the Look in dropdown select the form name (8) In the Match dropdown box select Any Part of Field (9)...

Re Total Query Hi Try a query like this: Use a Colon : after the field heading and use square brackets. Regards Tony

You could well be right Hi Arm1 Hi Paul Having had another look at the question I think you may well be right. Oh well! it might help someone one day who has never built a query with a calculating field. Have a good one Regards Tony

Concatenation in a query

Why not try a query like this? Hi Try a query like this:- This would result in this when run Make sure you use a colon : after the fieldname you want to appear at the top of the column and use square brackets. Regards Tony

Brilliant! Thank's Lagbolt I really appreciate that information. It works really well. I am a teacher of general Information Technology subjects and every week I have the task of setting up 16 folders on the server with the appropriate files for each individual students exam. I had already...

Hope this is of some help Hi Bev Insert the following code into a Command button's on click event (i've used a button caled Command38) The first row of the code deletes the old table Table1 (note! the first time you run this, an old table 1 must exist, any old table will do even an empty...

Ok I will have a look for you Hi Bev I'm in the Uk and it is now 1210 Pm and i need some sleep. I promise I will have a look over the weekend and post you a reply asap. If someone else posts a reply please have a look at it, but I will attempt to resolve your problem for you as so many...

Back to basics Ok Bev thanks for that, going back to my original question? Rather than using macro's or modules to do this job, why don't you use a button on a form, create an on-click event procedure, and add the bit of code that you have been given into the subroutine. If none of the...

Can you send me a copy of the Macro Hi Bev Can you either post a copy of the Macro, or a copy of the database so that i can offer a solution? Regards Tony

Do You Know How To Create A Command Button Hi Rather than using macro's or modules to do this job, why don't you use a button on a form, create an on-click event procedure, and add the bit of code that you have been given into the subroutine. If none of the above makes any sense at all...

I know it sounds daft Hi I know it sounds daft, but have you tried a compact and repair? Regards Tony