Search results

Is there any way to replace error message 8055 "Microsoft access can't change the working directory to ..." with a custom error message when opening a database? I want to let users know in firendlier words that this error message means they don't have a working connection to a required shared...

Got it! The sendobject command was running a report that pulls the Referral ID parameter, but i wasn't passing that parameter to the report (just passing it to the query). Since all i wanted to do was email the current form, I just changed the object type to acSendForm rather than acSendReport...

Smae result with that line deleted...Runtime Error...no current record

Sorry...do you mean just delete that line from the Query?

Forgive me, but I'm not sure how exactly to do that. I wrote the query in the Design view just by dragging and droppping fields and joins, then just went to the SQL view to see the code. The query runs fine, prompts me for the [Referral ID?] parameter and correctly pulls the right results...

PARAMETERS [Referral ID?] Short; SELECT [Dean Emails].[Dean Email], [Demographics - Current Students].[Counselor Email], [Staff Emails].[Email - Staff], [Student Guardian Emails].[Email - Guardian], [Staff Emails].[First Name - Staff], [Staff Emails].[Last Name - Staff], Referrals.[Referral ID]...

Hello, I'm using the following code to pass a parameter to a query. The parameter limits a query to a single entry, which then is set to the recordset. I then use this recordset to sends a single email to specific respondents using email addresses in the query result. When this code runs I...

Users are in Windows 7, and Access 2010. The two users in particular who are seeing this problem are both running the front end as a .accdb file rather than an .accde I had some trouble getting the .accde file to work on multiple machines until I found the need to "compile database" from...

I think that users have only their own inbox, but I will check into it. Today's goal will be to try and actually observe this behavior first hand. Compared to this teaching physics is easy. At least there things are predictable...even the teenagers :D

To help better understand what I'm doing here, this is part of an electronic system for managing student discipline records at a high school, and I'm just a physics teacher with some release time to help 'manage data'. Thank you all for your attention to this so far. It's good to hear that...

Sorry...I missed this in your previous post: "Or are you saying that a given user sees mixed data, meaning that someone else's data also appear in the data this particular user was preparing?" In addition to the other problem where one user mysteriously can do things on another user's...

A first...great. And yes...it's a plain old front end linked to tables on the back end, back end stored on the server, and front end stored locally on user's machines.

Let me start by saying that what you know about systems and sessions is lightyears beyond what I know. All I know is what you told me in your previous response.:) The strange setup part I'm referring to is within the coding for the sendobject, not with windows. Each user has their own...

It's a split database, and each user has their own front end. It's a somewhat strange setup, and I believe I know the source of the problem, but am not sure how to fix it. If I knew more about how the send object identified "from whom" then I be able to start troubleshooting. Here's the...

Hello, I have a working section of code that sends an email using SendObject, but the SendObject command seems to select the "send from" address unpredictably when there are multiple users in the database at the same time. I know that the from address cannot be specified using SendObject, but...

Hello, I've gotten many great answers from this site in the past, and on a whim decided to officially join. Looking forward to finding a good question to ask soon!