Good Morning
I have an unbound form "FrmInterviewSu ccesfful" with some unbound fields on it
There is also an option box with 3 options and by clicking on it
my subform wil filter with Sucessfull/Unsucessful and all Candiates
Works Perfectly..
In my subform i have the id some extra info about the candidate and then a tick box calles MoveToOffer.
1 or Multiple records...
natural
Last Activity: Oct 20 '08, 08:34 AM
Joined: Aug 29 '07
Location:
-
No Execute on Send Selected record To Another Table
-
Brillinat
Thank you so much for the help..
Regards
Natural -
HI
Thank you for the assistance.
I was wondering, this allows me to export the data in query view, and then to add it to the pivot. When it is in Excell
Is there a way to export the current pivot as it is in Access
Thank you in advanceLeave a comment:
-
Pivot Command
I was hoping someone might be capable to assist
I have a form called FrmEmployeeCoun tPivot
And on the above mentioned i have a subform called FrmEmployeeCoun tPivotSub
The Sub is a Pivot Table
What i am trying to achieve is normally i will click on my pivot table comandbar, on the export to excell. And will work perfectly.
Now Because the sub is on my main form my Pivot Commandbar,... -
Wow... Brilliant
It is working.
Thank you so much...
You have been extremely helpfull..
thank you very much for you time and help
Regards
naturalLeave a comment:
-
MMM.... Okay i created a form call Frmcontent with nothing in it.
It is unbound and now sits on my main form as the sourceobject. FrmContent
I reran the search and still gave me the
"The expression you entered refers to an object that is closed or doent exist"
I then thought maybe if i make Frmcontent Bound to my TblCandidates. (Not that i would want to due to having other tables...Leave a comment:
-
Hi
My apologies
I removed the reference..
Please find attached...Leave a comment:
-
Good Morning..
Thank for the responses..
It is difficult to say where the error is...
I have attached a rough copy to give you an idea.
The form "FrmHome" is the main form,
The is a cmdbutton called "Candidates "
If you click on candidates it will be "Search Candidates"
I will then double click on the candidate in...Leave a comment:
-
Hi Sorry for the delay in reply and thanks again for the assistance
No luck
I did the following but still gives me the error
"the expression you entered refers to an object that is closed or doensnt exist"
here is what i currently have
...Code:Private Sub SearchList_DblClick(Cancel As Integer) On Error GoTo Err_SearchList_DblClick Dim rst As DAO.Recordset
Leave a comment:
-
Hi
Nope...ID Is a number fieldLeave a comment:
-
Thank you for the repsonse and help
It opens the form properly.. but it gives me an error
" the expression you entered refers to an object that is closed or doesnt exist. "
Here is the exact code
...Code:Private Sub SearchList_DblClick(Cancel As Integer) On Error GoTo Err_SearchList_DblClick Dim rst As DAO.Recordset
Leave a comment:
-
Search Form
Good Afternoon
I was hoping someone could possible assist.
I have a form called frmSearchCandid ates
The Form opens up as a subform on my main form called FrmContent
I have
FrmHome (Main Form)
FrmContent (Subform On MainForm where all other forms appear in)
Before i made use of the above mentioned, i could do my search via a list box double click on the record,... -
wow Thank you very much
You have you have been extremely helpfull.
And thank you for the changes and advise.
I will definetly be looking at making some more changes
I really do appreciate it.
Once again Thank you
Kindest RegardsLeave a comment:
-
Subform
Hi
Thank you very much for the reponse, and help
I did use the combo function earlier, but will then only be presented with the current records that has been been updated and then addiding as needed.
I would like to make it as easy for the user, and therefor would like to list all the records currently in the TblInductionLis t
The user will then tick Yes this is done...Leave a comment:
-
Subform Visible
Good Morning
I was hoping someone could possible assist
First I hope this makes sense
I have 3 Tables
TblEmployee (Employee ID and all extra details)
TblInductionlis t (Which lists all the items to be inducted on With IndId)
TblInduction (Where EmpID and IndID gets Accosiated with some extra fields for additional info.
My Main From wich is based on TblEmployee... -
Thank you very much for the response, and my apologies for the vaugness.
So if I have a table called TblNewId
I will have 3 tables that will be looking at it.
TblCandidate
TblOffer
TblEmployee
All three would once "NewRecord had been Selected" Look at the table NewID and then make us of max +1
But what if tblCandidate used the last max
...Leave a comment:
-
New Id Generation
Good Mornining
I was hoping someone could possilbe assist.
I have three Table
1 - Candidates, (Where New Candidates Will be entered)
2- Offer (Where successfull candidates has been appended - Or new Offer Created without being in the Candidates Table
3- Where successfull candidates and offer records has been appended But also new record can be created from this table. ... -
docmd.setwarnings false isn't working...
Good Afternoon
I have an option grou[ and on the after update i would like to provide the user with a msgbox, and then action
placed my docmd.setwarnin gs false everywhere, but i still get my "record has been deleted".
Is i possilbe to please assist in where i am going wrong
Private Sub RecOffLet_After Update()
On Error GoTo Err_Handler
DoCmd.SetWarnin gs False... -
Hi Scott..
Thank you very much for your help. Working perfectly..
Regards
SusanLeave a comment:
-
256 Caracters
Good Day.
I am currently via Form send data to a word template..
I have about 150 bookmarks in a word document which was previously imported via a simular document. and appended into my DB. The data changes etc we export it back for various reasons.
I use the following
Code:
--------------------------------------------------------------------------------
Private Sub ExportPDForm_Cl ick()...
No activity results to display
Leave a comment: