I am awful at explaining things.
when i run the query without the "is not null" fields, i get records that only match what is selected from the form "Workshop". When the "is not null" fields are there, i get records that are not null, but not all of them match the item chosen from the form.
trixxnixon
Last Activity: Dec 17 '12, 08:51 PM
Joined: Sep 28 '08
Location:
-
Thank you for doing that. The attitudes towards being helpful on this board are unparalleled.Leave a comment:
-
I had some problems posting the sql within the tags.
...Code:[noparse] SELECT [Workshop Survey].[Course Code], [Workshop Survey].[communicate comments], [Workshop Survey].[manner comments], [Workshop Survey].[materials comments], [Workshop Survey].[objectives comments], [Workshop Survey].[participation comments], [Workshop Survey].[objective2 Comments], [Workshop Survey].[prep[/]
Last edited by zmbd; Oct 15 '12, 08:34 PM. Reason: When posting SQL, VBA, PHP, etc... please format it using the <CODE/> button.Leave a comment:
-
I apologize, I was trying to re edit my post when you replied.
I added a column that has a tracking number parameter that is selected from a form. I want the query to return only the records that have the corresponding tracking number, with the subsequent fields. . . with at least one that has content. Null or blank.
Does that make more sense?Leave a comment:
-
here is my sql below. it still returns items that were not selected on the form. what might cause this?Leave a comment:
-
it works, but only if all of the fields i have in the query have data. if one is null the record is excluded. how do exclude only the records where all fields are blank?Leave a comment:
-
sweet i will try this.Leave a comment:
-
exclude record if query yields no results
say i want to query a few fields from a table for the purposes of a report. how might i have the query only return records that have data in at least one of the fields to prevent the repot from having many blank pages? -
Error 2950
What might make a report give the 2950 error?
here is the situation, i have a report that has functioned correctly for years. there is a date range paramater where you can select a start date and an end date as the scope of the report. any date i select before july will result in the report being ran correctly, but if i choose a scope within july, i get the error about "complex expression".
can anyone reccomend... -
i have not test this as of yet, i was mostly curious to see if it was even possible. i will conduct a test today just to see.Leave a comment:
-
Using different versions of Access on the same database
Has anyone had a situation where they had to supply end users with a frontend for a database that was created with a different version of access that the table is housed in?
my database was created and deplyed with 97. we are slowly switching to 2010. i want to provide users who are already converted with access to my application. are there any know problems with doing so? or is it even possible? -
its stopping at "dim html as HTMLdocument"
i cant find the correct reference to add within the menu.
Is there a way I can install it manually?Leave a comment:
-
It seems like most of this doesn’t really work, and the problem is focused around actually successfully calling IE and opening the source.
maybe you can offer a better process for getting this done.
What im doing is pulling the id number of the logged in user, accessing the active directory via internet explorer, converting the webpage to the source, storing it in an html document, searching for the @,...Leave a comment:
-
Calling IE with access 2007 vba
this code worked in access 97 and i am getting an error on the internet explorer variable. Is there an updated way of having vba open this program?
...Code:Function getEmail(enumber As String) Dim url As String Dim IE As InternetExplorer Dim HTMLDoc As HTMLDocument Dim html As String Dim atLocation As Long, startLocation As Long, endLocation As Long Dim x As Long 'Create a new instance
-
what i am specifically working on is an email function that sends a confirmation email with user information.
it grabs the email address from active directory, accesses the exchange server, and sends an email with information from the record.
the get email and send email are in two seperate modules.
how would you suggest moving these modules?Leave a comment:
-
will the vba still work when converting from access 97 to 2007
I have an access database that was created in 97, we are going to be moving to the office 2007, then the 2010 suite.
if you were to convert a file from 97 to 2007, will the vba still work correctly, and if not are there things that can be done to ensure the functionality is not interupted? -
when a record was last updated
is there a way to tell when a record was last updated? -
you know i did a really bad job of explaining that. but it was much easier to just build a seperate report. thank you tho. =)Leave a comment:
-
Parameters gathered from a form with excluded items
i need to gather information from a form to plug into a query,but i need the query to exclude one item that is an option on the form housing the parameters, unless that item is directly selected as an option... ie if the field is left blank, the report will generate pulling records baased on all but that one option. it will however generate the report if that option is directly selected.Code:([Forms]![frm_Reporting].[type])
any idea... -
in sql as well as the access query,
here is what i am using currently
is there a way to add -1 to the start date and +1 to the end date? would that be the proper logic.Code:Between Nz([Forms]![frm_Reporting]![begin],#1/1/1900#) And Nz([Forms]![frm_Reporting]![end],#12/31/9999#)
Leave a comment:
No activity results to display
Leave a comment: