Search results for query: *

I have an unbound form with multiple tabs that contain listboxes. in the top of the unbound form, I have a combobox with clientID and name, once you select clientID, it filters all the list boxes to the data associated with the clientID. I want to add a tab with a field from the client_tbl. This...

Hi, I have a query result that I would like to add a value in a new column in the query result. Example of the query result is Name DOB Dept Division But I want to add another field which is not in the table showing the word Domestic in each records without inserting it in the table. Is...

I have a form that has about 30 fields. I want to make sure that 5 fields to be mandatory to enter information in. Name, firstname,lastname,dob,badgeID, and deptID Some are text fields and some are comboboxes. the form name is Staff_frm the form is bound to the tabel. I don't want to set the...

Hi All, in the codes below, I would like to hyperlink the line from http: all the way to the end of the link. when I click send, it goes without this line being hyperlinked. I am using this in send object. Any suggestions. Thanks Mymessage = Mymessage & "1. Go to " & vbCrLf...

Hi All, I need help with attaching a file automatically to the email when using the send object. The document will be word or pdf. Is there a way to automatically the file to be attached from a specific location? I am saving the file in H:/Admin/Welcome.Doc If intResponse = vbYes Then...

Hi Tek Experts, I am running a apend queries and wanted to add mesage box confirming the operation when the records are apended. the following codes I used to apend the records: DoCmd.Hourglass True Turns off the Access warning messages DoCmd.SetWarnings False...

Hi Experts, I was wondering if it was possible to automaticly email a report to individuals based on ticket date? each record will have one individual to send the report to. each report will have ticket date and e-mail address. I have a query result in a report with e-mail address field and...

I have a staff_table with field name testdate. Each staff must take this one test yearly to use him/her in any activity. I have Activity_tbl that contain staffID, what I want is that if we select the staffID from combobox in the activity_tbl,then we enter the services date, a Dlookup looks the...

Hi All, I need to pull the top six provider who has the highest number of apppointments from each depts in the following statement: SELECT Query2.Depts, Query2.[Full Name], Query2.CountOfAppointment FROM Query2;

Hi Experts, I have data result that looks like the below: Date name Quantity Amount 03/2011 Smith 4 1000 03/2011 John 3 9000 03/2011 Bert 1 1500 I would like to be able to show the result, if the quantity is more than one...

Hi All, I have a big project that I am working on and I am stuck. I don't have any clue of what to do. Any suggestions would be greatly appreciated. We have 3 big departments merged together. Each department has list of providers used for services. We all share the same providers as needed. The...

Hi All, I have a data for 50 departments. Each department has 100 or more staff members. I have to send each deparmtne the data and they may make changes to it. I want to be able when I get the data back to filter out what was not changed and keep the one with the changes, What would be the...

Question: I have a detail finance data in a table. I added a checkbox and combobox that link to invoice ID table, when the user select invoiceID from the combobox and ceck the checkbox, copy of this record to go to the invoice detail table with the right invoiceID. So I created apend query and...

Hi, I have data that I would like to group in columns semi annually and quarterly. I ran the pivot table in 2007 but I am not able to change the column sitting to group data in quarters or semi annually. it show the data monthly. Coustomer_number Name Description total_Orders Date

I have a query built from 4 tables. One of the fields is a checkbox that at the end of the month, we have about 50-70 record to check the boxes for. The query is not updatable. I think because of many table relationships and this field is 3rd table in the relationship. I am not sure how to go...

I have a form and subform. The subform is linked to the form Via ActivityID and StaffID, I will get alot of data in excel format. I want to be able to copy the rows from excel and paste it in the subform. I tried it and it worked when there is no linked relationship. but for the data to be...

Hi All, I have a concatenated field separated with a dash. Example, 555145520-5556 Is there a way that the I can show the whole number all time, but when the number starts with 5200 then it only show the numbers before the dash. Inv#: [Invoice#] & "-" & [InvoiceID] Thanks

Department_tbl DepartmentID Department EntityID DivisionID Division_Tbl DivisionID Division ProviderID DepartmentID Name Account_tbl providerID Account number I recieved a new table with mixed together infromation. Account numbers, department_name. however, the new table has the most...

I have the following query that I tried everyway to place $ to the year field since it is currency, when I click propertiy for the field and select $, it will not show in the output. Any suggestions on how to go about resolving this. TRANSFORM Sum(ByYear_All_DepartmentalSupport_qry.Amount) AS...

Is there a way that I can append records from access to outlook task list. I have the following fields in the datasheet: Date will be duedate Activity will be the title Staff will be the staff who the task assigned to. Notes will be the body of the task. Help please!!!