Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.18 seconds.
Search: Posts Made By: arnelgp
Forum: General Today, 01:24 AM
Replies: 2
Views: 2
Posted By arnelgp
Re: Help database design

show yout excel record and somebody will give you the table structure you need.
Forum: General Yesterday, 08:33 PM
Replies: 3
Views: 50
Posted By arnelgp
Re: DB sharing

make a shared folder.
add Everyone to its user.
on Advace sharing, make sure to grand "Full Control","Read","Write" to Everyone.
split the db (FE/BE) (on Ribbon, Database Tools->Move Data->Access...
Forum: Forms Yesterday, 04:21 PM
Replies: 2
Views: 43
Posted By arnelgp
Re: Using Forms with Union Query

uion query is read only query. combine your tables to 1 and just add 1 column for their designation .
Forum: Forms Yesterday, 10:58 AM
Replies: 5
Views: 82
Posted By arnelgp
Re: SubForm memo field - Spell Check

what code do you have to lock the bound controls and the subform?
Forum: General Yesterday, 10:28 AM
Replies: 2
Views: 55
Posted By arnelgp
Re: Need help converting excel formula to access

what is the basis of "changing in record"? by User & skill?
create this function in a Standard Module (VBA->Insert->Module).

Public Function fn20Check(pUser As Variant, pCase As Variant, pSkill...
Forum: Forms Yesterday, 10:03 AM
Replies: 8
Views: 157
Posted By arnelgp
Re: Changing images on a Continuous Form

here is another example (sample1 form), without using attachment field and instead using external image file.

before opening the db, extract the two images to "C:".
if you open tblNoAttachment...
Forum: Queries 07-22-2019, 10:10 AM
Replies: 7
Views: 162
Posted By arnelgp
Re: Query not accepting Form Value (multi Select List)

create a Query (same as qProducts_MachineCheck_TEST) but without parameter and without criteria.
save it to any name.
copy and paste it with Prefix "zz".
on your code:

Private Sub...
Forum: Modules & VBA 07-22-2019, 09:49 AM
Replies: 8
Views: 131
Posted By arnelgp
Re: VBA Open Record to Form

if you are opening the form frmCustomerExisting from elsewhere other than the original form, you must qualify the where clause:

DoCmd.OpenForm "FrmCustomerExisting", _
WhereCondition:="[Doc ID]="...
Forum: General 07-22-2019, 09:30 AM
Replies: 8
Views: 125
Posted By arnelgp
Re: Property Not Found - 3270 - For some users and not others

you can add the Property, if not found, so as not to throw error

Private Sub Form_Current()
On Error Goto Err_Handler
Dim Db As DAO.Database
set Db=currentdb
If Db.Properties("UseMDIMode") <>...
Forum: Forms 07-22-2019, 08:59 AM
Replies: 5
Views: 96
Posted By arnelgp
Re: How to "copy" data and "pasting" to the acNewRec

you mean carry over the last record.
the code is not mine although HasProperty edited.

Option Compare Database
Option Explicit

Public Function subCarryOver(frm As Form, strErrMsg As String,...
Forum: Tables 07-21-2019, 07:54 PM
Replies: 15
Views: 185
Posted By arnelgp
Re: Preset values in a field

your quick example is now ready.
Forum: Tables 07-21-2019, 08:37 AM
Replies: 15
Views: 185
Posted By arnelgp
Re: Preset values in a field

firstly you don't need the firstname and lastname on tblCerts.
you can get it from tblInfo by linking both tables (left join) by ID and PersonID fields.
you don't also need the other fields in your...
Forum: Forms 07-21-2019, 08:16 AM
Replies: 12
Views: 169
Posted By arnelgp
Re: Copy Last Entered Record with DMAX and DLOOKUP VBA

do you still want to copy the latest record.
here it is.
Forum: General 07-20-2019, 09:24 PM
Replies: 6
Views: 144
Posted By arnelgp
Re: Backup a Backend - enhanced

i always use third party program. Goodsync, set and forget. it has un attended feature. allows backup on file change. allows backup even when the file is in use.
Forum: Forms 07-20-2019, 09:39 AM
Replies: 8
Views: 157
Posted By arnelgp
Re: Changing images on a Continuous Form

sample continuous form using images from attachment field.
Forum: Forms 07-20-2019, 08:59 AM
Replies: 3
Views: 95
Posted By arnelgp
Re: Insert a form into a subform

agree with theDBguy.

If This = "stuff1" And That = "Stuff2" Then
[DM].SourceObject = "Form.theFormToShowHere"

ElseIf This = "stuff3" And That = "Stuff4" Then
[DM].SourceObject =...
Forum: Forms 07-20-2019, 08:15 AM
Replies: 8
Views: 157
Posted By arnelgp
Re: Changing images on a Continuous Form

what is the fieldtype of your custom images. OLE (blob) or attachment?
Forum: Forms 07-19-2019, 09:51 PM
Replies: 11
Views: 173
Posted By arnelgp
Re: Split form record selectors

is it the correct table coz I just tested it.
Forum: Forms 07-19-2019, 09:25 PM
Replies: 11
Views: 173
Posted By arnelgp
Re: Split form record selectors

on design view of your table->Property Sheet.
Forum: Forms 07-19-2019, 09:09 PM
Replies: 11
Views: 173
Posted By arnelgp
Re: Split form record selectors

no possible to program that part.
its for table view only and it is not a split form.
its a sub datasheet.

you can remove it on table design.
blank out the Subdatasheet Name on the property...
Forum: Modules & VBA 07-19-2019, 08:42 PM
Replies: 15
Views: 222
Posted By arnelgp
Re: Keep Access Application Minimized

only 1 comment, when you hide the app window and click to unhide it the ribbon is gone also the nav pane.
Forum: Forms 07-19-2019, 08:25 PM
Replies: 4
Views: 97
Posted By arnelgp
Re: displaying data from an xml file on a form

first read the file content to a variable string.
then find the tag <raw_text> save its position on the string.
next find </raw_text>, save it's position on the string.
then using mid() function...
Forum: Modules & VBA 07-19-2019, 07:58 AM
Replies: 12
Views: 142
Posted By arnelgp
Re: Open Admin Form after Login

okey.
add an Unbound textbox to Form1, anywhere in the form.
name it txtHidden.
Set it's Visible Property to No.

add code to the Timer Event:

Private Sub Form_Timer()
Me.TimerInterval =...
Forum: Forms 07-19-2019, 07:05 AM
Replies: 11
Views: 83
Posted By arnelgp
Re: autofill values for logged in users

on design view of your form, on its Property Sheet->Event->Before Update.
you choose code from the selection.
Forum: Modules & VBA 07-19-2019, 06:55 AM
Replies: 12
Views: 142
Posted By arnelgp
Re: Open Admin Form after Login

where do you call the Login form, from form1?
if so remove the code that closes form1.

If cboUser.Column(1) = "Admin" Then
'Open the Main form
DoCmd.OpenForm "Admin"
Else
Showing results 1 to 25 of 500

 
Forum Jump



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