Search results

I'm creating a fairly complicated excel sheet in access vba and I'm finding i'm needing to do some manipulation of the references, enough to make me start think i need to spend time writing a set of functions to make this easier (ie add x columsn to ref, x rows, etc) Before I do that has...

The wrox press books are pretty good, or the nutshell ones. VBA should be the same, although it has changed in different versions of office.

also isn't like case sensitive? ie *MM* wont match ommo but *mm* will match ommo and OMMO at least I thought that was the case.

Or you could use this: 'Execute Module 'ExecAss: Executes based on its OS association 'ExecCmd: Executes and waits for a process to finish '2000 Chris Beach ' Option Explicit 'Type Definitons '=============== Private Type STARTUPINFO cb As Long lpReserved As String lpDesktop As String...

mmm, I've never had any problems running xp with access 97 and office 2k, 2k2 or 2k3...as long as you install 97 first in a seperate dir and then the newer office in the normal dir. although I can't remember installing 97 after sp2...will try tonight on a virtual machine. it might be out of...

If your form is maximized with in the access app, when the access app is resized, your form will get its resize event fired...I just tested it:) If it is not maximized then it doesn't. In case its useful, my forms resize event 'resize the subform and title On Error Resume Next Me.subForm.Width...

not easily! I think it would involve a msg hook or a callback neither of which are simple. Why do you want to capture the access app resize?

you've checked the spelling in tables SEN_pilot_English_by_school and Percentile? do you need the [] for the fields in the addnew code??? also try ("fieldname") instead of the !/bang.

not positive about this: but would using ADO help? I know my VB app using ADO to talk to an Access db can return the number of records affected by a query. I dunno if ADO inside access can do the same thing??

it could be corrupted. try compiling all modules, try importing all database objects into a new database, if its simple form try recreating it. If its an old version of access, try converting a copy to a new format...if this fails (the new format crashes access) then its almost definitaly a...

movefile? will move from one name to the other:D :p :rolleyes:

the forms AfterUpdate event is fired after the record is written to the db, so this is where any reset type of code usually goes. So in this sub you would clear the combo box, and run the code to set the fields to empty. thinking about if the defualt value is nothing in the first place then...

I suggested excel because its the closest match to the access report. Word would be a pain because again you'd run into the same problem as access, in that the number of fields change. With Excel you could have a template with a lot of the formatting done, and export as much or as little data...

have you thought about exporting to excel?? sounds like it could be more suitable, as the basic case would be to fill an array and then shove array on to a sheet. This array has the column headers, the values and even formula if needed. obviously this can be dynamic as well.

then its not really a table link problem is it?? its more of a export/import excerise, in which case its just a case of getting the mainframe data out (connectdirect or whatever) and then importing it into the db.

probly not the quickest no:) or very portable, you wont be able to convert that on to SQL Server for example

yea, that's quite neat...although some of it is how """" is used when you want one ", 3 or 5 I could 'get', but 4 is just illogical:D

is the table open? that might cause problems. Below is a simple file exists function: You would use it before the transfertext sommit like: If Exists(tOutputPath & strFileName) then msgbox "some kind of warning" 'you could use Kill tOutputPath & strFileName to delete the file here end...

you will need to split the status in to a seperate table, with a 'SortBy' type of field to give you a numerical sort order. Or your lookup could be multiple columns, the first being your sort order id, the other the text, and then the sort order id is what is actually stored. Obviously this...

you've got no checks to see if the filename exists? also you seem to have too many options on your transfertext line, after the filename there is a HasFieldName and HTMLTableName option.