Search results

  1. spikepl

    Opening a report results in error

    what is 2501 error
  2. spikepl

    And Now For Something Completely Different - What Cartoons / Shows do we share?

    For people dealing with projects and software, apart from the the obligatory Dilbert stuff, I can highly recommend Geek & Poke http://geek-and-poke.com/ . Some of them are absolutely hilarious, some incomprehensible.
  3. spikepl

    MS Access macro that generates an Excel file from a template

    SO what is unclear in the posts you searched and found about how to get data from Access to Excel?
  4. spikepl

    Macro - After event create multiple records

    I need an example of data because I still suspect some things. 2-3 students, each with different requirements and accomplishments. Just enough to get the gist of how this thing is supposed to work but getting into all corners of this. Your desire of pre-making all those record for each student...
  5. spikepl

    Macro - After event create multiple records

    I need more than just a title. Give an example please. Again, the seemingly envisaged structure does not seem the proper one.
  6. spikepl

    Macro - After event create multiple records

    You might want to backup a bit and not getting lost in the finer Access details explain what this is about. Because I smell something very very fishy here. To assign qualifications/passes your envisaged way, if perceived correctly, is not the customary way of doing such things in Access...
  7. spikepl

    Output Form to HTML - change CELLSPACING

    No idea how to manipulate the template, whatever there might be of one. You could always reopen the produced HTML file afterwards as pure text, and line by line replace all CELLSPACING=0 with CELLSPACING=1
  8. spikepl

    You may be at the end of a recordset | Error 2105

    I have up/down , but should be the same as next/previous, play with it, call it from Current event handler: Public Sub SetMoveButtons(MyForm As Form) With MyForm If Not .NewRecord Then .RecordsetClone.MoveLast 'this to get proper record count...
  9. spikepl

    Displaying a PDF document link in a form

    Read the documentation for the FollowHyperlink method
  10. spikepl

    Beginner - General design

    I've personally witnessed over a period of 1½ years how stagiaires and their work were treated in a French high-tech company. Worse than the disposable Mexicans in one of the maquilladoras on the US border. I hope your company appreciates your efforts more.:D In any case, after all this BS -...
  11. spikepl

    Displaying a PDF document link in a form

    look up FollowHyperlink method
  12. spikepl

    loop of DELETE sql on one record - occasional error 3086

    So our magic eyesight can see all the code you're running and identifies line 42 as the likely culprit. If you want a better bet, you might consider providing something solid to look at.
  13. spikepl

    Cannot Open Attachments In Pdf Created From Access

    This is really a poor and ambiguous formulation. Say what you do and what happens in response to that, never use the totally informationless "I cannot", because that contains no useful information for you helpers. What office version do you have what pdf reader do you have what windows do you...
  14. spikepl

    Tables and Combo Boxes

    These operations you do in a form. No access to tables for users. You have cascading comboboxes (search) and the Not In LIst event for a combo, to insert new stuff. Look in the manual.
  15. spikepl

    case-sensitive

    "don't look the same " where exactly. Supply the context in which you wish to discern
  16. spikepl

    Ive Got the Many-to-Many Blues

    You have not supplied any specific information as to 1. which table is to be linked to which table 2. by which key or keys 3. by what type of relation Show the tables produced by this exercise: column names, and mark the PK & FK
  17. spikepl

    Calculate Column in Listbox based on User Date

    Calculating values in tables based on stuff outside of the tables makes no sense, since the values are no longer fixed. Do that in a query, base your listbox on that query. In a query you can calculate many things ... Try that. If that fails then show the SQL that "fails", and say in what way...
  18. spikepl

    Beginner - General design

    Maybe our reading of the situation is entirely wrong. But if you are "just" a stagiaire, then you could feign total ignorance of, and show total disregard for, such issues and just get cracking. I had a peek at your diagram: that's a lot of stuff. I'd recommend using the agile approach for...
  19. spikepl

    Escaping special characters when entering values in DataSheet view

    Try "" for each ". So """" in total. Meaning, in VBA. In typing in plain bound textbox "" should do.
  20. spikepl

    Question "SendObject Isn't Available Now" with v2013 MS applications

    This user is one here who has written the most about the newest Office offerings. You might try to PM him: http://www.access-programmers.co.uk/forums/member.php?u=31847
Top Bottom