Search results

Hi I have a problem with the attached database - It has a form with a common dialog control which works fine until you select the file. The form asks you to select a picture file and I am trying to get it to output the result to a field, instead what happens is that the form's background...

Hi I have a problem with the attached database - basically I have copied over from another access database some code for a field on a form on this database. The code is for a common control dialog. When you click the command button next to the picture entry box a dialog box opens and I can...

I have a form that adds data to one table - problem is that the table has 20 records but when I open the form it shows record one of one which also happens to be blank when I click on the arrows to go to previous record nothing happens. Does anybody know why this happens or indeed come across...

I have a command button on my form which runs an active X control. I use this to find files to enter into my database - however I have it set so that it opens a set directory on my machine therefore I only want to record to the database the filename not the drive name or directory. Eg test.gif...

I have about 20 check boxes on a form for various preference indicators a user can select - is there a way I can add these check boxes to something like a text box field with a vertical scroll bar so that I can reduce the amount of space these check boxes take up on my form? Thanks for any...

I have a form with tick boxes on it which when pressed runs an afterupdate macro that inputs data into my table. Which works fine except when a user changes their mind and unselects the tickbox - access goes and puts the same field into the database... the code is as follows:- Private Sub...

Hi I am having problem updating a field. I have a toggle field on a form when it is pressed I want a AfterUpdate statement or a Click event to update another field. My other field is called Features which updates a field called Features in a table called UserCar. my code is as follows:-...

Hi I need to create a form where users enter preferences eg. reading / walking / cinema / computers / sports etc. In all their are some 75 options that a user can select of which they will select some. Now I need to enter these values into either a text field or a memo field. The field will...

I have a form where users enter make and model of cars owned along with car features ie alloys, sat nav, electric windows, air con, sunroof etc all these options are from one table. I need to create a form where they can tick boxes next to the specific option which will need to update one field...

HI I am a newbie to access so I am not quite sure if this is a straight forward problem or not - I have a database with three tables - one lists car makes and model names with variants eg ford,mondeo,1.6 etc would fill table number 1 table two has colours and three is used to enter members data...