Search results

G'd evening, The Application.FileSearch no longer exist in 2k7/2k10/2k13 the most popular workaround is here G'd luck

Thanks for point that out! As a matter of fact i use to use vba.now instead of vba.date in my answers. The reason is that unless the question explicitly says that the time part is not required. From now on i'll keep that in mind. Cheers!

G'd evening, The answer to your last? question is not. That function is commented ' and won't do anything. If you uncomment that line the code will break. You can't declare a function within a function. By the way, in simple words, a public function is a procedure that you can call from...

G'd evening! First of, you don't need to create a variable for your textbox, second you don't need the value method, third to work with dates you should use vba.datediff, vba.dateadd, vba.dateserial etc. In your case you accomplish that in several ways. Here is an easy way: DateDiff DateDiff (...

G'd morning Daniel, What's the error number/description? have you tried early binding?

Hello and welcome! I guess that many people here may be willing to help, but you're telling us your requirement but we know nothing about your db. I may say: create a table with 31 rows and match the date. Then you'll end up with a report with 31 lines per Attendee... This may work or might be...

G'd evening, You can't copy a file just like that. You need to supply the full path and destination file name. Like: Filecopy "c:\song1.mp3","f:\anynamehere.mp3" G'd luck

Hello, I just finished prepared the input data stage. With this i think you can move on to work in the output and all the helper forms. I don't know if this is what you're looking for, but at least will give you some basic guidelines to build your own. Keep the images folder in the same...

After all i was partially right... i'd said that there is no code to check for the existence of a mailbox beforehand, and that's not true. In fact there are handful of scripts to do it. The problem (putting aside if can be implemented from access or not) is that not always work... for many many...

Hello Karen! i'm glad to know you found your way. A great day for you too. Best wishes Estuardo

Hello! I'm sorry i couldn't get back to you before, i just had more work of what i'd expected. I didn't quit :) . i'll try to make time today and come back with something. cheers!

I'm glad to know :)

G'd afternoon, Go to: File-->Options-->Current Database in the center area look for the "Navigation" section. Check the option "Display Navigation Pane" G'd luck

G'd Afternoon Steven, Access has its own timer function, but if you need a high speed function ChrisO developed his own version and shared with us his high speed Timer function. Also Alastair shared his Timer Database. Try that code and let us know if that solved your problem. G'd luck

G'd Afternoon KAren, It's a pity access has not a built-in function for this, but like you said the code doesn't look that complex :) . Best wishes

G'd evening Karen, the common way to do this is via FTP, what is not common is to do it with Access... But AJ and DCrake shared their code to accomplish this unusual task. G'd luck

G'd evening Mike, Following your example you don't need another table. you may need another column in your address table. That column might be a Yes/No type. This way you can select the confirmed address. G'd luck

I guess we're going in circles :( . In the Orders form you can add as many orders to the same customer as you need. That's what orders form is for. Add Orders to the same customer doesn't means that should be the same order. In fact orders are not made the same date and not necessarily...

May be you need to add some time to make it work. here is a full documentation. G'd luck

G'd Afternoon, May be i not following you... If you have a form with that button "AcceptChanges" you want to execute all that code and at the same time a msgbox in front of the form with the options "Continue" & "Cancel"? You can't cancel a query execution without affecting the processed rows...