Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.16 seconds.
Search: Posts Made By: arnelgp
Forum: General Today, 12:15 PM
Replies: 2
Views: 46
Posted By arnelgp
Re: Print one page only

on the click of the button, Count the source Table/query for "Fail".
if it has, print 1 page, otherwise print all (using DoCmd.PrintOut).

another one, is just create a single page report (from...
Forum: Forms Today, 11:37 AM
Replies: 13
Views: 91
Posted By arnelgp
Re: Issues trying to program rules for certain inputs

plz use Me., it so the Intellisense will appear and you can pick the correct Control name from the list.
Forum: Modules & VBA Today, 11:07 AM
Replies: 5
Views: 63
Posted By arnelgp
Re: Unbound values and triggering events

maybe you should rebuild your pop-up form.
I tried my own pop-up, (pop, modal), and the calculation on the Load event fires.
Forum: Modules & VBA Today, 10:37 AM
Replies: 5
Views: 63
Posted By arnelgp
Re: Unbound values and triggering events

use the pop-up form's load event to calculate,
remove first all expression from the textboxes, ie:

=impInch/12
=ImpInh *25.4

etc..

Private Sub Form_Load()
Me.ImpInch =...
Forum: Forms Today, 10:15 AM
Replies: 13
Views: 91
Posted By arnelgp
Re: Issues trying to program rules for certain inputs

NOTES is the fieldname, No_Excercised is the control name:

Private Sub Not_Exercised_AfterUpdate()

Me.[EXERCISED] = IIf([Not_Exercised] = "UNABLE TO LOCATE VALVE", "NO", "YES")
End Sub
Forum: Forms Today, 10:04 AM
Replies: 13
Views: 91
Posted By arnelgp
Re: Issues trying to program rules for certain inputs

short text, then:

Me.[EXERCISED] = IIF([NOTES]="UNABLE TO LOCATE VALVE", "NO", "YES")
End Sub
Forum: Forms Today, 09:49 AM
Replies: 13
Views: 91
Posted By arnelgp
Re: Issues trying to program rules for certain inputs

what is [exercised] datatype, Boolean?

Me.[EXERCISED] = False
Forum: Forms Today, 09:39 AM
Replies: 15
Views: 140
Posted By arnelgp
Re: Expression has no value

replace this:

Me.Parent!MemNo

with form name:

[Forms]!formname!MemNo
Forum: Queries Today, 01:34 AM
Replies: 6
Views: 73
Posted By arnelgp
Re: Delete Records with conditions

DELETE * FROM employee_certificates WHERE emp_no & certificate_issue_date IN
(SELECT emp_no & certificate_issue_date FROM employee_master);
Forum: Queries Today, 01:23 AM
Replies: 6
Views: 73
Posted By arnelgp
Re: Delete Records with conditions

From which table are you deleting?
Forum: Queries Today, 01:09 AM
Replies: 6
Views: 73
Posted By arnelgp
Re: Delete Records with conditions

DELETE * FROM employee_certificates WHERE emp_no IN (SELECT emp_no FROM employee_master);
Forum: Forms Yesterday, 12:15 PM
Replies: 24
Views: 287
Posted By arnelgp
Re: copy record in subform

ok, time for me to sleep
Forum: Forms Yesterday, 12:05 PM
Replies: 24
Views: 287
Posted By arnelgp
Re: copy record in subform

we will add it, what is the textbox name on the main form?

!Cycle = Me.No_Of_Cycle.Value
!Date = Date
!Record_ID = Me.??????.Value (texboxname in mainform)
Forum: Forms Yesterday, 11:53 AM
Replies: 24
Views: 287
Posted By arnelgp
Re: copy record in subform

try this, and don't use Me.[cycle subform], i am already using it's Recordset so no need to use the Form.
Copy and Replace your code.


Private Sub Command1608_Click()
Dim bolWithBlank As...
Forum: Forms Yesterday, 11:40 AM
Replies: 24
Views: 287
Posted By arnelgp
Re: copy record in subform

debug your code.
click on the Sub name and press F9.
run your form and click the button.
when it brings the code, press F8 until the error occur.
post the line where the error is.

also post...
Forum: Forms Yesterday, 11:26 AM
Replies: 24
Views: 287
Posted By arnelgp
Re: copy record in subform

I edited my last Code, please see it.
Forum: Forms Yesterday, 11:11 AM
Replies: 24
Views: 287
Posted By arnelgp
Re: copy record in subform

Private Sub Command1608_Click()
Dim bolWithBlank As Boolean
Dim bm As Variant
On Error GoTo new_Err

With Me![cycle subform].Form.RecordsetClone
If Not (.BOF And .EOF) Then
.MoveFirst...
Forum: Forms Yesterday, 10:49 AM
Replies: 24
Views: 287
Posted By arnelgp
Re: copy record in subform

either ID is null or not you will add the record?

Private Sub Command1608_Click()
On Error GoTo new_Err

With Me![cycle subform].Form.RecordsetClone
.AddNew
!Cycle1 =...
Forum: Forms Yesterday, 09:45 AM
Replies: 24
Views: 287
Posted By arnelgp
Re: copy record in subform

please clarify what do you mean by Null? No record on subform?
how about there is "ID"? there is same ID on current highlight on subform?
Forum: Forms Yesterday, 09:39 AM
Replies: 3
Views: 95
Posted By arnelgp
Re: Filter by form

macro:
RunCommand->FilterByForm
Forum: Forms Yesterday, 08:14 AM
Replies: 15
Views: 140
Posted By arnelgp
Re: Expression has no value

you must perform an .Update first on the function, before you can get the ID.

Private Function NewID() As Long
On Error GoTo Error_Handler

Dim db As Database
Dim rst As Recordset

Set db =...
Forum: Forms Yesterday, 07:25 AM
Replies: 15
Views: 140
Posted By arnelgp
Re: Expression has no value

so does NewID() function do?
Forum: General Yesterday, 07:02 AM
Replies: 7
Views: 143
Posted By arnelgp
Re: Access front end -to- SQL back end

consult again your IT, to allow Nulls to your fields.
Forum: General Yesterday, 06:58 AM
Replies: 3
Views: 80
Posted By arnelgp
Re: Set Value in Multi Select List Box

Me.List0.Selected(Me.List0.ItemData(PKnumber)) = True
Forum: Forms Yesterday, 06:51 AM
Replies: 15
Views: 140
Posted By arnelgp
Re: Expression has no value

If Nz(Me![ID], 0) = 0
Showing results 1 to 25 of 500

 
Forum Jump



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