Search results for query: *

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

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

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

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

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

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

Keep getting error when connecting to remote Oracle DB: "ORA 12541 TNS: No Listener" How to start "lsnrctl start" command on remote system from local system with limited rights? Thanks in advance, Mark.

I am trying to apply Conditional Formatting to a text box in a report by using the Conditional Formatting option on the pop menu. The condition is that if the value (sum of 4 other values) in text box is less than or greater than or not equal to 1 than the fore color will change to red but if...

I need to automatically wrap lines in a text file which exceed the column 80 mark to the next line. I receive text files which have more than a few lines which exceed this mark. Is there a code I can run on the text file so that it automatically scan the text file and wraps the text beyond the...

I have a table with no primary key. I want to assign a primary key to a field with ID numbers. I tried the following ALTER table syntax >> ALTER TABLE [table name] ADD CONSTRAINT [ID number] UNIQUE ('ID number' is the column name I want to make the primary key) I keep getting this error >>...

I have a table 'B' that is created (via a make table query) from another table 'A'. A column (Text datatype) in table 'A' carries employee ID numbers. These numbers are supposed to be 5-digit numbers but some employees have 4-digit ID numbers. The ones with 4-digit ID numbers are recorded as...

I am running a select query on a table where the date range is 3 days if the current day is Monday and date range is 1 day if the current day is any day other than Monday The purpose of this query is to view records added on the previous day. On Monday, it views the records added on Friday...

I am trying to run a select query on a table where the date range is 3 days if the current day is Monday and date range is 1 day if the current day is any day other than Monday I was using this syntax: IIf(Weekday(Date())=2,Between ((Date())-3) And ((Date())-1),Between ((Date())-1) And...

I have two tables: A and B I would like to append data from one column in Table A to one column in Table B. The Primary key in Table A is the Foreign Key in Table B. Is this possible? Thanks for your help. Mark.

I am setting up an application which send emails to recipients whose email addresses are acquired from a MS-Access DB table. The email content contains a hypelink to a website form. I need to add the ID number of each recipient to the hyperlink so that I can capture who responded to the email...

I am setting up an application which send emails to recipients whose email addresses are acquired from a MS-Access DB table. The email content contains a hypelink to a website form. I need to add the ID number of each recipient to the hyperlink so that I can capture who responded to the email...

I am trying to display total (dollat amount) of donations collected by reps in a MS-Access report. This monthly report needs to show number of calls successful and rejected; expected amount and collected amount. The report shows the correct number of calls for the month but totals up the...

I am trying to insert a single column of data ('calls') in a table from another table. The destination table has a column with similar data which needs to be corrected with the data from the source table. The 'calls' column in the source table is created from another table (call log). The...