Search results

You need a space after F4 Otherwise you need to give us an error message or some guidance as to what happens. Does the tblTestCsv get created / filled?

Setting Formula objExcel.ActiveCell.Formula = "=SUM(A5:A25)" Hope this helps

SubForm Link From the Main Form. Me.FrmSubFormName.Form.FieldName NB FrmSubFormName is not the name of the form but the name of the subform on the Main Form.

Thanks, All very odd as in ADO 2.5 the same code has it as optional. I'll certainly try to do it with the number of rows included but i might be better to make sure it uses ADO so that it is less cumbersome, especially as I need to write this eventually into asp.net. Goodeness know how I force...

A Macro !!! First bin the Macro. You don't want to start coding with these as when you migrate forwards it won't work. The easiest and quickest way to build the HTML page for your email is to deisgn it in an HTML editor. (Word will do). Then look at the source code and copy it to series of...

Getting Paid I think you'll find most of it is in kind! and not enough! A DBA will get paid dependant on 1.Type of Db (Access - not a lot; Oracle - lots) 2. Size of company. (and Db). 3. Experience. 4. Looks :) I get paid not a lot!!!!:cool:

Open Excel And mine. NB you need to have the correct References! Dim objExcel Set objExcel = CreateObject("Excel.Application") objExcel.Workbooks.Open "H:\PORs\POR Template.xlt" objExcel.Visible = False objExcel.Sheets("DATA INPUT").Select objExcel.Range("F3").Select objExcel.ActiveCell.Value =...

Arrany Syntax Are you sure? Actually that is a polite way of saying I a am sure you are wrong.:) vararray=objRecordset.GetRows(rows,start,fields) is the syntax with the paramaters all optional. I agree that it is just possible that it could be memory but since it only returns 500 records and...

Check that ID is allowed a value of NULL. If your Form is bound to a table or Query this would stop the action.

The OnChange event is called when a record value is changed but your question seems more like you want it to reset when you move to another record so that event doesn't get triggered. Try setting the new value for the subform field in the OnCurrent event in the Main form. This means that each...

Recodset and arrays A very fair point. Two reasons. 1. I am about to build a shopping cart system to replace an existing one and it will use arrays (asp.net) and 2. I can't think of this one. I think I get the UBound thing now... but then surely this would work? For i = 0 To intCount...

I have some code as follows: to insert a recordset into an array and then loop through it. sSQL = "SELECT imagename FROM tblproducts " Set rstimage = CurrentDb.OpenRecordset(sSQL) If Not rstimage.EOF Then arData = rstimage.GetRows() intCount = rstimage.RecordCount iRecFirst =...

Links as Adverts Hi, Does advertising include links like ... Football (UK)? Which by the way does not work!!:D And should it just be Glasgow Football!!! B

OS XP Pro Office 2003 I have setup an Access 2003 system to print 3 different types of invoice in a print run dependant of the invoice type and this works fine but a notification keeps flashing on screen. To stop this I have gone manually gone into Printers and Faxes, selected File and then...

I have an Access 2000 database which has the "on enter field" behaviour set to go to start of field, but on a form which has default 0 zeros I'd prefer that the behaviour changes to Select All so that users do not have to delete then enter a number. Any ideas how to do this in the OnFocus event...

Just what I needed, thanks

Web Version You could adapt this to suit. dbConnect is the current database connection. strSql1 = "SELECT * FROM TblName where Selectionfield = " & Selector 'create recordset Set rsData = Server.CreateObject("ADODB.Recordset") rsData.Open...

I have a module called by several forms which builds word documents from templates. On nearly all the Forms there is an AccountNumber field but for one this field does not exist. Does anyone know a way of saying something like this: if Field.Exists(Forms!frmName!fieldname) = True then .typetext...

Hi, Welcome to the Forum. First thing is to learn that you'll get more help if the subject is desciptive not general. "Help" means nothing, "database design issue" is more likely to get noticed. In a project like this I always start with a list of all the possible data i am likely to want to...

If you open the VB script editor and go to Tools || References it should say what is missing or broken. If missing then either find the equivalent dll or if broken copy from another PC.