Search results for query: *

Can I use an "If" statement in the critera of my query? If so, I am trying to return a value from a table in one column based on the condition of another column? Is this fesible? How do I do it? Thanks Jim

Can I give my users a pop-up calendar with which to populate a date combo box? Thank You, Jimenda

Part of my Db is a time clock type system in which my employees "clock in" and "clock out" of lunch and the workday. Is there a way that I can work with these timestamps (formatted as HH:MM) where I can calculate sums with the existing data? Being that it is base on 60 minutes to the hour I am...

I am trying to build a report that gives me the sum of the values in a field of one of my tables. I would need this sum to only be from selected entries in that field (conditionally selected by the entry in another field in the same table), also I need to format the entries to be summed up...

Thanks for the answers. But, maybe I'm not approaching this correctly, is there a way for me to display realtime on a form?

I have inserted a date/time box on my form and I would like to refresh it. It current just remains at the D/T when I open the form. So, how can I refresh data in certain portions of my form? Thank You Jimenda

I am setting up a time card type Table/Form I would like to have the time values entered into my table from the form to be negetive values if the user choses "back from lunch" or "clock out" in another combo box. Right now I have hidden text boxes that timestamp my record (I have done this to...

I would like a certain combo box on my form to only be visable (and functional) if a certain value is chosen in another combo box on the same form, is this possible? I also am looking to have a audio response made (in WIN XP) if a Certain value is chosen, how do I make this happen? Thank You...

Maybe I'm not bringing up propreties correctly. For one, I am working with ACCESS 2000. I right click on my form and bring up prop. I do not show a timer catagory under events. What do I need to be doing? Jimenda

Thank You Both. Where can I find the "Timer Event " on my form? Jimenda

I would like to have a text box on my form that displays a running current time. I would need to use this text box to timestamp any entries thru the from. Any help would be appreciated. Thanks Jimenda

I need help to see what I am not seeing, I have five combo boxes on a form, four of them you can drop down and select an item from the list, the item is then displayed (selected) in the combo box area. My fifth box will drop down yet it will not select, what am I not seeing here? Help if you...

Hi, When my ACCESS Db is first opened I have it display just my form without a window. My form has 8 combo boxes in which items are selected and then save to a table by clicking a submit button. My problem is that whenever I open my database my form displays as it should, but it...

I have a table with about 10 different fields, I would like to retrieve data from this table. What I am looking for is how to set up some type of shell in which I can choose a value and a field and then have each record in the table in which the field value matches my input value, then import...

g, Thank you for your help and patience. I did finally get the event sub to what I wanted, I added a line: DoCmd.GoToRecord , , acNewRec just before my other actions, this seemed to straighten things out. Once again thank you. Jimenda

I don't know if you can tell by my code but my table does not update until I click on the submit button (Enter Sub) & then it always write over what was on the top line with what is in my 7 combos. What I need it to do is to create a new line(record) and then input combos data, any suggestions...

Thanks g Sorry about the Dups, new at this. In my table that I am updating thru my form, it just seems to keep re-writing the same record and incrementing the ID #. It is on #6 now (after 6 test inputs) but only 2 records show on my table and the navigation bar only shows 2, the...

Thanks, I did go back and use the wizard and I got the table to update. But it updates the table on the same line each time. How can I get it to generate a new record each time and to save after each update? Thank You and God Bless, JIMENDA

I have a form that has 7 combo boxes, I would like to be able to make a selection in each box (if no selection made, then default or null), and then click on a button and have the selected items in each combo box to update/add 7 separate fields on a new line of a separate table. If anyone can...