Search results

In my opinion, the code is flawed in almost all areas including its intent. Perhaps try using a Multi Dimensional Array variable (declared as Variant) to hold the desired data and fill this Array by way of a Recordset rather than flipping though each record of a Form and pulling the data. As...

Curious....If you're not partial to Tab Stops on in the SubForm, what happens if you set the Tab Stop property for each button to No? I have come across this sort of situation may times and the solution I use is to hide a Text Box in the Form by setting its' Width property to 0, BackStyle...

Did you make the pop up calendar yourself or are you using a Calendar or Datate Picker Control? If you don't want the User to enter any other date other than todays date....then don't use a Pop Up Calendar. Instead, have the user double-click in the field to display todays date (just so they...

That certainly is more concise DCrake...Thank you. SELECT StrConv(FirstName & " " & IIf(MiddleName Is Not Null,MiddleName & " ","") & LastName,3) AS EmployeeName, * FROM [YourTableName]; .

You can either pass the Control Name to the Sub-Procedure or the Control object itself. If you pass just the control name then your Sub-Procedure will need to know what Form this Control resides in, for example: To call the IndexUpdate procedure: Call IndexUpdate("WhateverTheIndexTypeIs"...

Give this some thought (or something like it).... Create a Text Box field in your Report and name it FullName. Set the Control Source to FullName. Enter the Following SQL Statement into the Record Source property of the Report Form: SELECT UCase(Left(FirstName,1)) & Mid(FirstName,2) & " " &...

Here is a function I quickly whipped up to carry out the task for Single Dimensional Arrays only: Public Function MostCommonInArray(ByRef SrcArray() As Variant) As String '********************************************************************************* 'Returns the most common item in a...

So true that is datAdrenaline. Thank you for the correction. .

Private Sub Form_Open(Cancel As Integer) '*** Reference to DAO Required *** 'Required Variable declarations... Dim rst As Recordset 'To hold records from 'tblData' Dim ColorArray() As String 'To hold each color within the Selections Field Dim i As Integer...

If the "StartUpForm" property contains nothing (empty or none) then the property will need to be created with CreateProperty. Select a Form name in this property then try again.

Here is your sample Database back to you (attached). The returned sample DB does not utilize your BuildFilter function nor does it utilize any of your Queries. The Doctor Name within the Search Form has been changed from a Text Box to a Combo Box so that a doctors name can be selected rather...

See Access Help regarding the DateAdd Function. To Add one day to todays date: DateAdd("d", 1, Now()) To Subtract one Day from todays date: DateAdd("d", -1, Now()) To Add one Week to todays date: DateAdd("ww", 1, Now()) To Subtract one Week from todays date: DateAdd("ww", -1, Now()) To Add...

And...if you are going to be applying a Date or Time to a query string (SQL) or Filter etc., it will need to be enclosed between the Hash Marks ( # ). For Example: [Start Date] = #" & Me.MyDateTextBox & "#" which evaluates to [Start Date] = #01/01/2008# .

stLinkCriteria = "[Folder Name]='" & Me.Main_Folder & "' AND [Programme ID]=" & Me.ProgID Dup = DCount("[Folder Name]", "Folders", stLinkCriteria) .

If I recall, the property name is to be enclosed in Quotes: dbs.Properties("StartUpForm") = "Switchboard" dbs.Properties("StartUpShowDBWindow") = True dbs.Properties("AllowFullMenus") = False dbs.Properties("AllowSpecialKeys") = False .

I'm somewhat confused here. In your initial post you indicated that you were having problems with Scroll Bars in a Combo Box yet, the code you supplied in your last post which seems to resolve your problem, turns off the Scroll Bars for the Form not a Combo Box. It's obvious that I completely...

In my opinion......you should perhaps re-think your approach. What I mean is, rather than displaying Error messages all over the place because a User has moved out of data entry sequence within the Form, perhaps prevent the User from doing so. Again, what I mean is, make your Form fields...

I personally can't see anything wrong with the code you have shown and it should produce a XML file named technologies.xml within the Root directory (folder) of Hard Disk Drive C. To me, it doesn't look like you need the Constant declaration (Const cOverWrite As Integer = 1). Other than that...

Play with the following code........see if you can work it in: If the External Database was opened using the Following method: Dim mAcc as Access.Application Set mAcc = New Access.Application 'open the database mAcc.OpenCurrentDatabase "full path to your db" 'launch the form...

If your application is working with a DLL file that is not contained within the Computer system, then you will need have that DLL packaged with the very same application. You must then Register that DLL to Windows. To do this you would use the regsvr32.exe utility which usually comes with the...