Search results

Thanks guys and sorry for the slow response. I've checked the references. The only difference in references is that on the machine where it works, the name of the reference is "Microsoft Office 16.0 Object Library" while on the other it is "Microsoft Office 14.0 Object Library". The same is...

Hi, Sample database NigelShaw posted works perfectly on 2016 office machine. Not working on 2010 office computer. Checked preferences, the same set active on both computers. I am receiving the follwing message: "Microsoft Access cannot run the macro of callback function >name of the...

Hi guys! I am on holiday and just found out that my laptop does not have keywordsearchpane.dll reference installed. Can anybody please copy this file and upload it? Thanks!!!

Hi guys! I need to make report where summary values from page footer from previous page would show up on page header on the next page. Please see attached images with sample of what I need to create. I tried to search for solution, but could not find it on the forum. Thanks!!!

Thanks pbaldy, that was the solution.

No, I just need to change existing (fixed) paths in various well working queries with variable paths. I need that to avoid changing paths in code in case when Access files are being moved from one computer to another, where computer has different name. I want to change the path in a table and...

I would like to make function that will enable me to replace existing paths (\\compName\FolderName\dbName.mdb) with variable as function name. I already managed to use variable which uses path info from the table. The problem with this solution is that I have to write code in every procedure...

The code has fixed path information on a lot of places in different SQLs (DoCmd.RunSqL command). I want to replace fixed path info with variable path info. Variable path info is stored in the table. I managed to achieve that in the following manner: Dim db As Database Dim dbName as String...

Thanks guys, the simplest solutions are always the best. Date picker works perfect. For the sake of subject, it might be useful to know where to find Calendar control in Access 2010 although I don't need it anymore. In case you agree, you could provide calendar control solution for other people...

Thanks for quick reply! How can I make date picker available on the form? Which control in form design is used to activate the picker?

I need to set calendar control as criteria for date in VBA query. I cannot find Calendar control in ActiveX tools in Acc 2010. Where is it? Dare picker seams like very slick and simple solution but I can see it only in database. As it might be solution to my problem, can date picker be used on...

Thank you michaeljryan! I have to put first-day-of-month as default value for a control. After I make Public Function as per your advice, what should I write under the "default value" section?

How to set first day of the current month as default value to a text box? I managed to get current day minus 1 month using: = DateAdd("m";-1;Date())

Yes the db was just copied, not compiled and thanks for suggestion regarding "not working"!

Solved! Made new 2007 version file, imported all queries, forms, reports, macros... Everything is working now. I do not know why everything has to be so complicated with new office and Win versions. Old ones were simple and easy to use. spikepl, thank you for your interest in my problem!!!

Default open mode is set to Shared on com 1. The DB is about 12 years old. It use to work in multi-user enlivenment before, but under XP and prior Win versions. It worked perfect. I had some advance in the meantime... I made some permissions on the file and folder containing the table file. I...

I have a DB that was in use on one computer. Now, I need to set it to work simultaneously on two computers. DB is split to one Access file that contains only tables and to another that has forms, reports, queries, macros and modules. One copy of Access file containing forms, reports... is...

This code will insert external file to email body. Note, procedure must take place only after mail item is set!!! Dim objWord As Word.Application Dim objdoc As Word.Document Dim objrange As Word.Range Dim objInsp As Outlook.Inspector Set objInsp =...

I need to use template for mail body to send emails from Access via Outlook. Templates are being created in Word, or Outlook. How can I insert external word file contents in email body? If using external file as template is not possible, can I locate earlier saved Outlook message in...

If fields on your form are directly connected to table, the data are being saved automatically. However, if you use unbound filed, you need to add a code that will store data in the table. What, if anything, is declared as "Record Source" under the Form properties?