Search results

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.

Paul, I am sorry, I was working on another project and got confused. You are correct, and what you suggested works fine. Thanks for your help.

I have a form that has a combo box I wish the user to select a "site" from. I would then want a seperate text box to populate with the project manager for that site, which is in the "Sites" table as "PM". I am just unsure of the code to write on the "After Update" of the Site combo box to get...

Paul, I am using 2007. I am only seeing 2 selections through the wizard. 1. "Look up the values in a table or query" 2. "I will type in the values that I want"

I have a form that I have employees use to enter dates for specific records. Right now they have to use buttons to move back and forth between records. Is there a way to have it so they could enter data in a field that would pull up specific records based on what they type in rather then...

Thanks for the info Shane. Sorry to say, I am actually gonna scrap this idea, and try something else to solve an issue I was having. I appreciate your help in this matter.