Search results for query: *

Dude, The best thing you could do is hire a programmer. The time you can save and put toward your expertise should more than return on the investment. Stix 42 Long Live Rock and Roll Pop is for drinking

Hey Surotkin, What I meant was to put the form_load event on the frmMyForm module. Then the call does not have to be public. Also if the form is opened from anywhere else in your code you don't have to make the second call. It also is a better use toward encapsulation. Stix 42 Long Live...

MadetoHeal, Sorry about the limitations. Are you comfortable working with the Outlook object model? Because this is where you have to go to pull the information. Stix 42 Long Live Rock and Roll Pop is for drinking

david and pampers, The form_current event only fires when the record is loaded. You may want to find the fields that can be changed and add the code to their afterupdate events. Stix 42 Long Live Rock and Roll Pop is for drinking

I don't know exactly what you mean by running a command button. However, vba offers two events for the form while it is opening, Form_Open and Form_Load. Form_Open fires before the controls and data are loaded, and Form_Load fires after. If you add the command button code to either of these...

David, If you setup a global variable on the form to flag if closure is possible, you may want to consider using the form_unload event to set the cancel on close. This way the user can't close the form by any method until the values are reconciled and error message can be posted to the...

stupiet, You could create one table with all the dates and then link it to the table with actual employee, date and reason. Using join you can create the table you want. You may want to add a month combo to help managers with having to scroll to find a month. Or if you are really inspired...

Hey MadeToHeal, I may need your help some day. Have you tried using File/Get External Data/Link Tables. The Open dialog can be changed to Outlook through the file type combo at the bottom. I have not done this any more than verify that it is available in my Access 2000. Stix 42 Long Live...

Scott, Have you checked the references in VBA to see if she is missing something? Maybe MDAC version is not up to date. Stix 42 Long Live Rock and Roll Pop is for drinking

Hey Surfside, Sometimes things take time, like wine and cheese. Did you try the sum(field) function. It can be in the section header or footer. Stix 42 Long Live Rock and Roll Pop is for drinking

Is the fieldname StafforChildID? DCount( FieldName, Table, Filter) The "*" will work in counting records as well. If DCount("*", "dbo_EmergencyContacts", "[StaffOrChildID] = " & me.StaffOrChildID) < 2 Then MsgBox ("You Need to Input Another Emergency Contact") cancel=true End If...

Hey Julien, We all started where you are at now. Maybe next time you should consider posting one problem at a time or posting seperate threads to keep your threads shorter and to the point. So lets start with your time sheet form. What can you tell us about the tables and data that the main...

How about posting the code that is causing the error so it can be checked for syntax. Also any variable declarations. Stix 42 Long Live Rock and Roll Pop is for drinking

Hey Rob, If you don't want them to exit the form, you may want to use the form_unload event and set cancel based on the value returning 2. Otherwise you don't need the count() function when you are using the DCount, but you may need to add a filter to select the appropriate records if this is...

Maybe instead of select case you could use if then else statements IF( isGroup("GroupName1"))Then 'group1 execution elseIF(isGroup("GroupName2"))then 'group2 execution end if where isGroup is a public function Function isGroup(GroupName As String) As Integer 'Code sample from...

Maybe you could post the sql statement for the recordset being used. Or maybe the code that is setting the msg variable, or why you are not using the !msg variable from the recordset. Stix 42 Long Live Rock and Roll Pop is for drinking

You could create a public function and insert it into the macro at certain points to update a displayed form. If you pass a parameter of %complete then have the function update the form. Remember to add a doevents after changing the form so the display can update before running the next query...

On the other tab is a cycle property that can be all records or current record. Also by right clicking on the top left corner of the form, you can select from the popup menu the tab order and set the order the fields. Stix 42 Long Live Rock and Roll Pop is for drinking

Dead7, Maybe you could give us a reason behind your request, or more detail. You can use the activecontrol property to access the current control from a public function when you call that function. Stix 42 Long Live Rock and Roll Pop is for drinking

Have you tried using the first combobox's after_update event, or onclick event. Evaluate the comboboxes text and act upon it accordingly private sub combobox1_afterupdate() me.comboboxalpha.visible = comboxbox1.text = "Alpha" me.comboboxnum.visible = comboxbox1.text = "Numeric" end...