Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.36 seconds.
Search: Posts Made By: arnelgp
Forum: Queries Today, 11:40 AM
Replies: 5
Views: 74
Posted By arnelgp
Re: DLookup in Query Field

it's not that easy since tblFees has effective date on them.
Forum: Queries Today, 09:26 AM
Replies: 5
Views: 74
Posted By arnelgp
Re: DLookup in Query Field

how do you compute the AvailableCash?
Forum: Queries Today, 09:15 AM
Replies: 9
Views: 88
Posted By arnelgp
Re: uncombine string

you can create a Data Macro that will make the changes to your on either table.
replaced the encircled on the attached picture with your table name.

do the same macro on both tables, using the...
Forum: Forms Today, 08:49 AM
Replies: 12
Views: 8,643
Posted By arnelgp
Re: How to prevent users from opening database in design mode?

yes, you can edit the table structure in accde unless you make the table query Invisible.
Forum: General Today, 08:46 AM
Replies: 4
Views: 40
Posted By arnelgp
Re: Validating a field based on the selection of another field

do it on the Form's BeforeUpdate event:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If [Type].ListIndex = -1 Then
Cancel = True
Msgbox "You need to select Type from combobox"
...
Forum: Forms Today, 08:04 AM
Replies: 5
Views: 68
Posted By arnelgp
Re: When checkbox checked it shows textbox

add this function inside your Form's code.

Public fnShowTextbox(Optional bolChecked As Boolean = False)
If bolChecked Then
Me.Text1.Visible = (Me.Check3 Or Me.Check4 Or Me.Check5)
Else...
Forum: Modules & VBA Today, 03:14 AM
Replies: 10
Views: 96
Posted By arnelgp
Re: Output Open Form to PDF

you mean like print-screen?
Forum: Macros Today, 03:11 AM
Replies: 3
Views: 68
Posted By arnelgp
Re: Write conflict: I want to always Drop Changes

unless the other user requeries his form, he will never notice that the record he is holding has changed.
though, there is a utility to see if the current record you are working is Locked for...
Forum: Modules & VBA Today, 02:40 AM
Replies: 10
Views: 96
Posted By arnelgp
Re: Output Open Form to PDF

you use DoCmd.OutputTo

DoCmd.OutputTo acOutputForm,"theDisplayedFormName",acFormatPDF,"outputPath\OutputName.pdf"
Forum: Forms Today, 02:10 AM
Replies: 2
Views: 73
Posted By arnelgp
Re: Checking multiple values in textbox/list

ill go with the listbox thing.
after the txtSalesOrder has been entered, fill the listbox with related pallet records.

me.listPallet.rowsource = "select [palletID], [palletName], [qty], SONumber...
Forum: Queries Today, 01:05 AM
Replies: 12
Views: 111
Posted By arnelgp
Re: UNION Query syntax Issue

if it works on 2, check the last table.
does it have the fields specified.
Forum: Queries Today, 12:14 AM
Replies: 12
Views: 111
Posted By arnelgp
Re: UNION Query syntax Issue

is serialDate string?
Forum: Tables Yesterday, 11:53 PM
Replies: 3
Views: 75
Posted By arnelgp
Re: Multi-value lookup field

add ActivityID (long, FK to tblActivities) to your tblCompany.
your subform will be bound the tblCompany with
Link Master Fields to cboCompany and
LInk Child Fields to CompanyID.
ActivityID in...
Forum: Reports Yesterday, 12:16 PM
Replies: 2
Views: 55
Posted By arnelgp
Re: Charting?!

put pb.xlsm to same folder as the sample db.
run form1.
using excel automation to create the chart.
Forum: Macros Yesterday, 09:58 AM
Replies: 18
Views: 179
Posted By arnelgp
Re: Using Keyboard keys as condition in 2010 macro (not vba)

so whatever you learn, don't keep it in the brain.. learn it by heart.
Forum: Reports Yesterday, 08:40 AM
Replies: 4
Views: 69
Posted By arnelgp
Re: Reports displays more than selected records

if not Exact match, try this:

Open the report to display the selected trip group
DoCmd.OpenReport strReport, acViewPreview, , "[T_TN] Between '" & Me.cboTrips_lbl & "' And '" & Me.cboTrips_lbl &...
Forum: Modules & VBA Yesterday, 08:18 AM
Replies: 9
Views: 140
Posted By arnelgp
Re: Run macro from another, already OPEN database

make the sub Public.

app.Run "hello"
Forum: Macros Yesterday, 08:16 AM
Replies: 8
Views: 101
Posted By arnelgp
Re: How much of a performance impact does declaring variables / passing arguments hav

the impact on speed is negligible.
in fact your variables are encapsulated on that sub/function only.
make sure to declare the parameters as intented.
if you want to modify the content of the...
Forum: General Yesterday, 06:53 AM
Replies: 12
Views: 133
Posted By arnelgp
Re: Insert calendar picker in tabular form

there is already a built-in calendar/date picker in ms access.
if the textbox is bound to date/time field.
Forum: General Yesterday, 06:44 AM
Replies: 5
Views: 74
Posted By arnelgp
Re: Best method to get Access 2013

Access Runtime does not perform as Full installed access.
therefore, some of its functionality is reduced.

you can Emulate runtime using, and test your OutputTo:

msAccessPath\MSAccess.Exe...
Forum: Queries Yesterday, 06:42 AM
Replies: 11
Views: 115
Posted By arnelgp
Re: Update Query with percentage value

on the Click Event of the button:

Private Sub button_Click()
If Len(Trim(Me.txtRateIncrease & ""))>0 then
With Currentdb.CreateQuerydef("", "Update table Set [standard]=[standard] * p0, " &...
Forum: Queries Yesterday, 06:31 AM
Replies: 11
Views: 115
Posted By arnelgp
Re: Update Query with percentage value

you can use Update query against the table:

Update table set [starndard] = [standard] * 1.02, [overtime] = [overtime] * 1.02, etc...

or, add New table for the increase rate, with effective...
Forum: Macros Yesterday, 06:17 AM
Replies: 18
Views: 179
Posted By arnelgp
Forum: Reports Yesterday, 06:16 AM
Replies: 4
Views: 69
Posted By arnelgp
Re: Reports displays more than selected records

do you need Exact match for the cboTrips?
Forum: Macros Yesterday, 05:55 AM
Replies: 18
Views: 179
Posted By arnelgp
Re: Using Keyboard keys as condition in 2010 macro (not vba)

checked my demo again, it doesn't ask question when Ctrl-S is pressed.
Showing results 1 to 25 of 500

 
Forum Jump



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