Search results

Hi Peter, Sorry for the delay in replying. I've got it to work now. The code I posted was added just after a pivot table had been created and the particular cell I was trying to format already had certain elements of the cell bordered - so there may have been some sort of conflict when...

Hi All, I am experiencing the following error when trying to execute this snippet of code:- Run-Time Error 1004: Unable to set the LineStyle property of the Border class appXL.Selection.Borders(xlEdgeTop).LineStyle = xlContinuous appXL.Selection.Borders(xlEdgeLeft).LineStyle = xlContinuous...

Hi there, I'm using the FILECOPY command to copy a specific file on the C drive to a CD. I have been testing this for ages and it's been working fine. All of a sudden, I am getting a runtime 75 error. WHY??? Thanks in advance, Paul.

Lagbolt, Thank you very much for your time! It's exactly what I am looking for. I will read and digest your code and I hope I can get back to you if I have any questions. Thanks again! Rgds, Paul.

Update. Okay, I have figured out how to use the NodeClick event to open forms etc. Private Sub TreeView0_NodeClick(ByVal Node As Object) Select Case Node.Text Case "open form2" DoCmd.OpenForm "form2" Case "open form3" DoCmd.OpenForm "form3" End Select End Sub...

Hi there, I'm venturing into the abyss of treeviews and have read many threads on this subject. I have two questions to ask regarding the attached sample db, if anyone can help me please. 1) How can I adapt the existing code and create subnodes (or sub child nodes). For example, how can I...

Hi there, GHUDSON...no thanks needed. People have helped me so much on this forum, it is an invaluable source. Just browsing FAQ's and other threads is sufficient to answer a majority of my questions. THE DOC MAN...thank you for explaining the concept of the function code. I digested many...

Hi there GHUDSON, Option Compare Database --------------------------------------------------------------- '||| Make sure that the following REFERENCES are set:.... '||| MICROSOFT OFFICE 10.0 OBJECT LIBRARY '||| MICROSOFT EXCEL 10.0 OBJECT LIBRARY...

Thanks The Doc Man! From your idea I managed to sort it out. Kind rgds, Paul.

Hi GHUDSON and thanks for replying. Before the run-time error appears (3051) a "save as" dialog box opens and pressing cancel produces the error you have mentioned. The line which is causing the "save as" is:- objExcel.Application.ActiveWorkbook.Close True The full code is as follows:- Dim...

Dim objExcel As Excel.Application Set objExcel = New Excel.Application Dim strFileName As String strFileName = objExcel.Application.GetOpenFileName("Select CSV file, *.csv", , "CSV file") If "FILE IS ALREADY OPEN" Then MsgBox "File is currently open. Please close and re-run this program."...

Thanks Uncle Gizmo for the reply. Checked the links, but it's not quite what I was looking for. I'll try and put the question another way. I have already created an UPDATE QUERY to look for, say, ABC123 in the table. In the query there is a DMAX+1 function. But what the query does is look...

Hi there all, I am looking for a way to update certain records in a table with an incremented value of +1 each time. For example, TBL_MAIN will have fields REF_NO and INCREMENT_VALUE. In field REF_NO, the same record may appear more than once and the INCREMENT_VALUE field needs to update by...

Thanks alot Neil. I got this to work nicely even when I changed a few of the parameters for testing purposes, i.e. saved the file to desktop rather than D:\. The only slight snag was that the file opened but I had to manually close it for the copy to continue. Is this how it should work, or...

Thanks for your suggestion Neil. Are we talking MSDOS here? If so, I wouldn't know where to start! Could you please elaborate or give an example. Cheers, PAUL.

Thanks maxmangion for your reply. The DB is used by a single person in a small business. I was thinking of having a piece of code set-up to make it easier for him to back-up the data each night onto a CD to take home with him. Of course, he can just copy and paste the file using My Computer...

Good day all, I have read quite a few threads about backing-up DB's, but have not come across any coding that specifically shows you how to back-up a DB to CD. Maybe someone can point me in the right direction. I have a simple db (not split into FE/BE) and I want to allow a user to copy the...

Liv, Thanks for the reply. My thread does read a bit confusing. To simplify things, if I click in the subform itself, the ONCURRENT event code kicks in and auto-fits the datasheet columns to fit the data in each field exactly. However, if I click on the subform's scroll bar, the ONCURRENT...

Hi All, I have the following piece of code on my subfrom datasheet which re-formats the columns and rows either ON CURRENT or ON LOAD of the form:- Dim Cntl As Control For Each Cntl In Me.Form.Controls Cntl.ColumnWidth = -2 Me.RowHeight = 250 Next Cntl However, I find that if I activate the...

Thanks Vince for your thoughts. Have just spoken to our IT guys and because we are also trialling a new version of Citrix, the admin rights might be slightly amiss. It may be a "mish-mash" of problems! Regards, PAUL.