Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.05 seconds.
Search: Posts Made By: wiklendt
Forum: Other Software 06-26-2018, 06:40 PM
Replies: 4
Views: 548
Posted By wiklendt
Forum: Other Software 06-26-2018, 01:34 PM
Replies: 4
Views: 548
Posted By wiklendt
Re: Help with Custom Data Validation rule via app script in Google Sheets

Awesome suggestions,thanks Uncle Gizmo!

Yes i agree, i actually expected to see some google stuff here on AWF especially as apps script seems googles equivalent of VBA, but, of course, it's not...
Forum: Other Software 06-23-2018, 06:08 AM
Replies: 4
Views: 548
Posted By wiklendt
Question Help with Custom Data Validation rule via app script in Google Sheets

Hi everyone,

Our school is moving to G Suite. I want to create/modify a script in one of my google sheets which will add a once-off validation rule to a column in one of my sheets.

For each...
Forum: Modules & VBA 08-08-2017, 02:15 PM
Replies: 14
Views: 803
Posted By wiklendt
Re: Loop to detect when .ldb closed within a time limit

Hi, yes I have seen DCrake's db and had actually modelled some of my code on it. I think I will have to implement more of it in my database and try to run everything from the FE - when I last used it...
Forum: Modules & VBA 08-07-2017, 01:34 PM
Replies: 14
Views: 803
Posted By wiklendt
Re: Loop to detect when .ldb closed within a time limit

Id love to know how to convert my Access.mdb databases to SQL server but I lack both knowledge and time (maybe also motivation?) at the moment.



Yes, my database is mdb - the ".ldb" is the...
Forum: Modules & VBA 08-07-2017, 01:13 PM
Replies: 14
Views: 803
Posted By wiklendt
Re: Loop to detect when .ldb closed within a time limit

Hi moke123, yes i have connections from FE to BE. unsure how I'd access the BE data otherwise? To ensure no connections to BE for compacting i have created the SE.

Is that a second vote to...
Forum: Modules & VBA 08-07-2017, 11:46 AM
Replies: 14
Views: 803
Posted By wiklendt
Re: Loop to detect when .ldb closed within a time limit

Scheduled task is tricky as the db is in a networked environment where our IT dept has made it impossible to use anything remotely useful.

Sent from my GT-I9505 using Tapatalk
Forum: Modules & VBA 08-07-2017, 11:44 AM
Replies: 14
Views: 803
Posted By wiklendt
Re: Loop to detect when .ldb closed within a time limit

Thanks for your quick reply ridders. I have thought about other approches and I was under the impression that a compact is risky for BE data integrity when there's an .ldb on the BE. Does the BE even...
Forum: Modules & VBA 08-07-2017, 02:53 AM
Replies: 14
Views: 803
Posted By wiklendt
Loop to detect when .ldb closed within a time limit

Hi all, long time no see.

I have cobbled together a Side-end (SE) which is triggered by Front-end (FE) to Compact/Repair (C/R) the Back-end (BE) in an automated way when users are not connected. ...
Forum: Reports 10-05-2015, 11:13 PM
Replies: 33
Views: 3,158
Posted By wiklendt
Re: how i can do this???

A quick google search would have provided the same information, sometimes with screenshots.

The workbook i uploaded already has this setup for you. Test this by trying to type over one of the...
Forum: Modules & VBA 09-09-2015, 02:31 PM
Replies: 15
Views: 941
Posted By wiklendt
I've arrived at work now so I won't be able to...

I've arrived at work now so I won't be able to look at this again until tonight. I have, hopefully steered you in the right direction.
Forum: Modules & VBA 09-09-2015, 02:21 PM
Replies: 15
Views: 941
Posted By wiklendt
Re: Rename folder and file

For what it's worth, i always have a 'friendly' text that is displayed for users, but i always name my associated file(s) by the primary key for that record - that way, if any data change, the...
Forum: Modules & VBA 09-09-2015, 02:17 PM
Replies: 15
Views: 941
Posted By wiklendt
Re: Rename folder and file

OK, so you first need to create the new directory. Use "MkDir" to first create the directory, then follow that up with your "Name" statement. I've not used "Name" before, so i'm not sure if deletes...
Forum: Modules & VBA 09-09-2015, 02:11 PM
Replies: 15
Views: 941
Posted By wiklendt
Re: Rename folder and file

So folder "X:\BASE DATAS\Yamaha\GTC 2.14 - John Mayer\" already exists before you make any changes?

Renaming a folder is not the same as having two pre-existing folders. I just want to be clear i...
Forum: Modules & VBA 09-09-2015, 01:46 PM
Replies: 15
Views: 941
Posted By wiklendt
Re: Rename folder and file

ok my project did something different involving deleting an image file and replacing it with a new one. never the less, i think we can sort this out.

i checked the microsoft help file for the...
Forum: Modules & VBA 09-09-2015, 12:39 PM
Replies: 15
Views: 941
Posted By wiklendt
I can check some of my old code in about an hour....

I can check some of my old code in about an hour. I think I've done something like this before.
Forum: Modules & VBA 09-09-2015, 12:36 PM
Replies: 15
Views: 941
Posted By wiklendt
Also, if the user has changed txturlpic, then...

Also, if the user has changed txturlpic, then oldlink1 won't work anymore, I'd have thought.
Forum: Modules & VBA 09-09-2015, 12:34 PM
Replies: 15
Views: 941
Posted By wiklendt
Bit rusty on "Name" : what does MS Access Help...

Bit rusty on "Name" : what does MS Access Help tell you "Name" is used for?
Forum: Modules & VBA 09-09-2015, 12:25 PM
Replies: 15
Views: 941
Posted By wiklendt
Have you done debugging on the code: Which line...

Have you done debugging on the code: Which line returns the error?
Forum: Reports 09-05-2015, 03:08 PM
Replies: 33
Views: 3,158
Posted By wiklendt
I am glad it is suitable for you. ...

I am glad it is suitable for you.

Unfortunately it is against my personal policy to give out my personal contact details. I much prefer, when you have a problem, to post it on this site (it also...
Forum: Reports 09-02-2015, 02:18 AM
Replies: 33
Views: 3,158
Posted By wiklendt
Re: how i can do this???

OK, how about this.

I thought about your problem and your desire to not have to redo all the report each day and month.

I think excel can still be your main program for this data. I considered...
Forum: Reports 08-29-2015, 01:55 PM
Replies: 33
Views: 3,158
Posted By wiklendt
Re: how i can do this???

OK, just to clarify: your "to date" column is a calculation for the current month only, so what you would want would reset on the beginning of each new month, with opening balance of the new month...
Forum: Reports 08-29-2015, 01:16 PM
Replies: 33
Views: 3,158
Posted By wiklendt
Re: how i can do this???

OK, will have a look.
Forum: Reports 08-24-2015, 02:24 PM
Replies: 33
Views: 3,158
Posted By wiklendt
Re: how i can do this???

I have just returned from a few days away.
I have opened your database file but without all the other information i asked about i remain confused as to how your data fits together. i have no idea...
Forum: Reports 08-19-2015, 03:06 PM
Replies: 33
Views: 3,158
Posted By wiklendt
Please note I have edited my last post after I...

Please note I have edited my last post after I submitted it, so your email notification will show an older version if my post.
Showing results 1 to 25 of 500

 
Forum Jump



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