Search results

hi im trying to add the values in the arests collum in my listbox and show the total in a text box on my form any help apprechiated thanks rob :)

Hi you can do this on a form in its properties auto center = yes rob

thanks for the reply when i search for records added in the first month the database was created it works fine but when i search for records in any month after the first month it shows all records and dosent filter any hep welcomed rob search page code attached.....

hi all i have this code to search a date range it works for the first month only ....after that it just selects all records any hep will be apprecheatied thanks rob

cool link used the sode fo email in my project thak you Rob :)

Hi , Thanks for all your help with this. The Way i got it to work is with the following code. It opens the repot then converts to pdf with lebans code then closes the report I put this code into a moudle then called it when i need it. then call the module thanks again for looking and...

Hi i get a error when i call this code ? this is the error thanks for your help rob :)

Hi yes The report uses A saved Query As it sorce (clientsquery1) How would i go about useing a querydef ? could you explain. thanks very much for your help. Rob :)

Hi All, I've been useing the Leban report to pdf code and it works great. My problem is that some of my reports have no filtering from querys. they are filterd by the following code behind a command button that selects, selected records from a list box this is the lebans code (slightly...

Hi Mr. B , Thanks For your help with this ... As you say I was so close yet so far loll cant belive i missed the and :rolleyes: would you belive i spent all day yesterday looking at it and never found the mistake :o Thanks again for your help Regards Rob :)

Hi all, I have a Search form that i am useing (downloaded from here a few years ago) and dont know who wrote it orginaly? Any way it works fine I have 2 search fields that i can search "make" And "model" The problem starts here... i have Added 2 More unbound Textboxes To the form 1 named...

Hi thanks for your help with opening the reports i have sorted that bit now with your help :) I have another question now :rolleyes: I have a field in my table "clients" with a date in it called "installdate" how could i search for a start and end date in that field? I have placed 2...

Hi there, I have read this thread and have made the form and it works great. but im stuck on how to send the results on the sub form to a report? lets say the sub form displays 2 results from my search, i want to send the results to a report. any help or push in the right direction will...

This is good stuff! :) Is there also any way of getting the flash drive volume name my drives called "robs drive" for example, and would like to be able to show this in a form thanks guys Rob :)

Hi wiklendt. there is no data stored on the flash key it uses the serial number of the key to check if it is pluged in. regards rob :)

point taken and i agree but the registery is not that secure also you just need to run a small program that tracks reg entries and changes and then it would be easy to get round also most user coded security is not 100% secure from a experianced access coder /delevoper all we can do is...

Hi sorry for the delay getting back to you. was on assignment :( attached is a sample db that can be used to provide a timed demo (ie: 30 days)to clients using the db properties to store the dates etc. and has the code for checking if the computer date has been put back within it hope this...

Hi mcdhappy80 im working away at moment be back home tomorow will post some info then Rob :)

yep it could be a problem for some ..i dont distribute my databases over the internet as i only supply local govoment there is so meany pros and cons in the diferant ways in protecting your database the registery is a good way also ..its what ever works for your own situation i guess theres so...

If it is coded right the expiry date is preset before given to the client and even if the database is not used it will expire and can not be reinstalled after the expirey date this is how i code my databases you could also code a backdate to stop the client backdateing the system date