Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
CONCATENATE IN EXCEL...
In order to get the name formula to work, you must copy it to all 750 rows. There is no way to create a "calculated column" in Excel.- NancyS
- Post #6
- Forum: Microsoft: Office
-
*** INSERT INTO ***
Don't know what happened to the rest of my code. Here it is again...<br> <br> Dim sql as string<br> <br> sql =- NancyS
- Post #4
- Forum: Microsoft: Access Other topics
-
*** INSERT INTO ***
dim sql as string<br> <br> sql =- NancyS
- Post #3
- Forum: Microsoft: Access Other topics
-
What's going on here?
How are you updating your underlying tables and where are you filtering your records from. If you are filtering them from a form, are you refreshing your form after updating?- NancyS
- Post #2
- Forum: Microsoft: Access Other topics
-
Display the last n records in a subform
I would get the record count of the recordsource of the subform, then loop through the last n records and change the recordsource of the subform to " where identityfield = {the identity fields of the last n records}" Off of the top of my head, this is what I come up with...<br> <br> J = 0<br>...- NancyS
- Post #3
- Forum: Microsoft: Access Other topics
