Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 3.33 seconds.
Search: Posts Made By: arnelgp
Forum: General Today, 06:38 AM
Replies: 7
Views: 125
Posted By arnelgp
Re: Resize ink picture control

it does have a Horizontal/Vertical anchor property.
you can experiment with it (using Both value).
your pic will resize in proportionate to the size of the form.
Forum: Modules & VBA Today, 06:31 AM
Replies: 16
Views: 156
Posted By arnelgp
Re: Problem with query in VBA

also try the bang(!)

rs![GCDF No]

or

rs(0)

and your update query will not work, it needs a Query name not the Query string.
you may however use QueryDefs:
Forum: Modules & VBA Today, 05:17 AM
Replies: 12
Views: 178
Posted By arnelgp
Re: How Can I Remove two random buttons

dim RSlot(1 to 4) As Double

for integer, you need to cast it:

Dim RSlot(1 to 4) As Integer
Dim I As Integer
Dim j As Integer
Dim k As String
Randomize
For I = 1 to 4
Forum: General Today, 04:44 AM
Replies: 13
Views: 266
Posted By arnelgp
Re: Live Forex ticker HTML code

can you make a sample that actually work, without going to your site.
Forum: Modules & VBA Today, 12:38 AM
Replies: 7
Views: 101
Posted By arnelgp
Re: Lock Field after update

use the control's OnGotFocus Event instead of the Form's Current event:

Private Sub cboVehicleID_GotFocus()
Me.cboVehicleID.Locked = (Trim(Me.cboVehicleID & "")="")
End Sub
Forum: Tables Today, 12:29 AM
Replies: 7
Views: 136
Posted By arnelgp
Re: Need help with INSERT INTO

put in excel what are you trying to do.
Forum: General Yesterday, 10:32 PM
Replies: 7
Views: 125
Posted By arnelgp
Re: Resize ink picture control

is there a Horizontal Anchor and Vertical Anchor property of the ink Control?
Forum: Forms Yesterday, 10:26 PM
Replies: 7
Views: 147
Posted By arnelgp
Re: Sub Form controls

what do you mean by Group? summarized?

done.

done, but you must be inside the subform. use Up, Down arrow keys.

done. use the Up, down Image.


see the controls Format Property.
Forum: General Yesterday, 01:15 AM
Replies: 13
Views: 266
Posted By arnelgp
Re: Live Forex ticker HTML code

an alternative would be a running label.
the Timer would update the label from the fore site.
Forum: General Yesterday, 12:44 AM
Replies: 13
Views: 266
Posted By arnelgp
Re: Live Forex ticker HTML code

just add a web browser control and Navigate to this page:

https://www.dailyfx.com/forex-rates
Forum: Forms Yesterday, 12:27 AM
Replies: 8
Views: 95
Posted By arnelgp
Forum: Forms Yesterday, 12:02 AM
Replies: 8
Views: 95
Posted By arnelgp
Re: Want to count entries in form

put intPressCount outside the Sub:

Option Compare Database
Option Explicit

Dim intPressCount As Integer

Private sub cmdnew_click()
If intPressCount < 26 Then
Intpresscount =intpresscount...
Forum: Forms 10-16-2018, 11:35 PM
Replies: 8
Views: 95
Posted By arnelgp
Re: Want to count entries in form

Private Sub yourButtonToCount_Click()
intPressCount = intPressCount + 1
Me.UnboundTextbox = intPressCount
End Sub

when you close the form intPressCount is destroyed.
Forum: Forms 10-16-2018, 10:56 PM
Replies: 22
Views: 293
Posted By arnelgp
Re: 2nd time around Filter / recordsource don't work

i think there is no need for Filtering or changing Recordsource of
TargetSubform.

Add a dummy Textbox (txtLink) to the Main Form.
On the Current Event of the SwForm (first subform),
set the...
Forum: Forms 10-16-2018, 10:39 PM
Replies: 8
Views: 95
Posted By arnelgp
Re: Want to count entries in form

on the Click Event of the button, make the count:

Dim intPressCount As Integer

Private Sub yourButtonToCount_Click()
intPressCount = intPressCount + 1
End Sub

Private sub...
Forum: Queries 10-16-2018, 09:06 PM
Replies: 1
Views: 61
Posted By arnelgp
Re: update Table

put this new Query (SQL view):

Update TeacherTraining Set DateOfTraining=#8/22/2019# Where TeacherGroub="C"
Forum: Queries 10-16-2018, 07:38 PM
Replies: 8
Views: 171
Posted By arnelgp
Re: Join on substring

maybe create a function to strip the dot(.), space, and other special char before making comparison. and make the comparison both ways.

Public Function fncCompare(ByVal p1 As String, p2 As String)...
Forum: Forms 10-16-2018, 07:13 PM
Replies: 3
Views: 95
Posted By arnelgp
Re: Return correct On Change data from cbo to txt box

your forgot to include AssemblyDWG field on your combo's rowsource.
Forum: Queries 10-16-2018, 07:40 AM
Replies: 8
Views: 146
Posted By arnelgp
Re: requery combo box after selection

here is a much better approach, put in your form's VBA:

Option Compare Database
Option Explicit

Dim strCurrentFruit As String


Public Function UpdateFruitCombo(ByVal bolFilter As Boolean)...
Forum: Queries 10-16-2018, 05:52 AM
Replies: 8
Views: 146
Posted By arnelgp
Re: requery combo box after selection

to be safe, use the forms beforeupdate event i stead of the control's.
Forum: Forms 10-16-2018, 05:47 AM
Replies: 12
Views: 144
Posted By arnelgp
Re: Filtering Combo Boxes

id numeric the result you should use TeamId or code and CustomerId Or code.
Forum: Forms 10-16-2018, 05:27 AM
Replies: 11
Views: 132
Posted By arnelgp
Re: Syntax for SQL with Like & Wildcard

it will not show on screen, since it is a recordset.
you need first to create a Query with all or some of the fields that you showed.


from your code:

strSQL = "SELECT [t1].f1, [t1].f2,...
Forum: Forms 10-16-2018, 05:06 AM
Replies: 11
Views: 132
Posted By arnelgp
Re: Syntax for SQL with Like & Wildcard

You missed f7:
[code]
strSql = "SELECT [t1].f1, [t1].f2, [t1].f3, [t1].f4, [t1].f5, [t1].f6, [t1].f7 " _
& "FROM [t1] " _
& "WHERE [t1].f1 Like '*" & Me.[f1] & "*' " _
& "AND [t1].f2...
Forum: General 10-16-2018, 04:51 AM
Replies: 12
Views: 236
Posted By arnelgp
Re: Access Accdb 2010 slow on Ethernet

then prevent the laptop from sleeping (energy drink perhaps).
configure it on control panel->power.
Forum: Queries 10-16-2018, 04:25 AM
Replies: 8
Views: 146
Posted By arnelgp
Re: requery combo box after selection

you are right.
we will use the BeforeUpdate event of the combo and not the AfterUpdate to get the OldValue of the combo.
replace: Chr(34) & OldValue & Chr(34) & "," With ""
and add the Value,...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 11:32 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World