Recent content by Memnoch1207

My assumption is the 10.0 library is for XP and the 9.0 is for 2000. I would think that the 10.0 would be (backward compatible) so as to allow any version of Excel to open with that object library. [This message has been edited by Memnoch1207 (edited 05-20-2002).]

What do you currently have your recordlocking option set at??

I agree this is possible, but I also think it will be extremely hard. Here is how I would try doing it. create you form. Place an email cmdbutton on the form. That cmdbutton is going to call the advapi32.dll Library, which you will need to code it to open up an instance of Outlook (assuming...

Mydate RepID SCategory Number HCategory Number what i need to do is create a new field on the query line Total: Scategory number sum subtract Hcategory hand number sum + hcategory recieve sum Where does the Hcategory hand number sum come from???

The best way to go about this is to create a parameter query, to select the year. Then create a report based on that query. When you open the report it will prompt you to enter the year you would like to view.

something to the effect of If(fields.visible = true) then count = count + 1 end if Basically, if the fields are visible then add those fields to the count, otherwise don't.

You will want to create a parameter query (F1 type parameter queries, for more info) to allow the user to input the value of 'X' for the particular field you are wanting to sort by.

You have your map w/ the buttons. Then you have your (lets say 3) reports. the reports are already created. Your buttons on your map should have some code to get them to open teh specified report. Lets do Dublin. The button you hit to show the dublin report should have this code under it to view...

If you have time post ur code. I'll take a look at it, and see how I can help you.

Not sure how your DB is setup, but you could use a msgbox and if...then...else statement to trap it...kinda like this if num = another number in the num field then msgbox "You have entered a duplicate number." end if

n = row number count = total rows 2nd column:[row number / SUM[total rows] + 1]

You will want to do something like this. if IS NULL(txtdate.text) then txtdate.visible= false else txtdate.visible= true end if OR if Len(txtdate.text) < 1 then txtdate.visible = false else txtdate.visible = true end if this last one checks if the length in the string is less than 1...

Trying categorizing the report based on shift not on date.

You could do it something like this. In a textbox allow the user to input an item they want added to the list or combobox. then on the "add item" button add code similar to this. combo1.additem & '"txtbox.text" your telling the combobox to add the string that is in the txtbox.

The code you wrote to find the first character would be the same, just advance the code to use the second character.