Recent content by BobChesh

I am now bald, but I used to have a full head of hair!! I am trying to recreate a DlookUp type function in Excel. I have a list consisting of Primary and Secondary functions. I am trying to get two dropdown lists to show these. The first (Primary) is easy, but the second is far more tricky...

Clever People, Been hunting through this forum but to no avaial. I am trying to change a string whcich contains one or more dashes "-" into a dash and a slant "/". My table contains the following: 12345 12345-67890 987465-65824-56987 and I want the data to update and change the second (or...

HarleyQuinn I am looking to disable the application, since I have an "exit" button which closes the application (Application.Quit), after it deletes that user from the UserTbl created when the application is opened, if you see what I mean.

How do I disable the "X" Close Application button in Access 2003? I am trying to see who is logged on the the database (found that through thread 705-846343) and there is a link to another thread, but that is broken. I need to prevent users from closing the application using the "X" and...

Acess 2003, how do I code to enable me to refresh external links. I already use Tools/Database Utilities/Linked Table Manager; and then refresh, but I want to do this from within a Macro or Run Command. Can anybody help me out here please?

Folks, Having problems with the Dlookup function. I have viewed FAQ 705-4978, but can't make it work. I have a form where there are two combo boxes which select two "Reasons for Failure", combo1 being a Primary Cause and the combo2 being a Secondary Cause. I want to select the Primary Cause in...

Folks, On the same thread trying to use the Dlookup function. I have viewed FAQ 705-4978, but can't make it work. I have a form where there are two combo boxes which select two "Reasons for Failure", combo1 being a Primary and the combo2 being a Secondary. I want to select the Primary cause in...

Folks Trying to use the Dlookup function. I have viewed FAQ 705-4978, but can't make it work. I have a form where there are two combo boxes which select two "Reasons for Failure", one being a Primary and the other being a Secondary. I want to select the Primary cause in the first combo and...

Molby Thanks very much for this, I will keep it for later. My buddy has searched again and found out that XL does not support a "cc" address in the SendMail or Mailer functions, or at least not for a PC. It does however support it for a Mac, or at least we cannot find it. Oh well. Regards Bob

I am trying to send a mail from Excel using VBA. The syntax I am using is: ActiveWorkbook.SendMail Recipients:=Range("b21:b23"), Subject:=("Closure Data") This works fine, but I want to amend this to have a "To" recipients and a "cc" recipients. All my books are about as helpful as a third...

Is it possible to set two criteria in the selection part of a DLookup function I am trying to get a single value for a query with several records. To get the single value I need to set the [startdate] AND [SLTUnique], as below. slastart = DLookup("starttime", "SLAshiftquery", "startday = " &...

Folks My colleague has a problem. When he opens Excel, a blank sheet (Book1.xls) opens automatically. When a second sheet is opened, then Book1 is still available. However, when I do the same thing, my Book1.xls automatically closes, or at least is no longer available. Can anybody tell me how...

Tiffany, I am using a table created in HTML and the columns are: Report name Desc Available Last Updated Weekly Ops Ops report Monday 1/9/03 The name of the report (Weekly Ops) has a hyperlink to an Excel file. This file is updated every Monday. The bit I...

I am using the company intranet to publish performance figures on a regular basis, using a table to select the appropriate report. The site is built using FP. I am trying to set a field in a table to show when the figures were last updated. I can do this manually, by amending the date/time in...

bigdaz I had the same problem, but with help I got it fixed.try thread702-395772