Search results for query: *

sp_who

I'm sorry try this, Dim ct As Container Dim doc As Document Dim db1 As Database Dim FrmName As String, strRowSrc As String Set db1 = CurrentDb() Set ct = db1.Containers("Forms") For Each doc In ct.Documents FrmName = doc.Name strRowSrc =...

if you put LIKE 'soft*' it will give you everything starting with soft and so on. HTH

if you want to calculate days then it would be: Format("d", BeginDate, EndDate)

DateDiff

currentdb() or the full path and filename. eg. dim db1 as database set db1 = currentdb()

Dim ct As Container Dim doc As Document Set ct = DB1.Containers("Forms") For Each doc In ct.Documents List3.AddItem (doc.Name) Next doc Set ct = DB1.Containers("Reports") For Each doc In ct.Documents List4.AddItem (doc.Name) Next doc Set ct =...

sounds like there might be a problem on the share permissions, or the path changed. It should work the same on workstation and server, it's just accessing the file. HTH PsychPt@Hotmail.com

create a query from the values in the form and attach the report to the query. HTH

Try: SELECT NewClient.Name, NewClient.[Business Unit] FROM NewClient WHERE (((NewClient.[Business Unit])=IIf([Forms]![MIS]![BU]<>&quot;(All)&quot;,[Forms]![MIS]![BU],[Business Unit], &quot;Like *&quot;))); HTH PsychPt@Hotmail.com

If the Public Keyword is used in a module it is accessable by ALL. If the Public Keyword is used in a Form it is only accessable to the rest of the Application when the Form is loaded, if the form is unloaded or closed it will NOT be accessable. HTH Psychpt@Hotmail.com

make the .visible true

I don't know if this will help, but try DoCmd.SetWarnings False without the brackets. the runtime version is very bugy that way. HTH PsychPt@Hotmail.com

First of all, if you're using the dirty property you must do it for every edited control on the form. Second, when using the dirty property use the oldvalue along with it not undo. Third, The first On Error will never happen. Fourth, the help has a very good example of the dirty usage. HTH...

There are many ways to change toolbars. The most common and practical way is to create your own toolbar, include only what you want, and specify on startup or on forms(depending on how many different toolbars you create) which toolbar to show and hide. The proper syntax for showtoolbar is...

SELECT SUSER_NAME() HTH

try SUM(........)

DoCmd.GoToRecord , , acNewRec HTH PsychPt@Hotmail.com

with the calendar control that comes with access, you CANNOT change the color of just one day on the calendar. The only choices are: Border color, Background color, Font color for the days(all), Font color for the Grid(all), and the Title color. the only way to do what you want is to create...

yes it works in access vba too