Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 36
Search took 1.73 seconds.
Search: Posts Made By: shadow9449
Forum: Introduce Yourself 12-25-2018, 07:13 AM
Replies: 7
Views: 314
Posted By shadow9449
Re: N00b in MS Access from Rio de Janeiro

Seja bem-vindo! A gente aqui e muito legal. Voce fala inglÍs muito bem, carioca!

Feliz natal!

(Translation. Welcome. We are really cool/nice here. You speak English really well, person from...
Forum: General 10-05-2018, 07:46 AM
Replies: 9
Views: 282
Posted By shadow9449
Re: Database Corruption

1. Did you try replacing the front end that resides on her local computer? Maybe it got damaged and you can solve this by replacing it. The way I implement split databases is with a batch file on...
Forum: Modules & VBA 10-03-2018, 07:35 PM
Replies: 94
Views: 34,743
Posted By shadow9449
Re: calculate the driving distance between 2 zip codes

Jdraw:

Thanks for the research. It seems that Colin/Ridders/Isladogs has done some work using the Google Maps API using a key and the method using the key is inexpensive or doesn't cost at all.
...
Forum: General 04-10-2018, 10:09 AM
Replies: 48
Views: 2,115
Posted By shadow9449
Re: Front End Database and Users

Just to add a bit:

- If you want a really good article explaining why and how to split, read Albert Kallal's explanation on the topic: http://kallal.ca/Articles/split/index.htm

- One REALLY...
Forum: General 08-08-2017, 03:56 PM
Replies: 5
Views: 555
Posted By shadow9449
Re: Exclusive Access error

The first post stated that the database is split. If you're not clear on how and why (or if, in this case) splitting is done, Albert Kallal has a great webpage in clear language about the topic:
...
Forum: Introduce Yourself 12-30-2016, 08:16 AM
Replies: 2
Views: 314
Posted By shadow9449
Re: Hello from Toronto, Canada

Hey, cool. Welcome from another Torontonian. You've come to the right place for Access help!

SHADOW
Forum: Modules & VBA 05-23-2016, 07:11 AM
Replies: 4
Views: 866
Posted By shadow9449
Re: Drag and drop and show file name only.

The description of the question is not quite clear. However, Jack Leach created this awesome demo that I was able to modify for my own needs and incorporate in my projects:...
Forum: Theory and practice of database design 04-16-2016, 08:50 PM
Replies: 13
Views: 2,593
Posted By shadow9449
Re: Shared Drive Woes on the Backend

You can turn that off from the Device Manager, finding the LAN card and clicking the Power Settings tab.

SHADOW
Forum: Queries 07-31-2015, 07:13 AM
Replies: 10
Views: 1,385
Posted By shadow9449
Re: PDF Making in Access 2003

I don't use a PDF writer. I use Lebans' solution:

http://www.lebans.com/reporttopdf.htm

SHADOW
Forum: Modules & VBA 09-12-2014, 08:53 AM
Replies: 14
Views: 1,638
Posted By shadow9449
Re: Comm Ports without mscomm32

It's really hard to know without knowing what "end file" terminator they are using. Maybe it's in the documentation somewhere?

SHADOW
Forum: General 07-28-2014, 09:53 AM
Replies: 5
Views: 749
Posted By shadow9449
Re: Automatic Backup - Access DB

The way I implement backups:

- I use Albert Kalall's method of zipping the database: http://www.kallal.ca/zip/index.htm This puts the date on the Zip file for you and moves it to wherever you...
Forum: Theory and practice of database design 03-27-2014, 10:41 AM
Replies: 16
Views: 2,000
Posted By shadow9449
Re: Lazy Loading

Can you load the results of those controls using dlookup or opening the recordsource? I actually do the same in my example that I gave before. On the client's front screen it shows if the client has...
Forum: Theory and practice of database design 03-27-2014, 07:55 AM
Replies: 16
Views: 2,000
Posted By shadow9449
Re: Lazy Loading

Assuming I understand what you mean about "lazy loading", the idea is for data that's not necessary until the user clicks one of the tabs is not loaded until the tab is actually clicked. This reduces...
Forum: General 06-17-2013, 06:03 AM
Replies: 5
Views: 754
Posted By shadow9449
Re: Front end startup problem

If the application is put in the same location each time, then setting the location as a secure location on a one-time basis should help.

I assume the user is using a full install of MS Access...
Forum: Forms 04-22-2013, 07:13 AM
Replies: 4
Views: 3,362
Posted By shadow9449
Re: Converting Accde File To A Normal File

You can't change it back. But if you changed it to ACCDE, then you must have the original, right?

SHADOW

Edited to say: Paul beat me to it by seconds!
Forum: Forms 02-26-2013, 07:21 AM
Replies: 3
Views: 412
Posted By shadow9449
Re: Error Message when starting up Access

You must have put some startup code to tell it to open that form. Did you check the startup form, or an Autoexec macro?

SHADOW
Forum: General 12-04-2012, 07:17 PM
Replies: 3
Views: 658
Posted By shadow9449
Re: how much is this worth?

The place I would start would be to assess how long you expect the project to take and quote by the hour.

I posted some thoughts based on my experience in this post:...
Forum: Forms 12-03-2012, 03:36 PM
Replies: 8
Views: 1,360
Posted By shadow9449
Re: Search as you type

It's hard to be more specific without seeing the form setup, data structures and so on.

In general, you might have an ID for each ingredient (hidden from the user), and a list of ingredients on a...
Forum: Forms 12-03-2012, 08:20 AM
Replies: 8
Views: 1,360
Posted By shadow9449
Re: Search as you type

Well, once you've identified the specific ingredient, why don't you double click it or something to have it add to a recipe. Do you know how to do that?

SHADOW
Forum: Forms 11-28-2012, 07:14 AM
Replies: 3
Views: 521
Posted By shadow9449
Re: Starting a database in a Form

Try this:

http://office.microsoft.com/en-us/access-help/set-the-default-form-that-appears-when-you-open-a-database-or-web-application-HA010341995.aspx
Forum: Reports 11-09-2012, 06:42 AM
Replies: 4
Views: 1,171
Posted By shadow9449
Re: The Search Key Was Not Found!!!

That message usually indicates corruption. There's a number of ways to get a corrupt database, some of thethe most common being having an unsplit database with multiple users or using an Access...
Forum: Introduce Yourself 09-10-2012, 09:45 AM
Replies: 2
Views: 612
Posted By shadow9449
Re: Hello from Burlington, ON

Welcome, neighbour! I'm in Toronto

SHADOW
Forum: General 07-12-2012, 11:09 AM
Replies: 12
Views: 1,760
Posted By shadow9449
Re: Need expert opinion on a shared database

I would. Strange that it should reset itself...

SHADOW
Forum: General 07-12-2012, 10:36 AM
Replies: 12
Views: 1,760
Posted By shadow9449
Re: Need expert opinion on a shared database

You're welcome. I'm glad the kind people on the forum could help.

SHADOW
Forum: General 07-11-2012, 08:18 PM
Replies: 12
Views: 1,760
Posted By shadow9449
Re: Need expert opinion on a shared database

Splitting the database is more for performance and making your application more corruption proof rather than for speed.

Did you set a persistent connection to a table in the database? That makes a...
Showing results 1 to 25 of 36

 
Forum Jump



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