Recent content by slsy1212

Hi, I have code for sending batch emails to addresses listed in a query, which works fine on my pc with outlook express, but with outlook on the client's machine it keeps getting that pesky security message for every e-mail it tries to send. the client however also has outlook express...

Hi, I had the same problem before, I don't know what causes it, but to bypass it, instead of making a command button that opens a form, make a macro that opens the form and a command button that opens the macro. In the macro you can define what view the form should open in. :)

Hi, hope someone can help with this... I used code from this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=40346&referrerid=20626 to display the name of the person currently logged in on the main menu. Basically I made a module declaring a public variable, on the login...

same problem hi rvd48, i'm having the same problem with my form! and i'm just using a command button that opens the form and displays all the data, when i open it manually from the db window it opens in datasheet format, when i open it with the command button it opens in continous form format...

Hi, I have a form which functions as a main screen from which you can click a button that opens another form and displays all the data. However, with 3 of the forms (that are built on a query) when I view them by manually opening the form from the database its fine (ie the form displays in a...

Hi, i've looked all over this forum and there are so many threads about sending e-mails, but i couldn't find any that was what i needed... what i need to do is to have a button for each entry on a form, where upon clicking it an e-mail from outlook is generated with the e-mail address of the...

errr... i do have a login form, and i'm quite a begginner in access so i'm not sure what you mean with the debug error thing... there must be another way to go about doing this?

i've posted a thread about this before - i need to capture the username of the person currently logged in to record who made which entry, and previously i just used a query to extract the username, with Environ("username") as the criteria, and it used to work, but now i'm using an updated...

Hi, thanks for all your help... you're totally right Pat, i've now realized that the field has to be bound to the table in order to record the user for each entry that is made. I understand what you mean by inserting the code you provided in the BeforeInsert event of the form, but how do i...

Hi, i actually have Access 2000... and wouldn't even that keep changing as the username of the person logged on changes? :confused: Thanks...

hi, i have a form where i need to capture the name of the person logged in to record that they are responsible for making that entry. i used one of the threads in this forum to make a login form and then use dlookup to capture the name of the user that is currently logged in, which works, but...

Yay! i finally got it to work! i just thought i might as well try, i followed your advice and tried if rsVacs.RecordCount > 0 Then... and it works!! thanks so much for your help meboz, its much appreciated! :p but now i realized theres another smaller problem... if theres more than one record...

Hi, I'm making a database in access where the number of minutes a resident has kept something is recorded in through a query. What i need to make is a msgbox notification that checks if there are any entries where the minutes is equal to a certain number of minutes, and then displays the name...