Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. accessgebruiker

    challenge for expers!! how to create a strange form...

    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...
  2. accessgebruiker

    challenge for expers!! how to create a strange form...

    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...
  3. accessgebruiker

    A quries that puts values from differend field into one field

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

    A quries that puts values from differend field into one field

    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...
  5. accessgebruiker

    Fields from 3 tables in one field

    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...
  6. accessgebruiker

    Fields from 3 tables in one field

    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...
  7. accessgebruiker

    Fields from 3 tables in one field

    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...
  8. accessgebruiker

    Problem with tables

    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...
  9. accessgebruiker

    Problem with tables

    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...
  10. accessgebruiker

    After update: VBA code does not work properly

    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
  11. accessgebruiker

    After update: VBA code does not work properly

    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...
  12. accessgebruiker

    After update: VBA code does not work properly

    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.
  13. accessgebruiker

    After update: VBA code does not work properly

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

    After update: VBA code does not work properly

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

    After update: VBA code does not work properly

    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...
  16. accessgebruiker

    After update: VBA code does not work properly

    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

Part and Inventory Search

Back
Top