Selasa, 05 April 2016

Re: [MS_AccessPros] Is expression valid Office 2007 ?

 

John,


I have decided to upgrade myself to 2007 with your motivation.

Now should i uninstall Office 2003 and install Office 2007 OR keep both? Secondly my existing databases are in 2003, should those remain in 2003 format or they have to be converted in 2007 format ?

You told that earlier you kept different versions on virtual machines, i could not get the term virtual machines. Does it means that you have different versions of Access on your machine, and you make in different folders your customers applications for their version of Access?

Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Khalid-

The biggest hurdle in moving from 2003 to 2007 is getting used to using the Ribbon instead of Menus.  There are some new features as well, but anything you could do in 2003 you can do in 2007.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Apr 4, 2016, at 12:22 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

While upgrading myself to 2007 what will be the situation of all my coding in different databases ? Would i have to change any parts of my present coding ? And further for new coding would i be at comfort with my present knowledge of 2003 ?

Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Khalid-

The ideal situation would be to upgrade yourself to 2007 - especially if all your users are on that version.  When I was doing development regularly several years ago, I used virtual machines to keep separate copies of Access - one each to match what my customers had.  It's always best to develop in the same version.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Apr 4, 2016, at 9:44 AM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

Thanks to you once again. As you have been guiding and telling me the different techniques and ways to handle the problems. My current issue for 'CustomerID' is also resolved.

After doing some more work in database like putting some more controls on some forms and reports or changing layouts of forms. When i copied .Mde on users machine and opening it, again i got the same message for missing library and i have to uncheck the MISSING reference. Further i decompiled the database. Further compiled it again found no error. Then made Mde on users machine. This cleared the issue of control 'CustomerID'.

(In 2007, click the Office button in the upper left corner, then click Access Options / Current Database.) I saw an option for Access File format, which showed "Access 2000-2003" also. As i am doing all my work in Access 2003. Do you suggest that i change it on users machine to 'Access 2000-2003' format ?

I would like to again say thanks to you for all your cooperation and help.

Regards,
Khalid
 


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Khalid-

In 2007, click the Office button in the upper left corner, then click Access Options / Current Database.

I have no clue why typing is causing an error - unless you have code that's interfering.  What is in the Row Source,  Column Count, Column Widths, Bound Column, Limit To List and Allow Value List Edits properties of that control?  Do you have any code associated with the control?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Apr 2, 2016, at 2:30 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

Yes it worked, when i did it as you said i converted it to .Mde on his machine.

One thing i could not get there on Access 2007, the Tools menu where i can open the 'Starup' for .Mde and hide database window and status bar, what i have thought that open that .mde on my machine and then modify the 'Startup' options and then copy that to my users machine.

My second question was for CustomerID, while entering CustomerID through keyboard instead of selecting from combo box drop down list, it displays my defined message box for 'Not in List' event. (on users machine only)

Thanks for doing the favour up to now.

Khalid


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Did you compile the VBA project after you removed the missing library?  And if it compiled and saved OK, did you then convert that to .mde on his machine?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Apr 2, 2016, at 9:58 AM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

I opened the .mdb (FE) on my users system and got message like:

"You have broken reference to the file 'AcroPDF.dll' version 1.0."

The i checked it in Tools--> References

MISSING was checked (Adobe Acrobat Browser Control Type Library 1.0

I unchecked it.

Now still on my FE and MDE the report is OK and showing "Month, Year", but not on the user's system.

Further on my user's system on a control for 'CustomerID'  if he enters CustomerID the message displays "The text you entered is not in list" even for its properties in Data tab its Limit to list property is set to Yes.
Same is the case here on my own system it does works.

Khalid


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

I suspect the libraries aren't being updated correctly when your user tries to open using 2007.  You should send him the .mdb file and ask him to open any module to see if it compiles.  Is anything else broken in the database?  If so, that would be a clue.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Mar 29, 2016, at 2:23 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

He is using Windows 7 with office 2007, then obviously his Access would be 2007. But i have put backend and MDE of in Access 2000-2003 format.

Khalid


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Then that should work.  Is your user running the same version of Access as you?
 
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Mar 29, 2016, at 1:44 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,
 As i mentioned in my previous reply on Detail Section i have first bound control "SaleDate" with control source: SaleDate and these dates are displaying on detail section. Does it not suffice?

Regards,
Khalid


---In MS_Access_Professionals@yahoogroups.com, <JohnV@...> wrote :

Khalid-

Sometimes the Report engine can't find a field in the Record Source because it reformats the SQL to optimize it based on grouping, etc.  If you don't have SaleDate in a bound control on the Report, it's not guaranteed to be available at run time.  Try adding  a hidden text box containing that field.

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications 
SQL Queries for Mere Mortals 
(Paris, France)



On Mar 29, 2016, at 1:01 PM, khalidtanweerburrah@... [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:



John,

Reports Record Source is Query:

__._,_.___

Posted by: khalidtanweerburrah@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (20)

Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? The Yahoo Mail app is fast, beautiful and intuitive. Try it today!


.

__,_._,___

Tidak ada komentar:

Poskan Komentar