Search results

Hello all. I have already received some help on this in the "forms" forum, but I am looking for some more comprehensive answers for this one. I have been asked to develop an email management system in the database I manage. We currently use Outlook and Word merges for email management but we...

Ok, I've fixed part of the problem, I just needed to reference the Microsoft Outlook object library, and the code now hangs on the .send line. Is there a different or better command line for this?

Thanks for that! That works great. Now I have another problem. I have a "send email" button with the following on-click code: Private Sub Command20_Click() Dim mess_body As String Dim appOutLook As Outlook.Application Dim MailOutLook As Outlook.MailItem Set...

Hi. I have an email form which includes an attachment field for a file to be attached to the email. I would like a browser button that will allow me to select a file and pass the path reference to the attachment field. Can anyone assist with this, or are there any good tutorials for this? I...

I can't seem to get this right! I have a login form frmLogin, with a textbox txtUserName. In the AfterUpdate event of the textbox I have a couple of lines of code. Firstly to open a hidden form with a single textbox that I want to retain the User Name from the Login form, and the second to...

I am trying to set up a table that will add and delete users as they log in and out on Access. I have a login form that looks up the username and password etc. but I need to know who is logged in at any time so that if I need to conduct any maintenance in the back end I can communicate with...

Hi all. I am at the beginning of a challenging project for a database I administer at work. I am still learning VBA, so I will need quite a bit of assistance with this as I go I am sure. The task is to develop a call-center type application that will rotate through clients who need to be called...

Thanks, yes this worked! Regarding the multiple yes/no fields issue, yes, I certainly observe standardisation for most fields, but for day of the week fields, it is not such a problem as there is not likely to ever be a new day of the week added, which would cause problems. I tried a...

I have a table where I have client information including fields for weekdays. I elected to use separate fields for the days of the week for this table, which are Boolean fields. What I want to do is to set up a form where I can select the day of the week from a combobox with weekdays as...

Changing the locking option in the form seems to have worked! Cheers.

The form was set to "Edited Records" locking. I have changed it to "No Locks" and I will see what happens. A conflict error isn't a problem, as it will be easy to resolve for this form.

In the situation I am referring to, the user is not completing the entry into the field, but leaving the cursor in the field in "mid-edit". This is unusual in most situations, but in the environment we work in, an operator may be interrupted in the middle of writing to a record and attend to...

It is a split FE/BE with Access BE.

Hi. This is an annoying "thing" that happens from time to time and I need an answer. I have a multi-user database that is updated frequently in real time. From time to time we find that a user fails to save or exit a form and leaves their cursor "active" in a field. This prevents that form from...

Thanks for the suggestion Paul. I will do some more study into coding in VBA for these kinds of situations. For the time being I was able to overcome the problem this time by renaming the referenced objects to shorter names and rewriting some of the repetitive Or statements (e.g. instead of...

Thanks Paul. If I understand this correctly, I can copy the expression into the function after that first naming line? Is it as simple as that?

This is where my limited knowledge of VBA programming shows up :o. If you have the time, could you give me an example of how you might do this? I am in the process of sourcing a good course in VBA for Access but for now I usually have to either rely on the standard tools or have had...

That looks like a perfect solution.... except.... when I insert the textbox reference instead of the Date() reference for the date I get a message saying that the expression is too long and will be truncated! What I am thinking of is separating out a section of the expression and placing it...

I should know this but I just can't think of the solution :confused:. I have a report which is a call sheet that returns a list of clients to be called based on a query expression as follows: CallToday: IIf(Date()>=[NCUFN_Date] Or Date()=[NoCallFrom] Or Date()=[NoCallFrom2] Or...

I have a problem with a runtime error 2046. It relates to a macro not being able to run on the close of a form. This form is a hidden form that has an OnClose event that runs two macros. The first macro is macDailyStatsBackup which runs perfectly. This macro opens a series of update and...