Search results

I expected it to be much more easy. If the path of the image at each record can be written like: =[PEOPLE.ID]&".JPG" Is there a way on MS ACCESS to input this on the REPORT, so I can see the image I want? Thanks!

Thanks for your reply, On my TABLE I have the information like this: ID -- FEASSDDE RDSAAASE NEESSDSD AEIERIEIEE And what I need is to create a QUERY where I do ORDER BY ID, and to know the position of each ID in this order, something like this: POS ID -------------------- 1...

I want to have the photo of each person in a REPORT. PEOPLE table has as primary key an ID, and photos are named ID.jpg. For example: ID NAME ----------------- 7112 John 2322 Lewis 3553 Peter 1222 John and photos are labelled 7112.jpg, 2322.jpg... How can I do...

Good morning, I have a table ID (primary key) and ID -- FEASSDDE RDSAAASE NEESSDSD AEIERIEIEE and I want to do a select of these values, order by ID ASC, and see the position of each one in this order, something like this: POS ID -------------------- 1 AEIERIEIEE 2...

Thank U!!! THANK YOU so much for your help, you have been very kind with a newbe like me. Best regards, colleagues ;-) Artur

I have two queries containing this information (example): QUERY 1 "People having cars": Name Number cars Peter 2 John 1 Louis 1 Cris 3 QUERY 2 "People having bikes": Name Number bikes David 2 John 1 Louis 2 Phil 3 TABLE Names Peter...

Sorry, but it doesn't work, I cannot concat two strings or fields this way. I repeat the idea: I have Table1 with a field FileName (filename1.mpg, filename2.mpg, ...). What should I write on the "default value" field of a box in a FORM, so that it is as default: "\VIDEOS\filename1.mpg" for the...

Where do I write this? I've tried that on the "default value" field of the box, at design view of the form. There I write = "\VIDEOS\" & [FileName] But when I try it, I just get only the string "\VIDEOS\". What's wrong? Best regards!

I have a TableA and one of the fields is FileName (filename1.mpg, filename2.mpg...). On a Form, I have a box and I want there to have this string for the first row: "/VIDEOS/filename1.mpg". How can I do that? THANKS!

Thanks for your kind reply, that is just what I wanted... but I propose another question. Imagine a table with three fields (apart of primary key): name, type and file link, like the next. TABLE 1: Name Type File...

Thanks Simon, Could you give me the name of that 3rd party conversion utility? Creating the ASP site by hand would be too much work, having now a great MS Access database with all the forms, user control and reports developed. I have heard something about a dbGrid class which does this job...

Imagine a table with the information like shown below: TABLE "A": DATA1 DATA2 ------------------------ A1 B1 A1 B2 A1 B3 A2 B2 A2 B4 A3 B1 A3 B2 A3...

Hello again :-) I would like to create a table attribute called "video", which would be a link to a local video file, so that in a report or form, if I click on this field, the video file gets opened. how can I do that on MS Office 2003? Thanks a lot, Arturo

Thanks a lot for your help, How many tables are in your database? 9 tables, each one records from 16 to a maximum of 96 records. Will you be running reports off this data for the users to print? YES Do you use macros, VBA code, or both to automate the application? Just macros I just thought...

Thanks for your reply! It is an access application where you have at first to log in, and after that you can include details of some activities, or consult them. There will be just 8 users, and I need to put it on a website, because this users live very far from each other. I have all of this...

Microsoft Access 2003. I just want to make this database easy accessible and work-able from the internet without downloading the whole file and working in "local" on it. Is it possible? Thanks!!

I have developed an Access application with users/password control, and I want to put it on a website, so that people could work on it even if they don't have MS Access installed. I've checked the "export to ASP file" posibility, but I don't know how does it works. Anyone can help me? Thanks!