Search results

  1. Orthodox Dave

    What's your best/worst joke?

    This is for the oldies: A couple of gentlemen of a certain age are sitting in the garden together at one of their houses, while their wives are in the kitchen preparing lunch. The host says to the visitor, "You know, my wife and I had a marvellous meal in a new restaurant just opened in town...
  2. Orthodox Dave

    Email attachments from subtable / recordset

    A few considerations that I had to think about in my database: 1. If a file is missing in the folder, will you just go ahead and only add the files that are there, or do you want the code to tell you which file is missing and ask you to save the file before carrying on? 2. Are any of the files...
  3. Orthodox Dave

    Add records to table, run make table query, remove records from table

    Hi, I agree with Minty that there must be a simpler way than continually re-creating a new table. But for the sake of speed I can answer the question about the checkbox column. The results of a checkbox field are always stored in a table as a 0 (false) or -1 (true). That can't be changed...
  4. Orthodox Dave

    pass record_id to row source of combobox

    I would make it a GotFocus event rather than a Click event. The Click event will fire when you first click the Combo, and will fire again when you select the list item, whereas the GotFocus only fires on the first click.
  5. Orthodox Dave

    VBA Error: 'Compile Error: Block If Without End If'

    When I write a long sub with lots of interweaved If statements, I find it helpful to annotate the End If's with a comment showing which "If" they belong to. This also forces you to think the logic through. In your code for example:- Private Sub Processbutton_Click() If Me.RiskGrand = 0 Then...
  6. Orthodox Dave

    Display selected item in list box

    Hi Grenee, I suspect you put your post in the "Modules & VBA" section by mistake, because it is next to the "Macros" section in the Forum Home Page list. Most VBA types (me included) try to avoid macros, but in that other section you might find more Macro specialists.
  7. Orthodox Dave

    Search and Replace before DoCmd.TransferSpreadsheet via VBA

    In the command: DoCmd.TransferSpreadsheet( ** TransferType, ** SpreadsheetType, ** TableName, ** FileName, ** HasFieldNames, ** Range, ** UseOA** ) the HasFieldNames element is set to True if you want the first row to be used as field names. If you make this False (or leave blank as False is...
  8. Orthodox Dave

    Single apostrophe in search textbox

    OK JoseO, There are various ways you could achieve what you want, but this is what I would do. 1. Allow the form to load all the songs as usual (i.e. no SQL WHERE clause). 2. The user then enters part of the [SongChords] into the search filter box. 3. In the AfterUpdate event of the Search...
  9. Orthodox Dave

    Single apostrophe in search textbox

    The link from ridders gives a simpler solution than Chr(34) - the use of double quotes twice instead of double and single quotes. In that link, Allen Browne says:
  10. Orthodox Dave

    The code in this project must be updated for use on 64-bit system

    Colin, that is really helpful - thanks a lot. As a semi-retired old boy, I am developing a database from home that I don't even know will sell, but if it does, 64-bit could cause a problem. Just to clarify, are you saying that your code will run in both 32 and 64 environments? e.g. can you use...
  11. Orthodox Dave

    Pulling in data from Excel

    If it works for you, you can use the Excel files as Link Tables, by selecting External Data tab, new data source - file - Excel (might be different in your version). Remember to select the radio button "Link to the database by creating a linked table". The advantage is your database data is...
  12. Orthodox Dave

    The code in this project must be updated for use on 64-bit system

    I wonder how many developers are aware of this problem. Anyone exporting databases to other companies could have compatibility problems. One of Microsoft's suggestions is: It would have been better if Microsoft had provided a conversion tool themselves. They are usually pretty good at providing...
  13. Orthodox Dave

    access coopy paste only text into textbox

    Hi Megatronixs, I've done this successfully in my database using rich text in the Outlook email. Firstly, I have a table for Mail Text with fields in Long Text with RTF formatting. These can be populated just like a Word document (new line, bold, italic etc). When this field is copied to a...
  14. Orthodox Dave

    The code in this project must be updated for use on 64-bit system

    Hi Masoud, Looking over nhorton79's link, this seems a pretty long and complex article. A bit of a bombshell actually - complete news to me. It would seem your laptop has 32-bit Access installed and the other computer has 64-bit Access. If it is possible, I suggest uninstalling 64-bit Access...
  15. Orthodox Dave

    Document scanning

    This section of the site is reserved for questions about Modules and VBA in Access. If your questions are not about Modules or VBA, please look elsewhere.
  16. Orthodox Dave

    Print works for .accdb but not for .accde

    OK Aman, let's take a step back. You started out with code that worked perfectly in an .accdb database but your question was why did it stop working when you converted to .accde? The only things an .accde database won't do is open forms, reports and modules in design view, or allow the user...
  17. Orthodox Dave

    Print works for .accdb but not for .accde

    OK Aman, I think "strRecordSource = Reports(RName).RecordSource" causes an error if the recordsource is null. Try instead: If Not IsNull(Reports(RName).RecordSource) then strRecordSource = Reports(RName).RecordSource End If Then if the record source is empty, strRecordSource will = ""
  18. Orthodox Dave

    Is Mr Trump crazy?

    Thanks Doc Man - nothing against Barnum - just wanted to clarify (to us non-Americans) that stupidity is not confined to Americans. It's always tempting to denigrate a group of "others" to make oneself feel better. Yes - I have a friend in Greece who, with his family, was nearly caught in a...
  19. Orthodox Dave

    Is Mr Trump crazy?

    An honest appraisal, Vassago. We are an island people, so have always looked beyond our borders. The US has given great leadership in many respects. They rescued us at great cost in the two world wars. But having such enormous power, the US president should realise his decisions affect the whole...
  20. Orthodox Dave

    Is Mr Trump crazy?

    You can't generalise like that. Americans are just human beings. One of the problems is the lack of world news reaching many Americans, so no wonder many have a narrow view. This can be dangerous - look at North Korea. It's not the intelligence that's lacking - just the information.
Back
Top Bottom