Search results

Thanks a bunch Brian- I had a feeling I was missing some fundamental concept. My mistake for not locating that thread in the first place. Thanks also to Bob for the lesson on Null not equal to null. Another case solved by the Access World Forums - you guys are the best!

Thanks for the help. Using IsNull([Control]) instead of [Control] Is Null still leaves me with the issue that you point out - the absence of a value is not equal to the absence of a value (I did not know this). How can I solve my dilemma? Is there some technique I can use to do the following...

Greetings, My issue is simple. I am making a query interface for my database - so end users can easily extract what they want. I have several controls that may or may not be null when I run the query. I am using the following as my Criteria (which may be flawed)...

Simply amazing. Solved all my problems. Thanks Bob, my sleepless nights are over!

Thanks for the prompt solution to my long-winded post! Now that you point it out, what I was doing does appear to be very misguided. I will implement and post any further issues, but I'm guessing it should solve all my issues.

I am automating a task from an Access database. I am automating excel and word using vba. I am experiencing "unqualified method calls" - where I'm making a hidden reference to the old instance of the application. http://support.microsoft.com/kb/319832 Microsoft says to make all unqualified...

Thanks for this info. I was completely in the dark on this matter, and it is extremely helpful.

Here is a quick general question. I may be creating a new database that will be used on Macintosh computers with the MAC OS - is there anything I should be concerned about only having experience in windows? I have heard rumors of VBA being disabled on MAC OS? Is this true? Am I crazy to...

Hah! Well I'm glad I'm not the only one that feels this way. To be honest I don't like Excel too much either, I prefer minitab or grapher - but Excel will certainly give me want I want for this particular scenario.

Greetings, I need to create a report that displays a few pages worth of scatterplots (4 pages with 2 plots per page). I'll be honest, the pivotchart view really gets on my nerves (same with the "insert chart"). I'm hoping it is do to my own incompetence. All I want to do is display x,y...

Need help with proper event trigger, and potentially proper refresh. Data entry form with subform in datasheet view. The lab results are entered on the subform in the field "result". The result field is text, in order to accommodate characters like "<0.002". I want to guard against entries...

Awesome. Another case solved (and very quickly too). Thanks John!

The SQL code the query design view editor writes for you does work with the VBA. I have done unspeakable things using this approach - the sky really is the limit when you toss in vba variables into SQL queries as I'm so awkwardly am attempting to describe.

Check out the "Sample Databases" part of the forum. One of the admins has a great example posted of a log in interface. One thing I may warn you against is that if you go the public variable route, it may be a pain when testing/creating your database because if your code hits an error the...

Is it possible to disable the user from hiding columns in datasheet view of a subform? More specifically, what I am referring to is when the user right clicks the header bar at the top of the datasheet and can access the hide columns option. Thanks in advance, I have had nothing but very...

What I usually do, not being fluent in SQL is use the query design interface. Then I click SQL view and copy the code into VBA. You can use dummy parameters in the design interface and then replace them with VBA variables in the VBA editor. The convention I use is to populate my string all at...

1. Database is not split. I created it with Access 2007, as 2007 file format, and haven't split it or used any server/client type set ups - just a standard stand alone database (excuse my sloppy terminology). 2. The file is saved on a network drive. It is not saved on the hard drive of the...

I was able to revert back to a copy from 7 am this morning and everything works fine. Not sure what could have caused this issue (I didn't even open the file between then and when I had my issue - maybe somebody messed with my file). I suppose sometimes things just get corrupted for no good...

I have read posts about similar issues and am still unsure what to do about my situation. I'm using Access 2007 with 2007 file format. I was working on this database last night, everything seemed normal. The first time I opened it this morning - a message appeared "Cannot load...

Thanks for the assistance, it is much appreciated. Hopefully I won't keep learning my lessons the hard way!