Search results

  1. L

    Can I set the Windows default printer using VBA?

    Hi everyone, I am working on an application which prints both reports created in Access, and external PDFs. These documents are printed to a physical printer, but each document may need to be sent to a different printer than the previous one. For reports created in Access, this isn't an issue...
  2. L

    Silently Print PDF files

    Hello! I am using Access 2010, and trying to print out multiple external PDF files silently (without opening Adobe Reader or a print dialog). I am not generating the PDFs with the Access DB - they are created by another application and stored on a network drive. I've done a bunch of searches...
  3. L

    Searching a comma separated string (Normalization question)

    I am trying to read data from a table created by another application developer. In the table, there is a field for Part IDs. This field can have one or many Part IDs in it. If there are more than one, each Part ID is separated by a comma. My issue is that we have similar Part IDs, and that...
  4. L

    Could not find linked table..

    I am using Access 2010, and have a linked table using an ODBC Machine Data Source. I can open the linked table in the database view, and view all of the data. I can create a new form, and connect to the table, and read and display the data. However, when I try to connect to the table from an...
  5. L

    Emails generated from Access 2003 include ATT00001.bin for some recipients

    Hello! I have created a small application which generates PDF invoices and emails them to our customers. In many cases, these customers have a system on the other end which accepts the PDF and enters it in to their AP system. We send invoices to about 150 customers a day, and most report no...
  6. L

    Form Refresh triggering LostFocus on a subform

    Hey all, I'm kind of stumped with this one. I have a parent form which is being refreshed from another module using the following: frmParent.Refresh Immediately after the line of code above, the code jumps to a LostFocus event on a child form belonging to frmParent. frmChild is in datasheet...
  7. L

    Run-time error 3027: Cannot Update. Database or object is read-only.

    I did a search, and found some results, but none seemed to address the issues that I am having. I have two database tables, which have identical structure. Each table is hosted in a different physical and virtual location. My application connects to both databases. Editing table 1 works just...
  8. L

    Issues sending email with attachment

    Hi everyone, I am working with an Access 2003 application, and one of the functions of the program is to create a csv file, and then send it to a list of email addresses which are stored in a database table. The procedure that creates the csv file works every time. The csv is created, and it...
  9. L

    Ignore the LostFocus event?

    Hey all, I am working on an order management system where a user can enter an Order ID into a text field, tab out, and it will load the order. This is done by using the LostFocus event to call a module which loads the order. It works as intended - I have no problems whatsoever with loading...
  10. L

    How do I load the print dialog box? (Access 2003)

    Hi everyone, A bit of background. Users of the db I am working on print using a regular network printer 95% of the time. 5% of the time however, they need to change that printer to another one, or to a PDF printing program. All of the printers they need are installed in their Printers folder...
  11. L

    Text Highlighting Issues

    [SOLVED] Text Highlighting Issues Hi everyone, I have a weird issue, and I'm not sure what to search for, so I apologize if the answer has already been discussed. I'll try to explain my issue as briefly as possible. We have a bunch of notes that are stored in a database. The program looks for...
  12. L

    Form opening inside an Access window in the background

    Hello! So I've got a little problem.. I have three forms: Form_A (main form for the application - should always be open) Form_B (always open, but sometimes has visibility set to false) Form_C (opens from button on Form_B) When I press the button on Form_B, the only code behind it is...
  13. L

    howdy!

    hello! i'm from western canada, and i've been using access for way too long (15 years or so). i'm mostly working with some legacy enterprise applications that i did not write, and sometimes i need a hand with a few things. i've found a number of answers on this site, so i figured it was time to...
Top Bottom