Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. Chopper

    Create CR7 Compiled Report From VB

    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...
  2. Chopper

    Should this be done as a subquery or how else should i do this?

    You could achieve this in a crosstab query. -Chopper
  3. Chopper

    Background Image

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

    Replication Anomally

    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...
  5. Chopper

    Synchronization through Code

    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...
  6. Chopper

    Client/server application management

    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...
  7. Chopper

    Find longest string in text field (e.g. surname)

    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
  8. Chopper

    who is connected to my db

    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...
  9. Chopper

    Moving data from one table to another.

    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...
  10. Chopper

    Connecting to SQL Server Database

    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...
  11. Chopper

    Connecting to SQL Server Database

    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...
  12. Chopper

    Access Security and Network logins

    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...
  13. Chopper

    Unlocking Protected VBProject to Replace Module via Code

    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...
  14. Chopper

    SQL in RecordSource

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

    Converting data stored numerically to Words in a report

    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...
  16. Chopper

    How to reference a data field on a record in form view (datasheet) ?

    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...
  17. Chopper

    Control Not Keeping Focus

    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...
  18. Chopper

    Print a report using data from a subform

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

    why do I get the error : #name?

    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>
  20. Chopper

    Using Form for Query, then Query Results for SendObject For...Next

    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...

Part and Inventory Search

Back
Top