Search results

email Field on a form setup as hyperlink. Client would like to remove this, easy enough... However, in our quest to remove link...notice that over half of the 9k+ addresses have extra added on to the end of email addy. example: this is at end of email addylink...

this was an easy fix. I took out the save record button. It automatically saves on the subform with the cliendID link.

I have this form. It's been running correctly until.... They wanted yrs of data purged. I ran a query to find the Client ID's with old yrs and no activity. Appended to the structure only of a new table. Replaced/renamed old table with the new data and changed the new table name to what it was...

Perfect CJ London. Thanks a million.

I have a main report with no recordsource. on this main report are 6 subreports all using a query with TBLNewMthlyClients as their recordsource. I want to use this same table on the main report in an unbound control to give me the min and max intakedate that this report is being run for. the...

Trying to place a title on a report with many subreports all using the same table. Included in this table is a date field. ="Between " & Min([TBLNewMthlyClients].[IntakeDate]) & " and " & Max([TBLNewMthlyClients].[Intakedate]) get a #error on report run. Obviously, control not correct...

There are numerous controls on numerous pages of the main form...(bad design..) the query would be really complicated. the subform table needs populated by all the controls on the numerous pages. Over 40 controls. then subform will show on all pages with updated data.

I have a main form which has a couple of controls being populated with a query. I want to have those controls (if null) inserted into a subform containing a table. Where do I put the expression Insert Into on that control? After Update? Any and all help appreciated.

I like that...thanks...

IT's only showing 6 levels to put a criteria in... actually showing 9 levels. These will be OR criterias.

How do we run a query that has 20+ fields needing a criteria of is not null in each field?

The fields are the Issue ID and Barrier Strength. The red number is the IssueID

I've attached a screen shot. The items in red need updated to the subform on right. Currently they are input manually to subform. How do I update?

We exported the data to a new db and got it working how we needed. Was almost 400k records so tough to find that 1 record that was not a date/time. As far as I know, no math or conversions...but, I'm not sure of the background db. It was a sql db. Thanks for the help.

I've attached a pic of error message coming from running a query. Any insight? I'm not familiar enough with DB's connected with ODBC. The field in table is setup as a date/time field.

way too simple.... The fog has not lifted.... :)

Have a current table with an autonumber field already included. I need to create a field in same table to increment numbers by 1 since we can't have 2 autonumber flds in a table. How do I make this happen in a table? I know how to make it on a form in a control but not as a table field...

They're going to have to go with higher numbers for the invoices going forward. Don't want to jump through all these hoops for 1 number. I'm making an executive decision here, :) As long as the number is unique, shouldn't be an issue. Thanks for all your help

User would like the InvNbr to be autogenerated in there table. The field Invoice# is currently text. So, I've created a new field in a copy of the structure of the PayRcvdTable .....InvNbr I was able to get it started at the correct number in the new copy of a blank table. However, How do I get...

the combobox is named selactivity on the form I created.