Recent content by SRN

Hi Rich, yes just tried int([number]) still returning 0.185 as 0 any other ideas??

I have already tried this buy using CInt([number]) and it converts 0.185 to 0 Am i doing something wrong?

Hi, Can someone please help, i need to round up figures, it works fine in Excel but i need to now use access, anyway i need to convert 0.185 to 1 and so on. Can't seem to find the correct way to do it. Please can someone help Thanks

Hi All, What i have to do is the following. I have a master table which consists of 3 fields. Rack Barcode Style Nice & easy so far. Now what happens is someone scans in some information through barcodes about a unique Rack which is the key. Now what i need to do either add or delete the syle...

Works a treat thanks for your time Mike

Thanks for the reply, but what do you mean by setting the blanks to 300

Hi, Please can someone help!! What i have is a table with 5 fields defined. Style (text) Colour (Text) Description (text) Size (text) Qty (number) At the moment its a single record. but in the qty field there is 300. what i need to do is write a piece of code that will write the information...

Hi, Nice & Easy. What i have done is based a report on a query defined from the selection of a combo box, the query is in the after update. The combo box holds all departments for the company. so in the query i have [forms]![frmdept]![combo1], once the user has selected a single dept from the...

Hi, I have based a combo box on a table, the combo box is based on departments in our company. My question is, is it possible to add an all option so all departments will be displayed in a report rather than a single department? Thanks for your time SRN

Code for Numbers the following code works. Sub FindNonExisttentNumbers() Dim rst1 As DAO.Recordset Dim rst2 As DAO.Recordset Dim lngMinNumber As Long, lngMaxNumber As Long Dim lngTest As Long Dim lngCounter As Long Set db = CurrentDb Set rst1 = db.OpenRecordset("tblnumbers") Set rst2 =...

dcx693, Thanks, Yes ideally i would like to create another table that would hold the numbers. To answer your question about what i am doing with the numbers that don't exsist. I am creating unique barcodes. For some reason the exsisting software would create a number at random then through a...

Hi, I've just started to learn VB, my problem is i have a table that has a key of Number, in the table there are 25000 records but the last number is 99999. What i need to do is write a piece of code that will identify the numbers that don't exsist in the table, so therefore i should end up...

i have generated a 12 digit code, but need to create a Checkdigit to make it a 13 digit EAN code. Has anyone got an example i cold use???

Hi, I am trying to create a Checkdigit in VB, Having some problems. Can anyone help???

Shift Key Hi, if you e-mail me i will reply with a database that disables your shift key for you and you can also enable it again. stuart.nicoll@lyleandscott.com