Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.18 seconds.
Search: Posts Made By: pr2-eugin
Forum: Queries 06-24-2015, 03:13 AM
Replies: 3
Views: 442
Posted By pr2-eugin
Re: duplicate records, show only the last one

Try a GROUP BY Query, with a Max on the Date Field.
Forum: Modules & VBA 06-24-2015, 12:55 AM
Replies: 2
Views: 344
Posted By pr2-eugin
Re: Syntax Error in INSERT INTO - but I just cant see what it is?

Dates need to be surrounded by #, not '. Double/Numbers do not need any special enclosures. Also there is a dangling , at the end.

MySQL = "INSERT INTO TimesheetTableTemp (Employee, [Logon...
Forum: General 06-22-2015, 01:49 AM
Replies: 4
Views: 774
Posted By pr2-eugin
Re: set a monthly reminder using outlook

Cross Posted at - Stack Overflow (http://stackoverflow.com/questions/30975421/set-an-outlook-reminder-based-on-month-using-access-vba)

Please take a moment to read - A message to forum cross...
Forum: General 06-19-2015, 01:40 AM
Replies: 2
Views: 728
Posted By pr2-eugin
Re: Removing comma from string

How about.

? Left("Hello String, Welcome to my World, ", Len("Hello String, Welcome to my World, ")-2)
Hello String, Welcome to my World
Forum: Queries 06-17-2015, 12:27 AM
Replies: 3
Views: 603
Posted By pr2-eugin
Re: Query Date Format Issue

So in other words, they are not really Date and Time type but simply Text type. Try casting the text to a proper date format, using the CDate function.
Forum: Queries 06-09-2015, 02:39 AM
Replies: 7
Views: 783
Posted By pr2-eugin
Re: Totals Query - Return Data Set between Two Dates

So try a HAVING or WHERE clause.
Forum: Introduce Yourself 06-09-2015, 01:06 AM
Replies: 1
Views: 404
Posted By pr2-eugin
Re: Hello From Mohamed

Hello Mohamed. Welcome to AWF :)
Forum: Queries 06-09-2015, 12:55 AM
Replies: 3
Views: 378
Posted By pr2-eugin
Re: Creating a query that will merge various fields into one field

Create a SELECT Query that will get you this information. Something like,

SELECT
addressLine1 & " " & addressLine2 & " " & addressLine3 & " " & postCode As fullAddress
FROM
...
Forum: SQL Server 05-28-2015, 07:01 AM
Replies: 5
Views: 1,156
Posted By pr2-eugin
Re: Add Column to view that Concatenate 2nd view multiple records

You could use Functions in SQL could you not? translating the function using the Allen Browne's ConcatRelated (http://allenbrowne.com/func-concat.html) should be easy (I guess)?

How about this...
Forum: Modules & VBA 05-28-2015, 06:59 AM
Replies: 11
Views: 503
Posted By pr2-eugin
Re: Need another Pair of eyes - type mismatch error

You seem to be missing the FROM clause. Then improper use of concatenation.
Forum: Queries 05-18-2015, 05:41 AM
Replies: 53
Views: 3,563
Posted By pr2-eugin
Re: Get form VBA variables into query where clause

Try this,

Private Sub Review_Invoice_Click()
Dim tmpRS As DAO.Recordset
Dim customer2 As Variant
Dim PurchaseDate2 As Variant
Dim VendorName2 As Variant
Dim VendorInvoice2...
Forum: Queries 05-18-2015, 03:51 AM
Replies: 53
Views: 3,563
Posted By pr2-eugin
Re: Get form VBA variables into query where clause

You can, you need a Recordset object that will hold the data from your SELECT statement. Something like,

Dim tmpRS As DAO.Recordset
Dim tmpNo As Long

tmpNo = 10

Set tmpRS =...
Forum: Modules & VBA 04-27-2015, 01:24 AM
Replies: 12
Views: 1,255
Posted By pr2-eugin
Re: Birthday Remainder VBA...

