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 Chriss Miller 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: *

  • Users: japyy
  • Order by date
  1. japyy

    Using 2 versions of Access

    Yes: it's a real mess, and no: I don't know how to get around it neatly. One warning, though: using VBA-code will mess things up even more...
  2. japyy

    DLookUp Command

    "broker = broker" means: broker(in tblBrokers) equals broker (in the same record, in the same table). What you want to is: "broker = 'Jimmy'" or "broker = 12345" (using numbers as a primary key is strongly advised). Of course, 'Jimmy' or 12345 are variable, you...
  3. japyy

    DLookUp Command

    The Where-clause "[Broker]=[Broker]" isn't very specific: it's like saying "get anyone whose age equals his own age". You would need a stament like: "get anyone whose age equals " & TheAgeINeed, in your case something like "[Broker] = " & me.Broker
  4. japyy

    Save record with default values?..Please

    Consider it a sacrifice to the gods of Access you mentioned. Still seems to be a rather compicated way to solve something relatively simple but: if it works don't fix it...
  5. japyy

    Save record with default values?..Please

    Strange, maybe you're using Access 2000? I thought that didn't use DAO, but might be mistaken (and to lazy to check...) I tried Bob's code, and it runs fine in A97. Even simpified the idea to: Private Sub cmdSave_Click() DoCmd.RunSQL "INSERT INTO tblMyRecords ( recordid, recorddate )...
  6. japyy

    Determining which form has called it.

    You can use the 'openargs' to pass information to the form you'opening.
  7. japyy

    Combo boxes synchronized but how to show the value without clicking

    I 'm not sure if I get what you mean, but let's try anyway. You want your combo to show something related to the first record in your form. When a form opens, it opens on the first record. So, if you set the default value of your cbo to the related field in your form it might already do the...
  8. japyy

    NEED HELP WITH A MACRO OPENING MY SWITCHBOARD!!

    I think you still need a real macro called autoexe. You don't have to rebuild the old one though, just make the macro start your code.
  9. japyy

    Save record with default values?..Please

    Bob's coding seems to be OK, but it doesn't requery the form itself. Check if the record is saved in the table!
  10. japyy

    keyfield is number +1?

    BEWARE! If you calculate a field there is always the risk of getting the same result twice, wich would mess things up rather badly if it's a primary key. Imagine what would happen in a multi-user setting. If you realy must calculate do it when saving the record. Private Sub...
  11. japyy

    Macro within Code.. Waiting until Complete

    Did you consider converting the macro to VBA?
  12. japyy

    Need idea's for Conference Registration

    Probably there's lot of people out there to help you, (I will if my boss or kid don't interfere) but more info is needed: * is there an invitation-list, so do you know in advance who is coming? * what are 'groups'? Companys you invited, or guests who happen to bring there inlaws without telling...
  13. japyy

    textbox <> listbox in report

    There is function that looks up a value in a table: DLookUp(WhatField;InWhatTableOrQuery;WhatConditions). So you could set the source of your textbox to: =DLookUp("initials";"personel";"id_personel=tasks") However, easier and faster is to make query joining the...
  14. japyy

    Managing Database Size

    If it's a db you used to devellop in, and you made a lot of changes on the way, it might help to make a new (empty) database and import all objects from your old one.
  15. japyy

    Proper syntax for LOAD and UNLOAD

    I'd love to see that too. The syntax you use is obivously wrong, as "msgForm" is a string, and you need an object. Apart from that, I use load and hide in VB without any trouble, but never in VBA: I never succeeded in refering to an unopened form. The object-model is a bit confusing...
  16. japyy

    Creating a switchboard

    You can set this in the menu: Extra => StartUp (or something like that, my access-version is in (double)dutch.) You can also set other start-up opions, the most important being: hide database-window.
  17. japyy

    Can a report have both horizontal and vertical groupings?

    As far as I know, this is almost impossible. Your kids-table or -query needs a field indicating 'WhatKindOfKid', and the number of possible 'KindOfKids' needs to be limited. In that case you can make a crosstab-query, with 'KindOfKid' as columnheader, and use it as source for a report. If there...
  18. japyy

    Print Current Form as Report ONLY

    I guess the data-source of your report is the same table? You have to apply a filter, to select the record that matches the current record on your form. To do that, you need an unique field in your table (usually called ID) or an unique combination of fields. If the print-button on your forms...
  19. japyy

    Print Current Form as Report ONLY

    Sorry, should be "field = " & field but you guessed as much already I guess...
  20. japyy

    Print Current Form as Report ONLY

    I'm not sure what you mean by 'print as report'. If you mean that you made a report using the same query as the form, and you want the report to show just the current record of your form, then use this in the on_click event of your button: docmd.OpenReport "",,,"field -" &...

Part and Inventory Search

Back
Top