victorl
Last Activity: Jul 8 '10, 07:20 AM
Joined: Jun 24 '10
Location:
-
I fixed it so thank you very much everybody. To be specific, subscription is not its actual use but it was the easiest way to describe it as in order to get some information that were similar enough to help. I already tried asking direct questions about it since it is a companytask database with special requirements but without results, anyhow this helped me a lot so thanks again. -
Any help will be extremely appreciated now, it is my final day with this project and I have to get the loop working, loop the code above, just tell me how to write in order to do it, I think Jim may understand as his code is the one I want to loop. Be assure you will get a donation for this help. Once again, thanxLeave a comment:
-
I am trying out Jims code, as it works to get the next subscription, what should I do when that day has passed, like I subscribe 1st august using weekly subscription, then it will tell me it is renewal on 7th august but when the date 7th august has passed it must show 14th august as renewal otherwise it will remain useless.
And if anyone else may have use of this code,
remember you can add this too
Case Is = strSubScription Type:...Leave a comment:
-
Thanks for the input NeoPa!
Anyone know about for how long it will be repeated?Leave a comment:
-
Hi!
Yeah I get the idea, just a few short final questions, when using a line like this mentioned
" Case Is = "Weekly": RenewalDate = DateAdd("w", 1, dtSubscriptionD ate)
will it be displayed forever ( every week) or just once?
And as well, If I thought the "w" will return weekdays (5 / week) while "ww" returns it every week, correct me if I'm wrong.
...Leave a comment:
-
Dear Nico and Jim!
Thank you very much for the help provided.
I am sorry I did not provide enough details to reach out with my point.
I have already done until the combobox as in Jims reply. But then in the end, I want to be able to type a date and find out if I have to send any invoices that date. I was able to find the date using the search I created by typing subscription start date and subscriptions first...Leave a comment:
-
rebilling and repeating date
Hi!
I have been looking a bit into creating a query with function that repeat a date.
More specifically I want to create a new field named next renewal date based on "Subscripti on start date" and "Subscripti on type" weekly, monthly, quarterly.
Any help will be very appreciated. -
Hi Beacon!
Thanks a lot for taking time answering my questions.
In fact I already created a few forms. One for data enter and one for data removal. Actually the form I could not really figure out how to code is about the last one with parameters for report.
I will be looking further into the time parameters to figure out how to get the time to work correctly. For example: I add an issue the 3rd May, and prefers...Leave a comment:
-
Matching several criteria for date and time
Hi!
I am about to create a workdatabase that will let directors submit work into it and employees to get a report by filling in details in a form as well.
Then I also have multiple fields of time format that will need to work in the selection form to create a correct report for that employee and the current date.
What I mean is that I want access to check the following when I fill in the date: Which weekday...
No activity results to display
Leave a comment: