Search results for query: *

I need to merge two fields only when there is a duplicate. I created a query to separate the duplicates from a table (although that step may not be necessary. The table contains appt. information for an outpatient clinic. Some patients have multiple appts. A sample of the data is as follows...

In my table tbl2DaysAppts I would like to only view the records where the date and 2 names are equal. The query below does not provide this information. Any assistance is appreciated. SELECT tbl2DaysAppts.tblAnasaziStaff_LAST_NAME, tbl2DaysAppts.STARTDATE FROM tbl2DaysAppts WHERE...

I have read access help and Tek Tips http://www.tek-tips.com/viewthread.cfm?qid=1226608 attempting to find a solution. I have a table named tblMasterList with a date field, format Short Date. None of the existing records have the date field completed. I also have a form titled frmMasterList...

I have a table that needs multiple column data types changed to text. I am using this code that works: ALTER TABLE tbl6DaysSERVICES ALTER ID text The downside is I have to create a seperate query for each column to change each data type. I have tried: ALTER TABLE tbl6DaysSERVICES ALTER ID...

I created a macro with the following parameters: Transfer Type: Link Database Type: Microsoft Access Database Name: C:\LOGS\092006CALLS.MDB Object Type: Table Source: LoggedCalls Destination: LoggedCalls Structure Only: No I run the macro using Scheduled Tasks on the first day of each month...

My tbl4Sites has various StarTimes and EndTimes. I only want to see data where the StartTime and EndTime equals one hour. Both fields are text.

How can I replace multiple values in one field? UPDATE tblxAppts2Weeks SET ENDTIME = Replace(ENDTIME,"10:59","11:00") Now I want to add: Replace(ENDTIME,"14:59","15:00") Replace(ENDTIME,"13:59","14:00"), etc.

I have 2 tables: tblReservedTime & tblAppts. I need to exclude the ReservedTime record if there is an appt. record in tblAppts. Both tables have the following fields in common: Date Location EMP_ID LastName FirstName StartTime EndTime I have tried the unmatched query wizard and then tried...

The table I am working with has the field SSN. I need to seperate the numbers to 3 seperate fields: SSN1, SSN2, SSN3. The data in the field SOC_SEC_NUM is without hyphens: 123456789. I tried SSN1: Val(Left([SOC_SEC_NUM],3)) ; This works OK SSN2: ? SSN3: Val(Right([SOC_SEC_NUM],4)) ; This...

I need to seperate the name field. I only need help with the middle name which is sometimes a name and sometimes an initial. [LASTNAME, FIRSTNAME MIDDLENAME] or [LASTNAME, FIRSTNAME MIDDLEINITIAL] LastNAME: Left([SORT_NAME],InStr([SORT_NAME],", ")-1); Works fine FirstNAME...

I have a form frmDeleteRecord with a combobox Combo25. When the frmDeleteRecord is opened, the user is instructed to click on the drop down menu to make a selection. Once this is done, the other fields autofill. This works fine. The problem is after making the selection of the record to...

I have two forms: frmSearchDept and F_Search. When I open the frmSearchDept and click the X in the right hand corner, a message appears "Close the form?" with Yes/No. This works fine. ----------------------------------------------------- Private Sub Form_Unload(Cancel As Integer) If...

I have a simple phonebook database which includes tblPhonebook and frmAdd. I am trying to prevent erroneous data from being entered. I set the validation rule for the PhoneNumber field in tblPhonebook to Like "(281)*" Or Like "(713)*" Or Like "(800)*" Or Like "(832)*" Or Like "(903)*"...

I have a table with 2 fields representing time, data type text. Sometimes data in the StartTime column is 5 digits with other entries 6 digits. I would like to update the fields to reflect a standard time format HH:MM StartTime EndTime 80000 81500 100000 110000 Tried UPDATE...

I need to change the field data type in a table from number to text.

I created frmDataEntry and a combo box named cboCity. I also have a text box txtState that is autofilled from the cboCity RecordSource =[cboCity].[column](2). This works. The problem is now I have a macro button to add new record. It adds all fields except the City and State. I want to...

I want to import a file name that changes on the 1st of every month. I am using a macro to link to a table within the database. Is there a way I can import a Database Name that changes every month, on the 1st of the month? The format of the filename is MMYYYYCALLS.MDB. The current filename...

How do I run a macro on the first day of the current month?

I created a macro that links to a table in a Access database. On the first of every month, the database name changes to the current month name; e.g. this month (June 2005) the file is named 062005CALLS.MDB. Next month, on the 1st, a new file is created and will be named 072005CALLS.MDB, etc...

I would like to make the email address "email@domain.org" as a hyperlink instead of just text. .Body = "Attached you will find the latest Report. Please update." _ & Chr(13) & Chr(13) & "Important Notice: Text of email." _ & Chr(13) & Chr(13) & "Text 1" & Chr(13) & "Text 2" & Chr(13) & "Text...