Search results for query: *

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?

I have a query with a parameter prompting for a date range, (Between [Enter 1st date] and [Enter last date]). In the report which pulls data from this query, I need 2 total fields which pull the totals of an assessment amount for each type of account. CourtCosts: totalassessment...

I am breaking does case numbers that are in many different lengths and ranges. I have most of the case numbers broken down, but now I'm having a problem converting my year field to differentiate between case numbers from 1999 and under and 2000 and over. Here are my examples: GV101549...

That worked. Thank you so much.

I have case numbers from 2 different systems that I'm trying to compare. The case numbers can be different in a different format in both systems, but if I break them down, I should be able to do a good comparison. In one system, each portion of the case number is concatenated from several...

I would like an option button on an Access database form to close the current database and open another database. Any suggestions?