Recent content by MrMitch

Thanks for the info Steve. Unfortuantly, I am not versed when it comes to SQL statements, so I don't know if I will have one of those moments. :( Regardless, thanks for the effort in trying to educate me. :) I guess, I'll try and do some reading and see if I find out how to use that for...

Sorry, I forgot to mention I also want to see where the Employee_Name field is the same as well, so it would be... If the date, employee name, and site are the same.

I'm sorry, I may be confused. Do I put that in my sql statement? Also, I don't want to enter a date, I just want a return of all records that have the same date and have the same site. So if the date is the same, and the site is the same, I just want to see that data. My Site Field =...

Hi all, I have a table I am trying to query with certain criteria, and I am just not getting how I should be setting this up. Table Fields [Name] [Date] [Site] [Task] [Cost Code] [Category] [Hours] [TMUP] I basically want it to return only records where the Site field is the same on the...

Perfect. Thank you very much. :)

I have a 2 button group that I would like, depending on the selecting, to show or hide a Command Button. This is what I have right now, however, if only seems to work when "Yes" is selected. When I try and toggle back to "No", it does not make the button visible. Any help would be...

Thanks for the info. After doing a bit of reading, and trial and error, I have an update query doing this for me. Phew!

Tables: POs Cos Form: frmCO frmPO In the PO table there are records per "site" that have a "POCurrentAmount" field. When the "frmCO" is filled out, it has a "COAmount" value that is stored in the COs table, which I would like to be added on top to that POCurrentAmount field in the POs table...

RG, Thanks you so much! You rock dude. That works perfect.

That works, and I added a + 1 to the end of it so it would add each time the form is used to add a record, but I need that +1 based on the records in the table so it looks at the "site" field and it will see if there is a record for that site, and if there is, to simply add a +1 in the CONum...

Thanks for the info RuralGuy, unfortunatly, I am still pretty new to access and vb. I tried working with what you sent me, but I just dont think I understand how it should be written out correctly to get what I want. =/

Form: FrmCO Table: COs Table: | PM | SITE | COTotal | CONum | B. Smith 7-0121 $14,000 01 I have a field on the form (CON) I would like to look at the table and see if there is a CONum for that site when that site is selected on a combo box (Site), and if not start at...

I have records that have a field for a currency total. However, in the future there will need to be amounts added to that record in a seperate field to show additional amounts. Would it be better to have these amounts go into a seperate table? In the end, I need to show a report that can...

Is there a way in a form to have a text box setup to add a new field to the record it is accessing at the time? If so, how would I go about setting that up? Thanks.

Worked great Zaeed. Thanks a lot.