Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 106
Search took 0.01 seconds.
Search: Posts Made By: Acke
Forum: Modules & VBA 10-27-2019, 06:53 AM
Replies: 12
Views: 257
Posted By Acke
Re: Rightclick menu - OnAction with conditions

Thanks for the comment. Not sure what you are trying to say. How would you organize codes in this case? I am not a professional programmer.
Forum: Modules & VBA 10-26-2019, 12:28 AM
Replies: 12
Views: 257
Posted By Acke
Re: Rightclick menu - OnAction with conditions

I am sorry, I still don't understand how to set the condition at Function "DoSomething". What should be listed after "Select Case" in the Function "DoSomehting"? Please see both codes as they are at...
Forum: Modules & VBA 10-25-2019, 12:02 PM
Replies: 12
Views: 257
Posted By Acke
Re: Rightclick menu - OnAction with conditions

Where should this be listed? The function that triggers the contect menu, or Function DoSomething()?
Forum: Modules & VBA 10-25-2019, 11:39 AM
Replies: 12
Views: 257
Posted By Acke
Re: Rightclick menu - OnAction with conditions

The Tag value from context menu.

If "button1" (option one in right-click menu) selected, do "action x". Using "bt.Tag1" as condition.
Forum: Modules & VBA 10-25-2019, 10:47 AM
Replies: 12
Views: 257
Posted By Acke
Re: Rightclick menu - OnAction with conditions

It looks as if you understand what I wan to do.

I am not sure how to write the rest of the Function "DoSomething". How should I make a connection between bt.Tag from Function that triggers the...
Forum: Modules & VBA 10-25-2019, 10:25 AM
Replies: 12
Views: 257
Posted By Acke
Rightclick menu - OnAction with conditions

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...
Forum: General 09-23-2019, 09:59 AM
Replies: 18
Views: 6,927
Posted By Acke
Forum: General 09-21-2019, 12:26 PM
Replies: 18
Views: 6,927
Posted By Acke
Re: Which image formats to use with ribbon buttons?

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...
Forum: General 09-15-2019, 07:59 AM
Replies: 18
Views: 6,927
Posted By Acke
Re: Which image formats to use with ribbon buttons?

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...
Forum: Modules & VBA 07-03-2015, 01:20 AM
Replies: 1
Views: 353
Posted By Acke
keywordsearchpane.dll Missing

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!!!
Forum: Reports 04-19-2015, 10:22 PM
Replies: 0
Views: 386
Posted By Acke
Transfer page footer summary values to the next page

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...
Forum: Modules & VBA 06-20-2014, 08:02 AM
Replies: 10
Views: 846
Posted By Acke
Re: Function to return string

Thanks pbaldy, that was the solution.
Forum: Modules & VBA 06-20-2014, 06:19 AM
Replies: 10
Views: 846
Posted By Acke
Re: Function to return string

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...
Forum: Modules & VBA 06-20-2014, 05:45 AM
Replies: 10
Views: 846
Posted By Acke
Re: Function to return string

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...
Forum: Modules & VBA 06-20-2014, 05:22 AM
Replies: 10
Views: 846
Posted By Acke
Function to return string

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. ...
Forum: Forms 08-06-2013, 03:14 AM
Replies: 6
Views: 3,570
Posted By Acke
Re: Where is Calendar control in Access 2010?

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...
Forum: Forms 08-06-2013, 01:16 AM
Replies: 6
Views: 3,570
Posted By Acke
Re: Where is Calendar control in Access 2010?

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?
Forum: Forms 08-06-2013, 12:31 AM
Replies: 6
Views: 3,570
Posted By Acke
Where is Calendar control in Access 2010?

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...
Forum: Forms 07-31-2013, 07:27 AM
Replies: 5
Views: 9,148
Posted By Acke
Re: First day of the current month

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?
Forum: Forms 07-31-2013, 07:03 AM
Replies: 5
Views: 9,148
Posted By Acke
First day of the current month

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())
Forum: General 05-13-2012, 11:18 PM
Replies: 6
Views: 2,365
Posted By Acke
Re: Multi users Access 2010

Yes the db was just copied, not compiled and thanks for suggestion regarding "not working"!
Forum: General 05-13-2012, 09:49 AM
Replies: 6
Views: 2,365
Posted By Acke
Re: Multi users Access 2010

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...
Forum: General 05-13-2012, 09:11 AM
Replies: 6
Views: 2,365
Posted By Acke
Re: Multi users Access 2010

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...
Forum: General 05-13-2012, 08:02 AM
Replies: 6
Views: 2,365
Posted By Acke
Multi users Access 2010

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,...
Forum: Modules & VBA 11-23-2011, 12:07 PM
Replies: 1
Views: 1,178
Posted By Acke
Re: Email body template

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...
Showing results 1 to 25 of 106

 
Forum Jump



All times are GMT -8. The time now is 12:38 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World