Recent content by WaterGeek

dhookum, Damn! I'v gotten so much from these forums I thought that I finally knew enough to actually help someone else! I have to admit that i do not realy get the distinction of continuous forms...I have read the help files. Is a contious form the same as datasheet view?

Assuming that you have a form with a text box for each column. Add a form load event (and probably an after update event to each text box) Try something like this: Private Sub Form_Load() If Me.ProductOfficeTextBox.Value = Me.ProductsOldOfficeTextBox.Value Then...

I have an oracle database and I am using Access 2003 for the front end and reporting (read only - data is entered from a web interface). In an ideal world I would design my reports to run on the server side in a web interface but I'm not an IT guy and our IT dept is understaffed so I am stuck...

here is the code from the snippets: ********************************************************** ' Given a document name, a worksheet name, and a cell name, get the column of the cell and return ' the content of the first cell in that column. Public Function XLGetColumnHeader(ByVal...

I have figured out how to use some of the code snippets for the open xml sdk to create a drop down list of all the sheets in an excel file. I am using vb.net 2008 express edition. I can also use the code snippet to get the value of an individual column header. What I want is a drop down list...

PH - the count aggregate lead me to the sum which seems to be the soultion: 1) a select query with one expression field for each possible service returning a 0 if the service is not offered, 1 if it is 2) a sum query, grouping on company id and adding all service fields I think it can be...

I did try a cross tab query, but I kept getting error messages saying that I needed to do a calculation on each of the fields. When I searched on-line for cross tab info all the examples were of summations or averages so I did not think it would work for me.

I am trying to make a report in Access. All of the data is in an oracle database that I connect to through ODBC (instaclient 11_1, sorry I am not positive which version of oracle is used). My finished report should provide a list of services provided by a company, there are 28 possible...

Wow, that was a simple fix...but I pobably would never have found it! Thank you

I have learned a lot from reading these forums, but this is my first post... I have a form with button to export different queries to an excel file. The query exports fine but my error handler runs every time. I have other forms with the same error handler format and the problem does not...