Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 2.09 seconds.
Search: Posts Made By: arnelgp
Forum: Modules & VBA Today, 01:38 AM
Replies: 10
Views: 64
Posted By arnelgp
Re: FileDialog not filtering files

or

.InitialFileName = "E:\VnomicRep\Master_Workbook-Microsoft\Azure_Workbook\ImportData\" & partialName & "*"
Forum: Queries Today, 12:18 AM
Replies: 6
Views: 93
Posted By arnelgp
Forum: Tables Yesterday, 11:54 PM
Replies: 4
Views: 67
Posted By arnelgp
Re: table relationships issues

you need to create another table for those batches (not in product table).
add fields like product code, batch no, qty, date.
Forum: Modules & VBA Yesterday, 10:09 PM
Replies: 12
Views: 126
Posted By arnelgp
Re: Output Open Form to PDF

' https://access-programmers.co.uk/forums/showthread.php?t=245198
' pr2-eugin
'***********************************************************************************************
' * Please leave...
Forum: General Yesterday, 10:02 PM
Replies: 7
Views: 96
Posted By arnelgp
Re: Calculate the age

SELECT [First Name], [Last Name], [Date of Birth], Age([Date Of Birth]) As Age
FROM yourTable;

' agp
Public Function Age(Date1 As Date, Optional Date2 As Date = 0) As String
Dim Year1 As...
Forum: Queries Yesterday, 11:40 AM
Replies: 6
Views: 93
Posted By arnelgp
Re: DLookup in Query Field

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

how do you compute the AvailableCash?
Forum: Queries Yesterday, 09:15 AM
Replies: 9
Views: 93
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 Yesterday, 08:49 AM
Replies: 12
Views: 8,650
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 Yesterday, 08:46 AM
Replies: 4
Views: 41
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 Yesterday, 08:04 AM
Replies: 5
Views: 74
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 Yesterday, 03:14 AM
Replies: 12
Views: 126
Posted By arnelgp
Re: Output Open Form to PDF

you mean like print-screen?
Forum: Macros Yesterday, 03:11 AM
Replies: 4
Views: 89
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 Yesterday, 02:40 AM
Replies: 12
Views: 126
Posted By arnelgp
Re: Output Open Form to PDF

you use DoCmd.OutputTo

DoCmd.OutputTo acOutputForm,"theDisplayedFormName",acFormatPDF,"outputPath\OutputName.pdf"
Forum: Forms Yesterday, 02:10 AM
Replies: 2
Views: 79
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 Yesterday, 01:05 AM
Replies: 12
Views: 119
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 Yesterday, 12:14 AM
Replies: 12
Views: 119
Posted By arnelgp
Re: UNION Query syntax Issue

is serialDate string?
Forum: Tables 10-15-2019, 11:53 PM
Replies: 3
Views: 80
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 10-15-2019, 12:16 PM
Replies: 2
Views: 57
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 10-15-2019, 09:58 AM
Replies: 18
Views: 182
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 10-15-2019, 08:40 AM
Replies: 4
Views: 76
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 10-15-2019, 08:18 AM
Replies: 9
Views: 141
Posted By arnelgp
Re: Run macro from another, already OPEN database

make the sub Public.

app.Run "hello"
Forum: Macros 10-15-2019, 08:16 AM
Replies: 8
Views: 104
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 10-15-2019, 06:53 AM
Replies: 12
Views: 135
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 10-15-2019, 06:44 AM
Replies: 5
Views: 76
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...
Showing results 1 to 25 of 500

 
Forum Jump



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