Search results

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

Hi, Is it possible in your combo box to have an option if left blank it would display all, rather than looking for user input???

Hi, I have set a background image on a report also put in a header & footer, my problem is i am getting a second page showing just the image on its own then the 3rd page is again the header, footer & the image. I have check the size of the report and it fits on to 1 page.

Is it possible to have an image in the background of a report and have text on top of that image???

What's the Best Way. My problem is I am linking into a Table in a Personnel Database, the table holds sensetive information. What I need to do is be selective in what fields i want from that table and somehow link to those fields. If anyone can suggest an easy & secure way of doing this. Thanks

Hi, Can anyone help!!. I have designed an Returns form but the problem I have is that It's based on European Currency. Now this changes daily. So my problem is that when i update the new currency prevoius record are not updating. The new currency only works on any new records put in after I...