Search results

I have been developing Access databases for xx years but i have never created a web database. In Access 2010 one of the templates is to create a web database. In Access 2016 i can't find it. A few questions: If it is possible, how does it work? Is sharepoint always involved? Do's and don'ts...

Difference is that the "as" keyword is lined up and the variable names are sorted to their length. I believe it looks nice. But that's personal. It has no functional value. Thanks for your input!

Yes, i am.

This is probably asking to much but here goes nothing: I am looking for a way to select a piece of code in the IDE (VBA window) and then run my own function on it to modify the code in the selection. example: 'From: Dim intLongest As Integer Dim vItem As Variant Dim intItem As...

This means that i have to repost my message also to the same post. :-( Thanks ridders for bringing this to my attention. <edit>I don't feel like retyping my answer to this thread so this one is lost</edit>

Please compile your code before posting. To compile: Open VBA window (alt-f11), menu: Debug, Compile Database3 You use: End Sub instead of Exit Sub, Case1 instead of Case 1 You need to add a reference to ADO or DAO ... HTH:D

I created this some time ago. A module with a few functions and procedures to search, sort and beautify code. https://access-programmers.co.uk/forums/showthread.php?t=210180 HTH:D

My tables look like this: One table for the object, which has 4 fields One table with all possible properties. One table with a link to the object, a link to the property and a field for the value. That's all. It can accomodate any kind of object with 1 or 400 properties. Perhaps i need to try...

@Ranman256: The report shows one record. A single record can have up to 400 fields. It contains all specs of an Engine, its dimensions, settings and current values as i have shown in the attached picture. I know it is not your regular report. @ridders, thanks for the link to rogers acces...

Hi, I need a grid control for a report because the alternative would be to add over 400 textboxes and labels to the report. In the past i have worked with ComponentOne Flexgrid, which worked very well but it is quite expensive. An embedded Excel object would be a fine candidate but you need...

This is part of a piece of code i sometimes use. It is faster than TransferSpreadsheet and it gets the job done nicely. Public Sub ExportToExcel(rst As Recordset) Dim appXL As Excel.Application Dim wb As Workbook Dim ws As Worksheet Set appXL =...

It is a nice piece of code. I played with it but after a combination of ?SetAccessWindow(SW_SHOWMINIMIZED) followed by ?SetAccessWindow(SW_HIDE) followed by ?SetAccessWindow(SW_SHOWMAXIMIZED) or any other command to show the Access window the result is an empty window. All...

Hi Ranman256, Thanks for your input. I have customers all over the world using all kinds of environments. Your suggestion is to visit each customer and copy the database?

Or perhaps it is already there just haven't found it yet.

I can only tell you what i would do differently. From a quick glance: I would use hungarian variable notation, which means: give your variables a type prefix like strTablename. If you need to use GOTO. I would have programmed it differently. GOTO's only use is for error handling. Like MarkK...

No worries.

Hi CJ_London, Rx_ When i say crashes i mean that you get thrown out of access with no message at all. And removing the dll calls solved my problems. That was a few years back. Yes i used compiler constants to determine the Windows environment 32/64. When i switch from form design mode to the...

Hi The_Doc_Man, I am aware that API calls are used even when i don't specify them explicitly. Perhaps handles or addresses were dimensioned wrong. I have to look into that. Thanks for your input.