Search results

Simon and PR2 Thanks very much for your time in trying to help me out. I have had a look at both examples you sent me an I think Simon's one would be better for us as it has the picture showing all the time. I will try and have a go at Simon's version... I appreciate your help. Thanks, Alex:)

Hi Paul Not very far I'm afraid! I've just popped into work this morning and deleted all the pictures from the database, so hopefully now it's lovely and small that will stop it corrupting at least. I have created a text box in the meantime so the data entry lady can manually write the file...

Thanks for your reply Simon. I'm using Access 2007. The images are .jpgs stored on the c drive. We are currently just writing the image name in a text box on the form, but ideally would like to have a link to the file so the picture shows. Do you think this is possible in 2007? Thanks Alex:)

Hi ya I feel daft about IMO, I assumed it was Access Terminology! I managed to open the link thanks, although it came up with a run time error 2220 (it can't open the png file). Would this example work for a system where every access record has a unique picture? Thanks for your help. I am...

Hi Thanks so much for your reply. I've clicked on the link you suggested but it just comes up with a blank page? Excuse my ignorance, but what does IMO stand for? Thanks Alex

Hi everyone. The question I have is: if I link a .jpg file to my form, will I be able to see the picture or will I just see the file path? Scenario I designed a database for our watch repairing company that is used to book every watch in that we receive. A picture is taken of the watch and...

Thanks for your advice Rain. I am a beginner so if you could point me in the direction of how to de compile, recompile and compact and repair that would be much appreciated. Cheers Alex:)

Hi Bob The size of the original file was 175,096. The fe is now the same and the back end is 174,368. I saved the fe as a accde file and that is now 436 kb The front end is just a form. Thanks, Alex

I've just split my database and expected the file size of the front end file to be small and the back end file to be large.... However the size of the files are approx 175,000 kb each. Does that mean I haven't split it correctly? Does a database need to be empty when you split it? I had about...

Hi Mr. B Thanks for your reply. Yes, I will be splitting the database when it's finished and putting the front end on each machine. I just wanted to make sure the users with the 2010 version wouldn't cause problems with the database. Cheers, Alex

Hi there I'm an Access beginner and was hoping someone with experience could answer a question for me. The majority of our office has 2007 but we have just had 3 new computers which have 2010. I have created a database in 2007 and wanted to know if the 2010 users will be able to input...

Ok, thanks for your advice. Cheers, Alex

Dear Rain Thanks for your quick reply. I've had a search and found the programme you have written. I'm new to access so would you mind pointing me in the right direction as to how I add this to my database? Thanks in advance, Best regards, Alex

Hi I'm setting up a database for a watch repairing company. On the current system as each watch is booked in, it is given a number (currently at 47,500). It has been requested that when my new database goes live that I continue on with this number. It would make sense for the primary key in...

Thanks Paul. I tried what you said and it now works. You saved me a big headache!! Cheers.

Hello I've just created a database and want it to be used by other employees. I have read up how to do this and have split the database. The FE and BE are on the main server and I have put a front end copy on the C drive of the other computers. Now I'm stuck! When I open the file on the other...

Hello everyone I'm new to access and have spent the last few days slowly learning my way around the programme. Through searching on the internet, I've found some helpful information on this forum so have decided to join so I can ask questions for answers I can't find!! Thanks for your help in...