Using Control Names In SQL
Jul 14, 2005
I 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;
View Replies
ADVERTISEMENT
Dec 26, 2006
Once 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?
View 4 Replies
View Related
Nov 13, 2014
I have a main form that has a Tab Control. The tab control could have 5 to 10 tabs. Each tab has a subform and in some instances a tab could have a tab inside that tab with subforms as well. I want to be able to get the subform names in each tab.
I am able to get the main form name by using me.form.name
How can i get the names of each subform in each tab?
I am creating a dynamic form and need to get the names into variables for later use...
View 3 Replies
View Related
Sep 21, 2011
I need to create a table with names of controls on my forms.
I'll use that table to apply user rules.
Any solution to write the table automatically using VBA code ?
I know how to populate a combobox...
DoCmd.OpenForm YourFormName, acNormal, , , , acHidden
Dim c As Control
For Each c In YourFormName.Controls
[Control-Name].RowSource = [Control-Name].RowSource & c.Name & ";"
Next c
..., but not how to write a table.
View 1 Replies
View Related
Nov 8, 2013
In the default property of a subform control I want to use a control of the main form without using names of forms, but using me and parent.
I used in default property of cboVATDetail: =Me.Parent!cboVAT, but it is not accepted. My aim is to use cboVAT of parent as default in cboVATDetail of child.
View 3 Replies
View Related
Nov 7, 2006
I 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!!
View 1 Replies
View Related
Jan 17, 2014
How can I repeat column names and row names on multiple pages of the report ?
View 1 Replies
View Related
Sep 24, 2013
I added a new field to one of my tables and query, but when I try to add a control for that field into my form it is not recognising it and the field isn't appearing in the sources for the form, even though the table is sourced to the form? Or am I going to have to do the usual and redo the entire form because I made a minor adjustment?
View 1 Replies
View Related
Jun 18, 2014
I have a form with a tab control, inside the tab control I placed an ActiveX control (Microsoft Web Browser). These are at the bottom of the form.
Everything displays fine if the entire form fit on the screen but if the form is too long and I scroll down the browser control is getting obscured by the tab control and getting chopped off (the contents are covered). It is as if the browser control is staying in space where it was and moving behind the tab control as I scroll.
This problem does not occur if I place the browser control directly on the form. Also I note that the browser control is sitting correctly within the tab control.
I have been through all the settings and properties of both controls and haven't been able to fix it. I searched all over the web but no one has previously stumbled across this one by the look of it.
See the attached image ...
View 3 Replies
View Related
May 28, 2015
I have table that I had to add a new field to which we update with a form. I tried to add a control for the new field but the field does not show up in the list for the control source. I am trying to add a list box to the form with a blank and 5 options.
I have attached screen shots of the table design and the form. The table has the field in datasheet view and I have manually entered a few entries in it but it still will not show in the control source for the form control. The top section of the form is where we enter and select the data for the new records. The bottom section (circled in red) autofills the matching record, from separate tables, for updating with the new entries.
I have added form controls for modified fields in the past so I am confused about why this is happening.
View 2 Replies
View Related
Aug 3, 2006
OK. I have searched and searched and every thread dances around similar situations but none seem to address this particular one. I am trying to make a control on a sub form visible/not visible depending on the condition of a control on a main form. The catch is that the control I'm trying to change the state of is on a subform located in a tab control. I've tried a thousand combinations and none seem to work. How do I reference the control on the subform in a tab control?
Main Form: frmMemberMain
Tab Control: TabCtl12
Tab Control Page: 2
Subform: frmChildren
Control on subform: txtRelationship
Can someone please help before my brain explodes!! Thanks! :eek:
View 5 Replies
View Related
Apr 19, 2005
I 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
View 4 Replies
View Related
Apr 11, 2006
I 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.
View 4 Replies
View Related
Oct 31, 2006
If 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!
View 3 Replies
View Related
Jul 27, 2006
I 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!
View 2 Replies
View Related
Sep 2, 2006
Hello 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
View 3 Replies
View Related
Apr 6, 2007
My 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
View 2 Replies
View Related
Apr 24, 2007
Does 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 Related
Feb 29, 2008
Hi,
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
View 3 Replies
View Related
Mar 26, 2008
I 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
View 2 Replies
View Related
Jul 6, 2006
I 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.
View 8 Replies
View Related
Aug 23, 2005
About 4500 records in a database have two names in a forename field, I need to split these so only the first name stays there and anything else in that field is moved to 'othername'.
Using Access, and update queries, I just can't work out what to do. Using Query Analyser I can see a logic but can't get the syntax right.
What I need is omething like
Code:SELECT * from individuals WHERE forename is like * *Dim pa, pbpa = the bit before the " "pb is the bit following the first " " and including any subsequent onesforename = paothernames = pb
Some forenames have simple problems (eg 'John Peter') others are less simple (eg 'Mr J P and Mrs S P')
Any suggestions?
View 3 Replies
View Related
Nov 15, 2005
Just used the code below to output to .csv. however Field Names have been omitted from the output .csv file.
Can anyone help?
Thanks
Paul
Private Sub export_Click()
On Error GoTo Err_export_Click
Dim AString As String
AString = "Export_Occupancy_"
DoCmd.TransferText acExportDelim, "", "ChildCare Vouchers For Accor", "c:\Temp" & AString & Format(date, "YYYY_MMDD") & Format(Time, "-HH_MM") & ".csv"
Exit_export_Click:
Exit Sub
Err_export_Click:
MsgBox Err.Description
Resume Exit_export_Click
End Sub
View 2 Replies
View Related
Jun 8, 2006
I 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.
View 1 Replies
View Related
Mar 15, 2007
This should be easy but I can't see how to do it efficiently. I have a small application that books people in for a competition and creates a record for each. At most I get about 500 people registered in a day, I need to be able to highlight when anyone from a specific list of names (no more than about 15 people) comes forward and tries to register. I guess this is some form of CASE statement where I compare surnames against a text array or is there an easier way?
ps I don't mind if it's hard coded into the VB code rather than as a look up table.
Thanks
pps you can do this with conditional formatting but the limit there is three.
View 1 Replies
View Related
Jun 22, 2007
I need to capture the field names from a linked table and copy them into an excel spreadsheet. Does anyone have an idea how I can accomplish this?
Thanks.
View 3 Replies
View Related