Search results

I've been trying to apply this code onto an unbound text box as indicated, but it's not working. It's displaying the "#Name?" instead. I also tried to use this on a report to test it and the "Enter Parameter Value" message for the Me portion popped up. Do you know if it's not noticing the...

Hello, I'm trying to figure out how to pull information from one field on my table and have it displayed in conjunction with a preset text value as well. I have a small DB that will create invoices for document reproduction jobs in our office. My vision is to use a bar code (which the font...

Taking your advice into account, I've decided to use the calculated amount and set it to a field on this new form. This way, users on the other end don't have enter anything as the total amount is already listed. Here's the new challenge: My original table is a record of each check that our...

If I could set up a module to do this then I wouldn't be objected to it. The person requesting this change might be interested in this solution as well. Would you know how to set something like this up? I appreciate your reply to this thread :)

Hello, I'm working on a database currently that needs validation of an amount before a record can be saved. Since I'm very new to VBA, I'm hoping someone might be able to assist me in this procedure. So my database is working with checks and monetary deposits. On the particular form I'm...

The unit that enters this information is requiring this as a "business rule", therefore I have to make a required prompt. I figured that using a lookup function would suffice, but they've specifically asked me to do this. I've created a separate table for the data that they will need to...

The information being entered will be located on a form. I'm just not too good at setting up the syntax for an error message. I'm also confused as to which event procedure I need to have it run on (AfterUpdate, OnExit, etc.)

Hello, I'm trying to create a custom error message for my database. I'm not too experienced with doing this, so hopefully I can get some help. I have a TotalAmount field that needs to needs to match the exact currency input as the amount field in another table. I need to create a code for a...

I never thought of this structure! I appreciate your help in this matter greatly!!! Thanks again, Matt

Here's a quick breakdown of what I'm tasked with: Our division receives payments for various reasons. Since our office only accepts payments by check, it is my duty to maintain a database that records the information for our accounting branch. Every week or so, we'll enter these checks into...

Do you have any suggestions for normalizing this DB? I've heard the term many times but am not too familiar with the process. My forst guess for this would be to create an individual table for payments/refunds in general and to relate them to both the Main and Refund tables. This way, the...

That's correct. We enter the checks received (our only form of payment) as one record at a time. We don't need a separate table specifically for parties/customers since they are sporadically received. Because of this, we'll only need to issue one refund per check (record) received when a refund...

I've attached an example of an entered record in both the Main and Refund forms. The Refund form is based on a query but the recordset property is set to Dynaset so both tables will be modified. I hope this helps addressing my issue. Thanks again for your time

Hello, I'm fairly new to Access, so while creating a DB for my office, I came across a tricky little problem I need assistance with. I'm creating a DB that tracks payments made to our office. In the main table (titled Main), I have the typical fields for each entry (FirstName, LastName...