Search results

Strange It works just fine at home. Would my version of Outlook have anything to do with it? I use Access 2000 and Outlook2000 at work. At home, I use Access 2000 and Outlook XP. I dont' get it. I'll try stepping through as you described to see what happens... Thanks. Bruce

I'm struggling to get the code listed below to work properly. There are two issues I'm faced with. 1. When I open the database and run the sub, only ONE email is generated. 2. If I run the sub a second time, no emails are generated, but the MsgBox comes up saying that "Training Reminders...

Never mind! Sorry for bothering you all with this. It was an error in my tables that was causing problems. One of the dates was entered as 00/00/0000 rather than blank or a valid date. Bruce

Hi All, Hopefully you all can knock some sense into me on this one. I'm creating a dynamic query with a calculated date function that only works part of the time. This works: SELECT s.*, DateDiff("d",s.DSP_Trained_Date,date()) AS Expr1 FROM tblPersonnel AS s WHERE...

Thanks. Thanks Wayne. I'll take a look. Bruce

Why, why, why??? I "stole" some code for changing user passwords and am having nothing but trouble. The code kicks me out when it gets to Dim wkspc As Workspace and this is the error message I receive Compile error: User-defined type not specified I worked great last night... any...

Thanks - I'll give it a shot. bruce

I have a database that I want to distribute on CD. Unfortunately, things aren't working. It's understandable that the database can't be run from the CD due to the constantly updating queries, but why does it maintain it's "Read-Only" status after I copy the files to the HD? Is there an easy...

Never mind Form_Current seems to be doing the trick...

This should be an easy one, but I can't seem to find the right command... I have a two page form where I want either page 1 or page 2 to be displayed depending on a check box (checkSea). The code is below, I just don't know where to put it so it runs each time the user changes records...

Thanks Bob! It worked like a charm. Bruce

Did you try opening it in design view?

Here's another dumb question... Is it possible to specify a path to my linked pictures without listing the entire path? The pictures are in a folder one step below the database folder. I'd hate to have a user move the location of the database files and lose all the links. Thanks. Bruce

Got it to work. Was using the wrong command. The code should look like this: DoCmd.OpenForm stDocName, , , acFormAdd Thanks again to all of you for making this board so helpful! Bruce

Create New Record - Strange How do I create a new record on FORM2 when I'm working with FORM1? Here's the breakdown. I have a dialog box (FORM1) that contains a list box where users can make selections and a 2nd form (FORM2) opens up with the record details. I'd like to put a cmd button on...

Thanks edtab. That's actiually what I was doing. My problem was the location of the statement. I was aksing for a requery, before I went through my subroutine to to modify the query. What a knucklehead! Thanks again for your help! Bruce

Peter, It worked like a charm. I had originally put the statement in the wrong spot and it was updating before the query updated. I took your advice and put in a cmd button to update the list after the user makes all their selections - things move a bit faster that was! Thanks again for your...

Peter, The answer to the first question is 7 Check boxes. The user needs to be able to check all, some or none of the options. I've included a screenshot to help... I'm still new to Access and VB so, I'm not sure how to do the trap you were asking about. Any clarification would be helpful...

This is similar to a question posted by Kevin S in October but I'm using Check Boxes rather than a combo box BACKGROUND: The Form has two sections. One side consists of 7 check boxes and the other side is a listbox. Each time a check box is checked, a requery occurs, updating the records that...

Also, The dialog box only refreshes when I close it and reopen.