VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,737 questions
What's the issue with it?
Issue to DLookup
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 43%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
Peter_1985
2,686
Reputation points
Hi,
How to resolve issue with DLookup to line below?
Public Function TblExists(ByVal strTableName As String) As Boolean
TblExists = False
If Not IsNull(DLookup("Name", "MSysObjects", "Name = " & Chr(34) & strTableName & Chr(34) & " AND Type = 1")) Then TblExists = True
End Function
VB
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
881 questions
{count} votes
-
Viorel 118K Reputation points2021-05-06T04:26:03.937+00:00 It seems that DLookup and MSysObjects are available in Access, but not in Excel.
-
Peter_1985 2,686 Reputation points
2021-05-06T04:48:43.407+00:00 Viorel,
How to re-write it? To make it fine within VBA.
Sign in to comment
4 answers
Sort by: Most helpful
-
-
Peter_1985 2,686 Reputation points
2021-05-06T03:39:47.303+00:00 I got issue below, to DLookup.
-
DBG 2,301 Reputation points2021-05-06T03:45:28.01+00:00 Which line gets highlighted?
Sign in to comment -
-
Peter_1985 2,686 Reputation points
2021-05-06T03:46:56.477+00:00 See it below
-
DBG 2,301 Reputation points
2021-05-06T03:56:15.523+00:00 That's not what I mean. When you debug the code, don't you get a yellow highlight?
Sign in to comment -
-
Peter_1985 2,686 Reputation points
2021-05-06T04:26:13.21+00:00 FYI
I want to validate if table "Week8-13" is existing within Access database. If that is not existing, then further copy details of T1 table into table "Week8-13".
-
DBG 2,301 Reputation points
2021-05-06T04:32:12.593+00:00 Ah, it looks like this is related to your other threads as well. I don't think just starting out new threads will help fix your problem if you don't follow up the help you're already receiving in your other threads.
Sign in to comment -