Recent content by cathy68

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