Search results

  1. P

    Run-time error '3035'

    Registry Edit Safety Tigger -- have you had any feedback as to whether editing the registry is somewhat safe? I have the same problem with the MaxCounts and I'm hesitant about messing with the registry. If I can simply change it, perform the action I want, then change it back then I would do...
  2. P

    AutoNumber Error -- MaxLocksPerFile ??

    I have scrolled through other posts that are somewhat similar to this problem, however, I am not exactly a programmer so when people talk about entering code I'm asking myself -- where? If I can do it in VB then I can handle it...but I know enough to get nervous when someone is telling me to...
  3. P

    AutoNumber Error -- MaxLocksPerFile ??

    I'm getting a unique error when I attempt to add an AutoNumber field to a table that I created. The table itself has ~110,000 records but it will not let me create an ID tag for the records so that I can create a primary key. The error reads "File sharing lock count exceeded. Increase...
  4. P

    Creating a SUM field

    Thats not really what I'm trying to do...that thread talks about putting SUM functions in reports. I figured it out though...because not every field that I was trying to add together had a value in it (Null) it was unable to add them together. I created an update query to say that if field was...
  5. P

    Creating a SUM field

    What I'm looking for here is something similar to what you can do in Excel by simply using the SUM function (selecting each cell to be summed). I want to be able to do the same thing with this SUM field in Access. I am trying to do a sum across fields for each record. The name of the SUM...
  6. P

    Creating a SUM field

    I feel like this is a stupid question but here goes: I just created a large database of which a few fields are going to represent "total" fields as they are the sum of a few other fields. I attempted to build an expression in the "update to" box in an update query but it does not seem to be...
  7. P

    Maximum # of Fields for a Table?

    Yea thats what I told my boss but he's insisting that this is what he wants. Thanks for the help.
  8. P

    Maximum # of Fields for a Table?

    I understand that the maximum file size for an Access db is 2GB but can you essentially have as many fields as you like as long as you do not exceed the 2GB threshold? I am doing some planning for creating a database with ~90 fields and want to know before I start it whether it will be able to...
  9. P

    Printing Form w/ Multiple Subforms

    I had a feeling that you were going to say that. Thanks.
  10. P

    Printing Form w/ Multiple Subforms

    I'm running into an error when I print a form that I created. The form itself has 6 subforms fed from the master form (2 field feed), of which 4 of the subforms use the same table. I am trying to print out each record and I end up with duplicates of certain fields (directly underneath one...
Back
Top Bottom