Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. shanef1981

    Getting local user name while using fixed login on IIS

    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...
  2. shanef1981

    Invoking SelectedIndexChanged for GridView row inside LoginView

    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...
  3. shanef1981

    Exclude group footer on groups of only one line

    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...
  4. shanef1981

    Exclude group footer on groups of only one line

    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...
  5. shanef1981

    Determine the Access application Window height

    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...
  6. shanef1981

    Determine the Access application Window height

    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...
  7. shanef1981

    Determine the Access application Window height

    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...
  8. shanef1981

    Determine the Access application Window height

    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...
  9. shanef1981

    Determine the Access application Window height

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

    Determine the Access application Window height

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

    How to initialise a permanent variable

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

    How to initialise a permanent variable

    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 =...
  13. shanef1981

    Determine the Access application Window height

    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...
  14. shanef1981

    Export Access table to Excel without column headers

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

    Export Access table to Excel without column headers

    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 :)
  16. shanef1981

    Export Access table to Excel without column headers

    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
  17. shanef1981

    Removing non-number suffix in a field

    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...
  18. shanef1981

    Removing non-number suffix in a field

    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...
  19. shanef1981

    Removing non-number suffix in a field

    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...
  20. shanef1981

    Removing non-number suffix in a field

    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...

Part and Inventory Search

Back
Top