Search results

I need to contact a SQL db company in order to possibly reallocate the db size. I have been getting size errors. I would like to find out if this is even possible to do. I have read that it isn't possible to reallocate but you have to create a new larger db and import all the data into the...

Thank you for your help. I will try this tonight.

no. here is the whole code section: and while I'm looking at it, the changes are not here - they didn't save...??? ug! Private Sub ProcessCertificatesByClass() Dim strPathAndFileName As String Dim strMailMergeDocName As String Dim strRptName As String Dim strNewDocName As...

This had no effect. Maybe I'm not changing the right code portion. Thanks again for your help.

Thank you. I will give that a shot.

I have a statement that calls a certain report. It is working, but I need to modify it for a new position. The code is if the person teaching the class is the president, then use report 3. I need to add an OR if the person teaching is the Director, then use report 3. The existing code: If...

I tried cleaners with no results. I did all I could think of. I copied all Office11\1033 files, shared files, etc and tried to re register I did a last ditch effort and restored. It's working now, so what has been done can't be undone.

I could not fix this by uninstalling office alone. I restored my pc back to factory and am still in the process of reinstalling all my software and ms updates. But I did test it already and it works now. stupid registry

Thank you for your help - it is very much appreciated.

This all started because I tried to uninstall Office 2007 trial. It didn't work 100% so I went through the manual uninstall which had me due lots of stuff. I just tried a repair of Office, which told me it failed due to a office source engine error. I looked it up and it said the ose.exe...

The reason I think I messed it up is this used to work fine until I unchecked that reference. The error is: Run-time '48': Error in loading DLL

MSAccesRookie: No the current qry is NOT the same as post 22, the current qry is post #31

I added [StartDate]<>[EndDate] and also get no records. I specifically ran a multi-day class.

1-DAY: I added this to the Qry design and I get no records found. Without this, I get the records I want. DatesEqual: [StartDate]=[EndDate] This code is what works for the 1-day: SELECT DISTINCT tblBaClassSchedule.ClassDescription, tblBaClassSchedule.ClassScheduleID, [FirstName] & " " &...

ok, stand by

I'm sorry, I am a novice at all this (could you tell:)) Do you want me to try both of your last post WHERE STMTS and post the individual SQL STMTS?

The front end is 70 MB and the SQL backend is pushing 23GB. I can't post that. Bottom line is I am trying to fix a report that doesn't work right. when this report is run, you select the class and it generates a class completion certificate for all students (word merge file) who registered...

I removed after the OR and it said there was no data found.

I got an error: undefined function 'WHERE' in expression. Here is the SQL: SELECT tblBaClassSchedule.ClassDescription, tblBaClassSchedule.ClassScheduleID, tblBaClassRoster.FK_StudentID, [FirstName] & " " & [LastName] AS StudentName, tblBaStudents.LastName, tblBaClassSchedule.StartDate...

ok, so the WHERE should be: WHERE (((tblBaClassSchedule.ClassScheduleID)=[forms]![frmBaReportsMenu]![cboGetClasses]) AND ((tblBaClassRoster.EnrollmentStatus)=900) OR (((tblBaClassSchedule.ClassScheduleID)=[forms]![frmBaReportsMenu]![cboGetClasses]) AND ((tblBaClassRoster.EnrollmentStatus)=900)...