Search results for query: *

Many Thanks mstrmage et Al!!!! Its surprising what a .Display can do !

I would really prefer the message to be visible before sending, i.e. opening the application "as normal". It is not a standard email that would be sent, so automation would be unsuitable. Any other ideas anybody? I can get Outlook to run from a macro, which is simple, but does anyone know how...

Back again! I am having trouble with the section to open Outlook. I am assuming the code: Set objOutlook = CreateObject("Outlook.Application") Set objEmail = objOutlook.CreateItem(olMailItem) opens Outlook as it would appear normally, with a blank email item ready as well. When I debug the...

Hi Unfortunately Nathan's solution has not worked as yet. Access 2000 does not recognise objOutlook as an object. I am also imagining that as it is not in the objects list, that objEmail is not recognised either. Any further advice would be gratefully received either to fix the code, or add...

Hi All This is a simple query I'm sure, but I just cant quite get it! I wish to be able to click on a customers email addy in a form and then automatically open a new email message in Outlook with that email address in the To: field. I have the basic macro RunApp opening the Outlook program...

Hi All I have a subform in datasheet view. I wish to be able to select one row and send the data on this row to a report (in the form of an invoice). Is there any way to do this via the simple click of a command button? I am sure this is simple, but the grey matter is on melt down :o Thanks

It did indeed!! Many Thanks

Use Nero?!

Hi Folks I have a Job creation form with a workforce sub-form. I want the possibility of selecting more than one employee from the workforce and displaying them all in rows. Is this possible only in Datasheet view or am I attempting the unattemptable? I have another sub-form for...

Hi I have a Broadband/ADSL connection to a Win ME machine, via a USB MODEM and dial-up adapter. I wish to share this Internet connection with a second WinME system, connected via a simple network comprised of 2 Ethernet 10/100 NICs and CAT5 crossover cable. I am currently unable to obtain any...

Thanks guys!! Indeed IDE cable backwards on mobo! Cheers

Hi there Have recently upgraded my mobo and PSU....everything seemed to work ok until I went to use the FDD. Not reading disks and the disk-read light is permanently on. IDE cable is fitted correctly, as is power connector. Does anyone have any suggestions as to why the drive is behaving in...

Hi This is a very simple question! I wish to display a message box if a combo box value is not selected. Is the VBA code > If cboEx.Value = "" Then MsgBox "Message" cboEx.SetFocus Else End If The "" does not appear to work (I know it...

Craig This only appears to count each individual "call", i.e. Count(Calls.User_ID) = 1 for each row. What I am looking for is a sum total for each user. For example, if User 1 has taken 6 calls, I want the count to say 6. Does that help a bit? Cheers Chris

Hi I have a table 'Calls' with the following fields: Call_Ref Call_Type Status User_ID I wish to produce a query/report that displays the fields, Call_Ref Call_Type & Status PER User_ID and sums the total of calls, i.e. User 1 Call Ref Call_Type Status Total Calls/User 1 User...

Using the statement below.... SELECT [Exhibitor].[Exhibitor_Ref], [Exhibitor].[Exhibitor_Name], [Exhibitor].[Tel] FROM Exhibitor INNER JOIN Booking ON [Exhibitor].[Exhibitor_Ref]=[Booking].[Exhibitor_Ref] WHERE [Booking].[Booking_Status]="Provisional" And...

thanks for your reply... It however, comes up with the error: "You tried to execute a query that does not include the specified expression 'User_ID' as part of an aggregate function.' What does this mean? Thanks

I have the following query...(aided by this wonderful forum!) SELECT Calls.User_ID, Calls.Call_Type, Calls.Status, Calls.Date_Time FROM Calls WHERE (((Calls.Date_Time) Between [Forms]![frmCallsQuery]![Text1].[Value] And DateAdd("d",1,[Forms]![frmCallsQuery]![Text2].[Value]))); I...

I have modified the above SQL so that data is queried with respect to two text boxes (which contain DATE values). I again have the same problem with regard to the BETWEEN statement. For example to use the dates 01/01/2003 BETWEEN 08/03/2003 (01/01/2003 >= AND <= 08/03/2003), this selects only...

I have the following WHERE clause, to retrieve data between AND INCLUDING 2 dates: WHERE (((Calls.Date_Time)>=#1/1/2003# And (Calls.Date_Time)<=#3/3/2003#)); Data is pulled from 1/1/03 to 2/3/03, but not from the 2nd date specified. Any suggestions as to why the <= operator does not work? (It...