Search results

Hello All, I have got a continuous subform on a form - is it possible to make the subform fit the number of records there are? There will only ever be up to about 5 records, but I can't get the subform to grow/shrink to fit. Any Ideas?

Hello, I created a database in Access 2007 for multiple users. It works fine for everybody but there is one PC with Access 2010 that doesnt recognise the file. It recognises the record locking file but not the main database. If I open Access then open the database from the open window it...

I have got a form that shows a product image, but there are more that 1 images for each product. (ie 306.jpg, 306back.jpg, 306front.jpg) Is there any way I can create a form that will show all images with the product code in it. I want to type in 306 and then be able to open a form that will...

Sorted - Thanks for your help

Where would I put the IIF in the formula? The last column hasn't got () because if its blank you won't see it...there isn't more text after that column so it won't show as a blank.

It is a form with a lot of information on it which is controlled by 2 combo boxes with everything else locked.

The data is being returned to a text box. It is coming from a combo box which has all the notes in it.

How do I sort that?

I have checked for ZLS but all empty cells are null. The code I'm using is as follows: Me.txtCOMMENTS = (Me.cboCUSTOMER.Column(3) + vbNewLine) & (Me.cboCUSTOMER.Column(4) + vbNewLine) & (Me.cboCUSTOMER.Column(5) + vbNewLine) & Me.cboCUSTOMER.Column(6) Are there any errors in it?

I imported the table from Excel - will that import ZLS? How can you clear ZLS from all fields in a table?

Its still returning blank lines...

Hello, I have got a table with 5 fields of notes. Only up to 3 of the fields will have text in and I want to show only the fields with text in in 1 text box on a form. I am currently using: [notes1] + vbCrLf + [notes2] + vbCrLf + [notes3] etc... but this shows the blank fields. Is...

I have a form showing stock codes and details - we have a lot of codes which are stored as the customers reference but are the same as a standard code. When a new customer code needs setting up I want to view the product details and copy them all to a new record then change the code to the...

Hello, I need a button on my form to copy the current record to a new record on the form - how can I do this?

Thats what I thought. How would you construct a table to show prices for the same products for different customers?

Hello, I have a table to look up customer prices. The column headings are the customer name and the first column in the product code. How can I look up a price from the spcified column (by name) and by the product code in the first column?

Hello, I need to return a value from the last record on a table to the current record on my form - how can I get the value to pull through? Many Thanks

Hello, I have a continuous form with a check box on each record - how can I set a button to print all the records with the check box ticked?

Perfect! Thanks.

I've got the following code in a form to display an image: Me.imgIMAGE.Picture = "\\C:\images\jpgs\" & Me.cboPRODUCT_CODE.Column(0) & ".jpg" If there isn't an image with that name how do I stop it showing the error?