Syntax Error 3131 - dbs.CreateQuery Def ?

priscilla.jenkins

Alright, I'm really new to SQL and VBA and all this, so I might be
completely off course...but just tell me. I know C and Assembly, but
that doesn't help me much here.

I'm trying to create a module that creates 5 queries (that a report is
based on) based on a table that the user defines. My tables are named
by date (not my choice), for example:
-ArchivedActions 05-20-05 Everything involving that seems fine.

I'm getting a syntax error at the line marked with a asterik, and I
feel like I've tried everything. Anything obvious that any of you can
spot?

P.S. No one in my office knows a thing about Access.
THANKS!

Option Compare Database

Sub UpdateMatrixQue ries()

Dim Tbl As String

Dim strQueryName As String
Dim qryDef As QueryDef
Dim strSQL As String

Dim dbs As Database

Set dbs = CurrentDb()

cmdRequestDate_ Click

Tbl = "-ArchivedActions " & txtDate

strQueryName = "Matrix - MLBUSA Related Other"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Related*') And " _
& "((" & Tbl & ".[ActionType])='Other')) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA related*') And " _
& "((" & Tbl & ".[ActionType])='Other'));"

* Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Specific Other"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') And " _
& "((" & Tbl & ".[ActionType])='Other')) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA specific*') And " _
& "((" & Tbl & ".[ActionType])='Other'));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Related Significant"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Related*') And " _
& "((" & Tbl & ".[ActionType])='Significant' )) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA related*') And " _
& "((" & Tbl & ".[ActionType])='Significant' ));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Specific Significant"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') And " _
& "((" & Tbl & ".[ActionType])='Significant' )) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA specific*') And " _
& "((" & Tbl & ".[ActionType])='Significant' ));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "MLBUSA Specific Significant Issue & Plan"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[AuditName], " &
Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date], SnapActions.Fin ding, " _
& "SnapActions.Re commendation_1, SnapActions.Man ager, " _
& "SnapActions.Ma nagerResponsibl e, SnapActions.Ind RespDept, " _
& "SnapActions.St atusComments FROM " & Tbl & " " _
& "LEFT JOIN SnapActions ON " & Tbl & ".ActionID = SnapActions.Act ionID
" _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') " _
& "AND ((" & Tbl & ".[ActionType])='Significant' ) " _
& "AND ((" & Tbl & ".[Status])='Open')) OR (((" & Tbl & ".[Category]) "
_
& "Like '*BUSA specific*') AND ((" & Tbl &
".[ActionType])='Significant' ) " _
& "AND ((" & Tbl & ".Status)='open '));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

Set dbs = Nothing
End Sub

Private Sub cmdRequestDate_ Click()
Dim dteDate As String
dteDate = InputBox("Pleas e enter the date listed at the end" _
& " of the filename of the table you wish to use. Please" _
& " use the format MM-DD-YY and click OK.")
txtDate = dteDate
End Sub

Nov 13 '05 #1

Subscribe Reply

4798

David Lloyd

Priscilla:

It appears that Access is objecting to the hyphen (-) in the following line:

Tbl = "-ArchivedActions " & txtDate

I removed the hyphen and was able to create the querydef.

One other note, if you want to name your querydef with the value in the
variable strQueryName, you should remove the quotes:

Set qryDef = dbs.CreateQuery Def(strQueryNam e, strSQL)

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.
"priscilla.jenk ins" <pr************ ***@gmail.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .
Alright, I'm really new to SQL and VBA and all this, so I might be
completely off course...but just tell me. I know C and Assembly, but
that doesn't help me much here.

I'm trying to create a module that creates 5 queries (that a report is
based on) based on a table that the user defines. My tables are named
by date (not my choice), for example:
-ArchivedActions 05-20-05 Everything involving that seems fine.

I'm getting a syntax error at the line marked with a asterik, and I
feel like I've tried everything. Anything obvious that any of you can
spot?

P.S. No one in my office knows a thing about Access.
THANKS!

Option Compare Database

Sub UpdateMatrixQue ries()

Dim Tbl As String

Dim strQueryName As String
Dim qryDef As QueryDef
Dim strSQL As String

Dim dbs As Database

Set dbs = CurrentDb()

cmdRequestDate_ Click

Tbl = "-ArchivedActions " & txtDate

strQueryName = "Matrix - MLBUSA Related Other"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Related*') And " _
& "((" & Tbl & ".[ActionType])='Other')) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA related*') And " _
& "((" & Tbl & ".[ActionType])='Other'));"

* Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Specific Other"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') And " _
& "((" & Tbl & ".[ActionType])='Other')) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA specific*') And " _
& "((" & Tbl & ".[ActionType])='Other'));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Related Significant"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Related*') And " _
& "((" & Tbl & ".[ActionType])='Significant' )) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA related*') And " _
& "((" & Tbl & ".[ActionType])='Significant' ));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Specific Significant"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') And " _
& "((" & Tbl & ".[ActionType])='Significant' )) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA specific*') And " _
& "((" & Tbl & ".[ActionType])='Significant' ));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "MLBUSA Specific Significant Issue & Plan"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[AuditName], " &
Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date], SnapActions.Fin ding, " _
& "SnapActions.Re commendation_1, SnapActions.Man ager, " _
& "SnapActions.Ma nagerResponsibl e, SnapActions.Ind RespDept, " _
& "SnapActions.St atusComments FROM " & Tbl & " " _
& "LEFT JOIN SnapActions ON " & Tbl & ".ActionID = SnapActions.Act ionID
" _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') " _
& "AND ((" & Tbl & ".[ActionType])='Significant' ) " _
& "AND ((" & Tbl & ".[Status])='Open')) OR (((" & Tbl & ".[Category]) "
_
& "Like '*BUSA specific*') AND ((" & Tbl &
".[ActionType])='Significant' ) " _
& "AND ((" & Tbl & ".Status)='open '));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

Set dbs = Nothing
End Sub

Private Sub cmdRequestDate_ Click()
Dim dteDate As String
dteDate = InputBox("Pleas e enter the date listed at the end" _
& " of the filename of the table you wish to use. Please" _
& " use the format MM-DD-YY and click OK.")
txtDate = dteDate
End Sub

Nov 13 '05 #2

MacDermott

You might want to try this syntax:
Tbl = "[-ArchivedActions " & txtDate & "]"

"David Lloyd" <Da***@NoSpamPl ease.com> wrote in message
news:lY******** *************@b ignews6.bellsou th.net...

Priscilla:

It appears that Access is objecting to the hyphen (-) in the following line:
Tbl = "-ArchivedActions " & txtDate

I removed the hyphen and was able to create the querydef.

One other note, if you want to name your querydef with the value in the
variable strQueryName, you should remove the quotes:

Set qryDef = dbs.CreateQuery Def(strQueryNam e, strSQL)

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.

"priscilla.jenk ins" <pr************ ***@gmail.com> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .
Alright, I'm really new to SQL and VBA and all this, so I might be
completely off course...but just tell me. I know C and Assembly, but
that doesn't help me much here.

I'm trying to create a module that creates 5 queries (that a report is
based on) based on a table that the user defines. My tables are named
by date (not my choice), for example:
-ArchivedActions 05-20-05 Everything involving that seems fine.

I'm getting a syntax error at the line marked with a asterik, and I
feel like I've tried everything. Anything obvious that any of you can
spot?

P.S. No one in my office knows a thing about Access.
THANKS!

Option Compare Database

Sub UpdateMatrixQue ries()

Dim Tbl As String

Dim strQueryName As String
Dim qryDef As QueryDef
Dim strSQL As String

Dim dbs As Database

Set dbs = CurrentDb()

cmdRequestDate_ Click

Tbl = "-ArchivedActions " & txtDate

strQueryName = "Matrix - MLBUSA Related Other"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Related*') And " _
& "((" & Tbl & ".[ActionType])='Other')) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA related*') And " _
& "((" & Tbl & ".[ActionType])='Other'));"

* Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Specific Other"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') And " _
& "((" & Tbl & ".[ActionType])='Other')) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA specific*') And " _
& "((" & Tbl & ".[ActionType])='Other'));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Related Significant"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Related*') And " _
& "((" & Tbl & ".[ActionType])='Significant' )) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA related*') And " _
& "((" & Tbl & ".[ActionType])='Significant' ));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "Matrix - MLBUSA Specific Significant"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[Quarter New], " _
& Tbl & ".[Quarter Close], " & Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date] FROM " & Tbl & " " _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') And " _
& "((" & Tbl & ".[ActionType])='Significant' )) Or " _
& "(((" & Tbl & ".[Category]) Like '*BUSA specific*') And " _
& "((" & Tbl & ".[ActionType])='Significant' ));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

strQueryName = "MLBUSA Specific Significant Issue & Plan"
dbs.QueryDefs.D elete strQueryName
strSQL = "SELECT " & Tbl & ".[ActionID], " & Tbl & ".[AuditName], " &
Tbl & ".[Category], " _
& Tbl & ".[ActionType], " & Tbl & ".[Status], " _
& Tbl & ".[Past Due], " & Tbl & ".[Due Date], " _
& Tbl & ".[Revised Due Date], SnapActions.Fin ding, " _
& "SnapActions.Re commendation_1, SnapActions.Man ager, " _
& "SnapActions.Ma nagerResponsibl e, SnapActions.Ind RespDept, " _
& "SnapActions.St atusComments FROM " & Tbl & " " _
& "LEFT JOIN SnapActions ON " & Tbl & ".ActionID = SnapActions.Act ionID
" _
& "WHERE (((" & Tbl & ".[Category]) Like '*BUSA Specific*') " _
& "AND ((" & Tbl & ".[ActionType])='Significant' ) " _
& "AND ((" & Tbl & ".[Status])='Open')) OR (((" & Tbl & ".[Category]) "
_
& "Like '*BUSA specific*') AND ((" & Tbl &
".[ActionType])='Significant' ) " _
& "AND ((" & Tbl & ".Status)='open '));"
Set qryDef = dbs.CreateQuery Def("strQueryNa me", strSQL)

