Recent content by jonnj

thanks dhookum and Mazeworx for the reply. I got it working, I created a strsql and positioned properly and also I had edit some table field names that I had to then edit in the query.

Duane, Thx for the reply. I understand what you mean, and what I have done is added a combo box to a form and in the query criteria I have now have: forms![fexp]![text0]. This however still errors out at: Set objrs = objQDF.OpenRecordset. It's frustrating because I dont undertand why the...

I am trying to export a parameter query into a template excel sheet. If I run the query as a select query, the code runs perfectly, however I can seem to find the right code to do this as a parameter query. What eventually I would like to do, is have this execute from a combo box on a form. The...

TheAceman1, I am aware of what the MS 'help' says. Many times here, I know programmers find ways around microsofts' protocol, and was hoping someone here might have a work around for this. Thx for responding tho. John

I want to export a ms query to an excel sheet template to a specific cell range. I would like the export results to begin at cell "a6". I have googled myself to exhaustion, trying many suggestions. The common opinion is that the following code should work, (but it does not for me)...

Gammachaser, your solution work perfectly. Thanks very much

I have a data entry form that I want to populate the age field automatically when the (field) last name(after update event) is entered ( previously in table). I have used this dlookup: DLookup("age", "general info", "[Age] = '" & Me.Age). This bombs. I have tried some many variations I've lost...

I have solved my own dilemma. I put the form on the switchboard in the"add" mode when it should have been in the "edit" mode. However I would like to understand why it bombed in the add mode and works in the edit mode. John

I have a form with an unbound combo box(row source a table). When anything is clicked from the combo box it brings up data in a sub form. When I use the form from the navigation pane it works fine and correctly but when I call it from the switchboard it bombs with a run time error 3021,(no...

Thx dhookom that solved my problem.

I have a report that simply has first name, last name and the division they are in, Either Div 1, 2 or 3, I want to total the number of people in each Division. What started off as a simple task I thought, has become a headache. I started with(for example): =Dcount("[Div]","Gen...

Good Morning Everyone, I have a text box on a form in Access 2003 that pulls in an environment variable I have established. I upgraded to Office 2007 and now that text box shows the error - #Name. I have disabled the trust relationships, however this did not solve the problem. Does anyone...

Mark, Thx for the reply. I was hoping to avoid redeploying and was trying code like the one below. I can't seem to grab the correct language and make it work. I was looking for soemthing simpler in the script? Any other suggestions for code?? strComputer = "." stremail= "aol.com" Set...

Hi everyone, My company is migrating to Microsoft Exchange Server, but many of the employees still have a pop3 account. What I would like to do without user intervention is to run the vbscript listed below in a nightly push and delete any pop3 accounts and just leave Microsoft Exchange server...

Hi PHV... Not only was that the starting point..it was the solution. I had something close to this with vbdirectory, but couldnt put all the pieces to together nicely the way you did. Thank you very much, your time and help Hope you hit the lottery. John