Search results

  1. K

    Sending email without using outlook, etc

    I found a very handy dll that allows you to send email from within your ms access database (also ms excel). This allows you to send email without the use of ms outlook or other email clients. The web site for the dll is: http://www.ostrosoft.com/smtp_component.asp The zip download includes...
  2. K

    Keycodes with a form

    I am trying to trap specific key downs for use on a specific form. Basically, what I want to have happen is when the specified form is open, I want to have the number keys mapped so that when I press the 9 key, it puts the number 9 in the field and then moves to the next field. Same with the...
  3. K

    Dynamic Crosstab Report & Dynamic Labels

    This is a combination of a sample database from Lebans web page, and an activex dll I found that works really well in rotating the labels for reports in any direction you want. There are two databases in this zip file. One comes with the activex control and shows you a number of ways you can...
  4. K

    Backup & Restore using ZIP

    I came across a very neat activex dll that can be used for zipping and unzipping files (especially backend databases). The nice thing about this one is it works very well with access. The other nice thing is that it is free. :D Go to the following url: http://xstandard.com In their products...
  5. K

    Using Events from outside controls

    I am trying to use an "external" control in my access database. Very briefly, here is the scenario. I have a unique measuring instrument that uses hex codes to communicate with it via a comm port. To initialize the instrument, I send it 0xD5 in Hex. It responds with 200 in Ascii. I was using...
  6. K

    Two questions about Access Runtime

    I have two questions regarding access runtime. Here they are: 1) I have developed a database in Access 2002 for a friend. He currently has Office pro 2000 on his machine. IF I include the Access 2002 runtime for him to install, will it overwrite any of his Access 2000 files and cause...
  7. K

    Graph Problem in Access

    I have an x-y graph on a form that gets its data from a query. The query pulls five records of data from a table. So there are five data points I want to have displayd on the graph. I got the graph to work properly except it only displays four points! The first data point is not displaying...
  8. K

    Reference a field on a subform

    I have 10 fields on a subform. they are named value1 to value10 consecutively. I would like to loop thru them, and get their values to use in subsequent events. I tried the following to reference them... Dim iLoop as integer Dim fldVal as control Dim ItemValue as string For iLoop = 1 to 10...
  9. K

    Remembering field location on a form

    I have a form with a sub form (ms access). On the subform are a number of textboxes for input by the user. What I need is for the sub form to "remember" the last textbox it was in when the form closes. Then, when the form opens again, the focus in the sub form "returns" to the last text box...
Top Bottom