Search results

Hi Are you declaring IRibbon as a control? This should be a public variable. I don't have the link to hand as I'm on my iPad but if you search my threads, I have a very detailed tutorial for ribbon with the vba that's required. Cheers

Hi Dave I fixed the problem. It was because I had placed the bmp at the exact correct proportion. As soon as I put it at the correct size, the grid disappeared. Initially, it looked just like the grid on a form at design view. The image itself is a general windows image that comes with the os...

No need to panic and rush to my assistance any more lol it seems that unless the bmp is set up on a form at the exact same size that it should be, these lines appear. At first glance they look like they are the grid lines from a form but in reality it is the compression of the image. the...

figured it out. Divided the windowwidth by the RECT cheers Nidge

Hi Guys, just a quickie. When i look at the attached image in photoshop as a bmp, its perfect. When i add it to an Access form, it has a grid on it. Is this usual or unusual for a bmp? i have added it by an image control. cheers Nidge

Hi Sam, my bad. here it is lol :)

Hello mate. the rectangle on my form has these properties- Left - 3.199cm Top - 0.199cm Width - 13.898cm Height = 10.818cm by using this code, i can get the RECT of the popup form Private Type RECT Left As Long Top As Long Right As Long Bottom As Long End Type Dim FrameRect As RECT Set...

Hi, have you tried Me!BulkAttachment.Value Me!BulkAttachment.Text you could also use- Dim sAttachment As String sAttachment = Nz(Me!BulkAttachment.Value, "") Cheers Nidge

Hi Guys, just cant my head into gear today....... i am trying to set 4 points on a form. i am using RECT Private Type RECT Left As Long Top As Long Right As Long Bottom As Long End Type i am setting this Dim FrameRect As RECT i can get a return from the form of 4 co-ordinates Left...

Hi Sam, not sure which type of colour dialog you are looking for but this is a pretty ok & simple one. Centres in the screen too ;)

LOL i actually meant to do a color dialog....... sorry. I'll do another one today with a colour dialog only :) Cheers nidge

Hi Jon, i found these- Top poster of the month / year http://www.vbulletin.org/forum/showthread.php?t=236822 similar http://www.vbulletin.org/forum/showthread.php?t=240535 http://www.vbulletin.org/forum/showthread.php?t=121918 cheers Nidge

Hi Sam, Did any of the suggestions / examples work? it would be good order to let people here know so they can forget about the thread... cheers Nidge

Hi, with lots of users not being here for as long as others, it would be very difficult for someone to see their name in the 'top posters' section for a very very long time. To promote users to help other users, wouldn't it be great if there was a 'Top posters of the month' at the bottom of...

Hi Frank, try this: Option Explicit Private Declare Function GetLocaleInfo Lib "kernel32" _ Alias "GetLocaleInfoA" (ByVal Locale As Long, _ ByVal LCType As Long, ByVal lpLCData As String, _ ByVal cchData As Long) As Long Private Declare Function GetUserDefaultLCID%...

Hi Sam, try this little app i put together for you. Check out the routine (CenterWindow) which is responsible for centring the dialog. Cheers

Hi, has your application by chance, got a MS Flexgrid in it? Cheers Nidge

Dude I'll post my code tonight. I have a position example too from a different forum but it's quite hard to decipher even for me lol my code works just fine Tonight dude :) Nidge

figured it out, i set Sh As Rectangle have a fully fledged print form child window ( no borders ) now :D nidge

Hi, in Access on a UserForm, you do this- Dim sh As Shape Set Sh = CopyImage(Me.Image1, Me.Caption) i can also do this- Dim Frame As Frame The Frame is the equivalent to an Option Box in Access. My Question is and i know its very vague but, what is the 'shape' equivalent in Access...