Search results

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...

My database consists of importing excel spreadsheets from another source. I have no control over the source but they export spreadsheets that don't seem to work right away. I have to open them up. Then i get "The file you are trying to open, [Filepath].xls, is in a different format than...

Here is a image of the query.

I'm sure this has been asked before but I am trying to combine the fields from several different tables into one with the same key field. Can't figure out the criteria for it to update using the names I have the update query set up Field: Training Table: permpartytraining Update To...

Seems as a combination of both suggestions would probably be best. I used Allen Browns method, but the list has the whole file path in it, impractical for the user to see the whole path and select what they want. Need to figure out a way to rename those files. Doing my research on...

I'm trying to add a spreadsheet from a folder using wildcards by just looking for a number in the file name. strPath = "C:\Training\" strFile = strPath & "*" + "(ZZ131008)" + "*.xls" DoCmd.TransferSpreadsheet acImport, , "Training1", strFile, , "" I get a response saying it cannot find the...