Search results

There you go. Attached to the previous post.

Bob, Users should be able to add and rearrange the pedagogical items in the event that definitions change or if down the line there is an idealogical change and new items need to be added. This could be manually done if I were to still be in my current position, but it is likely that I will not...

Hi folks, So now we've having tons of fun. The folks here need to be able to add, edit, and remove records which relate to pedagogical items on a whim. There is no scenario where the number of these items will ever exceed 75. These items are then used to create table columns on a separate...

Alright folks, So I haven't spent much time i the past modifying recordsets with vba so I'm off to a slow start. I've been looking around and I'm still having trouble with the navigation. I have a listbox(lstGuidelines) which contains the records from a record set. The first column displays...

I like doing things manually. Helps me understand whats going on.

Brackets to the rescue.... So it should actually look like this: FROM (((tblCourseRecords LEFT JOIN tblSemesters ON tblCourseRecords.SemesterID = tblSemesters.SemesterID) LEFT JOIN tblDepartments ON tblCourseRecords.DepartmentID = tblDepartments.DepartmentID) LEFT...

Just as a matter of curiosity. I have see a number of articles which suggest the use of joins using a comma separated tables and the WHERE statement. Which is the way I have always joined tables. Where does the inefficiency stem from? For example...

Bob, I'm building it all manually and probably not in the most efficient way. I need the user to be able to filter it and sort with button presses. Also the "AS" Titles are pulled from another table so that the user can set names for each of the fields when they export them without interfering...

This works: SELECT tblCourseRecords.RecordID AS RecordID, tblDepartments.DepartmentID AS DepartmentID, tblSemesters.semTitle AS Semester, tblSemesters.SemYear AS Sem_Year, tblCourseRecords.courseID AS Course, tblCourseRecords.sectionID as Sections, tblCourseRecords.facultyID as...

They are all string fields. SELECT tblCourseRecords.RecordID AS RecordID, tblDepartments.DepartmentID AS DepartmentID, tblSemesters.semTitle AS Semester, tblSemesters.SemYear AS Sem_Year, tblCourseRecords.courseID AS Course, tblCourseRecords.sectionID as Sections...

Hey folks, So I'm building a query for export to excel based on user filters and so forth. It was working dandily, until I threw in some code to replace field names with values from another table. Now rather than look for problems with the vba, i'd like to figure out what the hell is wrong...

Problem solved: Got rid of all form references: Private Sub lstGuidelines_AfterUpdate() DoCmd.GoToRecord , , acGoTo, Me.Form.lstGuidelines End Sub

That results in an error regarding the wrong data type as its supposed to be the name of the form. Alternative using .Name instead of .Form returns to the original issue. Thus getting us nowhere. DoCmd.GoToRecord acDataForm, Forms!frmMain!frmSubGuidelines, acGoTo, Me.Form.lstGuidelines

Sean, I've had that open for the last hour working all of my other form reference bugs out. However, in this case that table recommends from Subform1 to Subform1: me.recordsource which in my case is: me.form.name as both the listbox and the record information exist on the subform.

Hi folks, So I have the following code: Private Sub lstGuidelines_AfterUpdate() DoCmd.GoToRecord acDataForm, Me.Form.Name, acGoTo, Me.Form.lstGuidelines End Sub Works like a charm when I load up the form. However, when the same form is embedded into my main interface form I get the...

Well I'm thinking of rebuilding the database from scratch at this point. I'll start by building a user system with either, userlevels, or action lists to determine which actions users are allowed to perform. I'm then thinking to make start on a home form with a header menu across the top and...

Hey folks, Does anyone have any resources on form planning? I keep revising my forms to make them more streamlined and then I discover new features that demand reorganization. Right now I'm trying to determine the best way to build a form with Add/Remove/Edit capabilities with an efficient...

Perfect. Thats basically the setup I had before. It was the form error handling that was pure magic. Cheers! Steven

In liu of attaching a database this example demonstrates the problem: Table - tblTest Field: ID - Default Settings Field: testText - Text, Required Field: testDate - Date, Required Field: testNum - Number, Not Required Form - frmTest Place the above three fields using default access names...

I removed all navigation for entry. But I do have a button used explicitly for save and cancel. I can get both of those to work without any problems. It's just the Close X button that's giving me the trouble.