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 derfloh 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. firsttime

    Generate an unique code from different fields

    Hi, I tried to use this code at home with Access 2000. It works fine. But at my work i have Access 97. When i want to put this code in Access 97 , it gives an error. "The expression you entered contian invalid syntax. You omitted an operand or operator, you entered an invalid character or...
  2. firsttime

    Generate an unique code from different fields

    Hi Savil, Just tested and it works!!! Thx a lots. Dan
  3. firsttime

    Generate an unique code from different fields

    Hi, I have a table that called 'Title'. I have made a form with fields from the ' Title' table. In one field i want to put a code. This code must exist the following things: a date, the first two letters from the field Theme, the first letter from the AuthorLastName, the first letter form the...
  4. firsttime

    Text in an combobox

    Hi, Usually when you insert an combobox on a form there is always a label with it on the left. But what i want is to put the text in the combobox(where it says 'unbound')instead in the label. And if you select an item in the combo the text disappear and when you go to another field it reappear...
  5. firsttime

    Using tab to toggle

    HI, THX guys , did not now it was that simple. Be back soon for more question :) DAN
  6. firsttime

    Using tab to toggle

    Hi, I have an example database that used toggle button to display data (and option group , i think??).Unfortunately, it is in a ".mde format" so i can't see how it was done. What i want is to have 4 toggle button on the top of the form like 'company, address, contact, other'. If i...
  7. firsttime

    search option

    Hi, In my form products i already have made an search function to look for products instead of using the navigator.It works fine. But if i have 300 products the list from the search function show 300 items that is too long. What i want to do is to make an extra search option. In my form product...
  8. firsttime

    Update Instock

    Hi, I have a form that displays an updated stock level for each product ID. The form is a Continuous form so it displays more than one record. I need to change the InStock value in the table with the new values from the text1 field on the form. Example: I have a form that contains 2 table...
  9. firsttime

    update Instock

    Hi again, Maybe i didn't explain it right. Example: I have a form that contains 2 table. 'Products' table in the mainform and 'order details' in the subform(like Northwind). In the mainform i have a field Instock,a Unitorder field and a text1 field. In my subform i have a field quantity...
  10. firsttime

    update Instock

    Hi, I have a form that displays an updated stock level for each product ID. The form is a Continuous form so it displays more than one record. I need to change the InStock value in the table with the new values from the text1 field on the form. Dan
  11. firsttime

    4 pricelists instead of one price

    Hi again, Can anyone help me with a vba code for this problem? DAN
  12. firsttime

    4 pricelists instead of one price

    Hi, This is what i wwant to do. But i don't know the VBA code for the pricecode. Can you help me Paul? Or somebody else who can help me?? DAN
  13. firsttime

    4 pricelists instead of one price

    Please can anyone help with this. Or give some comment if it is possible to do?? I need this to work,for my invoice report. Because every customer has a diferent pricelist. If i press on a button it just show the pricelist that is related with the customer.What i now see is 4 pricelist on the...
  14. firsttime

    4 pricelists instead of one price

    Hi, What i now have in my database is one orderprice so when a customer select an product the orderprice that is related with product is given. Instead of one orderprice i want four pricelists. Each pricelist is related with an customer. How can i define that?? I don't how or where to put the...
  15. firsttime

    Give the invoicenumber a specific number

    Hi, I have a box (record) called 'invoicenumber'. I want it to show: 'aaa.bb.cc' aaa(a number)= it start at 1 and add up everytime a new order is made bb(a number)= it shows the KlantId(CustomerId) cc(a number)= it start at 1 and add up everytime the same customer is chosen.So when the number...
  16. firsttime

    Updating after entering a date!

    Hi ken, The 'date' is in the main form and the 'orderunit' and 'received' in subform. Dan
  17. firsttime

    Updating after entering a date!

    Hi, I got an form that's called "Order".It look like this: -------------------------------------------------- Date:.... -------------------------------------------------- Productname orderunit receveid...
  18. firsttime

    Hi, I have in my database a form

    I tried to use this code but i get the error: "user-defined type not defined". And what do you mean by ; 'Make sure you have the DAO reference turned on before you run it.' I am new at this, could you be more specific!! The name of the box product-id=ProductId (autonumber) the name...
  19. firsttime

    Hi, I have in my database a form

    Hi, I have in my database a form that is called Product. (with productid,productname, product description,unit price,in stock etc...). Everytime i want to see all the information from one product, i have to use the navigation bar (record selector)to select the product.It takes a lot of time to...
  20. firsttime

    Reset autonumber to 1

    thx you very much!!

Part and Inventory Search

Back
Top