No announcements
Found 3710756 threads
-
0 VotesAccess VBA Debugging Record Set
When it gets to the first Record Set field to populate, it's not fulfilling that and then stopping at the next field.Answered | 5 Replies | 1579 Views | Created by PSULionRP - Friday, September 7, 2012 1:06 PM | Last reply by PSULionRP - Friday, September 7, 2012 2:19 PM
-
0 Votes
Get latest record only
Are you looking fro the below: Drop table t11 Create Table T11(ID int identity(1,1), Name Varchar(50),Status int,licenceID int) Insert into T11 Select ...Answered | 2 Replies | 939 Views | Created by Omar.Jabr - Thursday, May 23, 2013 9:51 AM | Last reply by SQLZealots - Thursday, May 23, 2013 9:58 AM -
0 Votes
Combine 2 records into 1 record
You don't say if you always have two records for a bidirectional relation in your old system or is something, you only have one without the other.Answered | 4 Replies | 3328 Views | Created by Geert Mathijs - Friday, October 21, 2011 12:28 PM | Last reply by Hasham Niaz - Monday, October 24, 2011 1:54 PM -
0 Votes
VB.NET and Access record pointer
After you add to the local dataset, then update the database, you have to re-read the dataset to get the updated key value from the database.Answered | 7 Replies | 954 Views | Created by Keith54AL - Monday, February 9, 2015 1:03 AM | Last reply by Keith54AL - Tuesday, April 21, 2015 3:22 AM -
0 Votes
Access and ASP - Reading and displying record set with LIKE operator - ONLY GET 1 record
User-1199946673 posted these forums are for ASP.NET (.aspx) only, for classic ASP (.asp) questions, find another forum....Answered | 6 Replies | 66 Views | Created by Anonymous - Monday, September 12, 2011 1:48 PM | Last reply by Anonymous - Monday, September 12, 2011 3:20 PM -
0 Votes
Update first Record only
It looks like I'm almost there - but now all the matching records in table2 is updated, but I only want the first record in table2 to be updated.Answered | 13 Replies | 2025 Views | Created by HCMJ - Wednesday, May 21, 2014 11:13 AM | Last reply by johnqflorida - Thursday, May 22, 2014 2:03 PM -
0 Votes
Set Property of text box on one record only
The only way to change the formatting of controls depending on the data in a record is through Conditional Formatting.Answered | 2 Replies | 356 Views | Created by Nueby - Thursday, November 26, 2015 7:22 AM | Last reply by Lawrence Ellefson - Thursday, November 26, 2015 6:27 PM -
2 Votes
Getting started with Active Record
One I am working with an Oracle Database and not SQL Express and 2 I am working with WPF and not ASP...Answered | 5 Replies | 3833 Views | Created by dino2dy - Wednesday, January 9, 2013 9:04 AM | Last reply by Ed Price - MSFT - Wednesday, January 23, 2013 6:09 PM -
1 Votes
Make a form add only one (1) record
Instead, try using something more like: Me.subformcontrol.Form.AllowAdditions = (Me.subformcontrol.Form.Recordset.RecordCount = 0)Answered | 6 Replies | 4076 Views | Created by RedGalaxy - Sunday, November 27, 2011 9:00 AM | Last reply by RedGalaxy - Monday, November 28, 2011 8:21 AM -
0 Votes
Accessing the current record in a DataTable
This would be great for setting some default field values for instance.Answered | 6 Replies | 3003 Views | Created by Andy Coultiss - Friday, August 28, 2009 11:00 AM | Last reply by Andy Coultiss - Wednesday, September 2, 2009 1:45 PM -
0 Votes
How to make a screen or the record read only based on In-Active option
1+1 = 3 for large values of 1Answered | 1 Replies | 2435 Views | Created by bullet117 - Thursday, September 15, 2011 7:08 PM | Last reply by Kostas Christodoulou - Friday, September 16, 2011 12:32 PM -
1 Votes
Import records then set AutoNumber?
On any forms where the user was able to enter or change that field, it will switch to read-only.Answered | 5 Replies | 3115 Views | Created by KCDW - Wednesday, September 28, 2011 2:40 AM | Last reply by Armen Stein, MVP - Friday, September 30, 2011 7:06 PM -
0 Votes
Unable to get records using Like Operator In sql server
I ahd to use Ltrim,Rtrim functions to get the results.Answered | 3 Replies | 3220 Views | Created by mm6969 - Wednesday, September 12, 2012 1:59 AM | Last reply by mm6969 - Thursday, September 13, 2012 10:38 PM -
4 Votes
LEN as a criteria to an ADO Record Set
This is for an in program record set and has nothing to do with the form's record set.Answered | 14 Replies | 4339 Views | Created by Robert Mernick - Tuesday, June 21, 2011 8:44 PM | Last reply by Dirk Goldgar - Wednesday, June 22, 2011 6:39 PM -
4 Votes
Alternative to NOT in operator to get the latest records
Try using openquery to perform a pass through query (all work including filtering is done on the remote server and only the matching results are returned.)Answered | 7 Replies | 5140 Views | Created by Aniketm - Wednesday, December 21, 2011 8:41 PM | Last reply by Arulmouzhi - Friday, January 17, 2020 2:24 PM -
1 Votes
List only getting the data of the first record
The structure of my report is there are multiple text boxes like To get a list you have to use a tablix control ...Answered | 2 Replies | 779 Views | Created by Ali Mohsin_ - Monday, May 19, 2014 12:27 PM | Last reply by Jumbarilla - Monday, May 19, 2014 1:58 PM -
0 Votes
Consolidate Like-records in Queries
Hans, Thank you so much...Such a simple solution and it feels like it was right under my nose.Answered | 2 Replies | 1710 Views | Created by Eric7361 - Monday, May 14, 2012 2:14 PM | Last reply by Eric7361 - Monday, May 14, 2012 6:46 PM -
4 Votes
Somehow a new record got created by a read-only user
But that button is not displayed for read-only users.Answered | 4 Replies | 403 Views | Created by AllTheGoodNamesWereTaken - Thursday, April 23, 2015 7:44 PM | Last reply by Lawrence Ellefson - Tuesday, April 28, 2015 3:35 PM -
0 Votes
Access 2010- Restricting a table to contain only ONE record
Like INSERT.Answered | 7 Replies | 9173 Views | Created by Steven Schuyler - Tuesday, May 24, 2011 2:36 AM | Last reply by AccessVandal - Tuesday, May 24, 2011 7:58 AM -
0 Votes
For Loop and declaring a record set
Also its possible to use GROUPING SETS to apply multiple levels of aggregation in the same ...Answered | 2 Replies | 549 Views | Created by Hey Kish - Tuesday, October 2, 2018 12:48 PM | Last reply by DIEGOCTN - Tuesday, October 2, 2018 12:57 PM - Items 1 to 20 of 3710756 Next ›
No announcements
