Search results for query: *

Hi Guys, I'm looking for a way to highlight an entire row when it is selected. This would be when the form is the 'Continuous Forms' state. Does anybody have a solution? Thanks, Clayton T. Paige claytonpaige@yahoo.ca Programmer Extraordinaire...

Hi, I'm trying to implement Access security and I'm not having very much luck. I have followed all the FAQs I could find on the subject and it still does not seem to work. When I open the MDB in the full version of Access 2000 I am prompted for a password, but when I open the MDB with Access...

Hi People, I wrote a Visual Basic program to change a users password for MS SQL 2000 Server. The server is currently using SQL security. The program changes the password fine, but it changed the password globally. I want the program to only change the password local to a specific...

Hi Everyone, I want to make a form in Access using bound controls that would have save and cancel buttons. It seems that soon as an entry is made it is inserted into the database. I want to be able to press cancel and remove this new record. Does anyone know how to do this Thanks...

Hi, I currently have a SQL 2000 Server that is setup as SQL Authentication. I have been reading about Mixed Mode authentication and wondering how exactly it worked. If the SQL 2000 Server is using SQL authentication , is it already using Mixed Mode? When using Mixed Mode does the server...

Hi, Is there some way I can write code that will execute everytime a table is read? Thanks, Clayton T. Paige claytonpaige@yahoo.ca Programmer Extraordinaire ======================================================== "Who is General Failure? and Why is he reading my disk drive?"

Hi, Is there anyway to have a SQL 7.0 password or login expire? thanks, Clayton T. Paige claytonpaige@yahoo.ca Programmer Extraordinaire ======================================================== "Who is General Failure? and Why is he reading my disk drive?"

Hi, I'm trying to solve a problem with a subreport. It seems that when the main report is run and there are no values on the main report the subreport is not dipsplayed. The start and end date are linked to the sub report. When I run the subreport independent of the main report it runs...

hey Does anybody know all the limits of the Access 2000 Database such as File Size limit, Table size Limit Etc. Do you know of a site that might contain these facts? Thanks Clayton T. Paige claytonpaige@yahoo.ca Programmer Extraordinaire...

hey Guys( and Gals), I have been trying to understand the PARTITION BY statement. I Think I have a slight understanding, but not totally. Can you please give me a description of what it does, How it works and a peice of sample code. Thanks! Clayton T. Paige claytonpaige@yahoo.ca Programmer...

Hey, I'm developing a VB Application that accesses Access 2000 through ADO. I have been trying to insert data into a few tables and it gived me the same error. Here is the entire function that returns the error. Public Function InsertAddress(iStreetNameID As Long, sStreetNumber As String...

Hello Everybody! I was running into a problem where an Access VBA program was crashing in the Access 2000 Runtime Environment. My solution was to comment out all the code and uncomment each line one by one. What I found was that certain functions were not supported including the following...

Hey Everyone! I have a problem with the Access 2000 Runtime Environment. I have developed a program in Access 2000 Professional and put it on a network drive. I then access the network drive with a computer that has only the Access 2000 runtime program. When I open the database it works...

Hey! I'm trying to write a template for Word and I was using the getAddress statment to popup up the Contact List dialog and allow users to pick who they want from the contact list. I Finished the template and eveything works fine, except the getAddress method only returns 255...

Hey Guys!! I have a problem. I want to find out what fields in different tables are foreign keys for a specific field. Thanks! :^) Clayton T. Paige claytonpaige@yahoo.ca Programmer Extraordinaire ======================================================== "Who is General Failure...

Hey, We have an application here that will read a directory tree and allow us to view reports that are present in the structure. This program was developed with VB and the CRviewer. The problem I am having is that when I run a report without parameters, the error "Invalid Parameter...

Hey! I have a query that needs to return all the records that have one field that is not null. If I run the query for records that are null it works fine, but not null just doesn't work. Nothing is returned. Here is my query: SELECT A.DATE, A.LEAVE, A.WORKCODE, A.COST...

I have constructed a UNION that I place in a VIEW. The UNION involves 13 tables. This seems to slow it down quite a bit. To make matters worse I'm running the UNION for a view. To speed it up I have removed all the JOINS from the selects and added a 'WITH READ ONLY' clause at the end...

Hey! I'm writing a plug-in for Adobe Illustrator and I need the use to the Layer List Suite. Well, this seems to be an undocumented feature. I only have the AILayerList.h file to look at. I was wondering if anyone out there has experience with this and could give me an example. Any kind...

Hey! Does anyone know of any sites or sources of sample code for the development of Adobe Illustrator Plugins? I'm really having trouble finding much of anything on the topic. The SDK seems to be the only source of info and it is quite limited. Any help would be great Thanks :^) Clayton...