Search results

So ... it looks like there is no option in Access that can turn off these backups? And as to this thread -I first created this thread, noone responded, so I asked you to take a look on it. I thought that they are to different questions ... Thank you

vbaInet, no good deed goes unpunished. May be you van help with another problemo - see thread Unsolicited Access backup Files ... Thanks

vbaInet - so simple? I tested this approach and it works. I feel stupid not to figure it out myself. But ... that's the friends are for ... THANKS A LOT!

ok. Let me try this Thanks

Aha. Exactly. Local table is a record source for the continuous subform.

My app includes 1) SS2K8 database on the back end 2) Access 2003 front end NOT LINKED, data flows through ADO and stored procedures on the back end. ================= Front End consists of forms/subforms and local tables "connected' to subforms. Data flows that way: Sql server table <===>...

My access application sometimes creates backup files, like Backup Of + original file name. It looks like it happens when some error occures. It is Access 2003 mdb file. It contains a lot of vba codes. All subs and funcyions have error handlers and Error Trapping is set to Break on unhandled...

You can do it either way. I prefer adoCMD.Execute adoRs.Open adoCMD because it allows ANY type of recordset, while Set adoRS = ... forward only

In my Access front end VBA code opens ADO recordset from stored procedure on remote SQL Server 2008. It worked OK for 2 years and SUDDENLY it stopped working. The code execution stops at line (see below) with popup: Run Time errror '3704' Operation is not allowed when the object is closed On...

And that: Dim i As Integer For i = 0 To Me.ComboBox.ListCount - 1 If Me.ComboBox.Selected(i) Then Me.ComboBox.Selected(i) = False Next

How about that: Me.ComboBox.RowSource =""

Hi everybody! I need: 1) to send a parameter from Access into CR report 2) read the resulting field values in the report I have installed 1) MS Access 2003 2) Business Objects/Crystal Reports 11 ============== Questions: 1) which library should I reference in VBA? 2) which properties of the CR...

Thank you vbaInet - Merrion's article looks promising. Will try it. And be back (on Monday). Happy Chinese New Year to everybody! Val

Well D, I can create the custom printing routine. But the question remains: how can I get a feedback from printer? Thanks Val

Thank you John. This is a nice aproach. But we do not know if the report was printed. Is there any way to get feedback from the printer (throgh windows api or else)?

Hi there, This is the problem: My report is open in preview mode. When the user selects File ==> Print and then clicks OK in the dialog box I need to update field 'ReportPrinted' in the database table. I'm using Access 2003. Please help Thanks Val

Your formula is certainly better, mine stutters at negative 'time' values like '-00:05:00'. For my specific purpose I would rather use 'notepad' approach and then use my utility to import data using two recordsets: rsAccess("FieldName")= rsExcel("FieldName") Thank you

In this file 0:20:00 is not realy a time but an interval - 20 min (it is never more than 60 min). So I can change it as a number using formula (see columns I and J in the attached).

It works your way (thru notepad). Thank you

Re: Exporting Excel data: covert to text problem No it does not work.