Recent content by 2wistd

So I am not well versed with Word other than your standard usage. I want to create a document that we use frequently to create a graduation script. We have multiple classes, and other bits of information such as guest speaker, emcee and of course names of graduates, but most of it is standard...

I am trying to open a report using this code: DoCmd.OpenReport "rptCustom", acPreview, , "IIf(IsNull([Forms]![frmChooseFields]![chooseflight], ,[Flight] = [Forms]![frmChooseFields]![chooseflight])" The form has a combobox with 4 different options for flights. When you select one and click the...

updated to show more accurate information!

Data in table "permanentparty": persName: persRank Worker1 SSgt Worker2 TSgt Worker3 SrA Worker4 LtCol Worker5 Col Worker6 Lt Worker7...

OKay, I'm looking for a report that shows 60 days prior to when someone is due for a course. The Xband is certain periods open up and they need to have the courses complete a year ahead of time. So I would like to see Worker1 has Xband of X1 which has a start date of 1/1/15, so his courses...

okay, database is attached, I hope I didn't strip it down too much.

Wierd, I removed pretty much all the data/tables, queries, and reports...but the file is still 31mb, same as the full file.

Yes, I just need to delete the data and put some fake data in for now.

I have one table with training dates, names, courses etc in it. Another has dates when training should be completed, which is different for everyone. Training has to be done 1 year prior to entering their time frame. Training Table: Name, LastCompletionDate, CourseName TimingTable...

The original respond was perfect for my application!

Thanks I reversed the single quotes!

courseName = "CourseA" CourseNameUpdate = "UPDATE CombinedTraining SET CombinedTraining.courseName = " & courseName & " WHERE (((CombinedTraining.courseName) Is Null))" currently this shows up as UPDATE CombinedTraining SET CombinedTraining.courseName = CourseA WHERE...

I see what you are saying about the query. The reason why I have different tables for each course is because they come from Excel Spreadsheets that I have no control over. It then goes through a few queries to set up the names, dates etc to match my existing data. I might be able to add a...

Okay I'll try to do this as least confusing as possible. I have one table (permpartytraining) which has: User Name: CourseA: CourseB: Jane Doe then I have another table labeled CourseA which has User Name: DateCompleted (and many more fields) Jane Doe Jan 14, 2014 Joe Doe...

INSERT INTO permpartytraining ( ForceProtection ) SELECT ForceProtection.LastCompleteDate FROM ForceProtection WHERE (([ForceProtection].[persName]=[permpartytraining].[persName])); Still doesn't do the trick. It has no problem without the 'WHERE' to put the records in the table, but not...