Search results for query: *

thread1462-1527034 I want to add to the formula in the referenced thread and ask it not to include a list of holiday dates in the calculation. I'm thinking of using an IF statement but am really new to programming. I'm using Crystal XI to pull from an Oracle 10g database. The following is...

I've had a monitor stolen from a workroom and need to find out what Make/Model it was. Is there a way to find out what type it was in the registry or anywhere else? Thanks so much! Angela Farmer

Hello all. I'm researching the use of the SPS 2003 survey feature as a quizzing tool for training materials, policy and procedure type stuff. Is anyone using it in this way that can offer suggestions, advice, guidance? Our Ideal solution would use (or convert) existing PPT's or docs as...

Hello all, I have a VBA excel(2003) reports that are scheduled to run every night. They began returning #value! in the results in August. I've been looking over the set-up and code but have not found anything obvious. Let me also mention that the code is about 5 years old and was written...

I need help taking an inventory of multiple Dell servers running Windows 2k and 2003. We had staffing change and I'm in over my head. I'm mostly PC/app support! Any suggestions on how to get a listing of installed programs and hardware would be greatly appreciated! I'm hoping there is a...

I'm running W2K on a server used for shared folders and direct AD to them for the each users home folder. I need to increase the size of one of these folders for a user and can not for the life of me remember how? Any help is appreciated! Thank you.

I have walked into this same problem today. Did anything work for you? I have tried what was suggested and nothing has worked for me. I can't open or repair the database. I've tried creating a blank and importing, linking, and establishing an ODBC connection with no luck. I ran the...

Here is my SQL SELECT qryAssessmentCalc.Name, qryAssessmentCalc.PStr, qryAssessmentCalc.Expr1, qryAssessmentCalc.Page, qryAssessmentCalc.Parcel, qryAssessmentCalc.ParcelNu, qryAssessmentCalc.ServiceLoc FROM qryAssessmentCalc WHERE ([b]Like GetFormValue("txtname")[/i]); I'm getting a missing...

I need to use a wildcard in the criteria. For example, if the user enters "farmer", I need the query to return all records that contain "farmer" as the first 6 characters. Is there a way to use a wildcard similar to the "like F*" used in the qbe with the GetFormValue function? I am asking...

Roy-Vidar, I was having the same problem but your last post walked me through using the expression builder and I got the correct path! Thanks so much. You've helped make my job easier several times since I joined Tek-Tips this year! farmera

Got it! Roy-Vidar gave me this hint: Instead of Set objSheet, change to: If objSheet Is Nothing Then Set objSht = objExcel.Sheets.Add Else Set objSht = objSheet End If

Thanks Roy-Vidar! That worked.

Posted to the wrong post originally! Thanks all for the help! The GetFormValue worked for the arguments error. I'm having another issue since I included all of the queries in the code: "Object variable or With block variable not set." It happens while posting the second page to the...

Thanks all for the help! The GetFormValue worked for the arguments error. I'm having another issue since I included all of the queries in the code: "Object variable or With block variable not set." It happens while posting the second page to the spreadsheet. The exact point is in bold...

PH, YOU ROCK! I mistook the strControlName as a filler for my actual control names. Thanks so much!

Thanks for the reply! I've tried it all morning but I've done something wrong. I get an error: "Wrong number or arguments used with function in query expression '((SampleDetails.KeepTest)=True) AND ((OrderDetails.CollectDate) Between GetFormValue("txtStartDate") AND...

I'm having the same problem but I have 2 parameters. How would you code the function to call both controls and use it in place of Forms!frmName!txtStartDate And Forms!frmName!txtEndDate?

Thanks SuicidEd! It works perfectly! I have another problem now and I've searched the forums but nothing specific to what I'm doing. I am using a form to allow users to select a date range for the export. I'm exporting crosstab queries to excel and everything worked great until I added...

Bernie10, thank you for responding! I've "developed", if you can call it that, a few Access db's but used very little code besides the basic SELECT, FROM, WHERE etc. I've tried several approaches: MS Query in Excel, cross-tab queries, exporting to Excel from Access. The company that...

I have an Sequel db with an Access front end. I have created a master query with all data and also created custom queries in access for each tab that I need to fill in the spreadsheet. Each tab is based on a "Site" and I need to export by date range. I would like to have this process as...