Search results

The most transparent mail control I've ever implemented was using SMTP and circumventing Outlook altogether. It took some time, but I have even at this point been able to send attachments, etc. from Access via SMTP. The nicest thing about SMTP is that you don't have to rely on Outlook or any...

If you've written a function, you can call it with the OnClick event like ColinEssex describes: Private Sub Button_Click() Call functionname End Sub

are you sure? I just tested it and the statement I posted above displayed the following results: (No Title) = John Doe (No Name) = Access Programmer (Name and Title) = Jane Smith, President

You could also just try the following as opposed to using a function. This works pretty well with mailing labels, etc. as the report field's Control Source: =IIf(IsNull([ContactName]), [Title], IIF(IsNull([Title]), [ContactName], [ContactName] & ", " & [Title]))

So between dates A and B, you need to be able to display each 30-minute increment from 12AM to 12AM? That's not too hard to calculate, actually: Try creating a test form with a list box, two fields (for start date and stop date), and a command button: ListBox: lstIncrement (the field source...

actually, I told you incorrectly the first time, sorry. It should be: Call ErrorTrap [This message has been edited by jatfill (edited 05-08-2002).]

Single Calendar Control Sample - Access 97 Single Calendar Control Sample - Access 2000 What these demonstrates is how to make a single form with one calendar control on it, and then call it from any other form in your database, even if that form has multiple date fields... This is something I...

Seems to me that would work. The only issue is if you need to reference "offending controls",i.e. being able to differentiate between user data errors and actual program issues, you would need to pass control names into the function as variables. It looks like you're sending errors via email, so...

The only flaw in your approach is that you are relying on data storage for each time interval. If you store the fixed schedules (employeeID, start time, stop time), you can build the snapshot based on that schedule by looking at a particular time, i.e. 5/7/2002 7:30AM & see how many have start...

Wouldn't you just call that function in the subs? Something like On Error Goto Err_Sub (Procedure...) Err_Sub: DoCmd.OpenFunction ErrorTrap

I believe the correct statement to pull the age would be something like DateDiff("y",Format([bday],"yyyy"),Format(Date(),"yyyy"))

I've done this with success on a DB I use at home... http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q209862

could you post specific error(s)? Chances are, one or more of the references in your project are broken when you transfer it to another user's machine, especially if you built in XP...

This may not be the easiest way of accomplishing this, but I would probably try something like the following: Create a table with two fields called "tblAccess", name the fields "rec" (text)and "accesscount" (number). Create a single record in the table with the "rec" field value of "primary."...

I get that message every time I use the label wizard/5160 combo. All I do to solve it is to resize/shrink the right side of the report over to the left, eliminating the right 'gap' between the end of the report and the end of the field. After that the message dissappears & they print fine.

I know this isn't a solution for the problem at hand, but you might consider using an option group instead of two buttons (you can actually make an option group look like two buttons also). Option groups have assigned values, so you can run your procedures based on which of the two options is...

On the structure end, you may want to consider adding the date to the timein/timeout fields instead of just storing the times. If you do this, the calulation bacomes pretty simple, and you can still display just the times using the Format function. If you do store the dates, you can even just...

I don't think you can supress the column based on a condition, but you can easily supress the record/row. In the criteria field for the column you want to filter, just add 'Is Not Null' (excluding quotes). The query will return all of the records in the table where the column you are filtering...

Assuming "timein" is null prior to you wanting to update its value (if there is another rule involved it may get a little trickier, but not impossible) you would modify the Form's Current event as follows: If IsNull(Me.timein) Then Me.timein = Now() End If This will only update the timein...

Make sure you have the ActiveX component registered on the second machine... chances are the reference is missing. In debug mode, stop the process and go to the Tools menu and select References. The list should show a broken reference, indicating that the control needs to be installed and/or...