Search results

  1. J

    Querying, then reversing the query..

    OK, coming up with a title for this one was a little difficult. Almost as difficult as the problem I'm facing ;) Here's the basic premise. The database is used to register people for a weekend convention. Part of the registration allows the person to request a specific roommate. In an ideal...
  2. J

    Email Individualized Reports to List --Filtering SendObject?

    Hello again, it's been a while. I'm back in Access Programming Mode, and here's my latest quandry. I have a list of registrants that I'd like to e-mail receipts to. The obvious solution would be to send the mail to each registrant as their information is entered in, but alas, this is not a...
  3. J

    Suddenly can't open a form (due to filtering, I think)

    Allright, so I've got a Purchase Order database that I created a number of years ago. It's been working fine, up until last week. When a user other than myself attempts to open the 'receive po' form from their workstation, I can see in the status bar that it calculates, then filters the form...
  4. J

    Mapped drives vs. UNC

    Are there any advantages/disadvantages to either? I've been told that Access works better with mapped drives than UNC...any truth to that? TIA, Jonathan Kok
  5. J

    SHIFT+OPEN trick not working in Access 2003?

    The SHIFT+OPEN trick doesn't seem to work on my Access 2000 files when I try to open it with Access 2003. I imagine it's the dialog box concerning possible dangerous code that's messing it up. Any ideas how to resolve this? Converting it doesn't seem to be an option; Access crashes about 1/2...
  6. J

    Problem with the date/time field

    I've created a database to track downtime of a machining cell. I've got two fields, stop and start times. The user can enter the times either by hitting a button, in which case it inserts the current date/time, or by typing the time in the field manually. The trouble I'm having is that it has...
  7. J

    tab control within a tab control

    ARRGGGGGHHHHHHH!!!!! OK, how can I insert a tab control within a tab control? Everything I've tried has resulted in placing the tab pages ON TOP OF the tab control. I can't seem to get it to insert the tab control on the tab page. Any ideas? Thx!
  8. J

    Comparing Numbers w/ Decimal Places

    OK, I've got a form in which I need to compare two fields and ensure that the numbers are the same. One field is a standard, unbound text box with Currency formatting. The second is in a subform, tied to a table, with the Number format in the table, and currency formatting on the field. If I...
  9. J

    Requery Chart in Subform

    Hey, all, been a while since I last posted, good to see this board's still up! First, a pic of what I want to work: OK, so here's the problem. I've got a table that contains ten fields per record that I need to chart in a line graph as a subform on a form. Since I can't do it using a...
  10. J

    Sending commands to printer

    Is there any way to send a command directly to the printer? Here's what I'd like to do: I have RightFAX installed on my client PC's, which allows users to fax documents directly from the desktop. This program allows the use of 'embedded codes' in documents to control how a document is faxed...
  11. J

    Time Delay in calculated fields on a subform

    Good day all, I'm developing a Purchase Order database for my company. I've run into a bit of a problem. The form I'm working on is the actual Purchase Order Entry form--you can imagine what it looks like. The difficulty I'm having is that on the Ordered Items subform, (where the user enters...
  12. J

    Printing to a specific printer

    I'd like to be able to print a document to multiple printers. For example, when I print a purchase order, I'd like one copy to print to the default printer, and another to automatically print to the accounting printer. Alternatively, I'd like to automatically print to the Fax printer when I...
  13. J

    Forcing New Line in Text Box

    I have a text box (based on a "Memo" Data Type Field), and I want multiple lines of information to be entered into it at the click of a button. But, it can't erase what's already in the text box; I want it to append to the end of the text as a new line in the same field. The current code is as...
Top Bottom