Search results

I use a public function to return the public variable. This works in all aspects of a query. Public MyPublicValue As Integer Public Function GetMyPublicValue() As Integer GetMyPublicValue = MyPublicValue End Function Used in a query like: GetMyPublicValue()

? Take the chart out of the detail section and put it in the footer?

So, you're putting this into a field in the query grid, and you're replacing MyNumericField with your actual field name?

If you want the total in the last row of the datasheet, you can make a totals query that contains all the same field names (aliases) and then union it to the other query. (I don't know if this is a 'best practice', but I have done it for an ASP page...and it works fine.)

If you are talking about VS.NET 2003, I don't know of a built-in server...VWD 2005 Express (free version) has a built-in web server emulator. I take it your limitation is that you have WinXP Home? Regardless of what MS says, you CAN run IIS on WinXP Home...it's just not a straight-forward...

I don't know what SEM is, but this returns a number: SEM: StDev([MyNumericField])/(Count(*)^(1/2))

I haven't done this, but apparently you can use this: Session.LCID = 2057 in your global.asa file. See this page. I have been using a function to fix my dates. That's pretty straight-forward as well.

If you just want to open it and that's it, put a button on your form and put this code in the onclick event of the button... Application.FollowHyperlink "C:\MySlideShow.ppt" (Obviously, change the path and name.)

So can you add a yes/no field to your question table? If you are using 60 queries for this, there's a problem. Have you read this post?

www.slipstick.com is a good place to start.

In the report's properties sheet, under the events tab, create a new event procedure for the "On No Data" event. Put something like this in the sub that is produced in the code window: Private Sub Report_NoData(Cancel As Integer) Cancel = True MsgBox "The print action was...

Looking for thoughts/inspiration on this: -Currently designing a process mgt app. -Process flow is pre-defined, but subject to change. -Flow consists of milestones with cumulative workday suspenses. -Some milestones are subsets of other over-arching milestones. -The project will flow according...

Right on! I have never seen the keyword "First" used. Brilliant! Thank You... (You now get some reputation.)

Hello All, In my table, I have some records that are duplicated (aside from the primary key). How can I select only one record from each set of duplicated entries? (There may be more than 2 of each of the duplicated records, but I only need to pull one of them...doesn't matter which one.)...

You didn't say what development platform you are using...if you don't have Visual Web Developer Express 2005 , get it! It's free from the MS site, and it seriously simplifies data-enabled web development. If you're stuck with using what you have...you need to elaborate on what you're asking.

Either: Create a recordset in code that matches the subform's. -or- Add a form footer to your subform, add a text box to that, make the control source "=Sum([MyField])"...you can refer to that control in code to get its value. ...at least I think that will work. Let me know.

Try this: SELECT Format([Batch Data].[Date],'General Date') AS formDate FROM [Batch Data] ORDER BY Month([Date]); Orders by month only...regardless of year.

The way I understand it: If you have a doc in a folder named "index.*" or "default.*" then the web server will deliver that document given only the domain and folder names. This address: www.MyDomain/MyWebFolder/ ...will pull this document automatically...

This will happen automatically if you have your subform controls set up with the proper Master/Child field relationships to the main form. If you haven't done this, right click on a subform control and select the data tab...you will see the Master field and Child field.

Nice one. That is amazing!