Search results

How about chaning the ControlTipText property to whatever you want to see? Private Sub Image0_MouseMove(Button As Integer, Shift As Integer, X As Single, Y As Single) Image0.ControlTipText = "This is a test of showing the text" & vbCrLf & _ "over an image when...

You will need to change couple things: tblJoin pkFacilID - should be a number (not AutoNumber) since it is foriegn key. For you form "CCL Residential Care Facilities", the subform needs a view that contains link between the tblJoin and Care Options table. This will allow you to link the "CCL...

Interesting idea. I just tried this in a quick sample db attached. It is not the right way of doing it, but just to play with the idea.

Me.sfrmDisplay.SourceObject = "NameOfTheForm"

Perhaps, you can initialize it like this. Private Sub Initializations() 'intialize variables, text fields, etc.. here End Sub Then call the sub routine when need to. Private Sub cmdOK_Click() Call Initializations End Sub If you want to intialize let's say combo boxes...

Thank you. This is what I need.

Put this in a module and call it when you need to open the database. You need to add the Microsoft ActiveX Data Objects to your ferences. Option Explicit Public gdb As ADODB.Connection Public Sub OpenDatabaseConnection() Dim sConnectionString As String Set gdb = New...

You should create a sub routine to feed the new data into the two process. 'the long way (not recommended). Private Sub DoThis() cboDataOne = "Data1" Call Process1 Call Process2 cboDataOne = "Data2" Call Process1 Call Process2 cboDataOne = "Data3" Call...

Attached is a little program that does what you are looking for. This little tool is the work of many authors across the internet. I have some listed in the program and not some. My appologies. You can use this program to change a file's Created/Last Modified/Last Access date/time. Please...

If you can identify what row should be percentage and what row should be number, you can format your output data that way. In the Detail section of your report, you can use the IF statement or SELECT CASE statement to determine that. Private Sub Detail_Format(Cancel As Integer, FormatCount...

Here is a scenario that I like to get some opinions from the forum. We have an Access application (FE) that access some databases from SQL Server Express. All of the databases (tables, views, etc...) are identical with the exception of the data in the tables for different databases. [Yes...

If user is required to select a value from the combo box prior to processing the next function, you will need to build an error handling routine to do that. This is a logical step. Private Sub cmdOK_Click() If HasRequiredData=True then 'do what you want to do here. End If End...

As Jardiamj suggested, I always use a public sub/function for that sort of thing. You could put something like this in a module. Public Sub Display(byval sFrm as String, byval sFilter as String) DoCmd.OpenForm sFrm,,sFilter, , ,acDialog If IsLoaded(sFrm) = True then DoCmd.Close...

I ran into the same issue for a similar project. I use a queue of users without projects and a queue of project available. Then I wrote another db just to check for those two queues. As soon as a user finish is last project, his db (FE) insert an entry into the User Queue which mark him as...

1. The forms are linked using POID, but your tblOrderDetail contains no POID so no surprise here. Subform's POID default value should be the Reference Number on the main form. 2. How do you want it? The cost code in the combobox is already attached to the table each time you change it...

Do do that, you will need to use some sort of select statement to check if a record exists in another table. For example. Private Sub DeleteRecord() 'assuming that you know the record ID for this particular record that you want to delete. If...

Just anyone else do what I did. Public Function EnabledAll() Dim i As Long For i = 1 To CommandBars.Count CommandBars(i).Enabled = True Next i End Function

Well, to know if selecting multiple items or using multiple combo boxes will work or not, we need to know what the form does when you select one item from the list box. Besides that, we need to know how the graph is generated. Peace. EZ

This is a pure common sense, but try this. Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" (ByVal hwnd As Long, ByVal lpOperation As String, ByVal lpFile As String, ByVal lpParameters As String, ByVal lpDirectory As String, ByVal nShowCmd As Long) As Long Public Sub...

Add a Date field to your table and then filter the form to only show records that are >= Date - 1 . This should only give you the previous day and current date.