Search results for query: *

Hi vbajock Now I understand I have to use Access project with MSDE as suggested by tonyflavell. the new question is: the master database is .mdb file, how can I use VBA code to create a new Access project and copy all the queries, forms, reports to another directory. original code from the...

Hi vbajock The second method you told me using VBA code. I know Access has a Docmd.trasferdatabase function. When I use: Docmd.TrasferDatabase acImport, "ODBC Database",........(I don't write rest of it) This function will import the tables from SQL server into the master database, but all the...

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 guys I solved this problem. The answer is: in tblFEMSAudit there is an AutoNum field called"ID " as Primary key. When I design this table at SQL server side, I set up it as "Primary Key", but I forgot to set up its indentity as "Yes", when I link it back to Access application, run the...

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...

Hi Roy-Vidar Thanks for these suggestion. I changed these reserved words as Number and Type. It works fine now.

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...

thanks Zathras, you are really star[2thumbsup]

Hi Zathras I meet another problem. same file, same customized bar, another button call"GoToday", the previous code is: Sub GoToday() cellname = ConvertCellNotation(1, 1) Worksheets("sheet1").Range(cellname).Activate Fcol = 1 Do Until...

Thank you Zathras!!!! [2thumbsup]

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...

What I try to do is I need to repeat "INTERNATIONAL FLIGHT, OVERSEAS FLIGHT, MIX FLIGHT" three text phrases across the entire width of the sheet, these three phrases are difference color. I tried one way as inserting these in column one in fomular bar, repeat it long enough, but when I...

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.

Thank you combo and xlbo!!!!!!!

Hi combo I tried your code. The funny thing is the comment box still in the same position, only I right click mouse, try to edit comment box, I can see its position changed. because I changed around the x, y value. it looks like the comment box having some default position to hold it, I am not...

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...

thank you guys. that is really helpful!!![thumbsup2]

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...