Search results

Hi Sean, Thanks for the nice comments on the 2010 book. For Access 2013 web apps, things are very, very different. - 2010 web databases used SharePoint lists - 2013 web apps, however, use SQL Server for their data source - 2010 web database data macros were converted to SharePoint workflows...

Hi Alexander, Good question. Some background first needs to be explained. Access 2010 introduced the concept of creating a web database that could be published to a SharePoint Server running Access Services. When you publish the web database, the data goes into SharePoint lists on the server...

Hi, Can you be more specific on where you are seeing this issue? What exact set of steps leads you to hitting this error? I've converted a copy of the 2010 Contacts web database into a client desktop database and so far I haven't seen this error. Can you tell me what actions are you taking...

Hi, You need to save the web objects (other than tables) as client objects. That's why you only see the tables listed in the import dialog. Web tables can be imported just fine and will become client tables. I don't see any attached database to your post here? Did it not come through? Do you...

Hi, This issue doesn't sound familiar to me at all. I have not run into this issue and I've been using Access 2013 for a long time. Let's start with some background. Are you using 32 bit or 64 bit Access 2013? What is your operating system? Are you using a Access 2013 web app or are you using...

Hi Crissy, It sounds like you are attempting to open the IssuesClosed form directly from the Navigation pane. That's not how this should work. The template is wired together with macros and tied in with the main navigation form that displays when the template is open. You should be doing all of...

Hi, This is by design actually. All Access 2010 web databases do not allow you to open web objects in Design view. If you are using the Northwind 2010 web database, those objects are all web objects and therefore cannot be open in Design view. You have to use Layout view for web forms and web...

Hi, Use the RaiseError data macro action to display whatever error message you'd like. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author - Microsoft Access 2010 Inside Out Co-author - Microsoft Office Access 2007 Inside...

Hi, A couple of issues based on how you have this setup up so far. 1. It seems like you're not using the navigation form to its fullest potential by taking advantage of the Navigation Where Clause property of navigation buttons in the new navigation control. 2. Your posted code is incorrect...

Hi, It's not completely clear to me since it looks like your text was cut off in mid sentence in your message post. What is it doing at the moment? Showing an error? Something else? Without knowing the exact fields names in each table (that would help us trying to test out on our own machines)...

Hi, I'm glad to hear you resolved the issue by looking at the Appendix for the install instructions. The reason you were hitting the issue earlier is actually because of a product bug in Access. We have VBA code in the Contacts sample application that will automatically relink all the tables to...

Hi, I know you can do this with Access 2007 and I detail how to do that on this page of my site: http://www.accessjunkie.com/Pages/faq_31.aspx I haven't, however, tried the same technique with Access 2010 but I think it might work. The only thing I'm not sure about would be the Backstage view...

Hi, In versions of Access pre-2010, if you wanted to run a series of actions on the basis of the outcome of a condition, you wrote the expression on the first line in the Condition column. To have the same expression ran against subsequent actions, you had to repeat the entire expression again...

Hi, I think you might have left out one important detail. You said: You didn't mention what Access version is on that other computer. Is it also running Access 2010 or does it have an earlier version of Access like 2007 for example? I'm going to assume for the moment that it has an earlier...

Hi, Sure, just hover your mouse over the top section of the Property Pane until your cursor becomes a four sided arrow, click, and then drag the Pane away from the right side of the screen. Once you release the mouse, the Property Pane is a free floating window you can move around and resize...

Hi, The best advice I can give on that is to simply pretend those system tables are not there. They exist for Access to maintain various areas of your application but you should treat them as "hands off." Don't try and add, edit, delete, or modify in any way shape or form these tables - their...

Hi, When you import the web tables, you need to make sure you import them into a new client ACCDB container, not a web one. Otherwise, the tables remain web tables. Also, when you import tables, never import any of the system tables - the ones that start with the MSys prefix. At any rate...

Hi, Yes it is possible to convert the 2010 Northwind Web Database into a client version. It will, however, take some manual work on your part. Follow these steps: - You first need to create a new empty client ACCDB file. - Once that is open, you can import all the web tables, client forms, and...

You're welcome, glad to help. I'm glad you have it working now. Good luck with your project and thanks for trying out the new web database functionality in Access 2010. -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET II - Access Test Team - Microsoft Corporation Author -...

Hi Nick, The problem you are facing is not Date() in the web queries, it is Between. You cannot use Between for expressions in web objects. So instead of using this: Between (Date()-1) And (Date()+14) Just use this: >=(Date()-1) And <=(Date()+14) Works just fine in client, it is web...