Search results for query: *

I forgot to mention I am using Access 2003

...& _ "Regards," & Chr$(13) & _ Forms!frmELT!ELT_First & Chr$(13) & Chr$(13) & _ Forms!frmELT!ELT_Full & Chr$(13) & _ Forms!frmELT!ELT_Title '**creates an instance of Outlook Set ObjOutlook = CreateObject("Outlook.application") Set objEmail = ObjOutlook.CreateItem(olMailItem)...

I am having another problem with this feature… My query is working great now, however I have duplicate records due to the one to many relationship. When I turn on the Totals feature in the query it makes the query run extremely slow. Without the grouping it takes 30 seconds to run, with...

Thank you PHV, that silly "'" gets me every time! The code works perfectly now.

I have added the code from faq701-4233 and created a query with the following code: SELECT tblEngagement_ClarifyData_Subcase.CaseNumber, Concatenate("SELECT [OwnerID] FROM tblEngagement_ClarifyData_Subcase WHERE [CaseNumber] =" & [CaseNumber],"; ") AS [Case] FROM...

There is no lock file that's what's weird.

I don't think I clearly stated what is going on. No one can edit records using the front end because the back-end is read-only. I need multiple users to be able to go in and edit their data in the database. I have record-level locking set as the default for the database. But somehow when we...

I have a shared database where the back-end sits on a network drive and the front end is on each user's PC. For some reason the database is modifying itself to be a read only database. No changes are made it just changes to read only. The file properties do not show read-only, but when you...

Thanks PHV! That didn't work but it got me to the answer! So simple, yet I have been struggling with it for days! =IIf(IsError(Forms!frmProjectData_PM!sfrmProjectBudget_Summary.Form!HI_BudgetColorID)=-1,"Please complete Tab 1 prior to completing this Tab","") Thank you!!!!

I have a form with several subforms on it. Each subform is on a different Tab using the Tab control. I am pulling information from the first tab onto the second by setting the default value of the field to the control on the first tab...

Leslie, Thanks for the info, however I was hoping for a more automated way. I would have to re-create the table with the split data every time we wanted fresh data which is several times a week. I also need to be able to pass this on to folks who want to run the query ad-hoc and don't have...

I have data that is pulling into an Access database from another source. In this table there is a field called Tasks which is made up of four pieces of data separated by semi-colons. I do not have the control over the database or data to change how the pull is setup I can only query on the...

I have recently developed an Access 2002 database for our Project Management office. The database has a back end with two front end files; one for the administrator and one for the Project Managers. The PMO asked for network space to put the database where approx 150 users from three locations...

...that the above is based on: SELECT qryHours_Allocated_Unique.strResource, qryHours_Allocated_Unique.dtmCurrentMonth, (AvWorkDays([dtmCurrentMonth])*8)-nz([SumOfLastOfintHours_M01],0) AS M01_Available, (AvWorkDays(DateAdd("m",1,[dtmCurrentMonth]))*8)-[SumOfLastOfintHours_M02] AS...

I have two tables; one that contains time spent on projects by resource and the second is a master list of resources. I have a query that relates the two tables with the Resource ID where it includes all records from tblListResources and the related records from tblProjectHours: Joe...

Thanks again for the help!

OK - one more question: Which part of the SQL statement determines what is displayed in the concatenation? Right now my result is displaying the case number rather than the subcase number. I need it to display the list of subcase owners from the tblEngagement_ClarifyData_Subcase. There are...

Thank you,Thank you, Thank you! That was it, so simple, but I just couldn't figure it out! It's been driving me nuts for days.

I am trying to use the FAQ701-4233 and am having problems. I have a query that I am relating two tables: tblEngagement_ClarifyData_Case strCaseNum (Key) strCaseTitle dtmCaseOpen dtmCaseClose strCaseOwner tblEngagement_ClarifyData_Subcase strSubcaseNum (Key)...

I think I understand...now I hope I am not being a pain, but I moved the end with and am now getting a different error: 91 Object variable or With block variable not set When I click OK it just keeps giving me the same error. I pressed Ctrl+Break and choose Debug, the Resume CleanUp line is...