Recent content by pallem

Hi, thanks for the reply. Tried that with no success, but have realised that it will now not let you assign any image file to the image control. I thought it was just jpg but its also .bmp, .emf etc.. This is a change in Windows 10 since Christmas as i was able to do this before Christmas. So...

Hi all, I still can't find a resolution to this. Any objections to posting on another forum and reporting back. Don't want to cross post?

That's great, many thanks for the links. I shall have a read through.

Hi, I have our access front end on the client PC which I am trying to connect to the Sql Server Backend database via an ODBC connection which works fine on our current network. I am trying to setup a new server using all the same software and ODBC drivers but I must have missed something in the...

Thanks for your reply. Very nifty code indeed! I will be making a purchase.

Hi, i am looking at including a user friendly query/reporting tool with our access application wherby users can create their own adhoc reports without having to ask me each time. The reports they would write wouldn't justify going down the lines of Crystal Reports or Business Objects. The...

The record in the main table is copied to a temporary table so that values/paramters can be changed/played with to obtain the desired results. These values are then copied back to the main record in the main table.

Hi, I have a record in table A that i want updated with the contents of a record in table B. The records in tables A and B have exactly the same layout. I feel there should be an easier way of doing this rather than using SET fieldA = FieldB for each field in the record in Table A? Many thanks

Thanks for your reply. I'll have a look at the link

When i open my Access 2003 database it display Error No: 29070. It doesn't display any other messages? Any help much appreciated.

Many thanks for all your replies. It gets very confusing with all the different permutations. I have to swap between different development platforms so sometimes end up using the wrong syntax in the wrong code. Now its working i'll leave it alone. Many Thanks.

Many thanks for all your help. I've made a schoolboy error and forgotten to take the quotes off so it should read: Forms(oForm.Name)(oCtrl.Name).Caption = "newcaption" which works fine. Serves my right for coding late at night!

Hi, i'm trying to change Form captions using code line: Forms("oForm.Name")("oCtrl.Name").Caption = "newcaption" Everytime i try to run the code the program flow just steps into it and then steps out without doing anything?? I have checked oForm.Name and oCtrl.Name and they both contain the...

Many thanks for all your replies. You have supplied some very useful info for me to use as a starting point.

Hi, I have an existing Access 2003 database which I have to convert to French. The data in the tables is fine but the Forms, Command Buttons, Message boxes and Reports need to be converted to French. There are a lot of Forms and Reports so i'd prefer not to have to do the conversion manually...