Search results

Used to working with VBA in Access. I am used to having the ability to trigger code happening if anything in an option group changes. Say I have radio buttons or check boxes within an option group. I could use the OnChange event of the Option group which would trigger code whenever any radio...

I didn't know you could do that. The two fields, together, make a PK. By themselves they are not unique. Anyway it's working now.

Works fine now. I'll just have to update my import methods, but rather do that than mess with the dual PK issue.

Well I just concatenated the two fields into a new field, made that the primary key. We'll see what happens.

It won't let me define both of them as unique. Probably because they aren't. If they are one field, they are unique, but as two fields, it is possible to have duplicates. But I don't want any where both fields are identical, which would indicate a duplicate account.

One more issue.... Code works fine on a temp table, but not the main one. I'm assuming it's because of the size... Temp table that I was testing with is about 25K records. The main table has 477K records. Is there any way to speed this up that you know of?

I have had problems with it not incrementing correctly, and I have to run some code on the back end to reset it. This has happened with a few databases that are heavily used. I don't know what causes it. I have heard that setting it to random fixes this particular issue. I just haven't done...

Yes, I did see the transactions portion. I have not done that before, but it does not look that difficult. If I run into issues I will just add a random autonumber as the PK and mark those others as unique. I prefer not to use an autonumber if I can. Thanks again!

Awesome! That works great! Having the two PK's was my entire issue...else I would have had the query right previously. Performance is fine, just a couple seconds. Once that's done, grabbing the ones that only match theirs should be really quick. Thanks so much!

Perhaps. I tried the IN part before, but it wasn't working right. My main table has 2 primary keys. Basically the two fields contain a whole account number, but they are split in two pieces. The first is a branch, the second is the rest of the account number. So in order to insure no...

Yes...well then I'm back to my other issue. I don't want to update based on any criteria. (Rather, the criteria I want to update based on will return all unassigned and uncompleted records, but I don't want to update that many.) I just want to update say 50 records. The only criteria being...

I have decided to go a completely different route. Here is a function I made which will get and assign new records to an individual. Public Function getNewRecords() Dim db As Database Dim rs As DAO.Recordset Dim strSQLFunc As String Set db = CurrentDb()...

I have error handling in it, and it pops up my own dialog box when the error happens which I have in it do On Error.

I have a few people getting this error in my database. Happens when they try to save a record and then get a new one. I have searched on Google and not found anything that seems to be related to my problem. I'm just curious how to get around this error. I don't mind if it pops up, but I want...

They mark it complete after finishing their call, and mark the result of the call. This is a single form which loads only one record at a time.

Where in your code are you running it? Try Me.txtBoxName or Me.txtBoxName.Value If it's not in the forms code, you need to reference the form name: Forms!formName!txtBoxName.Value

Well, it's not locking per se - but locking them from being able to view. I thought that this might be able to be done via some method I was unaware of. Apparently not. Because this information is used to call customers. We don't want to call a customer more than one time. Thus, if two...

I was wondering what you were talking about, then I saw you edited your post. Thanks for sharing.

I see...I think I often times overcomplicate things. Am I correct in assuming that adding the vbNullString will eliminate errors with the Len() function should it actually be a null value?

I'm sure it can. This is what I could come up with on short notice though, and it would work. I would certainly be interested in other methods.