Access 2000 Cursor Postion And Activex Calendar Ctrl
I have a form I am working on for data entry. The users enter in dates in multiple fields. I also have placed on the form for their conveinence the active x calendar control 9.0. The problem is when they decide they need to change months they use the calendar control. I would like for their cursor to stay in the field they are working in even though they are clicking on the calendar. I have seen programs do this before, just don't know exactly how it is done.
As always any and all help is greatly appreciated.
Thanks,
Remasters
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Textbox Cursor Postion Overwrite Data.
hi,please help.basically have 5 textbox,i need to overwrite value in the textbox with a command button .if all the 5 textbox already contain data ,where the blinking cursor is in the textbox ,click the commandbutton to overwrite the textbox data. now the problem is how to clear the data to preform overwrite data when click the command button.in the form have 20 commandbutton.please help.thanks.
this is the current code:
Code:
Private Sub Command1_Click()
If txtdata1c.Text = "" Then
txtdata1c.SelText = Command1.Caption
Else
If txtdata2c.Text = "" Then
txtdata2c.SelText = Command1.Caption
Else
If txtdata3c.Text = "" Then
txtdata3c.SelText = Command1.Caption
Else
If txtdata4c.Text = "" Then
txtdata4c.SelText = Command1.Caption
Else
If txtdata5c.Text = "" Then
txtdata5c.SelText = Command1.Caption
End If
End If
End If
End If
End If
End Sub
thanks for help.
Access 2000 Calendar Control
I am fairly new to Access, I am trying to add a calendar control to an existing database. using the calandar control i would like to be able to select dates and show all events listed for that date. is this possible?? if so please help.
Microsoft Access 2000, SQL And Calendar Control
Hello!
I'm doing a little project with MS Access 2000 and I have been stucked with the following problem a few days:
I have a SQL query:
SELECT Sum(Table.Column) As Total
FROM Table WHERE Table.Date = [Forms]![MyForm]![ActiveXCtl].[Value] (I've also tried many other SQL-queries)
On the form I have a Calendar Control and its name is ActiveXCtl, I have put the following function call to the ActiveXCtl's Click-method: Form_MyForm.Total.Requery
I also have that query on the form as edit box (Name: Total).
Now when I click on a certain date on the calendar control, I would like to see query results for that date, but nothing happens.
Can anyone help me with this one?
Access & Calendar ActiveX Control
Hi,
I am creating an Access database and I want to add a Calendar control to ensure users pick a valid date. In my form I click on 'More Controls...' in the toolbox. I have a long list available and choose CoyoteCalendar2.Calendar and this adds the functionality I need.
However, I am a little worried that when I move this database to another users computer the ActiveX control may not be on their machine. Is this correct and if so how would I get the control onto their computer?
I don't even know how the Coyote Control got onto my machine - it may have been while installing another program e.g. Visual Studio.
Any help is appreciated.
Thanks,
jonny
Custom ActiveX Control Slow In Access 2000 But Not Access 97
I have created a Calendar ActiveX control in VB 6 that I want to use in an Access 2000 database. One of the methods I have provided with my control is to change the calendar year.
The problem I am having is that when this method is called using the control in an Access 2000 database, population of the calendar is slow (about 5 seconds). If I use the same control from an Access 97 database calling the same method, population is instantaneous.
Has anyone had a similar problem to this before? Is there a compilation option in the creation of the ActiveX control that might fix this behaviour?
Thanks
Using ActiveX Data Controls In Access 2000
I have a question about using ActiveX controls in Access 2000, but I will give you some background on our situation first. We’ve just converted an Access 97 database into Access 2000. Our application connects to a Sybase back-end. Recently, we’ve discovered that in Access 2000, ODBC links are buggier than in 97, and, that the Jet performs more poorly. An example of the buggy link problem is, after entering a new row of data in a table or a form, the row disappears and shows #deleted in every column. This occurs when the Sybase (ASA) table contains indexes other than foreign keys.
We’ve known that eventually we would have to move away from using the Jet engine anyway, so now seems like a perfect time to bind our data controls to ADO connections.
Our dilemma is in choosing the appropriate database grid control. We want similar functionality as we received with Access Forms in datasheet view as a sub-form within a main form. The Microsoft data grid control does not look and feel as good as even an Access datasheet form, so we’ve been evaluating the Sheridan DataWidget controls. These controls seem powerful enough, but they seem to be buggy within an Access application and more difficult to use than within VB. One example of a problem that we’ve seen with the Sheridan OLE Database Grid control is that in Access, the ESCAPE key does not “undo” the record like it’s supposed to, but testing the same control in VB works fine. Other similar problems exist.
I guess my question is, what would you recommend for our situation? Are there other third party ActiveX controls that you would recommend which have similar look, feel and functionality to Access forms in datasheet view?
»Dan
Access 2000 VBA Importing Userdefined ActiveX
Hi friends !
I'm running in an old VBA Access problem. I have a Access mdb full of code written in vBA by myself in the medium of the 90 th when it was Access 1.0 This was upgraded and upgraded and code adapted so the last version of access we have is 2000 and program is still fine. But now I have to add an activeX, which I have written in VB especially for this old program. The activeX is tested in VB6.0 works, the ocx is comiled and put into windowssystem32 and registered. But I cannot see my control in the tools and I'm not able to add it to the activeX list of access. When I try to add the .ocx file nothing changes. I have heard once by rumor that there are needed some special settings if anyone wants to write a control that can be used in MS Access. Anyone knows whats needed exactly ?
Multiple Selections On Microsoft Calendar Control Using Ctrl
Hello all,
I am wondering if there is a way that a user can select multiple days within the Microsoft Calendar Control 8.0 or do I need to hard code this method in. If I need to hard code, can someone please provide a snipet of what I need to do and where?
Thanks...
Disable CTRL+ESC In NT/2000 In VB
I have been searching for a method to disable this key sequence in NT/2000 and have come up dry. There are a few techniques for accomplishing this in Win 9x, but I haven't anything for NT/2000 in VB.
Need To Disable Ctrl+ALt+Del In Windows 2000
Hi!
I was wondering if anyone here knows how to disable the Ctrl+Alt+Del / Alt+Esc / Alt+F4 / Alt+Tab keys in Windows 2000 / NT or if it's even possible with VB....
I've looked all over the net for help on this, but can't find it anywhere. I know how to disable the system keys in Win98 using the SystemParametersInfo function...but that obviously doesn't work in NT/2000/XP, and i don't want to use a customized version of GINA.dll. I would be really grateful for any kind of help on this subject.
Thanx!
Disable CTRL-ALT-DEL And ALT-TAB, Windows Key Etc In NT/2000
Hello ppl
Is it possible to block usage of CTRL-ALT-DEL, ALT-TAB, the Windows key etc in Windows NT/2000? I have Karl Moore's code for Windows 9x based platforms which works perfectly for those OS's but it doesn't work for WinNT and Win2k. Any ideas?
The Windows 9x based code was:
VB Code:
Private Const SPI_SCREENSAVERRUNNING = 97 Declare Function SystemParametersInfo Lib "user32" _ Alias "SystemParametersInfoA" (ByVal uAction As _ Long, ByVal uParam As Long, lpvParam As Any, ByVal _ fuWinIni As Long) As Long Public Sub EnableTaskKeys(Enabled As Boolean) If Enabled = False Then 'Disable task keys SystemParametersInfo SPI_SCREENSAVERRUNNING, 1&, 0&, 0Else 'Enable task keys SystemParametersInfo SPI_SCREENSAVERRUNNING, 0&, 0&, 0End If End Sub
then
VB Code:
' To disable task keysCall EnableTaskKeys(False)
to disable the task keys, and:
VB Code:
' To enable task keysCall EnableTaskKeys(True)
to re-enable them.
TIA.
Disable Ctrl+alt+del In Windows 2000
Does anyone know how to disable ctrl+alt+del in windows 2000. There is alot of code out there to disable it in win 95/98/NT, but i have yet to find any code to do it in win 2k.
Calendar Control With Win 2000
hi , i am having problems with this calendar control, i have developed an application that uses this control on a form .this form is called from variuos places by simply clicking a button , now after installing this application on a system running win 2000 sp1, the application runs but when the button to call the form containing this calender control is pressed , windows opens an intallation dialog box & asks the user to insert the win2000 install cd ( strange is'nt it ??) after the user cancels it the application runs showing the calender control & it never asks to install any thing even though the user calls the same calender form many times , untill the application is closed and started again , this happens only the first time the form containing the calendar control is called , any suggestions ??
thanks
yahya
Problem With ActiveX Ctrl
Hi,
I have one problem here, the following is a VB function:
Public Function connect(hostname as String, username as String, password as String) As Boolean
ADsPath = "WinNT://" & hostname & ",computer"
Set dso = GetObject("WinNT:")
On Error GoTo ErrorHandler
Set comp = dso.OpenDSObject(ADsPath, UserName, password, 1)
'If comp Is True Then
For Each obj In comp
......
Next
connect = True
Exit Function
ErrorHandler:
connect = False
End Function
This function runs very well. If I give correct hostname, usname and password, it returns 'true', if those credentials are not correct, so it returns false.
When I transfer this code into a ActiveX DLL control for ASP, the return value is not always correct, the finding is as follows:
For the same hostname(PC name), if the username and password are correct for the first try, then all returning values will be 'true' in future tries, regardless whether the username and password are correct or not.
The following is Active X control source code:
Public Function loginSPFADS(ByVal username As String, ByVal password As String, ByVal hostname As String) As Boolean
If connect_ads(username, password, hostname) Then
loginSPFADS = True
Else
loginSPFADS = False
End If
End Function
Private Function connect_ads(username As String, password As String, hostname As String) As Boolean
Dim ADsPath
Dim dso
Dim comp
On Error GoTo Errorhandler
ADsPath = "WinNT://" & hostname & ",computer"
Set dso = GetObject("WinNT:")
Set comp = dso.OpenDSObject(ADsPath, username, password, 1)
If comp Is Nothing Then
connect_ads = False
Else
connect_ads = True
End If
Set ADsPath = Nothing
Set dso = Nothing
Set comp = Nothing
Exit Function
Errorhandler:
Set ADsPath = Nothing
Set dso = Nothing
connect_ads = False
Set comp = Nothing
End Function
I debuged the Active X control and find when I run into "Set comp = dso.OpenDSObject(ADsPath, username, password, 1)" statement, even though the username and password are incorrect, it still return the correct comp value.
I tried to register this dll in MTS server and set it to support transaction, but still have the same problem.
How to solve this problem?
Many thanks in advance.
Activex Tree Ctrl
Hi there,
i've converted a 97 msaccess project from version 97 to version 2000, but there seems to be a problem with the treectrl that i'm using
Tree.Font.name = "Tahoma"
this gives an error, cause the Tree that i've registered doesn't support this methos Font! has anyone ever come accross this problem?
thanks for any help
brian.
Of course I do it for the ratings!
Microsoft Calendar Control 8.0 WIN XP <> WIN 2000
I've developed a VB appliction with the calendar control 8.0 on a Windows XP system with Office XP.
When I run that applictation under Windows XP with Office XP, the calendar works fine.
BUT when I run the same application under Windows 2000, I can't see the values on the calendar, I only see buttons, but no dates.....
I've registered mscall.ocx on Windows 2000.
Hope somebody can tell me what's going wrong.
Thanks in advance!
Tinne.
Outlook 2000 VBA Calendar Reminder Set
One of my pet peeves with Outlook Calendar is that people can send meeting invitations without the reminder turned on. (So, I miss the meeting). What I'd like to do is... when I get new mail, if it's a calendar entry, force the reminder flag to true.
So, the forum showed me everything I needed to know but I have a couple of questions.
What should I declare myMail as? I get errors when I declare it as Outlook.MailItem (because one of the entries is a calendar item), vice versa with Outlook.CalendarItem. I get an error when I set it to Outlook.Items. So, back to old faithful -- the Object.
When I get new mail, can I assume it'll be the top of the stack? Or do I have to loop through all mail (as shown below)?
Thanks in advance.
Code:
Private Sub Application_NewMail()
Dim MyMAPI As Outlook.NameSpace
Dim myFolder As Outlook.MAPIFolder
Dim objFolder As Outlook.MAPIFolder
Dim myMail As Object
On Error GoTo errorHandler
Set MyMAPI = Outlook.GetNamespace("MAPI")
Set myFolder = MyMAPI.GetDefaultFolder(olFolderInbox)
For Each myMail In myFolder.Items
If myMail.Class = olMeetingRequest Then
'Only look at Meeting Requests
myMail.ReminderSet = True
End If
Next myMail
errorHandler:
Set myMail = Nothing
Set myFolder = Nothing
Set MyMAPI = Nothing
End Sub
Activex Ctrl Which Understands Html
Dear all...
Is there a control available which will understand/interpret html text rendered to it ?
I know that IE can be used within an activex control project, but I cannot use IE for a certain reason.
please do tell me of you know of any other activex control which understands HTML text.
Thanx
vikram db
VB 6 ActiveX Ctrl Interface Wizard
Using VB 6 Enterprise. Have added VB 6 ActiveX Ctrl Interface Wizard to the references in my project, but does not show in add-in manager. How can I use it?
ActiveX Calendar
I would like to know if someone could help me.
I've putted one ActiveX calendar on my database and my problem is: if by example I press on first of June it will know the day of the month it is but if I want it to know which day of the week it is what do I have to do?
Thanks
ActiveX Calendar
I am using an ActiveX Calendar in my application. How can I make it default to show the current month? thanks for any input!
Outlook 2000 Calendar Save As Webpage
Hi
When you are viewing your calendar in Outlook there is an function
in File -> Save as Webpage. This function works very well.
Here is my question.
I want to automate this. That means this function should start in the background for example
every 5 minutes and save the html calendar to a specified folder.
Perhaps anyone of you can help me on this or has some tipps or links to this topic.
Thank You and sorry for my English
Benny
Ctrl+Z With SendInput Hangs ActiveX Control
With your help, I managed to get the Ctrl+Z combination working:
(KeyDown & KeyUp are subs that use the SendInput API call)
KeyDown VK_LCONTROL
KeyDown Asc("Z")
KeyUp Asc("Z")
KeyUp VK_LCONTROL
This works fine in, say, Notepad, but when I set the focus to my activeX control it hangs it. The ActiveX object is the NDL Active Terminal Server Client Control (if that helps?!?), embedded within a web page.
Does anyone know why the control would hang? I have tried using the Ctrl key with other characters, and the same things happens, so it's not the "Z" that's the problem.
Manually pressing the keys works fine. Any ideas?
How To Create A Control In A Form From An ACTIVEX Ctrl
Hi
I hav designed an OCX and i hav placed that
OCX in a Form. My requirement is I have a button
in the OCX called "Create". If u click that
buttonm then it should create button in the
Parent Form ( please look closely, the Control
should be created in the Parent Form not in the
UserControl)
If u dont know how to Create a Control, just tell
me how to set the Container property for a label
which is placed in the UserControl. So atleast
I will set the Container property as the Form.
I hope to receive a reply soon from anyone
Thx in Advance
Vijooo
"Ur work i a self portrait of urself. Autograph ur work with excellence"
ActiveX Calendar Control 10.0
I added a calendar control(not monthview) to my access program and am having problems manipulating it. I would like to click a day and have it highlight all days within a range a different color. anyone have experience with that or any ideas?
ActiveX Calendar Control
I'm trying to link the "Calander Control9.0" in Access 2000 to a date field. I placed the calendar on my form and then attempted to set my text box to the value returned but I can't find the calander name anywhere in my expression builder. Where did it go & how do I find it?!?
Activex Calendar Control
I'm doing a project for a friends church. Their budget isn't very much so I'm trying to keep things as cheap (or free) as possible.
I'm looking for an activex calendar control that allows notes to be saved a day and they days that contain notes are highlighted.
Anyone know of any free or very cheap ones? Point me in the right direction?
Thanks,
Randy
SQL Server 2000 Cursor Problem
hello guys, i know this not the right forum but i thought there are quite a good number of SQL Server 2000 gurus as well, to help me out. i have the following piece of Code in T-SQL.
Code:
DECLARE @strIMEIColl VarChar(8000)
DECLARE @strIMEI VarChar(15)
DECLARE curMatched CURSOR
FOR
SELECT DISTINCT(IMEI) FROM IC_Data
OPEN curMatched
FETCH NEXT FROM curMatched INTO @strIMEI
SELECT @strIMEIColl = CHAR(39) + @strIMEI + Char(39)
FETCH NEXT FROM curMatched INTO @strIMEI
WHILE @@FETCH_STATUS = 0
BEGIN
select @strIMEIColl = @strIMEIColl + ',' + CHAR(39) + @strIMEI + Char(39)
FETCH NEXT FROM curMatched INTO@strIMEI
END
WHILE @strIMEI = '' BEGIN
SELECT @strIMEIColl = @strIMEIColl + ',' + @strIMEI
FETCH NEXT FROM curMatched INTO @strIMEI
END
CLOSE curMatched
DEALLOCATE curMatched
PRINT @strIMEIColl
SELECT * FROM IC_Data WHERE IMEI IN(@strIMEIColl)
The variable @strIMEIColl has more than 20 Comma Seperated list of IMEI numbers, but still the Select statement wont show any thing. The PRINT @strIMEIColl statement shows the values correctly.
I tried using
Please tell me where am i getting wrong, or is there an alternative to it also ?!?!
Need An ActiveX Calendar Time Picker
I am creating a an access database that needs to handle booking times etc I would like to use a "FREE" calendar control like outlook has anyone seen or heard of one
My cat's name is sprinkles
-Ralph Wigam
Using Activex Calendar Value To Link To A Page.. Help Please
I placed the activex calendar on a form which has split frames top and bottm. When I select a day, I would like to call a page up related to the selected day. The page I created is named something like this: event1212001, When I select the day, I know the value is correct, I have a message box which displays the date like this : 1212001, I did this by Calendar1.day&calendar1.month&calendar1.year. I even appended "event" to the front of 1212001. The problem is, I cannot get the page to display either as full screen or at the bottom half of the current page. If I type the link in as event1212001, the page displays.. Can someone please explain what may be the problem. Appreciate the help..
Linking Subforms To A Option Box And A Activex Calendar
can some one help me. I am trying to make a form for users who could check to see if a location is reserved or not. i have a query that dose the job just fine but the users screw it up. im trying to make it so that they do not have to type anything at all, just click on the fields that apply to them. Is it possible to have a option box which displays the locations, a activeX Calendar to select the date, and a subform that would list the name and time of a event if there was one? im completly stumped on this and any help would be greatly appriciated.
thanks
Can Multiple Dates Be Selected Using ActiveX Calendar Control 7.0?
I have incorporated the ActiveX Calendar Object 7.0 (Class MSCAL.Calendar.7) into an Access form. BUt I really need to calculate based on two dates, a start date and an end date. To this end I have also included other obects that set the time span given the fixed date provided by the calendar object. This seems like a cluge and not very elegant. I see that the Calendar control has properties called value and oldValue. When examining these values it seems that oldValue is the date value that the calendar control had when it last lost focused and appears to be update when the control gains focus and has a new date selected. What I would like to do is to selected two dates while the control has focue and operate on the two dates since they represent a span.
Does anyone know a way that this can done. Thanks in advance. mc
Outlook 2000: Convert To Plain Text; Move Cursor?
I have written a VBA macro to generate an e-mail from content I input via the InputBox command.
I put a line of content in the body as part of the Macro, then display the message. The cursor displays at the beginning of the body. I want it to display at the end of the body. Hey, I'm trying to be lazy, I mean productive, here. The following code does not work:
myMail.Display
Selection.EndKey Unit:=wdStory
I get a compile error that wdStory is not defined. This is presumably because I am in Outlook and not Word. Is there a workaround for this?
TIA
Excel 2000 + Word 2003 - How Do I Move The Cursor After I Locate A Range
Excel 2003 VBA generating a Word document.
I'm using Bookmarks to locate a specific position in a document.
That bit is going fine.
Now I want to completely ignore the range and insert a whole heap of text and tables after the range position.
Declared -
Code:Dim oWord As Word.Application
Dim oDoc As Word.Document
Dim oRng As Word.Range
Dim oBkMk As Word.Bookmark
Dim oTbl As Word.Table
Code snippet
Code:Set oRng = oDoc.Bookmarks(oBkMk.Name).Range
oRng.MoveEnd
Set oRng = Nothing
Selection.InsertBreak Type:=wdPageBreak
Selection.MoveDown Unit:=wdLine, Count:=2
' insert a new heading for the current sheet
Selection.Style = ActiveDocument.Styles("Heading 1")
Select Case ws.Name
Case "AC"
Selection.TypeText "Performance against SLA - " & colTowns(ws.Name) & " Office"
Case Else
Selection.TypeText "Performance against SLA - " & colTowns(ws.Name)
End Select
Selection.TypeParagraph
Selection.Style = ActiveDocument.Styles("Normal")
' pick up an entry from the clipboard and paste it
oWord.Selection.Paste
My problem is, is that the Selection instructions all get the "Object doesn't support this property or method"
I'm assuming that the Selection is being interpreted as an Excel Selection rather than a Word Selection. How can I code this so that the correct interpretation is used?
Distribute A VB Program That Reads An Access 2000 Db On Machine Without Office 2000
Hi. I want to develop and package a VB6 program which will read an access 2000 database. I use DAO 3.6. Doesn't work on another machine without access 2000 installed. I've been told I can use MDAC_typ.exe in setup program BUT they said MDAC2.6 doesn't contain Jet files etc... I am a it confused. What should I do???
a) MDAC_typ.exe OR b) Copy certain files directly into the setup program. c) Have a beer?
Mail Merge Access 2000 With Word 2000/XP And Pass Variables
Hi, I debated posting in newbies, because I'm kind of learning VBA on the fly, and am not very good at all.
I am trying to Mail Merge an Access 2000 database with Word 2000 & Word XP.
I modified the code I got from the Microsoft Solution Base to try to introduce variables to allow me to merge more than one table and SQL query with more than one Word document.
This code works without the variables, when I just type everything directly. Unfortunately, I need the ability to merge multiple documents/tables.
Sorry if its sloppy code, I haven't really got much of an idea of what I'm doing in VBA yet.
Can anyone help me debug this, and maybe give me the syntax to use in my Macro for MergeIt(var,var,var)
I also need a way to email similar form letters. This is for a membership expired notice - some get mailed/faxed, so need to be printed, while some should be emailed. I've read that sendobject doesn't do so well. - is there a way to merge into Word (or Outlook) and automatically email these notices?
Thanks very much!!
--------------------------------------
Function MergeIt(docaddy, sqltable, sqlstr)
DoCmd.SetWarnings False
DoCmd.OpenQuery "Dues Expired Calculate"
DoCmd.OpenQuery "Dues NOT Expired Calculate"
DoCmd.OpenQuery "Dues Are Expired"
Dim objWord As Word.Document
Set objWord = GetObject(docaddy, "Word.Documents")
' Make Word visible.
objWord.Application.Visible = True
' Set the mail merge data source.
objWord.MailMerge.OpenDataSource _
Name:="F:workooo dbOOO Main Database.mdb", _
LinkToSource:=True, _
Connection:=sqltable, _
SQLStatement:=sqlstr
' Execute the mail merge.
objWord.MailMerge.Destination = wdSendToNewDocument
objWord.MailMerge.Execute
'The following line must follow the Execute statement because the
'PrintBackground property is available only when a document window is
'active. Without this line of code, the function will end before Word
'can print the merged document.
objWord.Application.Options.PrintBackground = False
objWord.Application.ActiveDocument.PrintOut
End Function
------------------------------------
Thanks for any help!
Edited by - case on 7/31/2003 7:40:22 AM
Using Access 2000 To Send Emails Through Outlook 2000
I remember running across a very small piece of code a few weeks ago but for the world of me, cannot find it now and I desperately need it. This piece of code was vbscript, it basically created an smtp server and sent mail using that smtp server instead of relying on outlook to do it.
I have an access database that needs to send roughly 520 individual messages based on criteria for that specific requested area (this is not spam either, this is requested information). It worked fine until I upgraded Outlook to the latest service packs and therefore no longer works. It prompts you with the standard MS security dialog asking for permission to send the email, I can tell it yes, it will prompt me once more, I tell it yes, then it just stops. The job process never completes. I do not want to have to revert back to an "unpatched" version of outlook and the piece of code I mentioned earlier would be ideal to use.
Any help would be greatly appreciated.
Thanks in advance
Todd
Problems-Upsizing MS Access 2000 DB App To SQl Server 2000
Hi all,
I am facing some problems while upsizing my current MS Access2000 database (.mdb file) to SQL server 2000 ( trying to make a client/server application by creating a .adp file).
I did everything using Upsizing wizard available with the MS Access2000. During the Upsizing using wizard I selected the option to create a new database, connected to the SQL server out there on the network( made sure that connection was tested OK), exported all the tables( was not sure what attributes of the table to select, so i selected all the options-indexes, validation rules, defaults, table relationships using DRI and even added time stamps).
Then i selected the option to create a new Access client/server application. I got two syntax errors while upsizing(one was while upsizing queries and the other was a form).But i clicked OK and the upsizing continued with no further errors.
When i looked at the snapshot created by the wizard. All the tables were upsized properly,but none of the queries were upsized. I got errors like "The wizard was unable to analyze the SQL for this query" or "This query is not upsizeable because it depends on a Form parameter". There was no information regarding forms or reports on this snapshot.
When i opened the .adp file created by the wizard, some of the components on the Forms were not working and giving the error messages like "The record source specified on this form or report does not exist".
I am new to this field and I would appreciate if anybody suggest me something related to these problems.
Thanks in advance.
VJ
A Good VBA 2000 Reference Book For Access 2000
Hi,
I have some experience with VB6 and VB.Net, as well as Access 2000.
I can query tables and retrieve, update records, etc. What I'm looking for is a good reference book where I can look up something and find the VBA code to do it.
I'm talking about compacting the database, transferring data, attaching tables to a back-end mdb from a front-end interface, and the such. I have found that I can make a macro to do the things I've listed here and then save the macro as a module to look at the VBA code, but I need a desk reference.
I bonus would be if it detailed Access built-in functions like saving a query to transfer text in a certain format (I had to get help here for that one).
I searched Amazon.com and read some feedback, but that's tough because you don't really know the author's abilities and they don't know what mine is.
So, now that I told you what my bacic ability is and what I'm looking for, I would sure appreciate your experiences in selecting the right book for me.
Thanks,
Tom
Sel Postion
Hi there there ay way to get the sel postion and change it to curent selposition + 3. I knwo there is 1 fuction.
VB Code:
variable=text1.selpos or cureentselText1.selstart= text1.currsel or selpos + 3
I know something ike that. i dont have vb now to work with as my pc is not working. i am posting from cyber cafe. so ican't check it.
I Still Don't Find &"VB 6 ActiveX Ctrl Interface Wizard&"
I use Visual Basic 6 Professional edition. I want to use the ActiveX Control Interface Wizard and I did steps according to the book. The book introduces to add "VB 6 ActiveX Ctrl Interface Wizard" in the Add-In Manager of the Menu Add-Ins, but I can't find any things except "DTC Framework Registrar" in the column of Available Add-Ins. Please tell me how can I do?
|
TRACKER
