need to combine these statements into one If/then, not, AND statement
If cell E3 is blank and N3 is blank, then blank
If Cell E3 is not blank and N3 is blank, then "open"
If cell E3 is not blank and N3 is not blank, then "closed"
Im frying my brain with IFs, IFNOTs, NOTs, ANDs and I cannot...
I appreciate the link. However, I cannot seem to get that to work in this particular form. I have approached it from every possible angle. Even cutting, pasting, and renaming the code as provided in the brinkster link.
Any other ideas?
I am using a query by for technique that generates a report. I have 5 fields that are combo boxes on the form that designates what criteria is to be queried. When the information is input into the fields, the query and the report work GREAT. However, I want to be able to leave fields blank...
I think the problem is that my code is not recognizing the 'calculated' values that are displayed within the late and late2 textboxes. I am pretty sure that I have it figured out though....but who knows...I am still a noob.
For some reason, this little piece of code does not seem to work. The code is for two different functions that are both run in the form code 'oncurrent'. I tried combinging the two pieces of code to make one, but it didnt work. This is what the code looks like...
Function CheckMe()...
You may want to recheck the name of the textbox on the form too. Make sure you are not confusing it with the label. This technique is called query by form. Here is a link to the microsoft website on exactly how to do it.
http://support.microsoft.com/default.aspx?scid=kb;en-us;209645
I was going through my startup options for my database so it would open a form when I opend the database. Now, I realized that I checked off so there would be no toolbars. I need my toolbars back and I cant find them. Is there some kind of shortcut key so i can bring up that starup box...
I am trying to create a query that pulls back data if it meets 1 of 4 different criteria. I tried putting in 4 different expressions, but it didnt work. If I put in only 1 criteria, it pulls back the records that were specified, no problem. Like I said though, I need it to pull back records...
Figured it out. Sometimes I have to go around my butt to get to my elbow, but here goes...
I set up a 'make-table' query with the fields that I wanted queried. Under one of the criteria I have code written for my query by form technique. The code is forms![form1]![team]. That is is for the...
Figured it out. Sometimes I have to go around my butt to get to my elbow, but here goes...
I set up a 'make-table' query with the fields that I wanted queried. Under one of the criteria I have code written for my query by form technique. The code is forms![form1]![team]. That is is for the...
I am not sure if this is possible...
I want to run a query and dump all the records from the query to a temporary table, and then design a chart from that temporary table. When the query or graph is closed, I would like the table to clear itself of all data until the next query is run. Please...
I have two fields that I want to be displayed on a form. Field X and Field Y. I want field X and field Y displayed on the chart only for records that match the criteria that I specify for Field Z.
In real time terms: I want to display all open/closed files(X) for all subteams(Y), that are a...
If I design a page in FrontPage 2002, can I then edit the page within access and save the page within an access database? I am asking before I go to designing only to realize that it may not support it.
Well, come to find out, it wasnt my code. It was a filter that I had accidentally specified in one of my macros that opened a report that was based on said Query. I took out the filter...and...viola!!!
Here are 4 expressions that are in two different queries. One query works perfectly. When the other query is run a popup box displays saying Category I - enter parameter value. I cant seem to figure out why. I took the database that was working perfectly, copied and pasted it and gave the...
We are trying to create a function in Excel through VB where it counts all of the fields whose text is "Accept" - but in another field its manufacturers name must be equal to a manufacturers name in another field in another sheet.
basically a countif function, with multiple criteria...
Figured it out. Rather than writing such a long piece of code, I inserted the field 'sent to field' into the query and put its criteria as null. The query defaulted and created another expresssion. Works like a charm. bare with me, im new at this!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.