Search results

OK, you are saying the tables are not related. So what do you do with the selections in the combo box? You can't prevent duplications unless you store a record of transactions somewhere , or am I misunderstanding?

You can have more than one primary key. If there is a many-to-many relationship between companies and products, you establish a joining table between the Companies table and the Products table with companyID and ProductID as joint primary foreign keys. This allows only unique combinations of...

As Jeff Bailey said and Pat Hartman confirmed, this command saves the record regardless of its status, provided there are no inherent errors in the record. It's the same as saving the record by going to the Records menu and selecting "Save Record". Errors in the record will ultimately prevent...

There is an rst.edit missing from the first update line. And there is nothing to update anyway... but I presume you've left out some of the code? Get rid of the other select statement as shown Private Sub btnPrintSlip_Click() Dim rst As Recordset On Error GoTo ErrPrintSlip Set rst =...

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q241141 Try this link..

OK, that means you don't need the second table, because there is a one-to-one correspondence between questions and their sections. Try not to get frustrated, because you are getting needlessly tied up in complexities that don't exist. Answers to the questions don't go in the questions table...

No, it's not a flat table, that's the whole point! The Big 4 appear in EVERY section. Right? The subsidiary questions may appear in ANY section, ie, they are not unique to a section. Right? If this is so, you don't even need two tables for your questions. The questions are in a one to...

Why have more than 3 tables? The Big 4 can be lumped all together in one table. All subsidiary questions can be in another table. A third linking table can relate section IDs in the subsidiary table to Big4 IDs.

See my response in another thread. But if you want to do this from your questions table, you simply create a query which includes both tables and base your report on that.

Do you always have the same questions in the report or do they vary from report to report? If they are standard, just copy and paste the question text into labels aligned to be opposite the fields containing the responses.

shouldn't be too difficult... It sounds like you can just write some code on the Click event of your count button and use rs.Recordcount to return the number of records in a query based on the contents of your combos . Send me the relevant part of your database as a zip file if you like and...

Records are locked so that two users can't edit the same record at the same time. If you and another user have a form open at the same time and the other user accesses a record and changes it, the record is locked only until the change is saved, i.e. very briefly. If you now access the same...

Use Select Case You need to exit the code if the combo column is null. Then the combo must be updated with a valid entry before the code will run to a conclusion : If Me![CompCycle].Column(0, 0) = "" Then MsgBox ("YOU DON'T HAVE ACCESS FROM THIS PC") Exit Sub End if...

For the purposes of this exercise, It would be better to set the breakpoint after the data has been updated. What code are you running in the BeforeUpdate? Unless it cancels the update, it should have no bearing on this problem anyway...

As I understand it: If there are no records where a check box is TRUE, this expression evaluates to NULL and the error message is printed. If there is one record where the checkbox is -1, the expression evaluates to -1 and the message is not printed. If the value is always TRUE, why would it...

Sorry, I misread your original post. ADO isn't implemented with Access97, so it won't be that. Just opening a file with A2K doesn't alter it in any way as far as I know. I do it often.What happens if you open it again in A2K? Does it work then?

Those two libraries are incompatible, so you can't load both of them. 97 works with 3.51, 2K with 3.6. You can convert an Access 2K database back to 97 though. Look up "conversion" in 2K Help

The Weekday Function.. is what you need. See help under this keyword in Access97. First day of the week can be what you like...

Can't see an obvious SQL error and it works in design mode. Ergo, there must be something wrong with your pick list. Set a breakpoint on the after Update of the pick list and see what value it is actually returning...

The syntax seems to be correct. A similar set-up on my PC works OK. It might be something to do with the way you set the yes/no field in the table. Presumably you only ever have one field ticked, or the expression wouldn't always return the right record anyway. When do you update the yes/no...