Search results for query: *

I have aquired a new PC which has a SATA HDD. I also have a prevous 300gb IDE HDD. The new PC only has one DVD drive and has spare IDE cable slot on the MB. Can I connect my old IDE HDD to the spare IDE slot? will it work or conflict with other hardware? Happiness is...not getting what you...

2008 being a leap year is causing me a headache on a date calculation - any help welcomed. I have a start date to which I need to add a year -1 day days and end with a new date exactly one day prior to the original start date e.g. 01/01/08 to 31/12/08 31/08/07 to 30/08/08 I have tried various...

I would like to check from within a Function if a Report has data but not sure how to go about it. My Function needs test to see if the specified report(s) had any data and if not would then be ignored. I assume this is going to require using the Object syntax and I don't know where to start...

Word 97 Template form I have created a form which will open using the "New" event. On the form I would like to add a command button that will open a pdf document (user help notes), the pdf is located in the same directory as the template. Sofar, all I have been able to do is create a...

I would like to set a Public variable in my application called "LastUpdate" and store the date that an upload took place, this would then be displayed on my Switchboard when the application is opened. The variable value will then need to be updated and stored following the upload of data done...

I have the following piece of code which splits a string date formatted 20070101(yyyymmdd) and attempts to rebuild it in to dd/mm/yyyy 01/01/2007. Range("j1").Select ActiveCell.Value = "=Left(I3, 4)" Range("k1").Select ActiveCell.Value = "=Mid(I3, 5, 2)"...

Hopefully a simple answer here.... When double clicking on a worksheet cell the formula is copied down where the adjacent left cell is not empty, once it finds an empty cell it stops. I have recorded this event in a macro:- Range("F3").Select Selection.AutoFill...

I have declared a public const in a module which works fine using the intermediate window. I want to use this constant in a control on a report but it does not recognise it. Can someone tell me why or how I can get it ona report. Thanks Happiness is...not getting what you want but wanting...

I have 2 Dcount statements that I need to join the WHERE clauses. Both statements work correctly independantly but when I try to add an AND and join it together it fails, I am presuming this to be a syntax issue and have tried many variances to get it right but so far no success. Any help...

The following is triggered by an afterupdate event on Me.txtWIDNo I am getting a Data type mismatch error when this runs and I'm not sure why. Dim ReturnedDate As Date ReturnedDate = DLookup("[WIDreturneddate]", "[tblwids]", "[WIDno1] = '" & Me.txtWIDNo & "'") [WIDreturneddate] is a...

How can I create a function to search through a string and remove all spaces so that "This string has 4 spaces" becomes "Thisstringhas4spaces" I have read the help relating to the Instr function but not sure how to take it forward and remove the spaces. Any ideas? Happiness is...not...

I feel like I have bitten off more than I can chew right now! In my infinate wisdom... I requested our firm to purchase a copy of Visual Studio for Office 2005 Developers Edition, initially it was to enable me to publish some Access db's using the Runtime licence that comes with it. Now that...

I have the following code in a form module Set oApp = CreateObject("Excel.Application") oApp.workbooks.Open strDir The workbook has macros within it and would normally open up with the dialog box asking for confirmation to enable them. However, this code does not fire up the dialog and...

Dim db As Database Dim rst As Recordset Dim Agency As String Set db = CurrentDb Set rst = db.OpenRecordset("tblBordereauxAgencies") Do While Not rst.EOF Agency = rst.Fields("agencycode") PrintBordereauxStatements (Agency) rst.MoveNext Loop The idea is that it opens a report in preview mode...

Anyone know if its possible to reference the form close button and setfocus to it? Happiness is...not getting what you want but wanting what you have already got

I have the following SELECT sql statement which is part of a Make table statement. This part is concatenating 2 fields with a "\" and creating the new field NewPolicy. The syntax creates a type mismatch error, I have tried various combinations to resolve this but I cannot get it right, if I...

I would like to run a Dcount statement only when the database is first opened. I have currently put this in to the main switchboard but of course it triggers the Dcount each time the switchboard is opened. I presume there are be a number of ways to do this but I'm not sure what would be the...

When using Excel (97 in this case) is it possible to make the cell cursor transparent? It might sound odd but I want to do invisible navigation around the worksheet and only use the cellref box to know where I am located. If IT ain’t working Binnit and Reboot

I have formatted 7 columns and 25 rows to highlight the max value in each row using CellValueIs=MAX($E10:$K10) and this works fine for rows where there is at least one value. When it reaches a row of cells with all null values it considers them to be equally null and highlights all the cells in...

I have 8 almost replica versions of a database being used each with their own unique data. Each db has a specific table that I need data the data from(all with same fields/attributes etc) I have created a stand alone db and created a link to each of the 8 tables. I now wish to build a single...