Search results for query: *

Hi Guru I convert one access 2000 database into SQL server backend, this is no problem. The problem is: There is another portable database called traveller is a 'snapshot' copy of Master database in it's entirety, which loaded onto a laptop and carry on the plane, so the traveller database has...

Hi Gurus I couldn't fix the question for a couple of days. Please help: When I run the following code I get an--error "ODBC call faileed" 1. This is an Access 2000 application connected to a SQL 2000 database. 2. tblFEMSAudi is linked table from SQL2000 databasse. 3. when debugging the error...

Hi Guru: I tried to use DTS import/export wizard transferring data from SQL to excel spreadsheet. I only transfer one table, there are 30 columns in the table.After finish transferring, I open the spreadsheet, there is only first column of the table I can view, rest of columns don't show up, how...

I am trying to set up some code to add records to a linking table based on a couple of parameters from the form, using VB in Access Form, SQL backend. I created the linking table (Diary_tb) from SQL server as: NUMBER nvarchar 8 primary key DETAILS nvarchar 50 allowed null STARTDATE...

Hi Guru I created one sheet in my excel file, and I created a customized bar as “NEW BAR”. In the customized bar, there are 5 buttons. One of them is called “ScrollRight1Screens”, underneath function as: Sub ScrollRight1Screens() Worksheets("sheet1").Activate ActiveWindow.SmallScroll...

Hi Gurus Are there anybody know how to change columns width of certain cells without affecting the whole column? for example, I want change Range("A1:H1") width, but rest of A or H column width don't be affected except row 1.

Hi Guru are there anyboyd know how to change the comment box position using VBA. Currently default comment box position is on the top right, is it changed to be under the cell or whatever? thank you very much

Hi Guru I create a customize bar using VBA in excal 2000. it works fine. but when I use minimize or restore button in excal's window,not the minimize or restore button from "Worksheet menu Bar", the customize bar disappeared,and in my VBA code I turn off Formula bar and Status bar, but...

Hi Guru: I meet a problem to deploy customize toolbar which I create in excal application. this toolbar has 5 controls and I add in different macros for them. In my own computer, this toolbar works fine. When another user open my excel application in his computer, it only shows the customize...

Hi is there anybody know in openform method in MS Access, what do these window mode mean?: acDialog, acHidden, acIcon, acWindowNormal. thank you in advance

hi Gurus I try to set worksheet menu bar invisible in excel. I write the code like this: Application.Commandbars("Worksheet Menu Bar").Visible = False in the Workbook_Open() VBA project. it doesn't work. every time it show a error message: Run_time error'-2147467259(80004005)': Method...