Search results

Hi Jane, Excellent! I'm pleased to hear you have successfully transitioned the customer data into the new lookup field. Now let's do some cleanup work. Please follow these remaining steps. 1. Delete the command button control from the view called Customers List since you no longer need it...

Hi, Since it seems several people have asked about it, I made a client-only copy of the Issues 2010 style web database. It is attached to this post as a Zip file so anyone can grab it from here. Hope you find it useful. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior...

Hi Jane, No problem at all. Just post back when you have time and let me know the status of how things went up to this point. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior SDET - Access Test Team - Microsoft Corporation Author - Microsoft Access 2013 Inside Out Author...

Hi Jane, Perfect, glad to hear everything is going fine so far. Here are the next steps to complete. 1. Create a new standalone data macro which we will use to populate the new Customer Name lookup field in the Orders table. Start by closing all open objects and then click the Advanced button...

Hi Jane, No trouble at all on the delay. We'll get you up and running in no time. Now that we're both at the same starting point, please follow these steps in order. If you have any questions or issues with any of these, just let me know. 1. Open the Customer table in Design view. I would...

Hi Jane, No trouble at all. Thanks for the additional information on your setup. I've created my own spreadsheet with two tabs of information, added in columns using the names you provided, and put in some dummy data. I did this so I can follow along with your setup. The first step I'd like...

Hi, Good questions concerning Access Services where you can create Access 2013 web apps. I'll try to answer them below. I believe that is correct. I think for Access Services you need a Small Business plan or an Enterprise level Office 365 plan. That is correct. However, you mentioned you...

Hi Jane, I believe I can help you with this. A quick question for you since you mentioned you are creating an Access 2013 web app. Are you using Office 365 to host this Access web app or are you using an internal SharePoint/Access Services setup at your organization? The behavior you describe...

No problem, glad to help. Good luck with your project. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior SDET - Access Test Team - Microsoft Corporation Author - Microsoft Access 2013 Inside Out Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access...

Hi, I'm glad you were able to use the Conditional Formatting button after expanding the Ribbon. This is an issue we are tracking in our system. Concerning the Shape Effects button, that option is only available for command buttons, toggle buttons, and navigation buttons. When you select any...

Hi, This issue sounds very familiar to me. By chance is your Ribbon collapsed when you are clicking the Conditional Formatting button? By collapsed I mean you don't see the Ribbon options until you click one of the tabs. If so, than that is the issue. Expand the Ribbon so you see all the...

Hi, Are you wanting to convert a Access 2010 web database or an Access 2013 web app file? Very important distinction we must know before providing guidance. Which type are you using? -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior SDET - Access Test Team - Microsoft...

Hi, You haven't got back to me yet on what specific Northwind database version you are using, but I did some quick checking on the 2007 version and the 2010 version (this one is a web database). In both of these versions, the workflow is as following: - When you start creating a new order, the...

Hi, The version of Access you are opening Northwind with isn't quite as important as what version of Access that copy of Northwind was originally created for. The Northwind databases created for Access 2003, Access 2007, and Access 2010 are each vastly different in their implementation. The...

Hi, Which version of the Northwind template are you using? It's not clear to me from your post which version you are using. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior SDET - Access Test Team - Microsoft Corporation Author - Microsoft Access 2013 Inside Out Author -...

Hi, I discussed your issue with some people on our team and we are thinking it might be a DNS resolution problem. Here is something that was suggested: >>>>> 1. Get the IP of the server, using a machine that can connect to it. Let’s say the server is y6fgzqj45e.database.windows.net and the IP...

Great, thanks for the confirmation Bob. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus Senior SDET - Access Test Team - Microsoft Corporation Author - Microsoft Access 2013 Inside Out Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access 2007 Inside Out...

Hi, Web queries in 2010 style web databases only allow you to use "web tables" as their source - essentially published web tables within the Access Services site. Similarly, web reports can only use web tables or web queries as the source for their data. It is not possible to base a web report...

Hi, Glad I could help. The subject of lookup fields in tables is a "hot button" with many developers. Most have very passionate <cough> opinions about the subject. :) That being said, lookup fields are essential in 2010 style web databases and 2013 style web apps. I suspect the discussions...

Hi, This seems very odd indeed. Are you using Office 365 to host this Access Services web database or are you using an on-prem SharePoint server within your own organization? Just to clarify, if you open the web table in Access, you can enter a negative value, but if you use the web form...