Search results

Jal, Thank you for your input. My rudimentary method seems to work ok for now. As I had stated; what I did was close down the POPUP form in the background whenever the button is pressed for the query to open in design format. This way upon closing the query the user is returned to the Main...

Raskew and Jal, Thank you very much for your input and great help! I very much appreciate it and will put this information to good use. Will post a message if I run into any obstacles with the coding. Jal, thanks for you suggestion I will look into it asap. Again, THANK YOU! Regards, Martin

Thank you Khawar! very much appreciate your input. I have another question please; If I am calculating the age in a query "Age: Int((Now()-[DOB])/365)" and wish to include everyone whose birthday is going to be turning 14 a month from now, can i use this criteria: =13.11? currently the...

:D GREAT :D Jal, again THANK YOU!!! I truly appreciate your help, time, and genuine effort. "what goes around comes around" Jal, if there is a study/book for getting a better understanding of VB you can recommend, I will appreciate it even more. Thank you for pointing me in the right...

Thank you Jal, I appreciate the info. Actually the query needs to made available so that it can be modified an manipulated. A form which enables viewing the data, be it in data sheet format, will not suffice because the query will still be locked away. What I have done so far is upon opening...

Thank you very much indeed; the extra table for lookup is a fantastic idea and i am confident it will work great...thx a bunch!!! One day I hope I can return this favor :cool:

Dear members; This is not related to a Query necessarily but here is the concern; How can I use a format expression where i can isolate the day from a given date so that it may be represented as "21st" or "22nd" etc...where the "st" and the "nd" can be automatic based on proper english...

Dear members; I have a form in which Popup is set to yes. I have many reports opening via buttons on the form and they are all set to Popup Yes and Modal Yes, so there is no problem. I however have to make a button to open a query for editing also but the query will not open in front of the...

Thank you Pono1 and boblarson..."=" sign was there and I had also tried sumoflastname. It has however worked...what I ended up doing is to take out the sum function from the query. Then I simply changed the statement to =dcount("[lastname]","qrsChildren") and VOILA! it worked :D So when...

I have a totals query, "qrsChildren" in which I have only three fields: 1-Lastname (is set to count, and returns the correct totals titled: countofLasName...this field is set to show) 2-facility# (in criteria; forms![frmFosterFamily]![facility#]...this field is not set to show) 3-current (is...

Dlookup from a query I have a totals query, "qrsChildren" in which I have only three fields: 1-Lastname (is set to count, and returns the correct totals titled: countofLasName) 2-facility# (in criteria; forms![frmFosterFamily]![facility#]) 3-current (is set to "yes") When run, the query...

Thank you for all your efforts dkinley... Problem is solved. Basically, I created a 12th invisible field in the form. The field will automatically contain an iif statement where it returned "*" value if the other 11 fields happened to be blank. The query criteria had to read the following...

Thanks dkinley, Before I figure out ways to attach a sample of the db, i wonder why the an iif statement cannot work in a query...for instance, I could actually create a text box in a form which will have certain criteria in it based on some conditions. The query criteria can be told to simply...

Criteria Problem... Thank you dkinley... Thats the setup I had with the &"*" yet I get weird behavior. Here's another thought; ...suppose I make a 12th field in the form and when the 11 fields are left blank, the 12th one could have a wild card value which the query could consider and show...

Criteria Problem... Thank you dkinley...I got everything going well with fields and how it works with the criteria. The problem is, i want the query to show all records when all 11 fields on the form are left blank. Thats where I am having some trouble. The criteria is working fine like...

Criteria Problem... I have been able to create a form which contains 11 fields. The purpose of the form and fields is to help with a query criteria. A field in the query which depends on these 11 fields has the following criteria: [forms]![RDmonthlyReports]![l1] Or...

Yes Mike375, that is precisely how I have made the form1. I am trying to get away from that by creating a criteria which can allow user entry instead of being form non-bound field driven. WayneRyan has a good suggestion, please enlighten me further on it as I am not that familiar with SQL...

I have the following criteria under [location] field in a query: Like [Enter location code: ND for North Dallas, SM for South McAllen, etc or leave blank for all records] & "*" Is there any way to modify this code so that when the query is run, I can type something like [ "ND" or "SM" or...

Thank you pbaldy & Pat Hartman! I will look into it asap. I guess you are right, everything has to be form driven and no access will be available to any design portions. This is the intended goal. once again, Thank You!

Thank you for your responses... The runtime version seems to be what I am thinking of. Can you please shed some more light on how to obtain the runtime version of Access, and can a pre-existing database utilize runtime? I am working with Access 2002 and may upgrade to Access 2003...