Search results

I have a form with a subform. I have an event on dbl-click on the subform's detail section, I want to display yet another form - frmDatePopup depending on a value in that subform. frmDatePopup has an Eval(Forms!frmDates!Start) for criteria for my date field. The problem is that when I dbl-click...

I decided not to use the code and in stead use a Delete query that runs after updating that field and it works great. Please let me know if you think that code would be better than my delete query. Thanks everyone!

I'm still struggling with deleting date range. I got a lot of help and finally got it to populate a range of dates. What i need help with is deleting that date range if user makes any changes. Let's say user originally selected Start-01/02/05 through End -01/05/05. Fill in between code that...

That helps as well... Thank you. But could you steer me in the right direction for deleting date ranges as well? I'm assuming that part of the code to add the dates to a new table will work for deleting them as well. I just need some help on what I need to change. Thanks again for all your help...

I figured that one out... I just had to save current record before that code ran. Once I did that, the error has gone away and it works great! Thank you. However, I do have another thing that I need help with. I thought that users could come in and change the start/end dates on that particular...

No, I did have a problem, but I deleted that message because I thought i was getting to be a big pain. Thank you for posting this. I made the change and tried to run the code without any data in the tables and I get stuck on rstOrig.MoveFirst it says No current Record. Any ideas? Thanks.

Actually, never mind... This works because DateID is different in the new table. Sorry... Thank you for all your help!

working, but...not correctly Thanks for posting a reply. This worked, but... I have 2 different records there one 1/1/05-1/10/05 and the second one 1/15/05-2/15/05 This code produced the dates from 1/1/05 - 2/15/05 and what I wanted to happen is to produce those dates depending on that record...

OK... I partially figured it out and some of the code is working, however I can't figure out how to make it stop looping. Not sure what I need to change. It does add all the dates I need, it just keeps going and adds them... Hope someone could help me figure this one out. Thanks. Here is the...

found something, but need help Col, Thank you for all your replies. I did find something here: http://www.access-programmers.co.uk/forums/showthread.php?t=14065&highlight=InBetween Posted by Harry a while ago. I'm pretty sure this is the code you were reffering to. I added a button, for now...

Thank you, I will do that.

Right now I'm not using any criterias at all. But what I want to happen is somehow the date range to be automatically populated day by day, rather than day range. What would this criteria: "Between Forms!YourFormName![StartDate] and Forms!YourFormName![EndDate]" do, where do I need to put this...

On my form I have a start date and an end date (form is based on a query which contains a DateID as PK and 2 date variables). Let’s say the user picks 1/1/05 as start date and 1/10/05 as end date. Right now everything is stored as a range of these dates 1/1/05-1/10/05. What I’m wondering if...

I got it figured out. I used the Group By in the query and it worked excellent. Thank you for the efforts. Always appreciate everyones help! :D

I need some help figuring out how to sum all values for a variable based on another variable. Here is an example: I have a Unit (Programming, Consulting, Training) and I have a variable called FTE which tells me how much that particular Unit is used. All I want to see on the form is Unit and FTE...

Thank you for your replies. They helped!

When I open this database, I get this strange error...see attachement. However when I go into References I don't see anything for comdlg32.ocx Any ideas how I can fix this? Thank you for all your help.

That = to "" produces the exact same error, I already tried it. I can set a default value, but what do I set it to? Thanks!

Is there a way to assign a Null value to a combo box in the OnLoad event of the form? I tried Combo0 = Null and it's telling me that I can't assign a Null value to a non-variant. Thanks.

I got it figured out... thanks.