Recent content by idbr

* or KB even...

Hi MazeWorX, Installing the fix from the KP has solved my problem and we're now up and running with no crash issues. Thanks again for your help with this. Regards, Iain

That looks very helpful, thanks. I'll let you know if it solves the problem.

Nothing running at startup. Not even startup options set. Crash interval is in the order of 2-3 seconds once corrupted, or immediately I try to open any form. Attemting to import the objects to another db throws the same error.

Hi, I have an A2010 db front end, linked to a SQL Server 2005 back end. I'm seeing multiple crashes and can't see where the problem lies. Usual crash point is opening the database with the followign details: Problem Event Name: APPCRASH Application Name: MSACCESS.EXE Application Version...

Hi, I have a simple data copy operation (running via Access VBA): appXL.ActiveWorkbook.Sheets(strSourceTab).UsedRange.Select appXL.Selection.Copy appXL.Workbooks(strWorkingFileName).Activate appXL.Workbooks(strWorkingFileName).Worksheets(1).Activate...

Fixed it with some help from this thread. Slooooow running code below, suggestions for improvements welcome. intInFileID = FreeFile Open strFile For Binary As #intInFileID intOutFileID = FreeFile Open strFile & ".txt" For Binary As #intOutFileID Do Until EOF(intInFileID) Get...

Actually, also worth pointing out that because of the lack of row terminators the file row count is hopelessly out too. Ta, Iain

Hi, I'm trying to process a csv export file but have a bit of a problem. It's been exported in Excel csv format. When I view the file in Excel, it splits into its constituent columns just fine. However, when I look at the file using notepad there dont appear to any row terminators at all...

Hi Skip, Macro recorder isn't working - or at least isn't picking up shpe operations. Useful. Anyhow, it seems it's an operation order fernicketiness problem. Changing .ForeColor.RGB = lngBlendMidColour .BackColor.RGB = lngBlendEndColour .TwoColorGradient...

Hi, Does anyone know how I can set a two colour gradient fill in E2007 VBA? I output a report that has 2 rectangles as the background. Left rectangle is gradient filled colour 1 to colour 2. Right rectangle is gradient filled colour 2 to colour 3. The shapes are place dnext to each other to...

Hi Max, Also, be very careful with referencing. VBA has a handy habit of opening a new reference to Excel whn you fail to properly reference an action in your VBA script. E.g. set appExcel = New Excel.Application ' do something appExcel.Open <workbook> appExcel.Range("A1").Select ' note...

Hi BxWill, How about using a template list? Set up a sheet with your SearchForInColA---Column B ----Column C--------Column D values listed in sequence. ' *** air code *** dim varfind dim intRow as integer dim i as integer ' Loop through he values on the data sheet. for i = 2 to...

Hi Lhuffst, If it's unreliable, why not just work around: Add a column to your table, say, Update_Key (Double) Add a couple of lines of code: dim dblUpdateKey as double ' convert the current time and date to double set dblUpdateKey = cdbl(now()) ssql = .... & _ "Update_Key = " &...

Hi Lhuffst, Are your records actually being updated? From the help file: In a Microsoft Jet workspace, if you provide a syntactically correct SQL statement and have the appropriate permissions, the Execute method won't fail — even if not a single row can be modified or deleted. Therefore...