Search results

Hi guys, I found the following code on the forum: Public Sub SendEmail() Dim thund As String Dim SendFrom As String Dim Email As String Dim cc As String Dim bcc As String Dim subj As String Dim body As String SendFrom = "test@test.com" Email =...

As a follow up to the earlier thread, I am trying to build an all Access chat. It should be a fairly simple project. To understand it fully, it would be necessary to learn more about the setup and solutions already implemented in the application. The information can be found in the already...

Hi guys! Simple code that successfully controlls the form on another Access file, on the same PC is: Funcion RefreshAnotherForm(strDbPath As String, strFormName AS String) Dim objAcc As Access.Application Set objAcc = GetObject objAcc.Docmd.OpenForm strFormName...

I need to input data to unbound form field from another Access database file. The event is to be triggered by a button in DB-1 and should input data on the form DB-2. Basically, when the button is pressed on the form at the DB-1, the unbound field at the DB-2 form should display a certain...

Hi Guys, I want to use one Function to trigger button action in the right-click menu conditioned by the button selected on the custom right-click menu. The function that activates the right-click menu: Const MyString As String ="MyMenuName" Dim cbar As CommandBar Dim bt as CommandBarButton...

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!!!

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...

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...

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())

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...

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...

I need code line that will Request Delivery Report in Outlook 2010. I know about ReadReceiptRequested reference and that is not what I need as it tigers "Request a Read Receipt" checkbox in Outlook 2010. I need a code that will check "Request a Delivery Receipt" box!

I need to use HTML template file as body in emails. The emails will be sent via Outlook 2010. The code I made is working well with .oft files, but these files are being received as plain text, although they are sent as HTML and although they appear fine in sent box. After googling, I found that...

I need a query that should filter null records in text field. If I set IsNull criteria, it is returning 0 records. If Not IsNull is set, it returns only records with data in the field - as it should. I have checked if the value of empty field is null by opening recordset and trying to present...

I need to create a query that groups records at certain interval, every x records. How can this be done? Tks...

Basically, that is the question. After data entry, and saving procedure I need to get the ID for that entry. Private Sub dgmPotvrdi_Click() Dim db As Database Dim rs As Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("klijenti", dbOpenDynaset) rs.AddNew...

I need to activate dao360.dll file, Microsoft DAO 3.6 Object Library, on the list of references. I have it in the list and when I click to activate it, it informs me that there was an "error in loading DLL". Please if anyone can help, I need to fix this problem by tomorrow afternoon latest...

I just swithed from Office 2003 to Office 2010 and my forms work funny now. Every time I want to update record on a form, based on control selection, I have to hit refresh button. I know I could solve problem with me.refresh, but I have a lot of places to put that command. Why is this...

How to change access icon to application icon in the task bar in office 2010? I was using office 2003 before and, when application icon was set in start up, it was automatialy visible in the task bar. Tks!!!