Search results

Understood arne, but I can't get the syntax right. The problem seems with the last 3 lines. ' wb.DisplayAlerts = False wb.Save objExcel.Quit I have to rem out the Display alerts or it errors. But the result is not good. The workbook won't open without a "locked for editing" error and...

I'm in the wrong forum, sorry...but may not matter that much but this is VB6. It was working without error until I added the Save and Quit commands. June: When this crashed I lost that getExcel Function and a whole lot of API I'd pasted in. But it just returned the Excel filename/path.

I seem to be stuck in a loop with: This action cannot be completed because the other application is busy. Choose 'Switch To' to activate the busy application and correct the problem. I can only Switch To or Retry neither give me back control. Sub Main() Dim ExcelFile As String Dim objExcel As...

Oh yes, but not me! I *did* rem out the Form_Open command without realising it was also set in properties.

Whew, many thanks for letting me know. I hadn't altered the shortcut property myself but I knew a left click had other uses (in this Form). But I don't remember shortcut being an issue when other fields were added before. (Maybe they were not hidden ?) Looking for the Hide/Unhide menu was the...

Perhaps a new approach... Have attached a db, when the Form is Opened the control 'txtEnginer' is not present or showing like all the rest are. Why ? It is in the query the Form is based on and is bound. Thanks. Have been trying to figure it out for over 12 hours!

Hi Doc_man, So few solutions... The message that forced an End task was a mistake caused while debugging. I was just wondering if any way to get out of it (other than End task) existed. That's not related to my second question. The search for Hide/Unhide goes on, and rather irritating, as I...

If a Form insists on displaying a message (looks like an OK msgbox) and just repeats forever forcing a Cntl-Alt-Del to end task (Access), is there any other way of quitting (without Ending task) ? Please, Where is Hide/Unhide to determine what fields are displayed in a datasheet Form. I have...

Very nice June, I can see that's a really good solution. Wouldn't have though of db.Execute.

LOL no I have not! I'd have to setup some test conditions and fluff around for ages. I'd find it much easier to do it all in VBA.

Can an single update query fix spelling mistake in e.g. all instances of "Sydney Lipton" change to "Sidney Lipton" The field is called "AC" and contains other text and "Sydney Lipton" could appear anywhere.

So that error will present even if Set Warnings = False

Galaxiom, what is the action of 'dbFailOnError? At run time I find Set Warnings False is needed, and just wondering if that will cause any issues?

Aah.. got it, thanks very much.

Run-time error '3075': Extra ) in query expression DoCmd.RunSQL ("UPDATE tblmain4 SET [AComment] = " & Dat & " WHERE [Prefix] = '" & Serial & "'") Dat is a String Serial is a String AComment is Long Text in the table Prefix is Short text What am I doing wrong ?

No, he didn't.

Thanks Arne. So an update Query is the wrong approach? It is working perfectly but from Private Sub txtField4_DoubleClick. varValue = Me!txtField4 worked but it could not find !txtFleld4. That had to be just "!Field4" Most baffling.. to me ! Thanks...

Yes arne, 100%. But I've got to be a bit careful as the form is based on a Filtered query.

I was wondering that. So I'd use the Forms record source ? Yes, updating null fields to the value c-clicked.

I want to update all Field4's in my datasheet Form1 to the value d-clicked in the Field4 Double click event (if a value exists). Update Form_Form1.Field4 = Me!Field4 Where Form_Form1.Field4 is null What am I doing wrong ?