Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.12 seconds.
Search: Posts Made By: arnelgp
Forum: Modules & VBA 11-20-2019, 01:40 AM
Replies: 2
Views: 111
Posted By arnelgp
Re: criteria to sum same product for one person

create a user-defined function and pass the PID number to check with the function:

Public Function fnCountProduct(pid As Long)

Dim rs As DAO.Recordset
Dim db As DAO.Database
Dim...
Forum: Queries 10-27-2019, 11:15 PM
Replies: 2
Views: 119
Posted By arnelgp
Re: Dlookup into a query field using Date Criteria

DLookUp("EXCRate","ExchangeRates","EXCDate=#" & Format([DateEntered], 'mm\/dd\/yyyy') & "#")
Forum: Forms 10-27-2019, 09:26 AM
Replies: 8
Views: 210
Posted By arnelgp
Re: Reports displaying multiple records

no worries, i get that all the time.
check the code, its very simple.
Forum: Modules & VBA 10-26-2019, 06:40 PM
Replies: 3
Views: 155
Posted By arnelgp
Re: Where Condition with multiple value

SQLDataSource = " SELECT * FROM tbtaskschedule WHERE TaskAssignedTo = " & TempVars![SYSID] & " And TaskBenefitID = " & forms!frbillingtest!benefitsid
Forum: Forms 10-26-2019, 10:07 AM
Replies: 8
Views: 210
Posted By arnelgp
Re: Reports displaying multiple records

check and test.
some trips don't have fuel records.
Forum: General 10-26-2019, 08:01 AM
Replies: 21
Views: 446
Posted By arnelgp
Re: Need "Select All Option" in Combobox for Query Parameters

SELECT [Employee Directory].[ID], [Employee Directory].[Employee Name]
FROM [Employee Directory]
WHERE [ID] = IIF(Trim([FORMS]!yourFormName!comboName & "")="", [ID],...
Forum: General 10-26-2019, 12:05 AM
Replies: 4
Views: 147
Posted By arnelgp
Re: Form Operations Misc

here you may test.
Forum: General 10-25-2019, 10:24 AM
Replies: 12
Views: 166
Posted By arnelgp
Re: DLookup with criteria into vba

mr.gasman, is that for me? remember he is only searching on Same table.
Forum: General 10-25-2019, 10:09 AM
Replies: 12
Views: 166
Posted By arnelgp
Re: DLookup with criteria into vba

Dim strValue As String
strValue = Nz(DLookup ("Supplier_id & '/' OrderCode", "ORDERS", "[Supplier_id] =" & Supplier_id & " AND [OrderStatus] = 4"), "")
If Len(strValue)>0 Then

MsgBox "Found the...
Forum: Queries 10-25-2019, 09:29 AM
Replies: 8
Views: 145
Posted By arnelgp
Re: Crosstab IIF in expression value

you can create another query based on the crosstab you have and put the expression there:

select correo, nombre, apellido, telefono, iif([1-1]=1,"1-1",[1-1]) as [1-1], ...
from qry_crosstabname
Forum: Forms 10-25-2019, 07:02 AM
Replies: 5
Views: 104
Posted By arnelgp
Re: Multiple Criteria Filter Subform

put the function on the main form not on separate module.
Forum: Modules & VBA 10-25-2019, 06:58 AM
Replies: 42
Views: 548
Posted By arnelgp
Re: Ribbon before AutoExec

without hidden form it works for me.
Forum: Modules & VBA 10-24-2019, 12:11 PM
Replies: 9
Views: 199
Posted By arnelgp
Re: dcount to find duplicates with ' (or ANY character)

If DCount("*", "tblInvoices", "ProjName=" & Chr(34) & Me.ProjName & Chr(34)) > 0 Then
Forum: Modules & VBA 10-24-2019, 02:05 AM
Replies: 42
Views: 548
Posted By arnelgp
Re: Ribbon before AutoExec

remove the ribbon name from access Option.
on autoexec add a code that will run a Function that will load your ribbon.
after calling the function from the macro, run other part of the macro.
see...
Forum: Queries 10-24-2019, 01:55 AM
Replies: 7
Views: 110
Posted By arnelgp
Re: Unmatched Query?

you may also try to create a Union Query for the two queries, then select the location Not on the Union query:

select location from tblWarehouseLocations
where location not in
(select location...
Forum: Modules & VBA 10-23-2019, 08:18 PM
Replies: 13
Views: 272
Posted By arnelgp
Re: Record Search

first it will find whatever the substring you type on the fields.
if it finds it on the first record it will be highlighted.
you need to press the "search" button again to search for the Next...
Forum: Modules & VBA 10-23-2019, 12:14 PM
Replies: 25
Views: 380
Posted By arnelgp
Re: Best string Function

not so elegant

Private Sub t()
Dim s As String
Dim ID As String
Dim CONTAINER_NO As String
Dim SEAL_NO As String
Dim ISO_TYPE As String
Dim MOVEMENT_TYPE As String
...
Forum: Modules & VBA 10-23-2019, 08:08 AM
Replies: 13
Views: 272
Posted By arnelgp
Re: Record Search

If WillContinue Then
Me.Bookmark = .Bookmark
Me.[Name].SetFocus
End If
Forum: Forms 10-23-2019, 02:37 AM
Replies: 4
Views: 106
Posted By arnelgp
Re: Workflow Approval - Approval Button?

have a table of Approved people.

tblAuthorized (tbl)
ID (autnumber)
AuthorizedName (text)

fill the table of all Computer name on your network.

using Environ("UserName"), you can get the...
Forum: General 10-22-2019, 09:47 PM
Replies: 9
Views: 268
Posted By arnelgp
Re: Ms access query by populating data base on a column

fDate: DLookUp("DATE","DV","CKcode > 0 And Payee='" & [Payee] & "' And Nz([date], 1) >= " & Format([date], "\#mm\/dd\/yyyy\#"))
Forum: Modules & VBA 10-22-2019, 10:29 AM
Replies: 25
Views: 380
Posted By arnelgp
Re: Best string Function

CDate(left(theString,instr(theString,"2018")+len("2018")-1)
Forum: Reports 10-22-2019, 03:48 AM
Replies: 5
Views: 160
Posted By arnelgp
Re: Open report from report with double click event

remove all Parameters from your Queries.
open the report with Where Clause:

DoCmd.OpenReport ReportName:="theReport", View:=acViewPreview, WhereCondition:= "CustID=" & [CustID]
Forum: Modules & VBA 10-21-2019, 11:26 PM
Replies: 7
Views: 208
Posted By arnelgp
Re: Move Typed value from field to another field

Private Sub AccountNo_NotInList(NewData As String, Response As Integer)

DoCmd.Beep
MsgBox "Sorry, file not received !" & vbCrLf & _
"* Please provide the Actual A/C # in the field you will...
Forum: Forms 10-21-2019, 11:51 AM
Replies: 12
Views: 211
Posted By arnelgp
Re: count gender and fill male female field

while this one will update your table.
see the current event of the main form.
see the afterupdate event of the subform.
Forum: Reports 10-21-2019, 11:01 AM
Replies: 13
Views: 251
Posted By arnelgp
Re: How to filter 2 reports with 1 form?

you're welcome and go ahead make your next move.
Showing results 1 to 25 of 500

 
Forum Jump



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