Search results

Just a couple of questions -- more curiosity. Are you identifying Products (independent of year or customer)? Yes Is this like a Product Serial number?- No, ID No Perhaps you could expand a little on what a product number means to your business. - Means nothing to our buisness means everything...

Thanks for your responces, However Im not that advanced but will put some time into this. I fully agree with the traceability issue, however we sell less than 999 parts per year and there is a year id within the table so we still have traceability in that sense Thanks If anyone wants to...

I have a database used for producing labels on product. there is a unique 5 diget code we use for our tracibility, however one customer demands a 3 diget max 1 to 999 Thus i would like to create a field which auto fills a number 1st record = 1 2nd record = 2 3rd record = 3 ect...

Ive had the same issue, people keep spouting how a memo will hold over 64K characters, when infact it only displays 255!. I dont understand the point. I created a table using some memo fields, then a form to allow users to enter data. Then I found out the memo fields are restricted to 255...

Sorry where do i put this in the criteria field on the date field

Before you all shot at me I seem unable to post int the correct sectiction My simple problem, I want to run a qery to select the last record in a table ie i have a qery created from 3 tables The qery gets the last record entered from a specific table the specific table does have a date...

Sorry not familure with VB at all, I have dragged the adress field onto my form and the control field is then assosiated with the correct field in the table then on the default value in the property box set to =[Cust_cmbo].[Column](1) but this doesnt work either, any other solutions Thanks

I have created a drop down box for my customer field the combo box has multiple collums. I have a second field which fills in the address dependant on the customer selected using the following =[Cust_cmbo].[Column](1) This workes fine the address field fills with the correct data . Here...

Simple help please Im trying to get this to work but not very well, I have a table with values in and a second table i wish to create records via a form. I want to auto fill some of the fields and understand the Dlookup function is probably the best way to go. I have looked up the examples...

Sorry in the properties of the combo box under bound colloumn i have the value 1 What do you mean. The criteria in my query points the the value of the combo in the form Thanks

Please help. Ive created a form and added a unbound combo box using the wizard. the combo box looks up values from a field in a existing table. (I told the wizard to remember the value for later use). Ive added a button to then run the report generated from the query. the query uses the...