Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by markedback

  1. markedback

    Display multiple records on single form

    Ja, kjv, thanks for taking the time and effort to respond. I continued to get just one record for each last name. Even in the continous form, the same record was displayed on all the subsequent forms. But I tried a different approach. I created a query with a Last Name parameter and used it as...
  2. markedback

    Display multiple records on single form

    I am building a form (linked to single table) that displays the employee details of an employee. It is supposed to work as follows - user enters a last name in the lastName textbox on the form and clicks on a command button that triggers the event procedure which displays the details in various...
  3. markedback

    Last Up-Date

    Sorry for responding so late. thanks pwise, Remou and PHV all your queries worked.
  4. markedback

    Last Up-Date

    Remou, the following is a sample of the data and the query. Call_Id Seq_Nbr Date Type_Of_CallProduct 3567841 0 05/13/2009 11:44:58 PM Inquiry tires 3567842 0 05/14/2009 9:07:00 AM Inquiry rims 3567842 1 05/14/2009 3:40:00 AM repeat rims 3567842 2 05/15/2009...
  5. markedback

    Last Up-Date

    I have a query based on a table that has multiple entries for same PK differentiated by sequence number of the entries and date-times. I am trying to pick the entries with the last (latest) date only, for the purpose of my query but it keeps picking all the entries. I have tried Max, Last...
  6. markedback

    Latest date

    I have a table (Main Table) that needs to be (preferably) updated on a daily basis. The updates result from a Make table query (using two other tables). The make table query creates a temporary table. Then, an append query appends the data from the temporary table into the Main table. This...
  7. markedback

    Max Month Date

    Thanks PHV your criteria works perfectly! pwise, I was looking for a solution like PHV suggested but thanks to you too for taking the time to help me. Thanks, Mark.
  8. markedback

    Max Month Date

    I am trying to automate the entry of a date range in a query. One of my co-workers has to run a query for a report showing details of last month's sales at various times in the current month. He has to enter the date of first day and last day of the previous month everytime in the parameter...
  9. markedback

    Data edits through form

    missinglinq, The table (salespersonList) used to pull the data (sales person's name) is in the same database. It is basically a list of all sales people. It contains their Employee number and Name (first and last names). This is list is only changed when some employee leaves or joins the...
  10. markedback

    Data edits through form

    Duane, When I first created the form and the button, the button worked as intended. Whenever a record with no salespersonName showed up and I clicked on the button, the salespersonName textbox was populated and the underlying table was updated. This process worked the first few times but then...
  11. markedback

    Data edits through form

    Duane, Thanks for your input. Unfortunately, I am not the DB administrator and have no influence on the structure of the table! I can only query it and correct the discrepancies. I was trying to help the process by building a form that let's me track missing data items. Also, the change you...
  12. markedback

    Data edits through form

    I have a form I use to monitor the entries in a table. The form is based on a simple select query which based on just one table. The table has fields like salespersonID, salespersonName, custAcctNum, custName, orderID, date, time. Whenever their is a blank cell, I use dlookup through a button...
  13. markedback

    Opening form

    I have a form in which the user enters his or her employee number and clicks on a command button to open another form (a form containing menu of other command buttons) which is specific to their employee number. I need the following to code to be modified so that it opens their respective form...
  14. markedback

    Sort Table

    Sorry for the "un-technical" language, dhookom. I was writing the question in a hurry. I will try to be more technical in the phrasing next time. I just wanted the right syntax for the 'order by' statement. Thanks PHV, your solution worked!
  15. markedback

    Sort Table

    I have a table that needs to be sorted by the ID number. Some of the ID numbers are 5-digit and some are 9-digit. When I try to sort the table currently, all the ID numbers sort in the order of the number in the first digit position irrespective of the number of digits. I would like to sort the...
See more

Part and Inventory Search

Back
Top