Search results

Maybe the teacher wanted the students to demonstrate that they have the ability to get someone else to do their work. :rolleyes:

You don't need a second query to filter results, you just need some criteria that can be applied as a filter on the original recordset. This criteria could be applied in the first query, it could be applied during the OpenReport method, etc.

That's not what I was suggesting, and that's not what the second command button on the example db does.It does not change the record source of the form. It rewrites the SQL of the existing record source before opening the form. Wrong. You're rewritng the SQL so you can include any criteria...

You started out using the term Task, now your using the term Module. Are we still talking about the same thing? Do the procedures for a module have any relationship to the employee? In other words, do employees get trained on each specific procedure of a module, or do they just get trained on...

Private Sub cboRequestedItems_Change() Me.Form![frmItemList subform1]![PricePerUnit] = Me.cboRequestedItems.Column(1) End Sub First, you should not be using the Change event of the combo box, as this fires at every key stroke. You should be using the After Update event. Second, some of what...

Actually, this is most definitely a reason not to use boolean fields to store this type of data. Think about it. Right now you have four boolean fields in your table, and you likely (or should) have other objects (queries, forms, reports) based on that table. Now a suit comes along and wants to...

I don't think I would have the Container Size table directly related to the Carrier table in this scenario. As you stated, this is a many-to-many relationship, so it needs a junction table. Presumably you have a table for shipping records to record where the shipment is going, etc. It would seem...

No. If the record source of the form is a saved query, then you could use querydefs to update the SQL of the query. Not sure whether or not that would be a solution for whatever it is you're trying to do.

The syntax for VLookup is; =VLOOKUP(lookup_value,table_array,col_index_num,range_lookup) Definitions of the arguments is as follows; lookup_value The value to be found in the first column of the array. table_array The table of information in which data is looked up. col_index...

I didn't have time to get to this yesterday, but I finished a sample file tonight. I'm attaching it here but I will also try to explain some of the logic. The sample has the following tables; tblMovies MovieID MovieTitle ReleaseDate tblActors ActorID FirstName LastName tblMovieActors MovieID...

You might have a look at Duane Hookom's At Your Survey sample application. It should give you some insight on how a model like this is handled.

The 64-bit version of Windows. That doesn't mean they will have the 64-bit version of Office. That's where the issues come in to play, when trying to run 32-bit Office programs in the 64-bit version of Office. You should have no problems on a 64-bit OS as long as you use the 32-bit version of...

Regarding your post #4, there's no need to declare a variable for the database object, just use CurrentDb; With CurrentDb .Execute sQry1, dbFailOnError .Execute sQry2, dbFailOnError End With

DoCmd.RunSQL is a method of the Access UI, so with this method the query is evaluated by the Access expression service before being passed to the Ace/Jet database engine. As a result, you will get the default Access warnings when running an action query about "you are about to update records in...

Sorry, we cannot help you crack a password protected file. It's against the rules of the forum and we have no way of knowing if you are an authorized user/owner of the app.

That's likely how I would do it, based on your description of the circumstances, although, if you have referential integrity enforced on your tables I would think that you would need to append the records to the Orders table first, then the Order_Line table. I would also use CurrentDb.Execute...

Assuming that your rental details table has start and end dates for the term of the rental contract, then you would likely do this in the After Update event of that form. The logic being that if the newest rental record for a given house has a start date, but no end date, then it is occupied. If...

If you're doing this in a query field; Status:IIf([CompletionDate] Is Not Null, "Complete", IIf([CompletionDate] Is Null And [TargetDate]<Date(), "Overdue", "Due"))

I would probably use a multi-select list box on my form to select one or more actors, then build a filter for the record set based on the selections in the list box. Post back if you need help with this. I can probably post a sample tomorrow if you need.

OK, so I was bored tonight. Lucky for you I guess because my boredom led me to put together an example of what this model like look like in Access. This is just a rough example. I'm sure it would need some refinement to meet your specific circumstances and it's not something that would be...