Search results

See Open...Read

Take out the .Value

You can use text, you just need to type more :^) Me.Controls("Document type value").Value = "yes"

MS Knowledge Base

Look at OPEN and READ, this will allow you read through a text file

What is the Fields Data Type? (It looks to me like it is a String/Text field in the table). If that is the case change the query slightly: SELECT dbo_INV_INFSVC.CS_NUM, dbo_INV_INFSVC.NON_TECH_DES, dbo_INV_INFSVC.USER_OPR, dbo_INV_INFSVC.SERIAL_NUM, dbo_INV_INFSVC.NMMI_NUM...

I believe your DLOOKUP is the Issue: Try this DLookup("[E-Mail_Address_To]", "Report_Config", "[Lookup_Id]= '" & Me!Criteria_Selection & "'" And [Report_Group_No] = " & Me!Group_Selection & " And [Report_Type_No] = " & Me!Type_Selection) ' Put email address here

Upload a copy of your report. or email me at travis_abraham@hotmail.com so that I can look at it.

Where are these blank pages occuring? Between the pages (look at your margins and make sure that you don't have anything outside those margins)

You have Three potential page breaks. First you will get a page break before the Header (not on the first page). This is what is causing a blank page between your Groups. (I recommend removing the Page Header force new page) Second take out the page break object in your footer. The Force...

Dim cntr As Control For Each cntr In Me.Controls If cntr.ControlType = acLabel Then Debug.Print cntr.Name End If Next cntr

Create a basic application with a reference to the OCX. Then "Package & Deploy" it. Install this application on your Notebook. Using the Package & Deploy will help in gathering all of the OCX dependencies.

From what I have read the answer to adding multiple columns with the ALTER Statement is Yes. Note: Take the time to test this on a Temp table to review the results before implementing.

DAO There is the CurrentDb.Execute function. ADO You could use a ADODB.Command Object to execute the Insert Query

docmd.SetWarnings False docmd.RunSQL docmd.SetWarnings True

It's been awhile since I've used A97. But I seem to recall that there is a Documentor function in Access under the tools menu.

You will need to retreive the last number used each time you start Access. You can do this using the DLookup Function or DMAX Function on the table that you are populating.

What class module is the Form_Delete Event located in? From the look of your code frm_ToolGeneralInformation is already opened.

Jon, I agree that he would be happier if he used a VB front end, but he may have to consider development time. I have found that I have a better time meeting the Clients goals if I first proto-type it in Access and then use VB and C++ to finialize. There is a lot less headaches doing it this...

Personally I'm holding out for the keyboard that has an electric current that is completed only when the user presses the Alt+F4. :D