Sorry for the late reply. Thanks ADezil that sounds a great approach; I have followed the steps and it worked
Neopa, I wasn't looking for detailed answers. I just wanted to know how to complete this task in the right manner as I had no clue about working with two different back-ends.
Thanks all
User Profile
Collapse
-
Transfer Records Between 2 Back-Ends
Hi everyone,
Hope someone can help with my issue. I have two back-ends that I use for my tracking system. Now, I need to transfer one table records (not all the records, some records) from one back-end to the other.
Can anyone enlighten me how to accomplish this?
Take into consideration that both of the back-ends are protected with password and the transfer should be done through the front-end (by clicking... -
Thanks to you Stewart Ross and Rabbit for the clarification. I understand what you are saying. Thanks again
wish you all the best for the time and efforts you dedicate in helping usLeave a comment:
-
Like Operator To Find Any Similarities
Good day everyone
I am trying to use LIKE operator in a query to find any similarities for a word entered into a parameter. To make my idea clearer, let me give you this example:
Assume that I have a table called tblEmpDepts and there are the following depts.:
1- Finance
2- IT
3- Maintains
If the user entered “Fin” or “Finan”, they query should retrieve record number#1 which is Finance. I... -
Many thanks for twinnyfo & zmbd. You have done great inspiring efforts and enlightend me a lot. Now it is working
Thanks again and best wishes to you allLeave a comment:
-
Good day all,
Thanks for everyone participated. Dear Rabbit, I cannot seem to have your suggestion worked out.
I built an aggregate query as directed by twinnyfo & zmbd, but when I joined it to the Trials table it didn't bring the required result.
This is the aggregate query to get the maximum tirals "Query1"
...Code:SELECT Trials.BadgeNo, Trials.TaskID, Max(Trials.[Trial Number])
Leave a comment:
-
Thanks for your swift response gents. I regret to tell you that I have done a mistake while posting the question. Although I have double checked the post but couldn't spot that minor error. The error is in the fourth record; the badge number should be 280000 instead of 270000.
twinnyfo, thanks for your support. The problem with your suggestion is that when I want to show the Trial ID in the query, I don't get the required result....Leave a comment:
-
Get Multiple Max Records
Good day,
Hope you can help me to build this query. I have two tables one is for the tasks and the other one is for trials (see description of tables below). Each employee is allowed to perform more than a trial per each task. In other words, each task could have more than one trial for any employee. What I want to get is the records in the Trials Table based on the latest or maximum Trial Number performed in each task for all the... -
Hi,
I think you need to use Recordset to run a SQL defined within the VBA. In your case, you need to define your query SQLToFindLowest RackNumber as String variable
Then Assign your SQL statment to your string variableCode:Dim SQLToFindLowestRackNumber as String
Finally, to get the result of your query:Code:SQLToFindLowestRackNumber="Select ..."
...Code:x=CurrentDb.OpenRecordset(SQLToFindLowestRackNumber
Leave a comment:
-
That's interesting discussion. Megalog, I am concerned to know what code you use to perform the kick off safely and save the records that are being used when you said " then it saves whatever record they are working, logs them out, and closes access"
ThanksLeave a comment:
-
Brother, I have mentioned that u need to include your codes so we can help you. Also, you need to state exactly what the problem is.Also, When you said your fn2 cannot be called, describe what you get in run time!
Help us so we can help youLeave a comment:
-
kkshansid,
I think no one would be able to help you with regard to your question. You need to add more details to help us to analyze and diagnosis your problem. It would be useful if you could add the code for fn1 and fn2.
All in all, I can suggest the followings as of now:
1- Check if fn2 is declared as private function. If it is so, changed it to public
2- Compile and test fn2 code to see if there...Leave a comment:
-
A Very smart suggestion from smart guy. Thanks so much Rabbit; that's absolutely the best approach.
Regards,Leave a comment:
-
Query to Get A Parent Record When All Child Records Have The Same Condition
Good day all,
I find myself stumped unable to build a query. I have a parent table for Departments, and a child table for Employees which is related to the Departments table by Department ID. In each departments there are number of employees with different job title. However, in some departments, all the employees have the same job title.
I need to write a query to get the departments that have employees whose jobs is... -
Thanks PGAC; I have decided to go with your first suggestion.Leave a comment:
-
Hi PGAC
Thanks for your response; that's the first thing came across my mind, but I was wondering if there is an easier way to get around this error rather than updating all the unstated tasks and remove the zero value from the Grade Report. Anyhow, thanks for your suggestion and I guess it is best approach to tackle the problem at its rootsLeave a comment:
-
Report Error#2448: You Can't Assign a Value to This Object
Good day all,
I know that this error has been discussed before, but all the discussions were forms-based discussions. Thus, I am sorry if you found this question repeated.
I have a report that lists the tasks' score by employee. Along with each task's score there is a Grade Report bound control. The default value of this control is set to 0%. In some cases, you find that the task's score is null, which means the employee... -
Mihail, Thanks for your inputs. I believe your codes would work with on forms based on Tab Control, but not with navigation forms.
Thanks allLeave a comment:
-
Neopa Thanks for your usual support. I have tried all methods of finding a control on the [Registration] tabs, but nothing worked out. Luckly, while searching the web, I found a post in a forum similar to my case. I found out that the way to switch from one tab to another in "Navigation Forms" is to change the SourceObject of the Subform Control. So, the code to carry out this task is:
...Code:Forms![ManageProfiles].[SubNavigation].SourceObject
Last edited by NeoPa; Apr 24 '12, 11:52 AM. Reason: Forgot to add the reference link - Sorry, had to remove illegal link.Leave a comment:
-
Thanks Neopa for you kind support. Yes, you are totally right; I should have included more details.
Well, as stated in my first post I have a navigation form that has 5 tabs. The navigation form’s name is "ManageProfiles ", and the tabs' names in order are:
1-EmployeesProfil e
2-EvaluatorsProfi le
3-MentorsProfile
4-Registration
5-WorkingSchedule
On clicking on WorkingSchedule...Leave a comment:
No activity results to display
Show More
Leave a comment: