Search results

  1. A

    Bringing Over a Table with an Autonumber

    I believe you still can use an autonumber, and import your data into that table. The autonumber field will accept your ProjectIds whatever they are (assuming there are integers and without duplicate). It will then continue numbering from the highest Project ID
  2. A

    Dynamic Subform Creation

    Indeed you do not want to create a new form, just to switch between already existing one. I would put a 'default' subform (eventually invisible untill the user selects one), then just switch its ObjectSource depending on the user's choice You would then only need something like Private Sub...
  3. A

    kill two bird with one stone

    I am not sure I should help a birds killer, but well... You probably have some VB logic in the OnCurrent event of your form (or somewhere else) to fill your textboxes. You have to skip it if the current record is new: me.NewRecord = true then
  4. A

    Another problem with totals

    With a minimum of 2 posts per day, I am afraid I am on a very bad slope... looking down I can see I am heading towards Stout chum, Weighty mate, Plump buddy, Heavyweight, Serious Heavyweight, Rich, Overweighed pal. :p Which makes me think I'm still in time to tighten my belt:D
  5. A

    Products sold

    Your structure should be like: TblCustomers -CustomerID (Autonumber ,Primary Key) -FirstName -LastName Other fields... TblProducts -ProductsID (Autonumber, Primary Key) -Description -Category Other fields... TblProductsPerCustomer -CustomerID (Long Integer, Foreign Key) -ProductsID (Long...
  6. A

    First Letter Cap after control update

    strconv(strYourStringHere, vbProperCase)
  7. A

    Another problem with totals

    I've been wondering for a long time, Rich. Did you learn them all by heart?:p Can we input a question, twist an ear an get a number? :D
  8. A

    Have a checkmark next to a custom menuitem

    I like unsuspected questions... when they come with their answer:D
  9. A

    strange ADO error

    I maybe wrong but at the moment I do suspect your error handling to be in cause. I put up a simple trial DB, populating records on the many side of a relationship from records belonging to another table of the same DB. Of course, these are not the same conditions as yours, but I introduced...
  10. A

    strange ADO error

    Could you show how you handle the error?
  11. A

    Form linked to another form

    You should use subforms instead, and set the parent/child field to your ID.
  12. A

    Make form size maximized without using the Maximize method

    I believe the following is what you're looking after. It uses API to get a handle to the Access window, then does some calculations... Credits are dued to Terry Kreft Maximize Restored forms - Get rid from the close button on maximized forms
  13. A

    strange ADO error

    If relational integrity was enforced in your DBcheck , you should have no unmatched records one the many side of a relationship, so I do not really understand how you come to get this error.? The only thing that comes to my mind is that you should always begin to populate top-hierarchy (the one...
  14. A

    custom number format

    I believe it is a huge overkill since Pat's formula (for an auto incremented number that does not need to be unique at the opposite from an autonumber) would work, AND a no no no since it breaks the logics of related data in a DB (you would find very hard to query on related records from...
  15. A

    problem with form implementation

    It is a short term emergency programme that is hoped to help alleviating the very serious humanitarian situation in desmobilized soldiers camps (food shortage, diseases...) and support the peace process and re-installation of internal refugees (demining, food aid primary health care, etc). 30...
  16. A

    Null value in combo box - 'Cannot assign a null value to a variable'

    Test for the value entered from the Before update event of your control. If it is null/zero-length string, then you would cancel the entry. Then you would have to decide if you want to display a message explaining that the value should be entered; or do nothing more (my choice since a user that...
  17. A

    problem with form implementation

    I am going to see if I can helo, for the sake of your health ;) (I wouldn't like you to fail in your attempt to quit smoking) But I need to understand better: what do you mean by and why do you want to save to a different table? Try to give a concrete example of what your are trying to do...
  18. A

    Correcting Entered Value and Storing It in Same Table

    To begin with, not a vital point but an observation: On principle it would be better to go for pre-processing (VB procedure using IF..) then eventually execute a query. This is because when you introduce functions into queries (with a few exceptions Like Sum), you prevent Acces from properly...
  19. A

    custom number format

    Before going for an autonumber (as per my suggestion) instead of Pat's incrementing number formula, did you take into account the point Pat just made that if your orginal (old) dataset may contains serials with an identical right part for two different years (ie 01-00006 and 02-00006) then using...
  20. A

    custom number format

    Very right, Pat. I had overlooked that!
Back
Top Bottom