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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: jioek
  • Order by date
  1. jioek

    Disabling Min/Max of Access in Taskbar

    Private Sub Form_Open(Cancel As Integer) Dim lngReturn As Long lngReturn = ShowWindow(Application.hWndAccessApp, SW_HIDE) End Sub you need to set the form popup = true this code hides access completely except when you press cntr+alt+del if you want to change the title go to tools startup and...
  2. jioek

    Combo Box Query

    in the query use like "*" & [mycombobox] or try nz(mycombobox) 'null to 0 funtion' that will return all
  3. jioek

    Error: You can't go to the specified Record

    you may need to set focus to that form then gotorecord
  4. jioek

    how to use a hyperlink to open a form in a subform

    in the hyperlink subaddress property of the control select "object in this database" find the form or create a macro to open the form
  5. jioek

    Help-JPEG's images not appearing in forms, just filenames....

    access requires office ie photo editor to display jpeg try to install "ms word viewer" if you can't get office http://office.microsoft.com/downloads/2000/wd97vwr32.aspx
  6. jioek

    disable/enable Insert key?

    place this in the Key Down property of the control or form Select Case KeyCode ' If user presses insert or shift Case 45, 16 ' Disable the keystroke by setting it to 0 KeyCode = 0 Case Else Debug.Print KeyCode, Shift End Select...
  7. jioek

    Turning Off Access Menus

    you need to put =0 in the menu bar property of the form or report and uncheck the "display database window" in the tools startup
  8. jioek

    Hide Top Part of Database Window

    create a new module and past this code then call RemoveAccessCaptionBar() in autoexec macro >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Option Compare Database Option Explicit ' Store rectangle coordinates. Type adhTypeRect x1 As Long y1 As Long x2 As Long y2 As Long End Type Declare...
  9. jioek

    Importing data in access table

    import it into a temp table then append to your table you can use a macro to do both or use code
  10. jioek

    Parameter query in subreport prompting twice!

    Recreate the form or the report.Copy and paste all controls and code into a new form. I had a form that was screwrd up and that worked for me.
  11. jioek

    ? Macro Condition to ck existance of table

    I use a form to perform that task and it works great. At the end of My DoSomething macro I open my DeleteTable form. I set the timer interval in the form to 5000 I put this in the "On Timer" event procedure Private Sub Form_Timer() On Error Resume Next DoCmd.DeleteObject acTable...
  12. jioek

    How to Hide Menu Bar in Excel

    have you concidered using access instead of excel you can use menu = 0 in a form and all menu items go away
  13. jioek

    Ideas on how to import e-mail into access 2000

    I use this program and it works well for me the email body is stored in the table using a field set a as "memo" data type http://www.cypressnet.com/Products/msgparse/msgparse.htm
  14. jioek

    Handling 0 record count condition

    use count(nz([Amount])) null to 0 function
  15. jioek

    Sort problems in Access

    try adding code in onopen DoCmd.GoToControl "customer name" DoCmd.RunCommand acCmdSortAscending or onopen add me.filter = "" docmd.applyfilter
  16. jioek

    Having the Access window min in the background

    http://www.kbsonline.com/hide_access.mdb is a good example save to your drive access 2000 or xp
  17. jioek

    Access 2002 to 2000 conversion problem.

    convert it to access97 then open it in 2000 and select convert to 2000 Good Luck
  18. jioek

    write a query to find date and time.

    use like #06/11/2002# & "*" or like *06/11/2002*
  19. jioek

    Minimum system specifications to run Access

    p1 200 64 meg works
  20. jioek

    Database window won't go away

    Application.SetOption "ShowWindowsInTaskBar", False add this code to the first form you open in the forms(on open) event procedure

Part and Inventory Search

Back
Top