Recent content by Stamey

You could use a File Splitter app like this: http://download.com.com/3000-2248-2728122.html?tag=lst-0-1 and burn the split pieces onto CD. Chris

Do you really need to validate the successful insert? You could just use VBA to check and see if the user ID and PW exist, and if so, open the form or do other, otherwise close the form, display error message, etc. You could validate that the insert happened successfully if you use a variable...

I personally have never heard of a way to do this. I know you can put an image in the background of your form(s). Perhaps you could put the image on a form and maximize it. Chris

Add the table to the "back end" database (the part with the data in it), and then, from the application database (the database with the queries and forms in it), choose File>GetExternalData>Link Tables from the menu and select the back end database. You will then be given a list of...

I agree with Bangsmic. I cannot see a reason to put image, or other binary data, into the database itself, except for if there is a security need. You should always link your database to the image files located in a given directory and have the application, Access or other, load the image file...

There's an undocumented switch called /decompile which may help. See this page for more info: http://www.trigeminal.com/usenet/usenet004.asp?1033 Chris

You may have a scoping problem. Make absolutely sure you aren't using the same variable name in one of your form modules. If you are, this would explain things. Chris

Not that I'm a genius in this area, but I will make a suggestion. Do the first insert and commit it. If this fails then bypass the second insert altogether. If commit successful, do this: Obtain the identifier from that newly inserted record (do this wherever is convenient). Within a...

There is also a KB article about the font size being smaller: http://support.crystaldecisions.com/library/kbase/articles/c2009324.asp When I first looked at the KB article they had a fix for it. I downloaded and installed the recommended fix but it made no difference. I guess Crystal realized...

Sure. The easiest way to to use the stored procedure, sp_DropUser. If you cannot do this, for various reasons I can think of, then you will have to set the Server option 'Allow modifications to be made directly to the system catalogs' to True, then you can delete from the sysusers table. Chris

Use VBA to change the links in the Access front end to reflect the relative path to the DB. I know this can be done with DAO but am not sure how it can be done with ADO. Let me know if you need code samples. I will try to dig some up. Chris

I spoke to Crystal Decisions this morning and this is what I found out. I asked the questions over and over, and even conferenced in someone else at Crystal to get these answers, still clear as mud. 1. Each organization gets 5 concurrent user licenses, whther it buys one or ten copies of Crystal...

I must strongly suggest that you don't hardcode anything in your app. You will pay for it later. Do you have configuration information for your application saved somewhere, INI file, Registry? You can put the other saved information about your DB connection there also. If the DB is something...

Either the previous way, listed in the last post, or save the following text as "MakeConnection.vbs" and then double-click it. When you have made your selections and click OK it will display an input box with your connection string in it. Dim oDataLinks, sRetVal On Error Resume Next...

As far as I know, unless you use a view to join the tables, you can only update one table in one statement. When you want an updatable view, there are specific rules you must follow to create that view. See BOL. Chris