Recent content by Dinictus

Thnks for your reply ! To be honest, I have given up. I'm actually pretty fed up with all the strangeness in Access. It's probably my skill level that is too low but I really see some strange non-intuitive stuff happing with access sometime.

Hi I have a strange problem. I have converted a 97 dbase to a 2000 one. When compiling it says compiling did't go perfect. (but what didn't go perfect it didn't say) and now I can't add any more record into all the tables that work via my subform view. I can add records directly into the...

Spacepro, That's truelly beautiful! It works.

Hi, This looks like an easy one but I can;t figure it out. I have a "main screen" for my dbase and on this screen I want a button that will make you go to the query tool. Now with the button wizzard you get several options like: run macro, close application etc etc. But how do I make it go to...

WHAA It work! Thnks alot. Stange how the you get more properties if youy selct properties from the toolbar than when you selct via right click. once again. Thnks

Yes I get the code builder and stuff but I seem to be in the wrong event. What woudl the sub be called for before updating a form called Levelone? If I stand on the form and and right click and build an event, the sub for the code is automatically called: detail_click.

Indeed! Thnks for the tip.

The beforeupdate event of your form I guess. damn I'm a dummy. cos I can't get it to work.

thnks, I found this already but unfortunately I have access 97. Do you think it will work under 97? Cheers

hmmz, thnks! I tried your last solution. Tried inserting syntax in the control source but I can't get it to work. I have added the date field but how would the syntax look like? :confused:

Hi, I know it is possible, i've read it here but I haven't seen an example. I want to have a user administration in 1 particular dbase. Security on a deeper level isn't necessary, just a username and a login is enough. But how can i do this? Or where can I find some reading on this. Am I not...

Hi, I have a small dbase with some tables related to eachother and so on. Now I want to track the last change that has been done to a certain customer. Can this be done i a not too complicated way? :confused: like: last change: 11/01/2005

Not sure how I can approach this another way so any advice is welcome. What do you mean by linking table? I need the retailers in the same table cos for them the entire data base is the same as for the clients, the only difference being that you can join them to clients. (technically it would...

Hi, I have a dbase with a form to look and search and stuff. Now It hold clients and retailers. What I want is to join certain retailers to a client. like: Client "blabla" Can get products from: retailer1: name address Button: CONNECT A RETAILER HERE Retailer2: name address Button...

Yes I had the query as the source. Sorting and grouping....I'll have a look at that. Thnks!