Recent content by cjany

OK, I'll try it. Thank you

Yes, but I'm not happy with the user having to expand the record to see the data.

I need to build a form that shows owner information, each property that they owe taxes to and then each tax year that is due for each property. My main form has the owner information. I built a subform for each property that is linked to the main form by name. Now I want to add a subform to...

No, I cannot update the linked table from access.

Yes, I can make changes manually to the TXEVNTD table.

Is it possible to use Access to Update fields on the AS400? I have an ODBC connection, and linked tables to the AS400. I've tried creating an update query to update certain fields. Here is my SQL: UPDATE EZTAX30DTA_TXEVNTD SET EZTAX30DTA_TXEVNTD.EI2RPLCDE = "REPLYNONE"...

Hi, I'm new to .Net. I have an ASP.Net form that I would like to use to open Crystal Reports that I have created. I successfully imported the Crystal report files into my Solution Explorer. Now I want a button on the form to open and run the Crystal Report when clicked. The name of one of...

Thanks, the 2nd option was much easier. I was trying to make it way to complicated. Cheryl

The datefields in our database are in yyyymmdd format. I have a formula field that converts to mm/dd/yyyy (date(val(left(totext({TXPYMT.PYMTDATE},0,""),4)),val(mid(totext({TXPYMT.PYMTDATE},0,""),5,2)),val(mid(totext({TXPYMT.PYMTDATE},0,""),7,2))) I also have another formula field that adds the...

I'm trying to create what should be a simple web application to pull data from an AS400 database. I could 2 routes: I currently have 2 SQLDataSource controls on my form. Each has their own select queries. I would like link those two select queries together using the casenumber field which is...

I need an SQL to update checknumbers where the 1st digit was incorrectly coded. There is a range of check numbers all updated on the same date (20061010), but the 1st digit on all of these numbers was applied with a 7 instead of a nine. Ex. 75785 should have been 95785. Here is the SQL that...

That worked great!!!! Thanks so much.

I have an Excel spreadsheet that has a column with both numbers, such as 68, and a combination of numbers and letters, such as 1D. When querying this via Microsoft query, the records with the letters show up blank. It only pulls in the records with the numbers. The column in my original...

Thank you for the explanation, I would never have figured that out.

Thank you. That seemed to have worked, but I don't understand this particular function. Could you please explain this code?