I hope this POST (http://www.access-programmers.co.uk/forums/showthread.php?t=246725) will help you, I remember helping another user with similar request. The other user wanted to send an email, you...
Forum: Modules & VBA 04-17-2015, 04:33 AM
Replies: 5
Views: 543
Posted By pr2-eugin
Re: Finding number in string

Of Course you can, something like.

Public Function HasNumbers(InputStr As String) As Boolean
Dim tmpArr() As String, lCtr As Integer

tmpArr = Split(InputStr, ";")

For...
Forum: Modules & VBA 04-17-2015, 03:56 AM
Replies: 5
Views: 543
Posted By pr2-eugin
Re: Finding number in string

You might need a UDF to get you this information. There is no native function that can do this. Something like,

Public Function HasNumbers(InputStr As String) As Boolean
Dim tmpArr() As...
Forum: Modules & VBA 04-15-2015, 07:12 AM
Replies: 2
Views: 1,765
Posted By pr2-eugin
Re: Dmax for empty table

DMax by default gives you a Null if nothing is there. So you can use the Nz (http://www.techonthenet.com/access/functions/advanced/nz.php) function, so.

Nz(DMax("CustomerID", "Customer_Details"),...
Forum: Queries 04-15-2015, 05:01 AM
Replies: 13
Views: 946
Posted By pr2-eugin
Re: Query to return entire rows with Min Date only

So many typos, you have a . instead of a , in the first SELECT. You need to use ( brackets for subqueries not [.

The last line has a Square bracket and a full stop where it should be a just ')'...
Forum: Modules & VBA 04-14-2015, 07:36 AM
Replies: 1
Views: 256
Posted By pr2-eugin
Re: Marking a record by what tab is was entered on...

Of course you can. This can be used as Audit log. See here for how to start - http://allenbrowne.com/appaudit.html
Forum: Forms 04-14-2015, 02:35 AM
Replies: 2
Views: 451
Posted By pr2-eugin
Re: Adding text boxes in form

I feel this is because of the fact they are being treated as Strings as opposed to Numbers. Try Casting them as numbers and try again.

=(CLng([TXT1]) + CLng([TXT2]) + CLng([TXT3]))
Forum: Modules & VBA 04-13-2015, 12:55 AM
Replies: 7
Views: 1,040
Posted By pr2-eugin
Re: need Object to send emails

Yes, you just need the settings for the mail servers. Gmail is available in the link I gave you. Hotmail should be available in MS Website somewhere. Do a Google search.
Forum: Queries 04-13-2015, 12:29 AM
Replies: 1
Views: 604
Posted By pr2-eugin
Re: 256 char limit from query

Allen Browne, has written a small article about this : http://allenbrowne.com/ser-63.html
Forum: Modules & VBA 04-13-2015, 12:24 AM
Replies: 7
Views: 1,040
Posted By pr2-eugin
Re: need Object to send emails

Use Gmail (http://www.blueclaw-db.com/access_email_gmail.htm) maybe, Using CDO?
Forum: Macros 04-10-2015, 05:44 AM
Replies: 8
Views: 1,271
Posted By pr2-eugin
Re: newrecord property

I do not think Macros are capable of doing this. I think it is time for you to move away from Macros ;)

Here is how you create a VBA. Click on the Form Design, then find the Form Current Event in...
Forum: Modules & VBA 04-09-2015, 08:50 AM
Replies: 24
Views: 1,220
Posted By pr2-eugin
Re: Check if All Forms are closed

Okay, figured my stupidity, :banghead: try this.

Private Sub Command98_Click()
Dim objAccObj As AccessObject
Dim objProj As Object, openFrm As Boolean
openFrm = True

Set...
Forum: Modules & VBA 04-09-2015, 12:23 AM
Replies: 6
Views: 778
Posted By pr2-eugin
Re: Dlookup with multiple condition...

Would suggest one alteration, use DCount instead of DLookup.

Dim strCriteria As String

strCriteria = "[LotNo] = '" & Me![LotNo] & _
"' And [Description] = '" & Me![Description] &...
Showing results 1 to 25 of 500

 
Forum Jump



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