Search results

Hi I am trying to make a form to to add data. so I made my table, made my main form and then made another form to update the table and placed a command button on the main form to open the update form. The problem is is that it works fine to add one record however every time I open and change...

yeah thats what I though but just wanted to check Thanks

HI I need to move my database from one computer to another and will need to put it on disk first. I have user serurity on the DB. Should it be ok as long as I put both files (the Db and the security) onto the disk and transfer them both? Just asking as I cannot copy to CD from my computer and...

Thanks for your quick replys The currentuser() works but only for that user, I want to see everyone who are logged on to the Database at the time. Thanks

Hi Just a quick question Is there any way that I can view which users are logged onto the database? Thanks

Thanks that works great and was so simple

Hi I have been looking at some past threads regarding scrolling text and have found some methods but I can seem to get the codes to work, does anyone know a good code for scrolling text? Thanks

Dont suppose you might have any idea what the code would be? ;)

The question is slightly different. I no longer want the unbound text box. Instead I want to click the button and have the box appear (as in an update query) so there is only one button and thats it. I have managed to get an update query to work by doing in the update to box: qty-[Amount]...

Hi I want to make a button which when clicked will bring up a box which the user will enter a number which will then be subtracted from a number in a field. I have tried an update query however not been able to getting it working. Any ideas?

yes that is great thank you

Do you know how I can clear the text box after the botton is clicked

Thanks that works fine

Hi Hopefully just a quick one. How would i go about making a an update button so that when i type a number in an unbound text box and click the button it subtracts this number from a quantaty field?

Thats great thank you for your help

I think that I have it sorted now but do you know how I can stop the warning boxes coming up asking if im sure etc?

What do you mean by build the SQL string into your code?

yeah I have looked into this but I will need it to update every time the information is changed which will be quite oftern.

Thanks for your quick response. The field is updated in the table for the current form that I am on however this will only update one record in the table and I need it to update every record in the table. Thats why I was thinking that me. means current form so is there a way to say this field...

Hi I am just wondering if anyone knows: If I want to change a field on the current form I start the code with Me. However is it possible to change every record for that field in the table so I assume it might be instead of me.[fieldname] = ??? it would be [tablecode].[tablename].fieldname]=...