Search results

Re: Access 97 to 2010: "The current user account doesn't have permission to convert o I'm not sure what you mean then. Using Windows XP/Access 2003 I can confirm that the permissions of the file and of its containing folder include me, with full read/write access (I'm in the Administrator...

Re: Access 97 to 2010: "The current user account doesn't have permission to convert o I receive the same error. Do you think my best chance is to import these objects into a new, Access 2010 database?

Re: Access 97 to 2010: "The current user account doesn't have permission to convert o I'll try when I get into work. Do you want me to do that with Access 97 or Access '10?

Re: Access 97 to 2010: "The current user account doesn't have permission to convert o Hm. Maybe I'm wrong about the '95 part. It's not an MDW file. It's an MDB.

Access 97 to 2010: "The current user account doesn't have permission to convert or en Hi everyone! Long time, no post. I've got an Access database that my workplace uses to track basic information about visitors. The database was likely built in Access 95 and is being regularly used in Access...

I found this (and several similar) threads unanswered. For future searchers, I solved my problem with this advice.

Mike, I had the same question six minutes ago and found your unanswered post. Check here. Andrew

Thank you, Wazz. I'll run with it.

...I could smack my database professor.

Does VBA not like hyphens in table names? This works: ...But add a hyphen to the table name in the code and in the database....And it doesn't....

Aren't you missing a quote after /16/? ...And remove the one at the end of the line. See below. BldCurDT = CDate(Month(Date()) & "/16/" & Year(Date())

...Oh, hell if I know. The term has changed about a million times. Maybe we're suppose to be saying least economically developed, economically developing, and most economically developed now.... But those terms only reflect a nation's economic status. Are there Twitter alerts or SMS services...

I just spent all day playing with the domain aggregate functions. My work is at the office, otherwise I'd be able to give you an exact example. In the meantime, the syntax you need is either this... strDteChkCurrDte = DLookup("ProcessDate","MonthlyTbl","[DateFieldGoesHere] = #" & strCurrDte &...

Pat, I'm honestly honored to have attracted your attention on the matter. I've been using this forum for years (I was formally mtairhead); you and a few other users have pretty much taught me anything I know now about database development, outside of one class in high school and a couple...

heh. I'd be willing to help for free if you stop associating the third world with "cheap" and start referring to it as "developing." You know, PC and all.. :)

Susan Harkins from Tech Republic wrote this article on MS Access and I'd be interested in hearing the die-hards (and the haters) chime in. I love Access but I limit my use to quick calculations/reporting...Generally, stuff that isn't going to be used again. I learned my lesson regarding the...

Paul, Your optimism astounds me. Do yourself a favor and go back to the superior product. Andrew PS - You CAN reprocess the information in Access if you connect/link the Crystal Report datasource to your access database....But you'd have to remake everything in Access. It tantamount to...

Sreedevi, I think the way you built this will require a more complex solution than a simple query. See if what I pasted below works for you. I just used the Query Wizard to create a Find Duplicates Query, which looks for duplicate combinations of Stlye# and DC#. Once it created that, I added...

It certainly could be populated by a query. Just make certain that that query is the source for qryRequiresSelect2.

Mkay. If you haven't already, your cboSelect combo should be populated by a table. I'm going to call the table tblSelect for now. Here's the structure: tblSelect(ID, type, requiresSelect2) PK: ID requiresSelect2 is a Yes/No (boolean) type. Make a query. We'll call it qryRequiresSelect2...