Search results

Because I didn't check in the append queries against duplicate data I would copy just the new tables without any data plus the update queries into a new database. Link the existing tables into this new database and execute the queries in the right order (I explained this before). After you're...

I left out the tables tblReportAuthor and the tblAuthor because the commata sometimes separates suffixes and sometimes authors. In further work you could add a character like "|" in the place, where the author names should split. In a general module you'll find a function for doing the...

Have a look at the relationships and you'll see how to go further. You have to fill the table from the bottom to the top. That means if there are Joins on the many-side the related tables of the 1-side have to been set up before. Maybe you can attach a file with a small set of your tables.

try this SELECT StudentID , [LastName] & ", " & [FirstName] AS Expr1 FROM tblStudentBasicInfo ORDER BY [LastName] , [FirstName]

Well, Sue, I will try to explain it in more simple words. My suggestion is that you will end up in a new database without touching your old data - if you do a right click inside the database window you will find in the custom menu an item for linking tables. In a new database use this feature...

First of all I would store a backup of the existing data. You could then link your existing tables into a new database and design some select queries for the basic data tables, change them to maketable queries and execute them. In Table design mode erase the data, add a primary key as an...

it's not so bad to allways use the Me prefix to reference a control inside the forms class module. Your code might fail if you'll open the form more than once. i.e. Me.CustomerID To your question - click on the control, which you use for the CustomerID and check in the property editor under the...

Look inside the object cataloge for the Module property - especially for CountOf Lines. Then read out all objects in the AllForms, AllModules and AllReports collections of the AccessObject. Open each of them in a loop (look for HasModule property inside the form or report) and add all...

I think you need a separate table in which waterbody and species get joined. I'll call this tblOccurance in the attached gif. An occurance is reported by a publisher. This report can have one ore more authors.

From A2k on and on upward versions of Access you can set an recordset directly the form's property with the same name. You can either use a DAO or an ADO recordset. Another possibility would be, passing the parameter(s) to the form in the OpenForm method lst optional argument. Through parsing...

I guess the data structure is not right when camparing values over more than one field. Use the search button here in the forum or google for data normalisation.

you could ask in the form's current event if the pointer is in a new record Private Sub Form_Current() If Me.NewRecord Then Me!YourControl.SetFocus End If End Sub

begin with a parameter query on your table(s) where you put your data together and distinguish the year. There is no need to do any grouping there. You have to explicitly declare the parameter(s). PARAMETERS [Please enter desired year] Short; SELECT TNXDTE , PRTNUM , NTXQTY FROM TNX WHERE...

try Like "*" & Chr$(34) & "*" in the criteria row.

Sum(GRADES * ACT CREDITS / ACT CREDITS) looks for me like Sum(GRADES) with only a difference when ACT CREDITS equals to 0.

Look into your help file under SetWarnings

Rick is right in his position. But maybe there is a temporary solution by using a select query. Can you uplaod a sample of the table with few sample data?

It depends on your interpretation of Null values. With the Nz-function (see Access Online Help) you can define any value you want instead of a Null value by giving the function the second optional parameter. Keeping the optional parameter away a value of 0 is used on numerical field types and ""...

Limiting a Report to a Date Range might be helpful.

I suggest you do a search on Google: data+normalisation - you'll get tons of results. Create two other tables. Firstly a table Judge with an autonumber field as PK and all the needed attributes for your judges. Secondly build a table CaseJudges where you put a FK to your cases table and a FK to...