Recent content by Pat Hartman

  1. P

    VBA command to create new records in tables and copy value of one field

    I made a lot of changes but lots more are needed. Tables: 1. I made JobID required and removed the 0 default 2. Removed the lookup from Job. There are lots of issues with table level lookups. They are a crutch. It is best to just not use them. Forms: 1. I renamed the controls on the...
  2. P

    Solved Hi, Can anyone guide me how to make an accounting database?

    @Khurramshaikh47 As long as "small" is understood to be single entry and limited features, you can create something that can replace your paper system. But, before you start building forms and reports, you need a rational schema so if you want help, start by posting the schema you have so far.
  3. P

    Any idea why this error handling is being applied to all error codes?

    It's an easy mistake to make. People do it all the time.
  4. P

    Command Button Fails

    You're welcome.
  5. P

    VBA command to create new records in tables and copy value of one field

    I take it you are not using a subform but you are opening a dependent form. Both forms must be open. You cannot reference a form unless it is open. If you have forms with related data that are opened by themselves, there is no option except to use a combo to select the job to make the...
  6. P

    Command Button Fails

    @Privateer I'm going to take a stab at why that code is only working in development. The .ActiveCodePane part may only be valid when the VBA window is open which it wouldn't be under normal circumstances. So the error 91 is saying that the Object Variable isn't available. Try this - put the...
  7. P

    How to give the parameter value Yes or No?

    Also, Don't be sloppy with your control names. ALWAYS give a control a rational, meaningful name. NEVER just accept the default like Combo29. No one who looks at that will have any idea what it is all about and neither will you next month.
  8. P

    Sub records?

    Don't be sloppy about your naming convention. 1. ALWAYS give controls proper names when you build them. That way you don't end up with controls named Command48 and events named Command48_Click. Changing the name now will orphan the code. Do it anyway and rename the orphaned procedures 2. I...
  9. P

    Integrate Word mail merge in MS Access

    Mail merge won't handle things like invoices where you have header/detail data. That's why I don't use it.
  10. P

    Lookup

    You should probably keep the time as hundredths of a second in an integer and scale it yourself. Then you can divide by 60 to get seconds and the remainder will be hundredths. But that is neither here nor there. Normalize the table so the lookup will be simplified.
  11. P

    Solved Hi, Can anyone guide me how to make an accounting database?

    And they never got fired for recommending IBM either even when IBM PC's were going for three times the price of Gateway's. I was cycling through the desktop group as this fight was going on. The price was worse for accessories. A card with two printer ports was going for $250 from IBM but $25...
  12. P

    Integrate Word mail merge in MS Access

    I don't use mail merge. I automate word to populate the documents. I've attached a very simple sample so you can see how it is done. The sample uses hard-coded fields so it isn't very practical. I have applications that use tables to manage the documents and data fields that manage thousands...
  13. P

    Buffalo Shooter

    It also appears that the perpetrator had a history of this type of threat and he was not in the "system" due to some silly law. Similar to the Parkland shooter. Perhaps we should take these threats seriously when they are made. Only deranged people want to kill strangers. Obviously we can't...
  14. P

    Solved Hi, Can anyone guide me how to make an accounting database?

    I think SAP stands for sucky application program. It tried to do everything but ended up doing nothing well. I can't complain. I made a lot of money building surrounding applications in both COBOL and with Access.
  15. P

    Lookup

    This is what the query will look like if you normalize the scoring table: Select Top 1 t1.BibNo, t1.AthleteName, t1.Event, t1.Timing, t2.ScoringPoint From tblResults as t1 Left Join tblScoring as t2 On t1.Event = t2.Event Where t1.Timing <= t2.Timing;
Top Bottom