Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 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: Modules & VBA 10-30-2019, 03:24 AM
Replies: 7
Views: 178
Posted By arnelgp
Re: Use input to determine which field to choose in SQL-WHERE

since you already has VBA, then substitute the fieldname using VBA:

dim strSQL As String
dim qd As DAO.Querydef

strSQL = select * from table where p% like '*" & [Name ?] & "*'"

select...
Forum: Forms 10-30-2019, 03:13 AM
Replies: 10
Views: 204
Posted By arnelgp
Re: Duplicate Form with Subform

duplicate with subform
Forum: Forms 10-30-2019, 12:01 AM
Replies: 9
Views: 196
Posted By arnelgp
Re: How to catch keyreturn in Listview

maybe use Keypress event.
Forum: Forms 10-29-2019, 01:30 AM
Replies: 8
Views: 210
Posted By arnelgp
Forum: Reports 10-28-2019, 05:26 AM
Replies: 4
Views: 149
Posted By arnelgp
Re: Count but not the repeated ones

this will work on Print Preview only:

Dim dict As Object
dim lngCount As Long

Private Sub Report_Open(Cancel As Integer)
Set dict = CreateObject("scripting.dictionary")
End Sub
...
Forum: Modules & VBA 10-28-2019, 05:03 AM
Replies: 33
Views: 456
Posted By arnelgp
Re: Custom ribbon images

you're image files should already have transparent background (png) for it to work.
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:55 AM
Replies: 11
Views: 160
Posted By arnelgp
Re: Update the value in a field based upon

the update will not be immediate, you need to go to another record to reflect the change.
if you want immediate change, add this Expression on the Change Event of each 9 checkbox:

=fncACLMet()
...
Forum: Forms 10-27-2019, 09:36 AM
Replies: 11
Views: 160
Posted By arnelgp
Re: Update the value in a field based upon

it won't update the field because of the expression on the textbox:

=IIf(Abs(([ACL1]+[ACL2]+[ACL3]+[ACL4]+[ACL5]+[ACL6]+[ACL7]+[ACL8]+[ACL9]))>5,[ACL - Met]=Yes,[ACL - Met]=No)

remove the...
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-27-2019, 03:43 AM
Replies: 21
Views: 364
Posted By arnelgp
Re: Use vba Indexes

add space between "&"

MkDir (strPathNl) & newNameA & "\" & newNameA & i
Forum: Modules & VBA 10-27-2019, 02:01 AM
Replies: 21
Views: 364
Posted By arnelgp
Re: Use vba Indexes

is this correct?

strPathNl = toPath & "" & rst!NomName & "" '. Pieces officielles"
Forum: General 10-27-2019, 01:09 AM
Replies: 9
Views: 160
Posted By arnelgp
Forum: Modules & VBA 10-26-2019, 10:59 PM
Replies: 7
Views: 201
Posted By arnelgp
Re: Filter Datasheet Split Form

Private Sub Form_Load()
On Error Resume Next

Dim Department As Integer
'''''' Department Privilege '''''''
Department = Val(DLookup("Department", "Employees", "[UserLogin] = '"...
Forum: Modules & VBA 10-26-2019, 10:46 PM
Replies: 8
Views: 173
Posted By arnelgp
Re: Date to Date

format(fieldName, "short date")

or

format(fieldName, "mm/dd/yyyy")

or

CDate(fieldname)
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: General 10-26-2019, 11:42 AM
Replies: 21
Views: 446
Posted By arnelgp
Re: Need "Select All Option" in Combobox for Query Parameters

can still be simplified:

SELECT [Employee Expenses].[Entry Number], [Employee Expenses].[Account Name], [Employee Expenses].[Employee Name], [Employee Expenses].[Work Date], [Employee...
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, 09:20 AM
Replies: 21
Views: 446
Posted By arnelgp
Re: Need "Select All Option" in Combobox for Query Parameters

what is the Combo name and the Bound Column number?
Forum: Forms 10-26-2019, 08:02 AM
Replies: 6
Views: 140
Posted By arnelgp
Re: Button click to open a list of forms

there is no need to create separate form for each month.
just use one form for all months and just filter the form for the month to display.
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: Forms 10-26-2019, 06:52 AM
Replies: 8
Views: 165
Posted By arnelgp
Re: Get value from record by clicking on it ??

how do you add participants? through subform?
you can use the subforms recordsource and select participants Not in subform.
or you can use an Insert Query to select participants Not in the...
Forum: General 10-26-2019, 12:11 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 [Employee Directory].[Employee Name] =
IIF([FORMS]![yourForm]![yourCombo] = "Select All",...
Forum: General 10-26-2019, 12:05 AM
Replies: 4
Views: 147
Posted By arnelgp
Re: Form Operations Misc

here you may test.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 07:37 PM.


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