Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: MacroScope
  • Content: Threads
  • Order by date
  1. MacroScope

    Trying to programmatically convert an Access 2007 report to pdf

    I created an Access report that is essentially a warning letter that is to be automatically generated when certain conditions apply. I want to print a copy of the letter for snail-mailing, and I want to save a copy as a .pdf file. Of course, opening in print mode is a simple matter, so the...
  2. MacroScope

    How can I make an SQL Server 2012 table programmatically read-only or writable?

    I have a 25 station Access 2007/SQL Server 2012 db that has developed an annoying glitch. One particular table, called Processors, which holds name, user name, phone numbers, and other data for processors on the floor is intermittently changing the name of a processor from the correct name to...
  3. MacroScope

    "object or class does not support the set of events" error on form events in Access 2007 s

    I'm posting this to offer a fix for those who may encounter the above error. I have nearly 20 years experience with Access, and I never encountered the error until today. It just seemed to materialize out of nowhere but it occurred with every event procedure on one form. After troubleshooting...
  4. MacroScope

    Need help creating an expression that identifies the last week day or Saturday of the month

    I have an operation that I'd like to carry out on user login on the last weekday or Saturday before the end of the month. Assume the 1st is on Sunday or Monday, the expression would evaluate as true on Saturday, and if the 1st is on, say, Tuesday, then it would evaluate as true on Monday. I...
  5. MacroScope

    Need a query that will list only one name from many companies in db that have several names

    I have a database that has many contacts from many companies. One company has 145 contacts in it, others have 1-5, some others up to 40. I am emailing them in small groups and I want to only email one person from each company with each mailing. As a contact receives an email a Sent checkbox...
  6. MacroScope

    How can I get a field to display month and day only?

    I have an Access 2007, SQL Server 2012 system and I have a field that, like a birthday or anniversary, only requires day and month but not year. The data type for the table I chose is datetime, and even if I format the field Format([HOExp],"m,d') After Update, the year still returns...
  7. MacroScope

    How can I attach both an Access report and an external PDF to the same email generated within Access

    I am trying to attach an internal Access report and an external .pdf file to an email generated within Access. I've read up on the limitations of the SendObject command and it apparently only allows one attachment. The flip side is to send as an Outlook application, and while it allows...
  8. MacroScope

    I need to generate consecutive numbers in a report with user defined start point

    I have an Access2007/SQL Server 2012 system with 20 users for an insurance company. Checks to our dealer network are currently being written manually in Quick Books, even though the amount to be paid is determined within Access. I've been asked to use an Access report to print the checks, table...
  9. MacroScope

    Outrageously long update time

    I have a table that has 50,000 records in it. I'm running an update query that updates only one field. The update is to proper case, so essentially the update is Proper([Make]). Seems simple enough, but it's been running for 45 minutes and is not finished yet. What can take so long? By the...
  10. MacroScope

    Can I check on DB open to see which drive copy is being used?

    I have a network of 20 users with Access 2007 and SQL Server 2012 back end. There's one central copy of the front end on our public drive (P:\), and a login script for each user. As they log in, it automatically updates their C:\ copy from the P:\ copy, so everyone is always using the most...
  11. MacroScope

    Need the help of a code whiz for complex thermodynamic calculations on Access form

    I have built a calculator using unbound controls on a form in Access that functions very much like a dynamic Excel spreadsheet. Changing a value results in an instantaneous recalculation of other values that are dependent on that input. The one calculation that eludes me is the one that...
  12. MacroScope

    EMail Marketing from Access 2007

    I want to implement an email marketing campaign using customers already in our database. I want to pull data from the customer's record to insert in the text of the email, such as name, type of vehicle the customer owns, and other personalizing information It's no problem for me to do this for...
  13. MacroScope

    Can I create a global message in Access 2007/SQL Server 20 user, one location network?

    Is there a way that I can get a message to pop simultaneously on all computers in a network? I have no problem creating the conditions to trigger it, but I don't know if there's any command that will get all stations to respond at the same time. Any help would be appreciated.
  14. MacroScope

    Is there an On Database Close event?

    I have an Access 2007 system with about 20 users, with a MySql back end. I've been asked to add a reminder message that pops up if someone either closes the database through the menu or hits the X at the top right. Is there an event that triggers only on database close? If not, does anyone...
  15. MacroScope

    One computer in a network won't respond to an OnTimer Event

    I've got an SQL Server network with about 20 users running Access 2007. When the database opens a hidden form opens with Autoexec that has a timer interval of 60000 and OnTimer it runs a macro that checks several things on each work station once a minute. For example, if certain parameters are...
  16. MacroScope

    How can I create a text box on a form that grows wider with more content?

    I'm trying to create a text box on a form in Access 2007 that will grow to accommodate more characters. The CanGrow and CanShrink don't make any difference and I can't seem to find any other appropriate way. Can anyone suggest a method that will allow the box to grow as additional characters...
  17. MacroScope

    Which event precedes "another user has changed record" error?

    I have written a live queue for an insurance company. When a user inputs info on a web form it is immediately placed in a staging table in Access 2007 housed on SQL Server 2008. The count of unassigned records in the queue is displayed on all screens and updated every 5 seconds. A...
  18. MacroScope

    How do I create an interactive queue in a local network?

    I'm working with an insurance company running Access 2007 with a SQL Server backend in a 20 user network all housed within one building. We are interfacing a web form so that when a web customer submits information for a quote, it is sent straight to our Access database. The data is then...
  19. MacroScope

    Installer runs every time I open a different version of Access

    I have Access 2003, 2007, and 2010 loaded on my computer, but every time I open a different version from the previous version I used, an installer runs that seems to take forever. What can I do to avoid this? All help will be appreciated.
  20. MacroScope

    How do I send an email programmatically?

    I'm using an MS Access command to open Outlook. I can get it to open, fill in address, subject, and text, but what I haven't been able to conquer is to get it to send without a mouse click on the send button within Outlook. I want the email to fill in and send without any human interaction...

Part and Inventory Search

Back
Top