Search results

Hi, I am actually doing a videotheque and so far everything is fine. The only detail I would like to do is, a click on the cover that appear on a Form open the picture (jpg or bmp) with IE. right now, the code I have is 'Application.FollowHyperlink MovieLogo' but it opens the jpg / bmp in...

I am thinking of using the "Replace" function. Basically, replacing all values that is equal to the deleted record by "blank" value Is it the only way and fist, will it work? thanks

I forget to attached the DB...

Hi all, I have the following problem of update/refresh in my DB, I have 3 Tables, 2 Queries, 2 Forms and 1 SubForm. 1 Field in "tbl_Equipment" is a lookup in "tbl_Sub", 1 Field in "tbl_Equipment" is a lookup in "tbl_Bus". If I delete a record in "tbl_Sub" or "tbl_Bus", I think in the...

Attached Solution Hi all, Problem solved! I was doing a lookup on a Number instead of a Text! I like this forum, you pose your Problem, you still work on your Problem, you solve your Problem, you post your solution. Hope this thread will help one of you in the future. H.

attached problem hi, for a better understanding of my problem, I have attached a sample of my DB. A click on the button creatres a XL file on the C Drive but in column B, I would like to get the Value and not the Reference of the field (exactly the same as Query3). PS: Does anyone know how to...

Hi all, I am having a little problem with an export to XL. I have created a tbl in which some field are lookups to other tbl. I have created a qry (that is a copy of that tbl). When i export that qry in XL, i am getting the fied ID instead of the Field Value! Anyone have a clue how i can sort...

Hi all, I would like to Export a REPORT from ACCESS into XL. I am not talking about a Table or Query but a Report already formatted in ACCESS. Anybody to help me ? Regards Herve