Search results

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

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

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

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

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

Just a quick question, is there any way you can disable a user from holding down the shift key when opening database and by passing any restrictions you have built into your database