Good Afternoon Everyone,
Here is a dataset. I am trying to locate missing sequential values in the Number column. What I'm trying to query is "978G" for ID ,"2" for Number. Anyone think of a good way of doing this ?
ID Number
623F 1
623F 2
623F 3
978G 1
978G 3
Thanks
pwag
Last Activity: Jul 14 '15, 12:44 AM
Joined: Feb 14 '14
Location:
-
Find Gap In Data Column
-
Thanks jforbes. that seems to have worked. i took out the loop and it works like i want it to now.
This is what worked.
Code:Dim MyValue As String MyValue = Nz(Forms![Project]!Plan_T_Update.Form.ID, 0) MsgBox MyValue
Last edited by NeoPa; Sep 8 '14, 07:35 PM. Reason: Merged posts which were posted separately for reasons unknown. -
Hi and Thanks jforbes. What I'm trying to do is mimic the behavior of a list box. When you click on a listbox it gives you the idea value based on the bound column OR Listbox.column( 0). I'm trying to get the ID value. Thanks.Leave a comment:
-
Call Value from SubForm with On Click Event
Good Morning Pro's,
My first time trying to loop through a Subform to grab a value. I would like to call the ID value in the row I click. My first time trying this as I usually use the Listboxes click event to call a value. is this possible on a subform? to click a row and call it's ID value already present in the row?
What I have thusfar but it only loops through all the rows and returns all values for ID. Anyway... -
RODBC - LIKE Operator From R to SQL Server
Good Afternoon Pro's,
I would have submitted this question in the R group but didn't see one.
I am trying to connect to SQL Server from R with the RODBC Package. In my SQLQuery line I'd like to user a LIKE operator but SQL Server doesn't recognize my syntax. How is the LIKE operator written in R when connecting to SQL Server?
Thanks,
Here is the script.
...Code:dataset
-
Docmd.SendObject acSendReport with Report Parameter
Good Afternoon,
Is there a way to add an additional parameter to the SendObject method of the acSendReport parameter? Kind of like the DoCmd.OpenRepor t object you can specify a Report parameter when it opens.
Could look something like this...
...Code:DoCmd.SendObject acSendReport, _ "Report Name" & Parameter, _ acFormatPDF, _ .Fields(0), , , _ -
twinnyfo,
That's great as well. In this case it's sub-data so I'm hoping 52 items would be enough. Great contribution.Leave a comment:
-
Send Excel Column to .csv file
Good Afternoon Pro's,
I have an excel file with a column of data that looks like this. Iterated over a thousand times.
01/01/2009 5 Male Height Weight
11/15/2001 6 Male Height Weight
08/22/1997 7 Male Height Weight
03/04/1987 8 Male Height Weight
With each space being a single space. What would be relatively simple way to read this out to a .csv?
Thanks,
P -
Jim,
That nailed it. =Chr([BulletNumber]+64)
Thanks!
PLeave a comment:
-
Lettering Bullets in MS Access Reports
Good Morning Pro's,
I'm in search of a solution in MS Access Reports. I'm aware of the Number bullets trick where you set control source of text box =1 and Running Sum(over the group). I was curious if someone had a "relatively " straightforward solution for Lettering over a group instead of numbers. Kind of like MS Word does. So final appearance would look kind of like this.
A.
B.
C.
... -
Hi Zmbd,
Wow. Great resource. Thanks for sharing those links!
PLeave a comment:
-
Thanks Jim. I have tried this and it appears this will also require a New Group in Outlook to be created along with giving all users of that group "authority" to execute outgoing mail on behalf of? Getting deeper.....Leave a comment:
-
Change "From:" Field with Automated Email From Access with Outlook
Good Afternoon,
I have found a Function to automate Emails from Outlook through Access. I was curious if there was a way to change the sender information when sending the email, specifically just name field? My code only delivers the originators information, rightfully so, since the mail was sent from that senders desktop. Is there a way to declare a sender NAME prior to sending the email?
So, in the recipients Outlook... -
Hi NeoPa,
Thanks! Exactly what I needed. I used this(a variation of your example):
Code:HAVING (Count(ColumnA))=(SELECT Count(ColumnA) FROM Table WHERE ID = ID);
Leave a comment:
-
VBA SQL - Filter Group By Over entire Group
Good Morning Pro's,
I am trying to write a script that selects a group based on the criteria within that group. I'm looking to pull in only records that meet that criteria.
With the GROUP BY, SQL will pull in my GROUP even if there are two records with 'A' or 'B', rightfully so. I'm trying to only select the group when all Columns meet the...Code:SELECT ColumnA FROM Table GROUP BY ColumnA HAVING ColumnA = 'A'
-
Just figured it out. Thanks.
Code:Dim lngRow As Long With Me.Listbox For lngRow = 0 To Listbox.ListCount - 1 If (Me.Listbox.Column(2, lngRow)) = "OC" Then Listbox.Selected(lngRow) = True Else Listbox.Selected(lngRow) = False End If Next End WithLeave a comment:
-
Sorry. This line is incorrect
It's really.Code:For lngRow = 0 To List489.ListCount - 1
Code:For lngRow = 0 To ListBox.ListCount - 1
Leave a comment:
-
Auto Select Items in Listbox based on Column value
Good Afternoon,
I'm trying to auto-select items in a multi-select listbox based on a column's criteria in a VBA Sub. Here is my code thusfar that fails. All values are text data type. Any suggestions? Thanks.
...Code:Dim lngRow As Long Dim lbvalue As String With Me.ListBox For lngRow = 0 To List489.ListCount - 1 If (Me.ListBox.Column(2, lbvalue)) = "OC" -
I have developed a different solution. I positioned a check box behind the button. Alternating logic with this check box True/False, it fires ASC/Desc.
Thanks!
PLeave a comment:
-
Hi,
The code is written in VBA. Yes, I meant to say "parenthesi s." I said "brackets," in the previous post. This code works for on sort change but gettting it to switch back and forth between ASC and DESC is still on the horizon.Leave a comment:
No activity results to display
Leave a comment: