Search results

Of Course! Thanks! Now, how does one combine one string with another? So, for example i have now got "10 February" with "2005" - two different strings? Update: I think i got it. I used CDate(strEndMonth & " " & strEndYear) to combine both strings with the gap in-between. Thanks! Popolou

Hello all, Ultimatey, my problem is linked to another issue i have posted, but since its a totaly new request..... How can you extract a portion of text from a string? I intend to convert a date entry/field into a string and then extract the day and month, leaving behind the year. So: -...

Hi Rich, The interval will always be a whole number of years and remains fixed for the whole term length. Previous dates are not required and the property (building) will have as many inspections as there are review intervals. So, if a term length of 25 years existed on 5-yearly intervals...

Not so much a solution, but a practical answer to the problem. If you use distiller, why not get access to print to a file and choose a working postscript printer. Then, through distiller, set up the watch folders and at your preset time interval, it will create the pdf which then can be dragged...

Rich, Can you kindly extend on what you just said? Update: Just read up on what you said I am not sure how this works. I tried this via the expression builder (while i still had some hair) as part of my starting efforts but it seemed not sofisticated enough to handle the formula. I will...

Can this be carried into some sort of VB that updates a field? You see, i have a form that upon entering the data updates the relevant field - in this case, the next review date. I have enclosed an image with this exactly. The form shows the inputs in the middle, with the outputs to the right...

I'm after the next review date on supply of the start date, length (in whole years) and review interval. Check out the example i provided in the OP. The problem is, it has to ignore previous dates and calculate the next according to the review pattern (in the case of the above example, 5-yearly...

Yeah, me think thats the best course. Problem is, i dont think i have enough of the skill necessary to get that silly formula licked: - Rent Review Date = (Term - ((Lease Start Date + Term) - Today's Year)) + Lease Start Date Ya'know, what a breeze this would have been if it was Excel. For the...

I may be mistaken, but this is not related to Access, but rather a general fault. Have you tried printing to the PDF printer normally, say via Word? Is it a local printer? Shared PDF Printers over a Lan wont work. Hope this helps Regards Popolou Update: Found this and i think it hits the...

The_Doc_man, I am much obliged for your time and efforts. I just want to point out that there is alot i hadn't mentionned about the remainder of the database, yet you picked it up rather impressively. Actually, dont get me wrong. The frontend (and most of the backend) of the Db has already...

Well here it goes. I would be eternally grateful for any insight into where i am going wrong. Background I am creating a database for collecting details of commercial properties. The essential data is the Lease start date, Lease length and a review every 5 years into that lease length. Issue...

Well, i decided to revisit the situation with update queries. I required the procedure to confirm with the user to continue with the search and mark those results as "read". This was to exclude them for any further searches next time round. I had initially created a macro to present the option...

Thanks for your input. I came to that possibilty too however, i need the option to mark the results as 'read' or not and hence the macro with the VB. Ideally, is there code that can do the same do i can enter it into the macro? Thanks again Regards Popolou

Marking Query Results as "Read" Hey all, Maybe someone who knows what they are doing will get further than me on this! I need to be able to mark the results of a query with Yes/No data. To be more precise, each entry has a tickbox and i need to be able to "tick" the search results only while...

Hey there, I came across a similair issue the other day and resolved it using the "Between....And...." parameters. For example, if you want to collect all the reciepts within the last 10 days i would use something like: - Between Date() And Date()-10 Or, if you wanted to get a particular set...