Search results

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...

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...

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...

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.

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...

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.

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...

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...

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:

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...

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...

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...

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...

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...

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.

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...

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 = ""

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...

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...

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.