Search results

Thanks - I have just given it a shot, and even with text in there it assumes that it is height of a single row of text. I think I might be best to make the rows of a fixed height and let that dictate what is written in them. Come back Access, all is forgiven!

I have inherited a spreadsheet that needs some modifications, and am wondering if I can make it a little more user-friendly. My initial thoughts were to start again from scratch, but I am under instructions that this is not an option and I need to make the modifications to the existing layout...

I think I have found the problem - it appears that our network has been less than happy, and has been dropping connections all over the place. We operate another type of database (essentially a large HR system) and it too has had problems; users who have logged out are not actually being...

I wouldn't believe that this was true if I hadn't seen it with my own eyes, but I assure you that it is. I have a table which is mainly used as a source of information that is used daily. Edits or additions to this table are fairly rare, and are done through a specific form and any changes...

Superb! Thank you :)

Is there any way to remotely terminate all users sessions to allow for maintenance such as a compact and repair to be done?

Sorry I am late back to this one, simply haven't stopped this past week or so. Thanks for the advice, I will hopefully be at a stage to use it shortly. :)

I am looking for a quick way to have a label's property set visible when a DCount is equal to 6, or whole number multiples thereof (so 6, 12, 18, 24 and so on). Doing it for just one of those numbers is easy, but what about the multiples - is there an easy way around it?

Thanks The OnCurrent event is Me.ResetForm which refers to a Sub that carries out the required processes. Your solution works perfectly, thank you once again :)

I have a form which has an On Current event which basically sets various items visible (or not) depending on the values of some of the fields. Previously, this was taken care of by the On Open event, but I needed it to refresh after data changed in a pop-up sub-form (see this thread Now, that...

After a little bit of experimentation, I now have this working beautifully. Thank you for all your help :)

Thank you - I am following it, but struggling a little to get my head around it. I have managed to get my current database to identify a new version, then open the update utility (I did this by changing strPath to the location of the database Update.mdb on my network) Now, the utility has...

OK, I have got my glasses on now (always helps :D) and things are a little clearer (I think :D) I am assuming that this bit of code strPath = Left(CurrentDb.Name, LastInStr(CurrentDb.Name, "\")) strPath = strPath & "Resources\Update.mdb" Is stating where to find the update utility? So, in...

How many users are using your database?

Things have calmed down a bit and I still have a couple of hours, so I thought I would give it a whirl - - I am working on a copy of both front and back end anyway, so if I do destroy anything all is not lost. I have created the tables as suggested, one linked, one local I have created a...

Your suggestion looks good to me :), thank you There are a couple of bits of the code that I am not quite getting at the moment (and things have just gone a bit manic here at work which doesn't help); I think my best bet it to try this out on my home network with a copy of the front and...

To date, whenever I have done an update that requires a new front end, I have ensured that nobody is using the database, then changed the name of the folder that contains the back end, updated the table links accordingly, created an .accde file and then saved that on a shared location for people...

Thank you :)

So, that would be Net Price = TotalCost / (1 + VAT%)? Sorry if I am being utterly thick :o

Brief background - a good friend of mine has inherited a small business as a result of a fairly nasty family breakdown, and prior to that breakdown the family that were running the business literally ran it into the ground (knowing they were going to have to hand it over); in short, there is...