Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

thx you very much!!