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 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...
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 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...
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.
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.