Search results

Try this: Private Sub btnFindLocation_Click() 'Define variables Dim callNumber As Integer 'Receive input callNumber = CInt(CallNumberBox) 'Find book Select Case callNumber Case 100 To 199 OutputBox = "The book is...

Surprisingly I created the form designs in Word, Then screen captured and saved using Paint! Not exactly top of the range products.

The code should work as long as all the items are on the same form.

You could try using the form.move property in your OnOpen event forms("FORM1").move(X,Y,Width,Height)

You could try a select case statement Private Sub combo_priorart_AfterUpdate() Select case me.priorArt Case "No" Me.PEP.enabled=False Me.PMTCT.Enabled=False Case "Yes" Me.PEP.Enabled=True Me.PMTCT.Enabled=TRUE Case "Unknown" Me.PEP.enabled=False Me.PMTCT.Enabled=False End Select End Sub

Here's a screenshot from one of my databases.

You can create your own forms using a graphics program. Choose whatever style you like then.

Just checking, but with Access VBA, isn't it more effective to use Currentdb.execute(SQLStatement) ?

Thanks GalaxiomAtHome, I have now re-written my Custom MsgBox to be totally self contained so I can use it anywhere. Will post some code in a relevant thread when I have tidied it up a little. Thanks again GalaxiomAtHome.

Simple but effective way of turning a postcode into a full address without paying for a subscription. Feel free to use the code, just send a thanks if you like it! Written in Access 2010, but should be fine with 2007.

I appreciate the notion, however I have found in many situations that a simple global boolean can save hours of work arounds. Simple to Fire a true / false when needed then an exit function command if the value is False. Sorry, I'm a completely self-taught programmer so I probably don't stick...

After days of searching for a solution to my problem I decided to tackle it head on and create my own. Why does Access not let you format a msgbox? Never mind, here's my solution for you to use as you wish. This is tested in Access 2010, but should be compatible with 2007 aswell. Rich.

Hello everyone. Been Access programming for years now, and only just scraping the surface of this awesome application. For the first time in ages I can say THANKYOU to Microsoft! Happy to help with any queries you all have. And any Freelance work that's hanging around, let me know! :) See...

Hi, Not really local to you, in fact probably as far away as possible in the UK. But would be happy to help you out. What project are you working on? Rich

Slight change of thread, but thought this may be of use. I've been searching all over for a way to customise a msgbox but there doesn't seem to be a solution. I therefore wrote my own. Hope this may be of use to someone. I've only written in options for up to 4 buttons, but the form / code can...