Recent content by sagsh

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

Can anyone help me with this? Sags :(

Thankyou! Thankyou! Thankyou! solved the problem - seems bizarre though that data entry has to be set to no! :)

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

Thanks Dan_Cat this works fine until someone ticks several boxes and thn hesitates and goes back to one already selected and unticks it. Do you know a way around this? Thanks for any help Sags

I tried the ChangeDatabaseValue() script and I got an error:- compile error syntax error - I have checked the script and it is exactly as you said so what could possibly be wrong? please help Regards Sags

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

I had named a field in my database and a control on my form with the same name! which was causing my problem! Thanks for your help! Regards Sags :)

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

have you tried cascading combo boxes? have a look via the search function on this forum regards sags

Form Tick Boxes Hi Wayne Thanks for the update! Could I not do something like - if true (indicating tick box is ticked) the val='alloys' then Me.SomeField = 'alloys' Me.SomeField & vbCrLf & Me.SomeTextBox etc. or am I totally wrong on this? Best Regards Sag