User Profile

Collapse

Profile Sidebar

Collapse
ahd2008
ahd2008
Last Activity: Mar 31 '13, 10:28 AM
Joined: Nov 4 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • ahd2008
    replied to Transfer Records Between 2 Back-Ends
    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
    See more | Go to post

    Leave a comment:


  • ahd2008
    started a topic Transfer Records Between 2 Back-Ends

    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...
    See more | Go to post

  • ahd2008
    replied to Like Operator To Find Any Similarities
    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 us
    See more | Go to post

    Leave a comment:


  • ahd2008
    started a topic Like Operator To Find Any Similarities

    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...
    See more | Go to post

  • ahd2008
    replied to Get Multiple Max Records
    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 all
    See more | Go to post

    Leave a comment:


  • ahd2008
    replied to Get Multiple Max Records
    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])
    ...
    See more | Go to post

    Leave a comment:


  • ahd2008
    replied to Get Multiple Max Records
    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....
    See more | Go to post
    Last edited by ahd2008; Aug 29 '12, 02:30 PM. Reason: typo mistakes

    Leave a comment:


  • ahd2008
    started a topic Get Multiple Max Records

    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...
    See more | Go to post

  • ahd2008
    replied to How to get SQL stored query into VBA
    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

    Code:
    Dim SQLToFindLowestRackNumber as String
    Then Assign your SQL statment to your string variable

    Code:
    SQLToFindLowestRackNumber="Select ..."
    Finally, to get the result of your query:

    Code:
    x=CurrentDb.OpenRecordset(SQLToFindLowestRackNumber
    ...
    See more | Go to post

    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"

    Thanks
    See more | Go to post

    Leave a comment:


  • ahd2008
    replied to call functions in another module
    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 you
    See more | Go to post

    Leave a comment:


  • ahd2008
    replied to call functions in another module
    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...
    See more | Go to post

    Leave a comment:


  • A Very smart suggestion from smart guy. Thanks so much Rabbit; that's absolutely the best approach.

    Regards,
    See more | Go to post

    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...
    See more | Go to post

  • Thanks PGAC; I have decided to go with your first suggestion.
    See more | Go to post

    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 roots
    See more | Go to post

    Leave 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...
    See more | Go to post

  • ahd2008
    replied to Switch Between Tabs in Navigation Form
    Mihail, Thanks for your inputs. I believe your codes would work with on forms based on Tab Control, but not with navigation forms.

    Thanks all
    See more | Go to post

    Leave a comment:


  • ahd2008
    replied to Switch Between Tabs in Navigation Form
    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
    ...
    See more | Go to post
    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:


  • ahd2008
    replied to Switch Between Tabs in Navigation Form
    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...
    See more | Go to post

    Leave a comment:

No activity results to display
Show More
Working...