Search results for query: *

Is it possible to create a compiled crystal 7 report from VB? (I am trying to have an e-mailable version of the report for distribution that maintains all formatting) And, if it is possible, what is the code to do so? I have been searching the help, developers help, and the FAQ from this site...

You could achieve this in a crosstab query. -Chopper

Is the AutoResize property of the form set to 'No'? -Chopper

I am using replication on a 2000 database through code (DAO). The replicas are partial replicas and the partial replica is based on an ID in a primary table. When a user logs in, they synchronize and receive just their data based on their ID. The problem occurs on one ID. When the replica...

I am synchronizing partial replicas using direct synchronization and can see all changes in the partials except additions. i.e. A user adds a record in their partial replica and synchronizes with the full replica. The addition can be seen in the full replica, but when another user synchronizes...

Whenever I have to put applications on user's machines and need to send out updates, I do the following: 1. Import your new objects into an blank database (your update database) 2. Put an AutoExec macro in that database that runs a code module. 3. In the code module, add code that exports the...

If you are doing this in a query, create a new field the field: LongestName: len([Surname]) Then, sort Descending on this field and the longest name will appear first. -Chopper

Alejandr, If someone has the database opened, then there will be a locking file (.ldb) of the same name present in the folder that houses your database. I.e. If your database is named database.mdb, then look for the file: database.ldb This tells you that someone has it open. If you are...

If you create an ID field in the Perm Table that is autonumber, as the first field in the table, your data will appear in the order you append it. The reason all the blank fields are showing up first is likely that you do not have a key or index for the table so all of the data is sorting on...

Wushutwist, I do not have any SQL Server software on my PC. I have been trying to test the connection via a .UDL I created on my desktop. I am doing this at another site, so I will have to wait to try anything out. I will investigate the firewall issue, however. Thank you for your reply...

I am trying to connect to a SQL Server Database on a remote server and I get an error on the connection string. The information I have is the IP Address, the username and password, and the initial catalogue. The error I get is: Specified SQL Server not found. (so, essentially, it cannot...

Suz, Yes, the user table can be linked, and I would encourage it. No, you do not have to re-release the application every time a user is added to the linked table. I am not sure how to tie the Access security to the Network login Security. However, the Network login security is really only...

Greetings, I am writing a patch to be sent out to remote users that will replace a code module with a new module that contains updated code. Their Excel Application is password protected, as is the VBProject. Since the VBProject is protected, I cannot replace it. I know the code to unprotect...

I don't see why not. Have you tried it?

Try using a nested iif: iif(comparison, valueIfTrue, iif(comparison, valueIfTrue, iif(comparison, valueIfTrue, iif(comparison, valueIfTrue, etc.)))) so, for your case it would be: iif([Status] = 20, "Ready", iif([Status] = 30, "Pending", iif([Status] = 40...

Paul, I have encountered something similar, and here is what worked for me: I used the On_Enter event to set the existing value to a form-level variable (so it can be used by the Before_Update event) which it looks like you are doing with QtyPrior. Also, instead of comparing the value to null...

Lightning,<br><br>A few suggestions worth giving a try.<br>1.&nbsp;&nbsp;Do not go to any control via code on the secondary form, but make the control you want the focus to be in the lowest item in the tab order.<br>2.&nbsp;&nbsp;If you do not trust #1, in the secondary form's on open event, set...

And you want help with...? <p>-Chopper<br><a href=mailto: > </a><br><a href= > </a><br>

Dennie,<br><br>Check this user's references.&nbsp;&nbsp;It may be that their reference to Visual Basic for Applications is missing. <p>-Chopper<br><a href=mailto: > </a><br><a href= > </a><br>

RoxanneP,<br><br>I see two problems that I think I can help with on your date problem.<br><br>First, when you are referencing the form, you must use the form name.&nbsp;&nbsp;The format is [Forms]![formName]![FieldOnForm]&nbsp;&nbsp;It looks to me like you are mising the form...