Search results

Thanks Pat. Sorry though, I am useless with code and need slightly more explanation please. I declared a public variable in the top of the form (below the Option Explicit - yes?) Public runsum as Integer then in the current event : rcount = runsum In the After Update event : runsum =...

You can also set the forms property to modal so that they keep the focus until closed. This will stop users from moving from the most recently opened form until they have finished what they were doing on that form (i.e and close and save etc)

Cant find what I am looking for on the forum so if anyone can help me or tell me what to search for that would be great... I need one of my forms to display a running total of updated records, but only those records that the user clicks a command button on. i.e if i have a recordset of n...

Thanks guys - very helpful. Its amazing how many new things I learn everyday from this site. The great thing is now I have a better way of testing for the last record and I also learnt how to trap errors. 2 for 1! thanks again.

Thanks RG. I was actually looking to show the record count on the form somewhere so this will come in handy (Thanks to GHudson). However, thanks to the forum (as always!), I now know how to trap errors and so I have created a msgbox for the particular error I was getting while leaving the...

Help please guys! I have searched the forum but can't find anything specific enough for me to work with. I have a form that displays the results of a query one at a time. The user then checks a few boxes/fills a few fields before clicking OK to move to the next record. When the user gets to the...

Its OK - thanks to the ubiquitous GHudson (what a guy! :cool: ) I have found an answer to the problem - I was actually looking to disable my mouse scroller and I happened to come across the vbInformation code i was looking for! MsgBox "There were no modifications made to the current record"...

I saw the solution to this on this forum a while back but no matter what I search under I cant seem to find it again! Can someone remind me how to change the Title of the error message boxes I can change the error message - by changing the Err.Description - but how do you replace the...

use conditional formatting... search the forum for more info if needed. Good luck

Does the scrollbar appear once you click into the memo field?

This is probably a convoluted method but it should work but only to change 4 digit numbers to six digits (but you can do it again for different lengths) Create a select query that contains the field you want to change. Set the criteria in this field to Like "####" (i.e it will only select...

Have you tried deleting the control from the form and then replacing it again? I sometimes have to do this with fields that I have changed within tables but do not update within forms. Only an idea...

Thanks for the standard colour in RGB but does anyone know the standard colour of the Tab area (that off white colour) in either RGB or the number that access displays colour in?

Do as selena suggests - copy the db onto a cd and then copy it back to another location on your hard drive to check it all works. It does sound like all these problems are occuring due to you running the db from the cd. The only other time I have got blank forms as you say (but can still see...

Im not sure about that. With my db I only had to start pressing the shift key once I had created an autoexec macro that opened my switchboard and maximised it. Have you got an autoexec macro? (or maybe check the startup option in the Tools menu)

when you open the db from a cd it will always be read only. You need to copy the file onto a writeable disk first i.e a hard drive. HTH

make sure you hold down shift when you click on 'open' (at the security warning about macros AFTER double clicking the mdb file)

Having researched further I am now under the impression that I can actually make my db available THROUGH my website i.e through the users browser (does this eliminate the need for Access to be installed on the users machine?). From what I can gather (and I am not at all clear with these things)...

I too have used redstation and have found them very good. The free hosting is good enough for home/small business sites (a very good 1Gb webspace), but beware it doesnt support MS Frontpage extensions (unless you upgrade to the business account - £99). The other consideration is bandwidth - I...

Thanks Ashfaque - I was guilty of all of these! I guess teaching yourself stuff is not always the bet way! thanks again.