Search results for query: *

Yeah thanx, that i didn't thought of that myself! but then jou have still textboxes. can you convert a textbox to an label ?? and can you make from an label an hyperlink ?? So you'll get a sort of a help file.. becouse thats it. It had to become a sort of a helpfile where you see all the...

I have a table with two fields. and I want to create a form with a list of hyperlinks/buttons from field1 and if you click on it you'll see field two example: table field1 field2 data test 123 ok then the form should like this: data 123 so that when you click...

Yeah thanx a lot, That I didn't thought of that by myself! It works.. William

Hi Presumably there is some common field in your three tables to allow you to make a join? But to get the three fields concatenated as one, make a calcualted field: SELECT All3:Computer.MSE & Monitor.MSE & printer.MSE FROM Computer .... etc with your join and WHERE clause Regards Ken Reay...

Yeah thanks a lot..... It do work... but ehmmm I think you're misunderstanding my question... What I'm getting now is bv: computer monitor query but what I want is: 5 11 511 5 10 12 1012 10...

Thanks for your information I'm sorry but that didn't work out.. I think I do things wrong , couse I'm nog very good in sql. But let's make it more simple. I make a query with three fields. no1, no2 and no3 how do I put these together in just one field. William I think this is a very...

Hi everyone.. I have a problem and I don't know if its possible to solve this. Mabey someone can help me. This is the problem I have three tables: computer monitor printer In every table there is a field: "number". What I want to do is this: I want to put the fields...

no.. sorry that's not where I'm looking for. Becouse if I set "indexed" to "yes (no duplicates)" I just can do this: In the table computer -> MSE = 5 In the table printer -> MSE = 5 (too) and what I want is that he gives an (sort of) error if you want to put in the same...

For my work I had to make a database where you can put in all the computers, monitors, printers, supliers, ec.. All computers, monitors and printers have unique "mse numbers". I made a table computer, a table monitor and a table printer. In all these tables I made a field MSE. But...

yeah thanks... I don't get the message anymore... The problem still exist, but they can work again with it William Thanks anyone ofcourse who tried to help me

Nahhh I'm so sorry... again it won't work. But the strange thing is: I get that error and if I click OK or Cancel he just still work properly. So is there a way to disable those error messages ?? Maybe there are some things that I overlooked so maybe its a good idea to empty the db and upload...

No i'm calling the procedures from the same form.. and it has no .show method.. Maybe it will help if i tell you that I get this error when I make a new record. so when i'm in the last record of the table en I jump one more record further he gives that error.

nope i'am sorry.. Ik get the same error in the same line. Thanx anyway

Allright... i'm going to try that. I let you know if it works

Here is a part of the code ( the whole code is a bit long ). These are the 2 subs where are the problems about. Private Sub Form_Current() If IsNull(Me![PurchaseOrderID]) Then DoCmd.GoToControl &quot;PurchaseOrderNumber&quot; <-- (this gives an error) End If End Sub Private Sub...

At my work they were using a database in access 97. But now we use access 2000. When we update the database he gives error. What should I do ? If you need the code ... just ask