Recent content by jioek

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

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

you may need to set focus to that form then gotorecord

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

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

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

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

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

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

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.

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

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

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

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

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