if i move a password protected database with linked tables to another pc in the same folders it will works?
Is there any solution to protect it for that?
i have database with products and i want to add a picture for each one
In the table of products i have a field "Image path"
D:\dun.jpeg
how can i insert this text-path from the form and not manually from table?
for example :with a button ADD IMAGE from the form and browse file.......
i want to make a crosstab query with 3 column headers and 1 column row
but access allow the creation of crosstab query with only 1 column headers and 3 column row
I have an access 2000 database and i want to make a cross tab query with 2 column headers but access doesnt allow that
I decide to make the inverted cross tab query and its ok
but now i want to use this in a report but inverted
ex
product type client1 client2 client3
a...
i have a table with a date field with default value for new records date()
when i change an other field and im going to save the changes access says that canntot save the changes because of unknown type date()....
I have an access db in a small lan (12 clients)
I want to make an upgrade and to go to an more powerfull tool than access
It is possible to do that easy with mysql sql server ........... or something else ?
Thank you
I have stored the image search link from google within the table
This is thw easy way
Your example is good and correct but its painfull to find all the links for all cars
I gave the link to my db simply for example
i have a cars database
because it is difficult to add 4000 pictures i want to know
if is it possible to add a field that opens an ie page in google images to show results of images for that car?
ex :
model : Ferrari
foto link...
i have an access database in lan and when 2 users are working in the same form and in different record the record will be locked
ex if the first user is changing the date in the fist record the second user cant change another record...
Thank you very much it works but I saw that I have and some records like
W7,4 without space after the number and this returns #error
Ex
W7,4 D12 gives W7,4
W7,42 D51 gives W7,42
W7,4 gives #error
I don’t know if this can be fixed
THANK YOU
I have a report with a query and I want to give a date and in the report I want to have fields like headings with the next 10 days
Ex I give 1/1/04
And in the report I want to have
1/1/04 2/1/04………….10/1/04
I tried to add fields like [date]+1 [date]+2……. But it doesn’t work
i have a text field with "W XX" inside (XX=number)
ex "W 32 sbiuisd"
"W 25 isjoisjos"
"hihiqhw W 31 sbiqweuisd"
i want to have a querry that returns only the "W XX"