Search results

I have a select query that has filenames listed. I would like to use the Like Operator to select only those filenames with certain bits of string. For example: In the Criteria area of a query Like "*Defense*" selects all filenames with the word Defense successfully. However, I would like to...

Thanks! I am using the VBA update query as a flag to indicate if the user has overridden a computed grade. The 1 indicates the user has changed the grade. Thanks for the help.

When executing an UPDATE query in VBA can I use a variable as a field name? For example: Dim myStudent as string myStudent = Forms![frmMasterReportCard]![Student_Name] mySQL = "UPDATE tblStudentCheck SET ["myStudent"] = '1';" DoCmd.RunSQL mySQL I am sure the problem is in the ["myStudent"]...

Thought of that... I thought of that, but the Math table is pretty big considering all of the sub categories that I need and then multiply it by 4, one for each term. It is not realisitic to break the math table into 4 different tables (for each term) as it would make the grading form a mess...

I have a report card program that I use in my classroom. The program calculates letter grades for various sub categories. For example, under the Primary Category Math, the computer will calculate a letter grade based on assignment scores and place the grade into a combo box for the sub...

I would like to import a linked table from one Access database to another linked table in Access database using VBA. I have tried to import the linked table using: DoCmd.TransferDatabase acImport, "Microsoft Access", _ UpdateFileLocation, acTable, "tbl_Elementary Roster", _...

I would like to import a linked table from one Access database to another linked table in Access database using VBA. I have tried to import the linked table using: DoCmd.TransferDatabase acImport, "Microsoft Access", _ UpdateFileLocation, acTable, "tbl_Elementary Roster", _...

Yes! Thanks. I must have been missing the single quote marks.

I keep getting a syntax error (missing operator) with this bit of code when executing SQL in VBA. "WHERE [tbl_Student_Roster].[Student Name]= " & [Forms]![form_Student_Roster]![Student_Name] & ";" It is part of a larger piece, but the rest works (or does not give me an error). Any...

How can I append the results of a query in database 1 to a table (with the same structure) in database 2?

Not quite true I can and do all the time (from home to work) open Access 2003 MDB files in 2002. In Access 2003, when you go to convert the database to a different format, there is no 2002 option, only 2002-2003. This implies that they are backward compatible. The trouble begins when one...

Thanks. That article is frustrating because it gives no reasons, just that Access 2002 SP3 cannot open a Access 2003 MDE database. Weird. Thanks.

Service Pack 3 - no help. OK, I installed office XP service pack 3 which detailed that it fixed the "corrupt" message. However, a new error appears when I try to run the MDE: "This database is in an unrecognized format." Any ideas? Thanks.

I have created a database using Access 2003. If I leave the database in the MDB format, it will run perfectly on my computer at work that has Access 2002. However, if I use Access 2003 and convert the database to an MDE file, and try to run it at work using Access 2002, I get an error that...

Got it! The following bit of code will populate the textbox during a loop with either one or multiple selections of a list box. Me.txtCurrentStudentName = Me.txtStudentCurrentStudentName & Me.lstStudentNames.Column(1, vItem)

I have a report that is dependent on the content of a single text box (a student's name). I would like to be able to select multiple names from a listbox and loop through those names to print the reports. So far, no success. I believe that if I could pass the name of the student during the...

I thought of using 999 99 can easily be a test score. You don't want to use 0 because you cannot differentiate between those who earned the score zero and those who are missing the assignment. There are a few times when students are absent and a daily activity such as a simple 5 point warmup...

I use Access as my grading program at school. Right now, if I want to excuse a student for an assignment, I delete that record. What I would like to do is put an "X" or some other string into a field that is numeric and Access would ignore that score when computing the average. A longshot...

Thanks! I will try it tomorrow at work. Thanks again.

The MDW file 1. Regarding the mdw file, what folder do I put it in on the other machine? 2. Suppose a collegue wanted to use the database, but I wanted to keep the same security structure. If I send along the mdw file, will it affect other databases my colleague creates or works with? 3...