How To Find SQL Group Names
Jun 8, 2006I have an Access front end linking to an SQL Server back end. My question is: Using VBA, how can I find the Group Names for groups I've got set up in SQL Server?
Thanks in advance to all who reply.
ADVERTISEMENT
Queries :: Find A Way For Access To Find Unique Dates And Unique Names?
Aug 1, 2014I have been working on a simple data base for some time now (beginner level) and am still trying to improve it. I would like to do something but before that I would like to have your opinion to know if it is even possible?I have a query QryMainReport:
Start Date/Time
End Date/Time
Employee
At the moment this is what the format of my report looks like (I removed other unnecessary fields):
StartTime----------EndTime---------------Employee
12/06/2014 01:00--12/06/2014 03:00------John Smith
12/06/2014 04:00--12/06/2014 06:00------Jane Doe
13/06/2014 02:00--13/06/2014 05:00------John Smith
13/06/2014 08:00--13/06/2014 08:00------Jane Doe
I would like to do as a report. (Dates would always be from Sunday to Saturday). I am not sure it is possible to do that. I suppose first it would mean:I would have to do a query to separate the times from the dates?I would have to find a way for Access to find the unique dates and unique names?Does it mean I have to use cross tab queries?
How To Find Names Of Relationships
Mar 23, 2006After you've created relationships between tables, does anyone know how to find the names of the relationships?
Thanks so much in advance!!
Queries :: Find All Field Header Names Containing String
Mar 21, 2013I need a query to find all the field header names that contain string "PL-" and along with records contain a value with the field name containing "PL-" within a Access DB table.
View 3 Replies View RelatedModules & VBA :: Find All Table Names From External File
Nov 6, 2013I'm trying to find all the table names inside an external access file from a path.
I have a code for the user to select a file which return a patch to the file.
Then I need to find all the tables names from that file and append them to a list.
so I them can input them into a code and link the tables.
here is the code to get the file patch:
Code:
Function getFileName(path) As String
Dim f As Object
Dim varFile As Variant
Dim path
Set f = Application.FileDialog(3)
[Code] ......
Find Top 2 In Each Group
Nov 9, 2007I'm trying to create a query that lists the last TWO entries (meter_read_date) and grouped by each distinct meter (meter_sn). ** In other words, I have a table with three fields (meter_sn, meter_read_date, meter_read_count), each month people input there meter readings. I want to create a query that will list each distinct meter_sn with the last two date entries.**
This is what I have, but it lists too many from each meter...
SELECT UTIL_METER_READ.METER_SN, Max(UTIL_METER_READ.METER_READ_DATE) AS MaxOfMETER_READ_DATE, UTIL_METER_READ.METER_READ_COUNT
FROM UTIL_METER_READ
GROUP BY UTIL_METER_READ.METER_SN, UTIL_METER_READ.METER_READ_COUNT
HAVING (((Max(UTIL_METER_READ.METER_READ_DATE)) In (select top 15 meter_read_date from util_meter_read ORDER BY METER_READ_DATE DESC)))
ORDER BY UTIL_METER_READ.METER_SN DESC , Max(UTIL_METER_READ.METER_READ_DATE) DESC;
Queries :: Keyword Search - Find Field Names Of True Checkboxes
Jul 10, 2013I've recently finished constructing a database that uses forms with checkboxes i.e. when a user opens a form there are several checkboxes associated with labels, but the table only stores the check-boxes and the form labels are the field (column) names on the table.
Now, what I'm trying to do is create a search feature whereby if a keyword search is conducted, a search through the column names from the table with checkboxes takes place and only lines (rows) with true (checked) checkboxes are returned.
Using 'Group By' To Find A Specific Record...
Oct 10, 2005Hi,
I have a table with various customer items, a current price and the date the price changed.
EXAMPLE DATA
CustID/ItemCode/DateChanged/Value
AAA 21 01/01/2004 £3.00
AAA 21 01/06/2005 £5.00
AAA 21 01/03/2005 £4.00
AAA 22 01/01/2005 £6.00
AAA 22 01/06/2005 £7.00
BBB 25 01/01/2005 £8.00
BBB 25 03/07/2005 £9.00
BBB 26 01/06/2005 £1.00
BBB 26 01/09/2005 £2.00
Note: Dates are in "dd/mm/yyyy" format. Also, not all data is in order in the table. It’s not how I would have designed it but that’s what I need to work with!
I would like to run a query that groups by custID & itemcode and also the most recent date for any price change. I would then like the query to display the relating price for the record it pulls out. (EG for custID 'AAA' and item 21, it would display the price of £5 as that is the value for the most recent price as of 01/06/2005)
I then want to link the custID & itemcode to another table that has sales in, to check that we are using the most recent price.
Is there a way I can do this via a query or do I need to put some code together?
Cheers
Red [CODE]
Field Names Don't Match Names On Form
Nov 7, 2006I have a form with several data fields on it. I also have a button on the form that allows the user to duplicate a record . The reason for this duplication is so that if there will be an additional client record for the same customer, but only one piece of data will need to be changed, it's easier to copy the record and then change the one field.
However, I am getting the following message:
"some of the field names you tried to paste don't match fieldnames on the form"
and then not all data in all fields gets duplicated.
I need to figure this out, but am going nuts with it. If anyone has an idea or two they'd care to toss my way, I would be happy.
Thanks one more time, in advance!!
Reports :: Repeating Row Names And Column Names
Jan 17, 2014How can I repeat column names and row names on multiple pages of the report ?
View 1 Replies View RelatedReports :: Sum Group Items By Specific Item And Hide Details Of Group Summing
May 29, 2015Despite Google I can't seem to figure this out.
I have some data in a format similar to:
Name / Style / description / speed / distance
john / driver / careful / 80 / 5500
mary / driver / careful / 70 / 7000
pat / racer / reckless / 100 / 6000
anne / driver / careful / 75 / 1000
peter / racer / reckless / 110 / 6500
don / snail / slow / 60 / 6000
I want my report to total by style, without details and to look like:
driver careful 13500
racer reckless 12500
snail slow 6000
How do you get a report to sum the group items by a specific item and to hide the details of that group summing?
Reports :: Control Group Expression For Group In Report?
Mar 28, 2013Is there a way to have an expression in the control source of a text box in a report, that re-starts or is exclusive for every group within the report?
View 5 Replies View RelatedForms :: Option Group - Warn User When Neither Of 2 In Option Group Not Ticked?
Jul 25, 2013I stumbled upon the Option Group function just yesterday and, happy as a clam, I created a group with 2 options in radio button style. I assigned the values to a field called Registration_Type as the 2 options are "Confirmed Registrants" and "Prospective Attendees".
[Great. That part works well. When I look at the table, a 1 or a 2 is in that field so it's great to know how to control accidental ticking of radio buttons (previous 450 records or so didn't have this option group functionality so one might easily tick one of the buttons. So one part of controlling option group I know I can handle via the table itself for now.]
The challenge is how to ensure the user always ticks one or the other ... I went back to the main table and tested the 'required entry' option for the Registration_Type field but forcing an action like this is not ideal in my mind. The usual error message vagueness for the average user is no good and I don't want to limit the user so much.
Is there a way to simply have a popup come up warning that neither radio button was ticked? Perhaps something linked to the form - i.e., maybe "after update"?? I only learned about attaching code to before and after update on controls a couple of days ago, so not sure if this would be best approach.
Just something to let the user know that nothing has been ticked in the option group as that controls in which of 2 reports the data will show up in so any record not ticked might mean a registrant being left out, which would be rather disastrous <g>.
A Word Find Can't Find
May 23, 2005A customer's name is SZEE. Seek him through the SName textbox with Find, and Access can't find him. (Same in the table.) Seek him with a wildcard Sz* and there he is.
I've tried it on another machine - also with Access2k - and it's the same.
Is it an Access quirk? Is there an answer? (The client asks why. Be good to be able to say.) Cheers.
Names
Apr 19, 2005I have a feild that requires firstname and lasatname for input.
How do I set it up so that is will takie the first name and Capitialize the first letter and do the same for the last name.
Ex: enter: john smith
needs to be: John Smith
Same thing for Company name
ex: the best company
need: The Best Company
I need it this way for a mail merge document I need to use
Parsing Names??
Apr 11, 2006I am trying to do the following
If any one of you have experienced Abacus ticketing system, each reservation is comprised of a group of names as follows
1.1 Gul/Mohammad Atif Mr 2.1 Gul/Mohammad Adil Mr
3.1 Bond/James Mr
I have to copy the above data from the abacus tcketing system into a text box.
My question is how can i devide the above three names into three seperate text boxes.
Field Names
Oct 31, 2006If 2 tables have a field named 'EmployeeID' (for example), are you screwed when it comes to queries and vba, as far as selecting fields / specifying data goes?
Thank you!
Control Names
Dec 26, 2006Once a control has been named and referenced a couple of times it becomes a fraught task to rename said control.
Is there an easy way that controls and their references can be globally renamed, so that the DB continues to work?
Field Names
Jul 27, 2006I need an opinion. I'm new to access so I'm really lost I have to create a database consisting of 20 clients. Then they gave me 4 steps I had to accomplish:
Create a total of all account balances, so the total number of recievables are known.
For each account, calculate the number of days each balance has been outstanding.
Classify the account into 4 groups three late (30,60,90 days overdue) and one current (under 30 days), Total the amount of outstanding recievables for each catagory.
Sort using number of days balance is outstanding as primary sort key and outstanding balance as the second sort key.
My question is should I make a field called Days overdue and a separate one for outstanding balance. It also seems they want me to do calculations in the table. I thought that was not an excepted taboo? Are the 4 goals possible to accomplish in access? Please give me some help!
Using Control Names In SQL
Jul 14, 2005I am creating a query that retrieves data from one table and creates a second table. I want to name the columns in the new table using the contents of the controls from a form within the same mdb. The form will be open when this query is run, but I am having trouble creating and saving the query.
Here is a sample of what I am trying to do...Any help is greatly appreciated!!
Thanks
SELECT IndividualHolidays.SU, IndividualHolidays.SSN, IndividualHolidays.Init, IndividualHolidays.LName,
Max(IndividualHolidays.NewYearsDay) AS Forms!HolidayDatesEntry!NewYearsDay,
Max(IndividualHolidays.AftNewYears) AS Forms!HolidayDatesEntry!AftNewYears,
Max(IndividualHolidays.PresDay) AS Forms!HolidayDatesEntry!PresDay,
Max(IndividualHolidays.AftPresDay) AS Forms!HolidayDatesEntry!AftPresDay
…<etc>
INTO HolidaysByEmp
FROM IndividualHolidays
GROUP BY IndividualHolidays.SU, IndividualHolidays.SSN, IndividualHolidays.Init, IndividualHolidays.LName;
Lists Of Names
Sep 2, 2006Hello all, I wonder if anyone can help me.
I have two queries which are both similar. They consist of a list of names with a ‘count’ function to see how many times that the name occurs. Some of the names in the two lists are identical and some are different.
I am looking to create a query (or smoothing) that takes the two sets of numbers, matches them by the name (NameID). If the name does not exist in one of the lists then put a 0 (see example below). Once I have this I then want to create a stacked bar graph to show the results.
Example:
Smith, Iain23 7
Bowman, Dan12 2
Rixon, Simon06
Cooper, Lee10
Jones, Andy21
I am very new to MS Access so please make any explanation descriptive.
Any help with is will be very grateful.
Harold Clements
Concatenate Names
Apr 6, 2007My database has FirstName and LastName fields.
I would like to initialize a new field called UserID with the first letter of the first name concatenated to the last name. I have found references that point to using Left([FirstName],1)&[LastName] but am unsure if this can be done in the table definition or if it must be done using a query. Either way I could use some advise on initializing this fields since I have 3500 registered users.
Thanks
Parsing Names
Apr 24, 2007Does anyone know of an expression I could use in a query to parse a full name field into last name, first name and middle initial?
View 4 Replies View RelatedFile Names
Feb 29, 2008Hi,
I apologise in advance for my lack of understanding but I need to know whether an access 95 database will accept file name's that are 21 characters long and contain underscore's?
I have never had to get involved ith access database's so far but have been told find this out.
Any help would be much appreciated.
Thanks in advance,
Mike
Counting Names
Mar 26, 2008I have a query in which I have the name of teams and the names of staff in those teams. I am trying to have a count in my query that counts the number of staff in each team but I cannot get this to work properly. In the same query I have other calculations which sum figures.
Thanks
Duplicate Names
Jul 6, 2006I have a firstName text field on a form and a Surname Text field. on the Event AfterUpdate i have this code:
If (Not IsNull(DLookup("[FirstName]", _
"Employee", "[FirstName] ='" _
& Me!FirstName & "'"))) And (Not IsNull(DLookup("[Surname]", _
"Employee", "[Surname] ='" _
& Me!Surname & "'"))) Then
MsgBox "Someone already exists with the same name! Please check for duplicates", vbCritical, "IPDMS"
Me.Undo
End If
I am trying to Check the table "Employee" to prevent duplicate personnel from being entered.
My code at the moment is preventing any duplicate surname, its not combining it with the FirstName.
i.e. any person with the surname "Summers" cannot be entered twice even if they have different FirstName.
Thank you in advance.