Search results

Question: is there always an "x" and a "y" for each site in table 1 ? Sounds like no. So you need: 1) sites with x and y 2) sites with x only 3) sites with y only and then put it all together. Right ? Start with this and we can move forward. RichM

Try some forums that deal with ASP and/or ASP.Net Do a Google search on "ASP forum". "DAP" is dead technology I believe. RichM

You buy "Speed Ferret" from Black Moshannon Systems. Look it up with Google. RichM

Rob, Yup, just one of those days. RichM

You have to create a *function* that returns a value. I don't know what you mean by "looping through the combo box" If you want to present a list or combo box with all stuff that meets some criteria, then make a *query* and use it as the RecordSouce of the combo box. Use the *function* as a...

Agree with Wayne's reply. Make a module with functions to "read" and "write" parameter variables. This is much better than using the name of an open Form. RichM

You probably don't need to "combine 2 rows". If you want the total for a Memeber, create a query with Group By on Member. HTH, RichM

Chris, Another option: in the Caption property of the report, enter "Ctrl + P to print". Then open the report in view mode. The user will see "Ctrl + P to print" in the top of the view window. The user can key "Ctrl +P" to open the print dialog window. RichM

Clive, The pain goes away after a few drinks. RichM

Martijn, I don't have time to examine your code. But I can assure you from my experience that DAO works well in Access 2000. DAO is the preferred interface if you are using native Access tables. RichM

In the 21st century, you use "Property" procedures instead of global variables. Create a module, call it "modProperties". In the module: Private PstrYourString As String Public Property Get GetYourString() As String GetYourString = PstrYourString End Property Public Property Let...

"sproc" ? That's a new one ! I like it. You create an ADO connection and specify the provider, user id, password, etc. Then you create an ADO command. In the command text you put something like this << "{call APSNOA_pkg.get_apsnoasdi (?,?,?, {resultset 1000000," _ & "Eff_Date...

Jon, This is how I report on Oracle mainframe data using Access as the front end. First, a mainframe DBA creates a stored procedure to select data. This procedure accepts parameters, usually a from date and to date. I write a function to call the stored procedure. The function uses ODBC and...

Jon, You have an Access front end MDB. You can link a mix of back end tables from native-mode Access and SQL Server. But.................. if you try to join Access tables to SQL Server tables in a query, the query will suffer a huge performance hit. If you do need to join tables in a query...

I looked at some old code I use for locking and unlocking controls. In the loop that goes through the controls collection, I think you need something like Set ctl = frm.Controls(index) before you refer to a property of the variable "ctl". RichM

Try ctl.[Enabled] = True instead. I think that will work. RichM

It depends on how you use reference tables; do you want to return one value or many ? do you want to join other tables to a reference table for report grouping ? If you are using a reference table to look up one value, sort of like an old fashioned "INI" file, then a single table with...

It sounds like you would have an easier time if you: create a table with fields set to the lengths you want, put values in the fields - align as you wish, export the table to a fixed-width text file. Forget the "Format" stuff. RichM

You wrote << My question is...Is it ok (i.e. safe) to copy all of the DLLs that are being referenced and paste them into a seperate folder on the shared network drive? That way I could reference them from the network drive and every user would be using the same version of the DLL. >> I don't...

Sean, You wrote << When it says "performs migrations", I thought that it meant either exporting the tables or just updating an Oracle db from an Access one. Wouldn't that be the case if the Oracle db was already set up and working properly (with triggers set, security in place, etc... ?). >>...