Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 54
Search took 0.03 seconds.
Search: Posts Made By: aman
Forum: Modules & VBA 04-26-2019, 10:23 AM
Replies: 3
Views: 121
Posted By Cronk
Re: Bookmark on word document

@aman, had you stepped through your code, you would have found that the loop is not executed. That is a reason for no data being inserted in your document.


(not .bof = true and .eof =...
Forum: Modules & VBA 11-30-2018, 06:09 AM
Replies: 3
Views: 770
Posted By Ranman256
Re: Export the query in Pipe delimited .csv format

All your specs should be stored in a Spec name.
set all your formats, delim, pipe, etc
manually import a file, set all these settings, save the spec name.
then

docmd.TransferText acExportDelim...
Forum: Modules & VBA 11-26-2018, 08:11 AM
Replies: 26
Views: 1,214
Posted By sxschech
Re: Distinguish between visible and invisible attachments Outlook

Here is code to exclude embeded attachments. (logos, etc.) Only downloads "actual attachments" such as emails with the paper clip icon.

This is the code I use to download attachments from a...
Forum: Modules & VBA 04-13-2018, 05:07 AM
Replies: 14
Views: 442
Posted By isladogs
Re: Phone number validation to exclude space

Forgot about "-" so have added it below

Public Function NumbersOnly(ByVal strText As String) As Boolean

'use to check phone 'numbers' are numeric

Dim intCounter As Integer

...
Forum: Modules & VBA 04-13-2018, 04:45 AM
Replies: 14
Views: 442
Posted By jdraw
Re: Phone number validation to exclude space

aman
I'm not sure what range of phone numbers you will validate, but I have seen the "-" used quite often. I did Google search and found this...
Forum: Modules & VBA 04-13-2018, 01:55 AM
Replies: 14
Views: 442
Posted By isladogs
Re: Phone number validation to exclude space

Your function will fail if the string contains a space, starts with zero or + or (.
All of these are common in phone numbers

For example:
1754324562 => true
01754 324562 => false
+44 1754...
Forum: Queries 03-16-2018, 08:40 AM
Replies: 9
Views: 313
Posted By arnelgp
Forum: Modules & VBA 03-13-2018, 06:29 AM
Replies: 5
Views: 603
Posted By moke123
Re: Adding multiselect listbox items as a filter in sql statement

I read your original question wrong but i believe you can do something along these lines as suggested by Cronk.

In order to use transfer text you need a saved query or table but you can construct...
Forum: Modules & VBA 02-07-2018, 11:36 AM
Replies: 24
Views: 827
Posted By isladogs
Re: Make the text in a textbox scrolling horizontally in a form

Thanks Paul
I had already sent a PM to Aman saying the same thing
Forum: Modules & VBA 02-06-2018, 04:42 AM
Replies: 24
Views: 827
Posted By isladogs
Re: Make the text in a textbox scrolling horizontally in a form

Aman
You really should be able to work out the solution yourself as there really is no magic to this ....

The original purpose of scrolling or marquee text is to allow a message wider than the...
Forum: Modules & VBA 11-10-2017, 02:13 AM
Replies: 6
Views: 311
Posted By arnelgp
Re: Import files to the access database

dont make GetLinkedFilePath variable a Constant:

Dim GetLinkedFilePath As String

GetLinkedFilePath = CreateImportFolder()



...
Forum: Modules & VBA 08-30-2017, 04:17 AM
Replies: 15
Views: 766
Posted By Galaxiom
Re: Password validation

I really would encourage you to look at the function I wrote at Frothy's link. It is quite slick in the way it uses dynamic settings in the call.

Definitely also worth a look for anyone...
Forum: Modules & VBA 07-21-2017, 03:14 AM
Replies: 41
Views: 1,912
Posted By Frothingslosh
Re: Open a copy of the Access application rather than the actual shared file

No, you don't.

Read the code. Understand the code. Never use code that you cannot understand, because then you can't troubleshoot it.

While you're at it, go back and actually read the post that...
Forum: Modules & VBA 07-10-2017, 03:00 AM
Replies: 41
Views: 1,912
Posted By isladogs
Re: Open a copy of the Access application rather than the actual shared file

Aman

Several people have responded to this thread with comments along the lines that you are expecting everything to be done for you.
Although you claim that isn't the case, it does seem like...
Forum: General 07-05-2017, 05:16 AM
Replies: 16
Views: 757
Posted By The_Doc_Man
Re: API in access database

I'm going to offer a couple of general comments and then step away because I have no specific experience with web conversions.

1. In general, it is relatively easy most of the time to migrate the...
Forum: General 07-04-2017, 03:38 AM
Replies: 16
Views: 757
Posted By CJ_London
Re: API in access database

you use API's to communicate with other systems - typically web based.

So if you wanted to find the geo coordinates of a postcode, you could use the google maps API to send the post code and...
Forum: Modules & VBA 06-26-2017, 02:43 AM
Replies: 25
Views: 1,296
Posted By isladogs
Re: Browse actual file vba

Will do so this evening UK time. Out all day


Sent from my iPhone using Tapatalk
Forum: Modules & VBA 06-25-2017, 11:44 PM
Replies: 3
Views: 630
Posted By JHB
Re: Add break in email html body

Look here:
https://www.w3schools.com/tags/tag_br.asp

.HTMLBody = ... & ". <br>The Reference number is " ....
Forum: Modules & VBA 06-22-2017, 05:33 AM
Replies: 25
Views: 1,296
Posted By isladogs
Re: Browse actual file vba

Hi
Sorry you need to add the reference 'Microsoft Office 14.0 Object Library' if you are using Access 2010 (or 15.0 for 2013 etc)
If it still doesn't compile also add Microsoft Forms 2.0 Object...
Forum: Modules & VBA 06-19-2017, 05:52 AM
Replies: 2
Views: 262
Posted By Peter Reid
Re: Make just the startup form visible to the users

Does 'the leftmost slide' mean the Navigation Pane?

If so, this gives you a good idea of what needs to be done

https://access-programmers.co.uk/forums/showthread.php?t=187697
Forum: Modules & VBA 06-15-2017, 01:37 AM
Replies: 11
Views: 599
Posted By CJ_London
Re: Exit event to change event

compare the line suggested by Cronk

If isdate(me.txtEndDate.text) then

with your equivalent

If IsDate(Me.txtEndDate) Then
Forum: Modules & VBA 06-14-2017, 08:11 PM
Replies: 11
Views: 599
Posted By Cronk
Re: Exit event to change event

aman,

CJ gave you the answer ie use the change event, something like
private sub txtEndDate_change()
if len(me.txtEndDate.text & "") = 10 then
If isdate(me.txtEndDate.yext) then
...
Forum: Modules & VBA 11-30-2016, 07:42 AM
Replies: 15
Views: 577
Posted By Minty
Re: Find total "Competent" calls for each employee

Assuming every call record has a OutcomeID then add another calculated field :

Count(OutcomeID) as NoOfRecs.

To get your percentage then you need to use the following as you can't refer to the...
Forum: Modules & VBA 10-28-2016, 03:05 AM
Replies: 2
Views: 204
Posted By Minty
Re: Bound form problem

Set the form to data entry = yes. I can't believe with 900 + posts you couldn't find this somewhere...
Forum: Modules & VBA 10-26-2016, 12:45 AM
Replies: 4
Views: 304
Posted By Tieval
Re: Subform code doesn't work

Private Sub fraBreach_AfterUpdate()
If me.fraBreach.Value = 1 Then
me.cmdBreach.Visible = True
Else
MsgBox "hellO"
End If
End Sub
Showing results 1 to 25 of 54

 
Forum Jump



All times are GMT -8. The time now is 12:11 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