Search results for query: *

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...

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...

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

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...

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...

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...

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.

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...

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...

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...

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...

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...

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...

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!

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...

Thank a lot, pwise. Your syntax worked perfectly.

I have a form that needs to display employee details such as employee name, manager's name, date of employment and so on when the ID number is entered in an unbounded textbox. The form is working. The ID number is in the text form in the original table. The ID numbers range from 1 to 7...

gruiz, Go to 'Tools' > 'Internet Options' > 'Advanced' tab > "Browsing" Check (select) "Disable Script Debugging (Internet Explorer), Close by selecting OKs. -Mark.

Peter, Start by going to the dropdown menu 'Tools' > 'Internet Options' > 'General' > 'Tabs' > 'Settings' > 'Tabbed Browsing Settings' Under the item: "When a pop-up is encountered", select the "Always open pop-up in a new tab" option. Close by selecting OKs, close and restart browser. -Mark.

Roger, Did you check your default printer? Go to File > 'page setup' > Printer > Properties Make the changes you want here based on the paper size used. -Mark.