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

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

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

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

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

I am trying to open Excel from Access 97 on an NT o/s, using the RunApp macro command. I can get Excel to open, but since the sheet that I want is deeper than the root directory, I have problems getting there. It would seem that I am limited to 6 characters for the folder name, and anything...

I am trying to send a table in XL format (acFormatXLS) using the SendObject command. It works when the number of records is around 10000, but when the table is much bigger (35000), I get an error message of "too many rows". I know that Excel has a limit of some 65K, so that limit is...

I have a CSV file which contains data in the dd/mm/yy hh:mm format (01/06/03 11:35) When I save this using VB, either using Filename.SaveAs:=myfile or Filename.Save then when re-opened, the format of tha data is in mm/dd/yy hh:mm, (06/01/03 11:35). Yet when I save it manually then it saves...

I am trying to send a form, containing the details of one record, via E mail (using the do.cmd.SendObject, acForm, ACFormatHtml etc etc) The problem is that when it is received, it is in datasheet view, and contains all the records, rather than just that conatined in the form. How can I send a...

How can I prefix an autonumber with a bit of text? I want to add records, using the Autonumber as the ID, but I want to prefix the value with "BUS ", so the record ID becomes BUS 1, BUS 2 etc etc. cheers

I want to use an update query to amend data in a table. One of the fields is in Text format, and I want to update this field to show the text "Week Ending" followed by a date (in text format). I can use the square brackets [] to open an User Input Box to insert the required text, but...

Is it possible to auto-compact a database (Access 97) on close. I am aware that this is available in 2000?