Search results

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!

report which gives me orders per customer Hi, I hava a simple system: level 1 has adres info. Level 2 holds orders for these adressen. Now I want to create a report that gives me all the order which haven't been send yet. I have query for these data, it lookt like this this: customer1 name1...

Yes I will just lead someone to the subform and let them add,close or change it in this form. but what I want is that access askes if someone want to create a todo (and then goto the subform) when you exit another table (via a form) So, I create an order in the Order table then on exiting this...

Why not enter a default value in the field properties in the table design?

I get the above to trigger as an event. The problem is as follows: The todo form opens, I add a record but now the newly added todo is not in relation to the customer I am in! It is in the todo table but doens't have a customer name. IS this a problem I have with a relation? It workt whrn I...

Hi, I have a simple dbase with customer name and a level 2 todo table. (so 1 customer can have more that 1 todo. Now in certain circumstances I want acces to automatically ask if the user wants to create a todo. And on "yes" I want access to go to the todo form and open a new record. I've been...