Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 3.07 seconds.
Search: Posts Made By: arnelgp
Forum: Modules & VBA 11-08-2018, 11:08 PM
Replies: 4
Views: 505
Posted By arnelgp
Re: Change Function name in event in form design

rename first your function.
on a module paste this and run:

Public Function fnAllForm()
Dim frm As AccessObject
Dim ctl As Control
Dim thisForm As Form
For Each frm In...
Forum: Queries 11-08-2018, 08:21 AM
Replies: 9
Views: 203
Posted By arnelgp
Re: Less than or equal to

you should probably Sum on the expression:

SUM(IIf((DateValue([OpenedTime])>=DateValue([ContractStart])) And (DateValue([OpenedTime])<=DateValue([ContractEnd])),[TimeUsed],0))
Forum: Macros 11-07-2018, 05:24 AM
Replies: 3
Views: 1,467
Posted By arnelgp
Re: Export to Excel with filters enabled

you could create a Public Function in a Module, and call it within your macro:

macro:
RunCode fnAutoFilter("the path and filename of excel file")


the function:


Public Function...
Forum: Modules & VBA 11-07-2018, 12:25 AM
Replies: 1
Views: 65
Posted By arnelgp
Re: pre set folder path

....
With fd
.InitialFileName="the path here"
If .Show Then
....
Forum: Queries 11-06-2018, 08:11 PM
Replies: 4
Views: 147
Posted By arnelgp
Re: Latest record for each

easier if you can add an AutoNumber field to your table.
you can then query the Max() of this field to get the latest name.
eg, ID here is the AutoNumber field:

SELECT T1.MaxOfID AS ID,...
Forum: Modules & VBA 11-06-2018, 07:56 PM
Replies: 28
Views: 478
Posted By arnelgp
Re: Access closing unexpectedly after editing VBA

don't mixed edit your vba on x86 and x64 mso.
also if the db is made from earlier version, don't edit it in higher version.
doing so will add extra sys tables to your db and most likely won't work...
Forum: General 11-06-2018, 07:32 PM
Replies: 11
Views: 305
Posted By arnelgp
Re: Combo Box

here is a sample for you to study.
Forum: Site Suggestions 11-06-2018, 12:08 AM
Replies: 2
Views: 422
Posted By arnelgp
Re: Subscribe to forum?

no, but you will get e-mail (if you provided your email on this forum and click receive notification) notification on the post that you are involved.
Forum: Queries 11-06-2018, 12:06 AM
Replies: 1
Views: 159
Posted By arnelgp
Re: Query is modified when I run it

maybe on the previous thread you made, you will find the answer on those removed fields.

regarding the list.
don't to open the Report, but rather Open a pop up form that will then open your...
Forum: Forms 11-05-2018, 07:37 PM
Replies: 4
Views: 273
Posted By arnelgp
Re: Form Valication

the easiest way is to make a ComboBox the the Mode of Payment with the rowsource coming from table or Value/List.

then you will only need to use 1 txtAmount textbox.

if you prefer the table...
Forum: Modules & VBA 11-05-2018, 07:27 PM
Replies: 3
Views: 328
Posted By arnelgp
Re: Compare and update table with data from multiple files

you can make your Select query in Post#1 as Make Table Query or Append Query (to tmpTable).
Join tblLetters to this tmpTable and view.
Forum: Modules & VBA 11-05-2018, 07:19 PM
Replies: 3
Views: 221
Posted By arnelgp
Re: Item not found in this collection

check this line:

strSQL = "SELECT * FROM Spool Data"

you need to add squre parenthesis if your table/field has space between them:

strSQL = "SELECT * FROM [Spool Data]"
Forum: Queries 11-05-2018, 05:43 PM
Replies: 4
Views: 585
Posted By arnelgp
Re: Need to run Query twice to clear Error

cheers, and its more easier to see the logic and formula.
Forum: General 11-05-2018, 05:07 AM
Replies: 4
Views: 130
Posted By arnelgp
Re: Calculation of field in specific period

forget about making the Year textbox unbound.
you also need to use the Current Event of the Form:

Private Sub Form_Current()
If Me.NewRecord = False Then
Call txtYear_AfterUpdate
Me.Dirty =...
Forum: General 11-05-2018, 04:45 AM
Replies: 10
Views: 244
Posted By arnelgp
Re: Hi! Need to count long words in LIX

what error do you get and which line?
Forum: General 11-05-2018, 04:42 AM
Replies: 4
Views: 130
Posted By arnelgp
Re: Calculation of field in specific period

create the Year textbox as unbound.
on its AfterUpdate Event, calculate the C_Leave and A_Leave textbox:

Private Sub txtYear_AfterUpdate()A
Me.C_Leave = DSum("*","tblLeaves","LeaveTypeField='C'...
Forum: Forms 11-05-2018, 04:24 AM
Replies: 6
Views: 133
Posted By arnelgp
Re: One form to update Two tables ID

I find it hard to create the form you need.
there is subform in the attached.
but now it appears as if it is a textbox.
only one degree can be entered to it (1 on 1).
Forum: General 11-05-2018, 03:45 AM
Replies: 10
Views: 244
Posted By arnelgp
Re: Hi! Need to count long words in LIX

here.
study the code that I made for you.
run the form, select the files and click the button.
Forum: Forms 11-05-2018, 12:15 AM
Replies: 6
Views: 133
Posted By arnelgp
Re: One form to update Two tables ID

here is a sample to begin with.
Forum: Queries 11-04-2018, 11:14 PM
Replies: 9
Views: 203
Posted By arnelgp
Re: Less than or equal to

in behalf of mr.gasman, youre welcome.
Forum: General 11-04-2018, 10:58 PM
Replies: 10
Views: 244
Posted By arnelgp
Re: Hi! Need to count long words in LIX

you need to break the sentences into words using Split():

public fnWordCount(sString As String, Optional iMaxLen As Integer = 6) As Integer
Dim v As Variant
Dim i As Integer
sString =...
Forum: Queries 11-04-2018, 05:28 AM
Replies: 4
Views: 585
Posted By arnelgp
Re: Need to run Query twice to clear Error

it is better to create a UserDefine Function if you have lots of IIF()s in there.

Public Function fnCalCulate(ClCh As Variant, GCh As Variant, NetCH As Variant, ResN As Variant, DCh As Variant,...
Forum: General 11-04-2018, 05:09 AM
Replies: 31
Views: 449
Posted By arnelgp
Re: Error in module

you must create a public function in a module and must add a
form parameter to it:

public function fnNextRecord(frm As Form)
With frm.RecordSet
If Not .Eof Then
.MoveNext

...
Forum: Reports 11-04-2018, 12:50 AM
Replies: 3
Views: 192
Posted By arnelgp
Re: Issue with access subreport page break

can you make it into a single report so you can force a new page if the detail has 10 records. subform/report have limited events to work with.
Forum: Queries 11-03-2018, 10:31 PM
Replies: 7
Views: 135
Posted By arnelgp
Re: error in updatequery

replace your Update To field with:

IIf(Nz([DateOfTraining],0)<#1/1/1999#,#1/1/1999#,[DateOfTraining])
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:55 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 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World