Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: arnelgp
Forum: Queries Yesterday, 06:58 AM
Replies: 7
Views: 72
Posted By arnelgp
Re: database corruption?

Make a second cipy of the table.

Go to vba and type it in immediate window.

Or make a oublic sub/ func and run it.
Forum: Queries Yesterday, 12:57 AM
Replies: 6
Views: 83
Posted By arnelgp
Re: Auto Calculate Deadline Date excluding Weekends

Simply create a function in a module then call it in the query:

Public function calcDeadline(cat as string, byval dteReceived as date)
Dim i as integer

Select case cat & ""
Case is =...
Forum: Reports 06-17-2018, 10:30 PM
Replies: 4
Views: 132
Posted By arnelgp
Re: Sub Report Total

Put the total on Report Footer and not Page Footer. Also use textbox not label control.
Forum: Tables 06-14-2018, 04:18 AM
Replies: 12
Views: 177
Posted By arnelgp
Re: Easiest way to get Excel table into Access

you need VBA if you want to hide the process from the End Users.
you use:

DoCmd.TransferSpreadsheet TransferType:=acImport, SpreadsheetType:=acSpreadsheetTypeExcel12Xml, TableName:="nameOfTable",...
Forum: Modules & VBA 06-14-2018, 03:35 AM
Replies: 20
Views: 336
Posted By arnelgp
Re: VBA not requerying form on not in list event

Had you post the db earlier, we might solved it the soonest.
Forum: Tables 06-14-2018, 02:12 AM
Replies: 12
Views: 177
Posted By arnelgp
Forum: Modules & VBA 06-13-2018, 09:54 AM
Replies: 20
Views: 336
Posted By arnelgp
Re: VBA not requerying form on not in list event

It is very simple. Look at the sample that i have created to mimic your forms.
Forum: Modules & VBA 06-13-2018, 05:11 AM
Replies: 13
Views: 165
Posted By arnelgp
Re: HELP - Tick box to refresh form

something like this:

Private Sub yourTickBoxName_Click()
With Me.yourTablCtrlName
.Pages(0).Visible = Me.yourTickboxName
.Pages(1).Visible = Me.yourTickboxName
...
Forum: Modules & VBA 06-13-2018, 01:02 AM
Replies: 20
Views: 336
Posted By arnelgp
Re: VBA not requerying form on not in list event

here again.
add an unbound textbox (txtHidden) to frm_AddSku.
set its visible property to No.
some unnecesary codes were commented.
the folkowing is a modified code:

Private Sub...
Forum: Tables 06-12-2018, 10:56 PM
Replies: 11
Views: 269
Posted By arnelgp
Re: Link tables to specific Back Ends

You can also make a new table with fields:

WorkPlace (string)
LinkedTable (string)
Connection (string)


Fill this table with info such as if the db is in home, put ib the field workplace...
Forum: Modules & VBA 06-12-2018, 05:16 PM
Replies: 20
Views: 336
Posted By arnelgp
Re: VBA not requerying form on not in list event

There are many ways to fix this. The one you missed is that after the new sub cat is added you need to set the Response to acDataErrAdded.

But the question is how will you know if the sub cat is...
Forum: General 06-12-2018, 07:43 AM
Replies: 12
Views: 561
Posted By arnelgp
Re: upload Attachments to SQL server 2014

you are using late bound for your objects. Subst 3 to adUseClient or better set Reference to Microsoft ActiveX Data Object 2.8 or 6.1
Forum: General 06-12-2018, 02:06 AM
Replies: 12
Views: 561
Posted By arnelgp
Re: upload Attachments to SQL server 2014

try this forums:

https://usefulgyaan.wordpress.com/2014/09/30/store-and-fetch-files-sql-server-tables/

https://www.tek-tips.com/viewthread.cfm?qid=1776574
Forum: Modules & VBA 06-10-2018, 11:30 PM
Replies: 10
Views: 214
Posted By arnelgp
Re: flicker,flashes form on mouse move event

Sorry mr.moderator when i compact it it goes berserk.
Here is a good one.
Forum: Modules & VBA 06-10-2018, 10:31 PM
Replies: 10
Views: 214
Posted By arnelgp
Re: flicker,flashes form on mouse move event

Did ot bother to chk your table. I go and try to resolve the flicket. I think i minimized it. Some cool stuff also
Forum: Modules & VBA 06-09-2018, 11:52 PM
Replies: 3
Views: 126
Posted By arnelgp
Re: Click Vs Double Click

You cant compare anything to null. So

If RoomNumber = Null Then

Is not valid. Use:

If IsNull(RoomNumber) Then

Instead.
Forum: Reports 06-09-2018, 10:23 PM
Replies: 1
Views: 99
Posted By arnelgp
Re: Subreport question

Create a query and use that query as the Row Source of your sub report:

Select Ingredient, Code From yourtable Where Not (Code Is Null);
Forum: Forms 06-09-2018, 08:47 PM
Replies: 4
[SOLVED] Maximize Form
Views: 153
Posted By arnelgp
Re: Maximize Form

copy and paste this in a Standarrd Module.
this will maximize access window.


Option Compare Database
Option Explicit


'==============================
' CONSTANTS FOR DBASE WINDOW
Forum: Queries 06-07-2018, 05:40 AM
Replies: 8
Views: 183
Posted By arnelgp
Re: Delete certain data from a table

Yiu set all values to Null on your query, except the field you want to retain, with criteria Active=False.
Forum: General 06-07-2018, 03:24 AM
Replies: 15
Views: 863
Posted By arnelgp
Re: iIF function

Tnx ms.minty.
To the op, you owe me a doughnut.
Forum: Queries 06-07-2018, 02:31 AM
Replies: 2
Views: 108
Posted By arnelgp
Re: Delete Query with inner join

DELETE [SB-AD History].*
FROM [SB-AD History] WHERE [Aircraft Registration] In (Select T1.[Aircraft Registration] From [Aircraft List] as T1 Where T1.Active=False)
Forum: Modules & VBA 06-06-2018, 02:38 AM
Replies: 11
Views: 156
Posted By arnelgp
Re: why does my code miss out a record?

I think there is no GetDate() function in access, or is it a udf? Yiu should use Now() or Date().
Forum: Queries 06-05-2018, 07:32 PM
Replies: 7
Views: 213
Posted By arnelgp
Re: Custom Row Heading Sorting in Crosstab Query!

Take a look at the query again. It is now sorting correctly without extra table involved.
Forum: Modules & VBA 06-05-2018, 11:26 AM
Replies: 10
Views: 175
Posted By arnelgp
Re: Run-time error 3061

If you can't have it run using currentdb, and you said it works, you can try to use DoCmd.RunSql:

DoCmd.SetWarnings False
DoCmd.RunSql Currentdb.Querydefs("qryvoidBlank").SQL
DoCmd.SetWarnings...
Forum: General 05-31-2018, 10:06 AM
Replies: 3
Views: 732
Posted By arnelgp
Re: Not Like "X*" in query critera, if empty does not show record

just a guess enclosed X inside sqr bracket:

Not like "*[X]*"
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 03:29 AM.


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