Search results for query: *

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

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

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

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

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

Is it possible to query the value of a combo box on a form? (The value of the combo box appearing in the WHERE clause). Query to be used in a report. Is it possible to achieve this in SQL only or does VBA have to be used? Thanks

Hi Im trying to create a query for a report in Access 2000. The basic idea is to select any bookings that have not been confirmed within the previous 5 days of todays date. ie. select any dates 5 days previous to today's date. However, the problem is that the company concerned does not...