Search results

Resolved :) You kind of nudged me in the right direction. The issue was that I was expecting the code to apply all records within a given form. This, I now realize does not work, and the code only affects the selected record. I found a workaround after that became clear that is very database...

Hey, thanks for the reply. Yes, one form will need to activate the code for the other form. The other form (the form which the code affects) remains open after the form which activates the code closes. Hope that's clear.

Follow up question actually! While the code worked when used applied after the form itself was updated, I also need to give this command when another form closes. How can I specify for a field in another form to take another field's lookup column value within the same form? I tried...

Worked like a charm, thank you. I will look into how to normalise the database. It was an inherited system and I'm somewhat new to data management. Appreciate the help.

Hello again! Much simpler question this time, despite how the title is worded :) What We Have: We have a form, which has a field linked to a "Recipients" table through a lookup. The field is bound to the recipient's name, but the lookup displays additional columns to help the user identify...

Hey David, Just one last thank you. Successfully implemented your solution into our database system this morning. Working perfectly. Best of luck to you in the new year! Rob

Just wanted to say not to worry about it, I realized my syntax was incorrect. The underscores were not necessary :banghead:

Will remember that. But another question. While implementing your technique, I am having an issue with the queries. I am modifying the appendCurrentToTemp query and am running into a error I'm not familar with. What I've done: Within the appendCurrentToTemp query, I modified this line...

Hi David, I've gone over your solution and again, I have to say thank you. I've been able to learn a lot from it, but I do have a couple follow up questions. 1) Within the FormExpenses VBA, I see DoCmd.OpenForm "formSplit", , , , , acDialog Why are the commas with spaces necessary? 2)...

David, you're example is amazing. I'll need more time to fully explore it, and this will probably need to happen tomorrow but I'll reply back if I have any questions. Thank you again for your help! Really appreciated.

Hi David, My mistake I missed that. All of the recipients will be pre-entered by the users and then reused. So no, it's not possible an outside attendee to occur. They will be added into the recipient table prior to the completion of the payment entry. Thanks!

Can ask as many questions as you'd like, I really appreciate the help. .accdb format

It stores the record automatically when you leave the record and proceed to a new blank form. Thanks again.

Hi, thanks for replying. Mihail - Yes I'm 90% sure the database is normalized correctly. I assume it would be running into functional issues if it were not. It's been in use for half a year now and we have extracted CSVs of the transfer of value data several times before. David - The...

Good morning everyone, What the database currently has: A payment entry form consistenting of many fields. This form populates a payment entry table. Some of the fields within the payment entry form are linked to other tables and queries for data (such as a recipient list). What the...

Hi Gina, Thanks for your reply, I'm relatively new to Access so will need to work on my query for a bit. Hope it works!

Hello there! I need to merge two tables together, but not create new rows of data. So for example, I will have a table provided to me with the following information for one entry: Individual ID number (table key) and the Individual's Name. I will then need to populate the unknown data...

Hello again Pat, thank you for your help, but the form still isn't working as desired. When you clear the Recipient Table, and enter the first recipient. The code works fine, and doesn't trigger. But, when you enter a second recipient, even with a completely different Entity Name, the code...

I'm having a bit of a struggle... Here's the code: Private Sub Entity_Name_AfterUpdate() If DCount("*", "Recipient Information", "Me.Entity Name = Me.Entity_Name") Then MsgBox "Recipient already exists. Please choose another.", vbOKOnly Cancel = True Me.Entity_Name.Undo...

Edited: Deleted, follow up question not required (for now) :) Thanks