Search results

Change the SQL of your query to the following: SELECT tblMogel.ArtikelNR, tblMogel.Namn, tblMogel.Vikt, tblMogel.Symboler, tblCount.Count FROM tblMogel, tblCount WHERE (((tblMogel.ArtikelNR)=[Forms]![frmMogel]![Artikel nr]) AND ((tblCount.Count)<=[Forms]![frmMogel]![ArtikelNR])); That should...

Hi Doco, That's good to hear everything appears to be working for you now. It's definitely odd that it wasn't working before, but now it is. Such is life when we play with 1's and 0's all day long. My guess would be it was sun spots for this one, yeah, must have been sun spots. :)...

Hi Doco, I'm still concerned about the embedded macro issue. Can you try these simple steps for me? 1. Open your 2007 ADP file 2. Open one of your existing forms in Design view 3. Drop a new command button onto the form surface and dismiss the wizard if it comes up 4. On the Property Sheet...

Hi Doco, I miss the scenery of Central Oregon and the four seasons. Let's start with something simple and work our way up to see if we can isolate the problem (and to see if I can repro the issue in house.) I'd like to try creating, saving, and running a simple macro object in the ADP file...

Hi Doco! Long time no chat. Hope things are well with you. From your post, it sounds like you create a macro in a 2007 ADP, but then the macro never gets saved. Is that correct? That seems very odd. Can you give me some more information on exactly what you're doing? Are you creating a macro...

Thanks for the update on this. I've been trying to repro this issue in-house and have been asking around the team, but at the moment, I'm a little stumped as to why that specific PC is not able to run CSD Tools. If you find out any more information, please feel free to pass it along...

Hi, This is very odd indeed. I've never personally seen that error nor has anyone reported that error to me when running the tool. I'm a little stumped at the moment. Some quick questions. 1. What service pack do you have for Access 2003 as Bob mentioned? 2. If you open a report in your...

Excellent, I'm glad you've been able to achieve your goal of showing more than eight items on a Switchboard page. To answer your next question, yes it is possible to open a query from the Switchboard form, however, this will require more work because in this case you will have to manually...

Did you take a look at the new FAQ page I created to explain this? Here it is again: http://accessjunkie.com/faq_58.aspx I thought the instructions were pretty clear, but let me try again. 1. Don't change anything about the Switchboard form. Meaning, don't add any more controls to the form...

I recognize the instructions you posted; they are from a previous post of mine in years past. I have instructions for adding more than eight items to the Switchboard in versions of Access pre-2007 here: http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html For Access 2007, it's...

This feature is built right into Access 2007. See this page on my site for more information: http://accessjunkie.com/faq_50.aspx -------------------- Jeff Conrad - Access Junkie - MVP Alumnus SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out...

It is with great pleasure that I announce that Bob Larson has been given the Access MVP award! Bob’s devotion to the Access community at large is unparalleled. In case you haven’t seen Bob around (which is highly unlikely), here is some information about him: Bob is a forum administrator of...

I have a really easy walk-through on how to get your form to open in Datasheet view from the Switchboard form: http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html#datasheet Also, that page has a whole bunch of FAQ information about the Switchboard...

Bob already has you covered just fine, but just in case you have other Switchboard Manager questions, I have entire FAQ page on the subject. You might in the future find some of the information useful: http://www.accessmvp.com/JConrad/accessjunkie/switchboardfaq.html -------------------- Jeff...

How about this? http://blogs.msdn.com/access/archive/2005/10/19/access-12-security-model.aspx -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007...

This page on my site should help: http://accessjunkie.com/faq_51.aspx -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials...

You haven't played Access Vaders????? My goodness, I thought everyone around here was an Access Junkie. ;) http://www.happy2-island.com/e/access.shtml Pick up a copy of Block Destroyer while you're there as well. I am not responsible for your subsequent decrease in work productivity. :) Have...

Does this help? http://support.microsoft.com/kb/937998/en-us -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials...

See if this page helps: http://allenbrowne.com/ser-46.html -------------------- Jeff Conrad - Access Junkie - MVP Alumni SDET - XAS Services - Microsoft Corporation Co-author - Microsoft Office Access 2007 Inside Out Presenter - Microsoft Access 2007 Essentials...

Hi Prashant, You have lots of resources at your disposal to learn about Access. I would start by looking at my Resources page here: http://www.accessmvp.com/JConrad/accessjunkie/resources.html You'll find links to hundreds of free resources concerning Access. Start there and see if you can...