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

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

I'm using the following vba string to create an email with a report attached: DoCmd.SendObject acSendReport, Report_Name, "snapshot format" 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...

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

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 "You canceled the Previous Operation" 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...

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

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

I would like to consolidate the following code: F1 = ListBox.ItemData(1) F2 = ListBox.ItemData(2) F3 = ListBox.ItemData(3) Into something like this… For y = 1 to 3 F(y) = ListBox.ItemData(y) Next y What do I need to do to set-up F(y)? -illini

I have some VBA code attached to a form which opens an Excel file, and extracts specific data within a spreadsheet. This data is then placed within a listbox. When executed, the code works great! The problem I'm faced with is that I want to set this up within a report. However, when I try...

I have two queries: one groups records by Date Created; the other groups records by Date Completed. Each query has dates in common, as well as dates unique to each. I would like to combine both queries to produce a report which will illustrate the date, number of records created (if any), and...

I have a dbs which is setup to pull data and email it (via Lotus Notes) to a client. Currently, the VBA code I'm using automatically pulls the data and sends it. I would like to make a change in the code which will create the email and then allow the user to view & edit it (in Lotus Notes)...

I have a memo field on a report with the following control source: =[Forms]![Frm_Fax]![TB_Contact2] & Chr(10) & [Forms]![Frm_Fax]![MM_Remarks] When I run the report, instead of getting a carriage return, I receive a box symbol instead. What syntax do I need to use via the Expression Builder...

I have a report which lists contacts by company. The report is based off of three tables: 1. Table 1 contains all the CompanyIDs which subscribe to Service A. 2. Table 2 contains all the CompanyIDs with associated Company name & state. 3. Table 3 contains all contacts by CompanyID. This...

I have an update query as follows: RecID=LB_Search_Company.Column(0) DoCmd.RunSQL "UPDATE Tbl_OCN SET Tbl_Company.Client = ""-1"" WHERE ((([Tbl_Company].[ClientID])= " & RecID & "));" This gives me a Runtime Error '3464' ("Data type mismatch in...

This is the first time I've attempted to split a database. Everything went fairly well. The backend was placed on a network server. Afterwards, though, I've noticed that loading forms and accessing data is extremely slow. I expected some lag, but it can take up to 20 seconds for a form to...