Search results

Good to hear, glad I could help.

Well, forget I said anything then.... How do I go about digitally signing the front end? that would be nice to know <---- Nevermind, I gooooogled it! Looks like the company plans to deploy in delphi are cheaper than getting a signing program anyway. thanks for advice. I will change back all...

Hi, Can you hold shift when opening the database toallow you to get into the forms, tables etc? If so you whould be able to goto options and change the startup form. If not, i am out of options, sorry.

Hi guys, Long time since I posted, but I have actually done this for all my work PC's. I am the designer and programmer and all other machines are running runtime only. Just paste this into a text doc and save as a .reg file, then run it on each PC as needed to import into the registry...

Hi icemonster, It could be that when the form opens there are no controls or text boxes near the top for the focus to go to. Try setting up a hidden button with no command behind it as the main focus when the form opens.

You had this in your example. Me.Field2 = DateAdd("yyyy", 3, Date) Try this instead Me.Field2 = DateAdd("yyyy", 3, me.yourdatefield) The last part of a dateadd command is the date to compare it to. it does not have to be the actual date. hope that helps

Thanks Bob, I have been using dateadd in most of my queries and even had to concatenate some fields due to having my date format in dd/mm/yyyy format instead of the Access expected mm/dd/yyyy. This I found especially true when building SQL queries in VBA, the date format does not automatically...

I take it using the "m" in Dateadd does this then to save the tricky calculations with month lengths and the annoying February length every 4 years. Thanks for the answer. Clarifies it nicely.

While this post is still open, I thought I would ask. Why use date() + 14 instead of dateadd("d",14,date()) ?? Is it the same or does it evaluate differently depending on where you use it? Thanks.

2 questions. 1.)Are lngId and LamID on the same form where this is running from? 2.)Are they text or number fields? I would definitely go with spikepl, use the debug.print command and even put a breakpoint on the code when it runs so you can see the result. what i do then is copy the SQL...

Hi Graeme, I replied with this example in the forums a little while ago and it has worked for me during my ongoing project at work. hope it helps you http://www.access-programmers.co.uk/forums/showpost.php?p=924191&postcount=6 Kev

Hi dnphm, Try this (http://www.lebans.com/reporttopdf.htm). I had to use something like this for my work as they won't part with the ca$h for A2010. I also have the unfortunate hassle of having to export the pdf to Lotus Notes. One rhing I have noticed with my own use is that sometimes you may...

Hi welcome to the forums. Try this page here http://www.databasejournal.com/features/msaccess/article.php/3548586/Auto-Logout-Users-for-DB-Maintenance.htm it may be what you are after. When you tick a box it logs of other users and prevents them from loggin in until you are completed your...

Hi LadyDi, I hope you are still trying to work through the project. I used the one attached here as my starting point and it helped a huge amount to give ideas and made a great starting point for me. http://www.access-programmers.co.uk/forums/showthread.php?t=154067 HTH

Hi Ollie, I had a similar problem recently with a db I have created for work to keep track of mistakes made in a warehouse operation. Instead of deleteing the staff, I have check box for 'resigned'. The queries then look up all records where 'resigned' = 0. This way the records are all there...

Why not put this into your query as a custom Expr? Then you will get that in the correct place on your form?

Hi peoples.... I am trying to modify the idea presented here ( http://allenbrowne.com/ser-62.html) to be able to have a pivot chart in the form footer (as a subform). The footer is made invisible until the search button is clicked then it show up and should show only the data required. I am...

SOLVED. I found the solution, if anyone is interested please note here. Cheers for the prospective help anyway. I did have to use a me.formcontrol.requery in the onclick and the ongotfocus events to make it work.

I am not sure how possible it is, but I want to be able to do it. I have a form that lists employee info - simply name(txt), staff number(num), two dates (next review and last review) and a comments box(memo). I have added a bound combo box for a who reviews next field. I need this combo to...

Hi Teddy, Create a query from your Data and add the line at the top of an empty query expr1: Rnd(Len([FieldNameGoesHere])) ensure the properties are set to Top and choose 1. You do not have to show this on the form so it does not matter if it is visible or not. then do this again for a new...