Search results

Access Runtime is intended for distribution to those who don't have full MS Access installed. I have no experience of this personally, but others have certainly had a problem with Access Runtime 2013 when full Access 2007, 2013 or 2016 are present...

Dear NT100, Please forgive me for being bold, but I have noticed in your posts, you rarely close the thread with clear feedback as to whether the suggested code worked or not. 9 out of your 13 posts are left with someone offering a solution, but we don't know if it worked or not. And in one of...

Not a good road to go down. Then you'll need Ltd. (with the dot), Inc, Incorporated, Inc., Partners, Ptnrs - the list could be endless.

Colin beat me to it - I was about to suggest a combo box. You could allow the user to enter a new Account Name by setting the "limit to list" option to No. I don't think the solution as it stands will work anyway with the example you give - i.e. "*Keyboard Ltd*" will not produce a Like match to...

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