473,386 Members | 1,745 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Getting an error when I upgraded to MS Access 2007 on Environ

anoble1
245 128KB
I use a database that has query that pulls the user's current NTID or name. Here is what my query says:
Expand|Select|Wrap|Line Numbers
  1. Environ("UserName")
Worked on offce 2003, since I switched the Environ is not valid. How do I get this to work? Is it called something else?

Expand|Select|Wrap|Line Numbers
  1. UPDATE tblReviewNames SET tblReviewNames.SignedIn = True WHERE (((tblReviewNames.NTID)=Environ("UserName")));
Jun 8 '10 #1
2 2085
QVeen72
1,445 Expert 1GB
Hi,

Try this :

VBA.Environ("UserName")

Regards
Veena
Jun 9 '10 #2
anoble1
245 128KB
Actually I fixed it this morning. Scott Kelley from Bessemer State Technical College told me to put:

Expand|Select|Wrap|Line Numbers
  1. UPDATE tblReviewNames SET tblReviewNames.SignedIn = False WHERE (((tblReviewNames.NTID)='" & Environ("UserName") & "'));"
So
Expand|Select|Wrap|Line Numbers
  1. '" & Environ("UserName") & "'));"
Not sure why that worked. btw thanks QVeen72 I tried that also, same error happened. Not sure why 2007 doesn't see stuff that has worked on office 2003.
Jun 9 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

0
by: Imran | last post by:
I m getting this error when i open asp.net Form Design View. "The file failed to load in the Web Form Designer. PLease Correct the following error, then load it again. The designer could not be...
1
by: Tor Inge Schulstad | last post by:
Hi. I know that Access has it's limitations, but does anyone have a good strategy for avoiding "unspecified error" when retrieving data from the database. I always close my connections, but the...
1
by: dipesh | last post by:
I am getting error when trying to Add Web Reference in Visual Studio 2005. "Some of the files required for web references are not installed"
7
by: martin DH | last post by:
A user of a database received this error when attempting to open the database on a new computer. The Access database was built in Access 2003 and is being opened in Access 2007. The database is set...
1
by: jonny | last post by:
Went from using Visual Web Develop express to Visual Studio 2005 and getting error when trying to open project. Error message: "One or more projects in the solution could not be loaded for the...
0
by: =?Utf-8?B?UmF2aQ==?= | last post by:
Hi, I have WCF service and integrated with STS (WS-Federation). The Service exposes 5 endpoints Win, UNT and Federated Windows, Federated UNT and Mex endpoint. My STS Service exposes 3 endpoints...
1
by: fifothekid | last post by:
Hi everybody, I made a primitive cost control database system using Microsoft Access 2007 as a front-end (don't ask my why did I use Microsoft Access!!!) and SQL Server 2005 Enterprise as a back-end...
0
by: Tony | last post by:
I am continuing to develop an Access 2007 application which was originally converted from Access 2003. In Access 2003 I was able to disable the Access Close button in the top righthand corner of...
5
by: Tony | last post by:
I am continuing to develop an Access 2007 application which was originally converted from Access 2003. In Access 2003 I was able to disable the Access Close button in the top righthand corner of...
4
by: sumit kale | last post by:
Hi, Can somebody help me resolve my problem ? I am getting error when calculating total using unbound textfiled in subform. I have a main form called purchase_register_master and a subform...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
jinu1996
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.