Search results

I'm not sure how to do something like that? Could you explain to me the difference between what I was asking for and what you recommended?? Your way might be best, I'm just not familar with what that is/or accomplishes?

I have about 8 tables. But I want to calculate each currency and number field per table. Yes, it is based on the month and year so all of March, maybe 5 records were entered, for each field in that table, i need those 5 numbers/values to be added and the total to be displayed...as you can...

still seeking help...thank you

Yeah your right, but sometimes the users will only need to enter data for one or the other so I decided to keep it simple and eliminate both sets of fields on one form/table. I don't give my office too much credit. Again, even though they are paired...their values have nothing to do with each...

I put a few notes on my dashboard/menu screen. Thank you! Note: There is no searching in this database other than the monthly report. So input forms and the one search....once I figure out the search and calculation my database will be completed.

It's hard for me to describe since I do not know all of the terminology. None of the tables have anything to do with each other. I just need to show the totals of the tables all in the same place (one Form/Report). None of the tables have the same amount of fields and a user may not fill in...

I guess thanks for that DCrake? Maybe next time you can avoid being an ass when trying to help someone on the forum. If I knew what I was doing, I wouldn't be on the forum in the first place. Here's what I need and maybe someone can shed light on the best possible way to set this up. I have...

This would take a lot of work, but should I have set up the database as one giant table. And given the type of form (because it is specific to the user) i just pick what fields from the table I want that person to be able to input to? Note: I have about 200 fields in these 8 forms. Edit: Which...

Hi All, Access 2003. I have 8 tables and 8 corresponding input forms created already for my database. At the end of each month, I need to total each field in each table for that given month and display it in a report. For example...Form A feeds Table A and contains Field A. I need to...

I knew this was simple! Awesome vba, thank you so much!

No. All I want to do is show what I searched for: i.e. what fed ID i inputted in the unbound textbx of Form A. I want to display this on Form B. So text26 of Form A is shown in text21 on Form B

I may be missing something but this is just an unbound textbox where a user will enter in a 9 digit Fed ID and then click a command button to run the search and open Form B. I also looked at my table and my fields are indexed...but again I don't see the connection.

Can someone please help me with this?

No dice. Here is my code: Private Sub Text21_BeforeUpdate(Cancel As Integer) Forms!frmFedIDSearch.Text26 = Me.Text26 End Sub I'm going to attach my database...I think it might be easier to look at then explain and troubleshoot if you don't mind. Upon opening the dashboard --> Click Fed ID...

Hey Everyone, Access 2003. I have a form "frmFedIDSearch" where I enter in a 9 digit Fed ID and hit a search button to open "frmSearchMain" to retreive a record with that given Fed ID. At times, the Fed ID will not be in the system so I'd like to show what the user searched on the second form...

SOS to the rescue...thanks buddy..that works great! And sorry about the yellow, I went to change it to Red and I guess the edit didn't take effect.

Adding or taking away the ")" doesn't work...but that seems fairly obvious

Did you mean Me.Me.VendorName for the change OR Me.VendorName? Either way, I am getting a compile error: expected: list separtor or ) Answer = DLookup("[VendorName]", "tblInputNewVendor", "[VendorName] = """ & Me.Me.VendorName & """)

Rainman, there is a lot of code in there and I'm not sure which one I'm trying to mimic...could you point me a step closer..

Hi All, Access 2003. I have an Input form that stores a new "VendorName" and "VendorFedID". I later use this table to select the Vendor on a different form and attach a W9 file. On the first input form adding a vendor (with fed id), if I add a Vendor's name with an Apostrophe somewhere in...