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 derfloh 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: illini
  • Order by date
  1. illini

    Dlookup Next Record

    I have a table of various numeric figures. I would like to use the dlookup funtion to find a field based on a number. Specifically, I'd like to set it up to either find the record, or (if the record doesn't exist) the record of the next higher number. In other words, I'd like to use it...
  2. illini

    Determine if Form is Minimized

    I think a found a relatively simple solution which uses a form's WindowWidth property. I discovered that when a form is minimized (at least on my database), the form's WindowWidth = 1920. So, here's the sub I developed to determine if a form is minimized... Sub Determine_Form_Min() For Each...
  3. illini

    select the item of the second column

    Try the following... strBranch = Form_F-01-FIRM.BRANCH.column(1) Let me know if it works. -illini
  4. illini

    Determine if Form is Minimized

    Is it possible to determine if a form is minimized via VBA? I have a form with a listbox which I would like to resize once a pop-up form has been minimized or maximized. Thanks. -illini
  5. illini

    Include Hyperlink using SendObject Method

    Thanks p27br. I tried your method, but all I got was an email with the following message in the body: <A HREF=&quot;http://www.microsoft.com/downloads/details.aspx?familyid=B73DF33F-6D74-423D-8274-8B7E6313EDFB&displaylang=en&quot; Snapshot Viewer</A> -illini
  6. illini

    Include Hyperlink using SendObject Method

    I'm using the following vba string to create an email with a report attached: DoCmd.SendObject acSendReport, Report_Name, &quot;snapshot format&quot; I'm using the snapshot format. (Adobe .pdf is not an option.) I would like to include a link to download the Snapshot Viewer from MicroSoft...
  7. illini

    Search for BackEnd dbs

    I have a dbs with a backend on the network. I want to set up the dbs so that the user can create a backup of the backend on their hard drive (when out of the office on business). This backend copy would be read only. I would like to set-up some code in the frondend, so that upon opening, it...
  8. illini

    Low System Resources

    John, The number of rows varies. I'm running Windows 98SE. Most of the other computers around have the same OS. I haven't tried it on another because I'm trying to work out the bugs before installing it on someone else's computer. Thanks for the feedback. -illini
  9. illini

    Low System Resources

    I have a form which loops through a recordset, opens an Excel template, moves the data, and then saves the Excel file. As this process occurs, I can see my system resources slowly drain until I receive an system warning that my resources are dangerously low. I've gone back through the vba code...
  10. illini

    Ghost Forms ???

    Actually, there were no references to these forms. Additionally, I did delete the code off these forms, but received the same error messages. In the end, I had to return to a backup copy of the database. Thanks for the assistance. -illini
  11. illini

    Ghost Forms ???

    Recently, I deleted several forms from my database. However, the VBA for each of the associated forms seems to have remained. Now, whenever I perform an action, I receive a message indicated that the &quot;You canceled the Previous Operation&quot; and then it runs through a list of the forms...
  12. illini

    Determine if Form is Visible

    I'm looking to find a faster way of running through all the forms within a dbs and determining if they are visible. Here's what I have... Function Test_Forms() For Each dbsForm In Access.Forms On Error Resume Next If dbsForm.Visible = True Then Call Run_Test On Error GoTo 0 Next...
  13. illini

    Loop through Records in Table

    Thanks, Jeff. I'll give it a try. The purpose of this routine isn't to update, append, or delete records from the table. I simply need to pull specific pieces of data in order to print reports. Hopefully, your sample will do the trick. Thanks. -illini
  14. illini

    Loop through Records in Table

    Is there a simple way to loop through records in a Table? I'm looking for something along the following: For Each Record in Table1 x = [Company_#] 'call some other sub Next Record Normally, I would use DoCmd.FindRecord knowing the Company_#. In this case, I do not know all the Company_#s...
  15. illini

    Can a ListBox reflect the records on a Form?

    Let's say I have a simple form. Its record source is a query which has two fields (rec_id and state). The query is sorted by the rec_id. The form has two textboxes (one for each field) and a listbox which shares the same query as the form. If I sort the form by state, the listbox will still...
  16. illini

    Can a ListBox reflect the records on a Form?

    Thanks for the input; however, this doesn't resolve the issue. Based on the scenario I described above, requerying the listbox will not reflect the records as sorted on the form. -illini
  17. illini

    Can a ListBox reflect the records on a Form?

    I have a form with a query as record source. On this form, I have a listbox with the same query as the row source. Is it possible to have the listbox's row source reflect the form's record source. Thus, whenever data is sorted on the form, the listbox would reflect the sort. Thanks. -illini
  18. illini

    Force Page Break on Report

    I have a report which sorts records by state. I would like to force a page break in the 'Details' section with each unique state. Therefore, a group of records for three separate states (which currently fits on one page) would now be displayed on three separate pages. What is the best way to...
  19. illini

    Reassign Function Keys

    I currently have an Access program which the users do not need access to the normal Function Keys (e.g. {F12} Save As). However, I would like to retain access to these shortcuts for my purposes. By doing this, the user will only have to press {F12} to access the form. Therefore, I would like...
  20. illini

    Generating Email from MS Access

    Is it possible to generate an email (via Lotus Notes 4.6) from Access 2000 without sending the email? I'm looking to provide the user the ability to generate an email and review it before sending it. All the code I've come accross sends the email automatically. -illini

Part and Inventory Search

Back
Top