Search results

If you include the following vb in the forms update event.... me.requery ....new records will become visible without closing and re-opening the form

To Hide your database navigation window use the following VB in your forms open event DoCmd.RunCommand acCmdWindowHide The following makes the navigation window visible again DoCmd.RunCommand acCmdWindowUnhide

If you give users enough rope they will probably hang themselves so although you can't hide the File Menu you can use VBA to restrict what appears at run time. I also use a custom Ribbon to hide lots of built in commands to avoid any user being "innovative" All the built-in commands are...

What version of access are you using ?

Hi I am using Access 2010 and I have just copied your SQL into a query After I swapped the table name and field name for ones in my database, the SQL compiled and ran without an error so....... If the Query used to work but now it doesn't, something external may have changed. Have you...

Hi If you want the code posted by Mark_ to be actioned without the user having to click the DIADL field, you can use the forms timerInterval event The status of DIADL would then be checked nn times every second

By the way using a sub form you will need syntax along the lines of me.controls("SubFormName").form.controls("ComboName").Column(0)

Hi In this scenario I always have a hidden column (width set to zero) containing the GUID of each record. I then use an "OnClick" event with the control to compile a SQL string along the lines of :- Dim s as string s="SELECT * FROM [TableName] WHERE " s = s & "[GUID]=" & Me.ControlName.Column(0)

DoCmd.OpenReport ReportName:="ERA Updates001",View:=acViewPreview,Where Condition:="Not IsNull([ERA Updates]) And [ERA]=#10/26/2017#" End Sub Change to WhereCondition (leave out the space)

Also noticed that Variable "Password" is being passed into the function....... Public Function InitConnect(Optional UserName As String, Optional Password As String) As Boolean ..........but you are using variable "PWD" as part of the connection string in your querydef With qdf .Connect =...

Hi Jeff I know nothing about MySQL but I have noticed that in your connection string..... strConnection = "ODBC;DRIVER={MySQL ODBC 5.3 Unicode Driver};" & _ "Server=" & SERVER & ";" & _ "Port=" & 3306 & ";" & _ "Option=" & 0 & ";" & _ "Database=" & DATABASENAME & ";" .......the values of...

Hi Gasman I believe your hashes are in the wrong place "[InvoiceDate] < " & Format(Date(),"\#mm\/dd\/yyyy\#") should be "[InvoiceDate] <#" & format(Date,"mm/dd/yyyy") & "# AND [PaidDate] is null"

Thanks MarkK & CJ_London for your speedy posts I suspected that there was going to be no alternative to using VB to loop through a recordset in some shape or form however it was worth asking the question just in case.... CJ - Trains which run over midnight get picked up via an IIF clause as...

This has stumped me as I can't come up with any GROUP BY logic which fits the bill I work for a Train Company which runs circa 1,300 services per day and I need to count how may trains are running on a minute by minute basis from 00:00 until 23:59. A highly simplified example :-...

Discovered that simply making the form pop up will stop all flickering (doesn't need to be modal) The only downside of this workaround is that any user defined ribbons will not be displayed while the pop up form is displayed George

Hi Don't know whether this is a help to anyone I use form captions as a pseudo status bar to keep users informed of what is happening in lengthy multi stage functions I Recently migrated from Access 2002 to 2010 and got the form flicker effect every time the caption changed on a continuous...

Hi Thanks for your response I already have "Microsoft Shell Controls and Automation" ticked in the VBA references and I have no disabled features which I why I am a bit mystified why the Shell Command won't compile. I have managed to do a work around by writing a .BAT file and then...

Hi I'm using Access 2002 and can't get the Shell Command to compile Anyone any idea which VBA reference needs to be ticked to enable compilation ? Spent hours reading threads this afternoon but couldn't find any which covers this issue Thanks in advance George