Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by genomon
-
SQL Server to control MS Access?
Have come up empty in searches so far. Does anyone know if there is a way to instantiate and control an MS ACCDB from SQL Server (2016 in this case)? I was thinking maybe APIs, command shell, etc.? This is not my area of expertise. The request is to automate some end-user ACCDBs that have...- genomon
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Programming
-
ComboBox in VB from Access DB
As far as I know you cannot show "a table", but you can show its fields in a CBO. Beir bua agus beannacht!- genomon
- Post #2
- Forum: Visual Basic (Classic)
-
Application-defined or object-defined error
Have you tried setting oProgress = Nothing between instantiations? Beir bua agus beannacht!- genomon
- Post #2
- Forum: Microsoft: Access Other topics
-
Opening access 2003 .mdb file
Or there could be an .ldb associated that needs deletion. Beir bua agus beannacht!- genomon
- Post #5
- Forum: Microsoft: Access Other topics
-
cannot connect to sql view
Agree. Use underscore, or alias the column name in the view to something that follows syntax rules. Beir bua agus beannacht!- genomon
- Post #3
- Forum: Microsoft: Access Forms
-
One Subreport and Many Subreports in One Report
Try grouping the report by manager, and linking the subreport to the (group header) manager in the detail section. Beir bua agus beannacht!- genomon
- Post #2
- Forum: Microsoft: Access Reports
-
Enumerate Grouped Records in a Query
Post the SQL behind the query - specifically the ORDER BY clause... Beir bua agus beannacht!- genomon
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
Paid travel
We pay a per-mile traveled standard rate. Beir bua agus beannacht!- genomon
- Post #2
- Forum: Tech Industry Trends
-
Take photo from Access form
Might be some help here? https://social.msdn.microsoft.com/Forums/en-US/9c110f5e-ce8c-40cc-9baa-436956e26e45/capturing-photos-in-ms-access-using-vbvba?forum=isvvba Beir bua agus beannacht!- genomon
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
customising icons
Is this what you are after? C:\Program Files\Microsoft Office\Office12\FORMS\1033 then look for .ico file extensions. Beir bua agus beannacht!- genomon
- Post #2
- Forum: Microsoft: Windows
-
Application server can't be accessed any more
Have you tried this? http://www.mydigitallife.info/how-to-flush-and-reset-dns-cache/ Beir bua agus beannacht!- genomon
- Post #2
- Forum: Enterprise Management
-
Query Help
Does Master ID1 mean the same thing as Master ID2? Beir bua agus beannacht!- genomon
- Post #2
- Forum: Microsoft: Access Queries and JET SQL
-
64-bit\Updated VB6 Project
Interesting. Thanks for sharing! Beir bua agus beannacht!- genomon
- Post #2
- Forum: Visual Basic (Classic)
-
Append query doesn't work but no errors are generated
I don't see where the parameters are declared. Any help here? https://msdn.microsoft.com/en-us/library/office/ff193967.aspx Beir bua agus beannacht!- genomon
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Pivot Table Seems to get corrupted when updating the pagefields with VBA
Could it be a refresh issue? There are settings and VBA to look at here: http://www.ozgrid.com/VBA/pivot-table-refresh.htm Beir bua agus beannacht!- genomon
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
