Search results

Is it possible to change the text in a label on a report in the Report_Open event procedure?

Hi, I have a simple multi-select list box. I can select multiple items from the list box. But when I double click on an item in the list box, I want to be able to bring up another form showing the record that relates to the Name in the list box. All I need is to be able to detect a double...

Sorry, I found it using the search facility. Me.MyTextBox.Text = Me.MyTextBox.Text & vbNewLine & recordSet("aField") [This message has been edited by Essendon (edited 05-06-2002).]

Hi, I have a text box on the screen, whose text is then taken as a string and made the Message body of an email message. Here is the code: doCmd.Sendobject, acSendNoObject,,,"joebloggs@bloggs.net",,,"EMAIL SUBJECT", Me.MyTextBox.Text If I type some text into my text box and then hit enter, I...

Hi, My database has a picture link field that holds the path of a jpg image. (e.g. "C:\project\images\pic1.jpg"). I have a report that has code that pulls the image from the path and displays it in a Image Frame on the report (Me![Image_Frame].Picture = Image_Path_Variable). This works fine...

I have found the information I needed off another site: http://p2p.wrox.com/archive/vba_access/2001-05/17.asp Thanks.

Thanks for your response So now I have: DoCmd.SendObject acReport, "aReport", acFormatRTF, "a@b.c", , , "This is the subject", "This is the body of the email", False How do I send multiple reports in this single email? Eg I want to send the reports "aReport", "aReport2" and "aReport3" all...

Hi all, I have the following code (taken from a post found in the search facility): Dim appOutl As Object Dim MyNameSpace As Object Dim myemail As Object Set appOutl = CreateObject("Outlook.Application") Set MyNameSpace = appOutl.getNameSpace("MAPI") Set myemail = appOutl.CreateItem(0)...

Hi, I have an annoying problem that I have literally spent hours trying to fix. I have a single form that is used as a reports menu. Within it, I have a combo box with the names of schools in it. When I choose a school, a corresponding list box shows the students of that school. I can then...

Thankyou very much

Im having a bit of trouble getting it to work. With reference to the following code: Set Q = DB.QueryDefs("MultiSelect Criteria Example") Q.SQL = "Select * From Commercial Where [ID] IN(" & Criteria & _ ");" Q.Close ' Run the query. DoCmd.OpenQuery "MultiSelect Criteria...

Hi just a simple question that will help fix a problem and clear up my understanding of VBA. given the following loop: Dim i As Variant For Each i In aList.ItemsSelected ...do stuff... Next i how do I access i? All I want to do is to deselect all the items in the list that are selected...

The values of the check box would be random. The combo/list box sounds like the way to go... Thanks for you help...

Thanks mate, I'll look into it now. Peter

G'day from Australia. I have a report that will show all the students from a certain school (obtained via a query). There is a combo box, and the user simply selects the name of school from that combo box and all students from that school are obtained via a query to be shown in the report...

problem fixed...no need to respond thanks

Hi again, I was wondering how I would open a datasheet form (called List View) and get it to move the cursor to a specific position? With the following code, It opens only the matching record in datasheet view. However, I want it to open all the records, but have the cursor in the position of...

hi, This is probably too easy a question, but I was wondering how you can enter formula into a field that references another field in the same table? I have one field called Fare, and another called fare2 that (in excel) is: "= fare * 100.5" How could I get this to work in access?

I found out after I had started that they had Access 97. I thought that they would be purchasing Access 2000... I dont suppose you can package it all together to make an exe file that runs independent of access?!

I am developing the database in Access 2000, but the final version will be running on Access 97. Does this mean that landscape problem will not exist once I have converted it to 97? Thanks for your response...