Set dbs = Nothing
End Sub

Private Sub cmdRequestDate_ Click()
Dim dteDate As String
dteDate = InputBox("Pleas e enter the date listed at the end" _
& " of the filename of the table you wish to use. Please" _
& " use the format MM-DD-YY and click OK.")
txtDate = dteDate
End Sub

Nov 13 '05 #3

priscilla.jenkins

Success at last!

This:

Tbl = "[-ArchivedActions " & txtDate & "]"

....as well as getting rid of the sub function and running that code
directly from the main code worked!

Nov 13 '05 #4

Similar topics

11934

access 97: runtime Error 3146, form, pass-through query

by: JMCN | last post by:

hi - i have created a passthrough query and have it automatically connect to the odbc and then on a separate form, i have the user type in the date parameters. however when i run the following code on my form, i receive an error that the odbc connection had failed "ODBC – call failed. (Error 3146)", even though in the pass-through query i pasted the properties odbc connect str to the qdf.connect code below. does anyone know why i have...

Microsoft Access / VBA

5121

Run-time error '3011' in select statement in access2002

by: Polly | last post by:

I had a macro that ran a parameter query and created and opened an Excel file with the system date as part of the file name, but I had to change the file name by hand. So I converted the macro to code using tools-->references. The converted macro included the following statement: DoCmd.OutputTo acQuery, "qselLabelsBloodLog_output", "MicrosoftExcelBiff8(*.xls)", "S:\susan_cheree\lb041129.xls", True, "", 0

Microsoft Access / VBA

11327

UPDATE query syntax question

by: deko | last post by:

I'm trying to update the address record of an existing record in my mdb with values from another existing record in the same table. In pseudo code it might look like this: UPDATE tblAddress SET AddressDescription of Entity 456 = AddressDescription of Entity_ID 123 Address1 of Entity 456 = Address1 of Entity_ID 123 City of Entity 456 = City of Entity_ID 123

Microsoft Access / VBA

22610

SQL syntax: How to insert srting with double quotes?

by: deko | last post by:

I'm trying to log error messages and sometimes (no telling when or where) the message contains a string with double quotes. Is there a way get the query to insert the string with the double quotes? Do I need to use code to scrub each string and remove or escape the double quotes before using it in a query? The error I get is this: Error Number 3075: Syntax error (missing operator) in query expression '"credit card billed by...

Microsoft Access / VBA

16227

error: syntax error before '*' token

by: Manuel | last post by:

I'm trying to compile glut 3.7.6 (dowbloaded from official site)using devc++. So I've imported the glut32.dsp into devc++, included manually some headers, and start to compile. It return a very strange error. In your experience, where I should looking to find the real error? Surely the sintax of glut is correct... gcc.exe -c glut_bitmap.c -o glut_bitmap.o -I"C:/Dev-Cpp/include" -I"../../include" -D__GNUWIN32__ -W -DWIN32 -DNDEBUG...

C / C++

3076

Error on QueryDef on Close

by: sara | last post by:

Hi - All is fine if I open my form, do something, then close it. However, if I just open it, then press the Close button (or go into design view), I get "object variable or with Block variable not set" error 91 on mqdf.Close The following code appears at the top of the module: (someone wrote it for me)

Microsoft Access / VBA

4023

Pass Through DDL SQL to Oracle Express via ODBC - Run-time Error '3003'

by: Greg Strong | last post by:

I'm experimenting with using Access 2k2 as a front end to Oracle Express. I am creating 10 tables using pass through DDL queries. The PROBLEM is the general format of the VB code WORKS on the 1st 6 tables created, then an error is thrown which I can't find much help on. I've compared the code on the 6th table to the 5th which is successful, and the general format is the same. It seems the more you try, the quicker the problem is...

Microsoft Access / VBA

2947

Error As Variable Not Define

by: mukeshsrivastav | last post by:

Dear sir, I want to create a query at runtime and assigning value to them through a sql query.what is the error here. error is shown over variable qdf declaration Dim QDF As QUERYDEF 'On Error Resume Next DoCmd.DeleteObject acQuery, "databaseQuery" 'On Error GoTo 0 Set QDF = CurrentDb.CreateQueryDef("databaseQuery", ssqltext) '

Microsoft Access / VBA

399

12787

PEP 3131: Supporting Non-ASCII Identifiers

by: =?UTF-8?B?Ik1hcnRpbiB2LiBMw7Z3aXMi?= | last post by:

PEP 1 specifies that PEP authors need to collect feedback from the community. As the author of PEP 3131, I'd like to encourage comments to the PEP included below, either here (comp.lang.python), or to python-3000@python.org In summary, this PEP proposes to allow non-ASCII letters as identifiers in Python. If the PEP is accepted, the following identifiers would also become valid as class, function, or variable names: LÃ¶ffelstiel,...

Python

8349

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8275

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

8695

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8576

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6157

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

4143

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4281

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2696

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1585

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General