Search results for query: *

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

Randall Brill, Thanks for this. At least I will not be trying to do something wihich will fail. Looks like a rethink is on the cards Cheers Bob

Folks, I am trying to add a field in a table (via a query) to set a flag to either 1 or 0, depending on the previous value of one of the fields. i.e. Request No Order No Flag 12345 456789 1 12345 654321 0 12345 987654 0...

Help Can anyone offer help on what causes a "String data, right truncated on column number 1[TABLE_CAT]" error to appear? It started happening out of the blue when my colleague attempted to retrieve data via MS Query from Access to Excel. He naturally assumed that it was something to...

natatbh, Muchos thanks. It looks like it works. I have modified the code though, since the user may not always put the imgae in the same folder. So, by using a Hyperlink in a text box, I then use this value as the variable 'Pathname', and then the image which you showed me how to insert is...

natatbh, OK here goes. I am building a datbase for an insyrance assessor for vehicle damage. I have a main form contaning vehicle details (reg no., owners address etc etc) and several sub forms grouped with various bits of the vehicle (Engine, bodywork, chassis, electrics, Steeruing and...