Search results for query: *

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...

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...

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

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

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

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...

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...

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

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...

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

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...

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...

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

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...

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...

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

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

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...

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...

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