Search results for query: *

Hi Everyone, I have scoured Google and the likes for days on end now trying to find an answer to this... hoping someone can help me here. I am setting up an intranet site for my region, and I want the application to recognise the user automatically as they access it. I need IIS to be set up...

Hi Folks, I have a GridView control (ASP.NET 2.0) inside a LoginView/RoleGroup section of a page. For some reason GridView1 is not recognised in the code-behind file. I changed the login view to the RoleGroup so I can see the design of the GridView in VS, but the aspx.vb file still fails to...

I managed to sort it myself :-) For anyone else that wants to know: I created a hidden field on the group footer that is a count of one field in the detail, then coded an On Format event for the group footer to Cancel if the count = 1, like so: If InvNoCount > 1 Then cancelfooter = 0 If...

Hi Folks, I am trying to solve a little problem I have. Having recently re-designed our customer statements, and am now being asked to group all transactions on each invoice together, for example, the original billing, any payments and/or credits, journal vouchers etc. I have done this and...

got it: Declare Function GetDC Lib "user32" (ByVal hwnd As Long) As Long Declare Function ReleaseDC Lib "user32" (ByVal hwnd As Long, _ ByVal hdc As Long) As Long Declare Function GetDeviceCaps Lib "gdi32" (ByVal hdc As Long, _ ByVal nIndex As Long) As Long Const HWND_DESKTOP As Long = 0...

Now I'm getting an error from the Sub at this section: If hwnd <> 0 And GetWindowRect(hwnd, rct) <> 0 Then Height = (rct.Bottom - rct.Top) * Screen.TwipsPerPixelY Width = (rct.Right - rct.Left) * Screen.TwipsPerPixelX End If it doesn't seem to like the TwipsPerPixelY and...

Maybe it's me being totally stupid, but how do you call the Sub from the form? I've tried intWindowHeight = WindowSize.Height without much success, and unsure how else I would reference it... But really - thanks for your help so far golom - I have spent all day trawling the net for a...

Okay, I have that lot figured out, but how do I now get the height value through to my form so i can tell it where to position itself? The form is 1185 twips high, and I want it positioned at the bottom left of the screen. The status bar is present. I'm sorry to sound like such a novice, but...

now knowing as little as I do about API coding - where would I put the Private decalre function sections?

I knew the answer would involve APIs - cheers Golom! :-)

Just to quickly elaborate on where the registry settings are saved too: HKEY_CURRENT_USER/Software/VB and VBA Program Settings/ProgramName/

Hey guys, I have started using GetSetting and SaveSetting instead - this saves the items to the Windows Registry for later use. I have found this handy for features like program environment customisation. SaveSetting "ProgramName","SubKeyName","Property",Value and: envSetting1 =...

Hey Guys, I would like to code something that will give me the height of the Access application window as I wish to place a 'ticker tape' style device at the bottom of the window. I have determined my 'ticker tape' device is 1185 twips high, but the actual inner height of the access window...

it doesn't work, it still places the column header in the file...

I would prefer not to, as it ends up with a customer and they specified Excel. I'm trying to remove any manual intervention from the process, to eliminate any chance of human error. Cheers :)

Hey Folks! How would I achieve the above? Everything I have tried so far has yielded no result. All I want to do is to have access determine a filename to save as (from a form) and export a table to that filename WITHOUT the column headers. Any help would be great :-) Thanks

Here's the solution programmed on a form button: Private Sub ProcessNow_Click() DoCmd.GoToRecord , , acFirst While entry_type <> "" stock_no.SetFocus While Right(stock_no, 1) > "9" stock_no = Left(stock_no, Len(stock_no) - 1) Wend While Right(stock_no, 1) = " " stock_no...

No Remou, looking at that it wouldn't work as sometimes there may be more than one letter suffixed. One way I would have looked at doing this in the past is using a form and loading each record through it in turn, altering the field with code as each record passed through. That I could...

To be honest I haven't tried anything - I was hoping someone out there may have already addressed this and save me hours of experimenting with code as I am unfamiliar with writing modules for use in queries...

Hey Folks :-) I'm trying to find a function or formula that will present me with only the numeric part of a field, say if a field has the value of 0475878X, i just want the number without the 'X' suffix. Problem - The string isn't a fixed length Problem - There may be more than one letter...