Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 157
Search took 0.06 seconds.
Search: Posts Made By: Anakardian
Forum: General 03-13-2018, 11:34 PM
Replies: 10
Views: 612
Posted By Anakardian
Re: Has anyone else had all of their fonts spontaneously change?

Keep in mind that size is not the same across fonts.
I have found that verdana is about 1 size larger than arial.
No doubt the same can be found between other fonts.

I would not be concerned...
Forum: General 12-14-2017, 07:37 AM
Replies: 4
Views: 689
Posted By Anakardian
Re: building a preventative maintenance database

Regarding the first part of your question, this is quite possible.
All you need to know is the service interval for the particular job.
You can then calculate the next due date.

With regards to...
Forum: Modules & VBA 08-15-2017, 03:14 AM
Replies: 15
Views: 733
Posted By Anakardian
Re: Password validation

You might want to consider this article before making everything complicated:
Forum: General 12-05-2016, 11:13 PM
Replies: 3
Views: 657
Posted By Anakardian
Re: voyage leg analysis

Be careful when dealing with ships and the way they navigate.
Most of the time they will be using rhumb line instead of great circle since great circle is a major pain in the a.. to use.
For short...
Forum: Tables 11-30-2016, 11:01 PM
Replies: 11
Views: 1,056
Posted By Anakardian
Re: merging all Identical tables

You could also use the import function you have in access to import the tables into a temporary holding table.
In that table you can then have the additional columns mentioned above.

Use an...
Forum: Reports 11-28-2016, 03:00 AM
Replies: 3
Views: 343
Posted By Anakardian
Re: Printer lost some queue reports

Because it has just been a friday I cannot resist.

Forum: Debates 09-26-2016, 03:56 AM
Replies: 10
Views: 3,914
Posted By Anakardian
Re: If a moon of Jupiter support life - should we introduce new life for Earth travel

Using it as a refueling station though, that might be possible with a robot.
Water is a quite useful resource for oxygen and fuel.
The amount of fuel you can save by refueling out there is...
Forum: Debates 09-26-2016, 12:43 AM
Replies: 10
Views: 3,914
Posted By Anakardian
Re: If a moon of Jupiter support life - should we introduce new life for Earth travel

It really depends.
How many new species of fish and other marine life is discovered on earth every year?
How long will it take to be sure there are not other lifeforms there already?

We are...
Forum: Queries 09-21-2016, 09:50 PM
Replies: 2
Views: 350
Posted By Anakardian
Re: Tables to feed into main table

I would use the two tables you mention from ebay and paypal as the place where I import data.
For my own use I would strip out those fields I need from both tables and have them in a single table....
Forum: Modules & VBA 09-14-2016, 10:09 PM
Replies: 4
Views: 177
Posted By Anakardian
Re: Output query to excel multiple times

How about using this method?

I had it in function for exporting the various things I needed to a data sheet in an excel file. I could then run the few calculations needed in excel from that. The...
Forum: Modules & VBA 09-08-2016, 02:05 AM
Replies: 2
Views: 332
Posted By Anakardian
Re: Importing Data From Legacy System Into Access 2007, Access 2007

I have used something like this to import from excel files:

Option Compare Database
Public strPathOriginal As String 'The original path to teh file location
Public strPathWorking...
Forum: Tables 09-07-2016, 04:27 AM
Replies: 7
Views: 475
Posted By Anakardian
Re: Month question

Having run into similar trouble as CJ_London is describing, I have taken to always displaying dates in a manner that will never be mistaken.
In your case, I would display Aug 2016 or Aug 16.
Forum: Queries 09-05-2016, 02:42 AM
Replies: 4
Views: 410
Posted By Anakardian
Re: Combine MS queries

You can set all three fields in the same query if they are in the same table.

When you are in the query editor, simply add the fields to your query and set their new value.
Forum: Web Design and Development 08-25-2016, 11:24 PM
Replies: 10
Views: 13,086
Posted By Anakardian
Re: Creating a website

Google has a free website service you can use.
I am sure there are other places that have a similar service you can use.

If you have your own webiste, there is a chance that your hosting company...
Forum: Tables 08-18-2016, 12:04 AM
Replies: 4
Views: 338
Posted By Anakardian
Re: Query large sql server linked table from MS Access

Have a look at stored procedures and views?
That way the calculation, filtering etc. is done on the server and you only get the result back.
Generally the server is better equipped to do the...
Forum: Modules & VBA 07-07-2016, 03:42 AM
Replies: 10
Views: 260
Posted By Anakardian
Re: Word Reports as template

Depending on how you build your word template it can be done somewhat easily but it might be easier to use the reports in Access with their limitations.
Forum: Tables 06-29-2016, 04:07 AM
Replies: 3
Views: 320
Posted By Anakardian
Re: Access 2010 & Alpha-Numeric Issue

Doing that will ensure you have a unique number.

The number may or may not be sequential and can be both positive and negative.

I would certainly use the autonumber but only as a reference...
Forum: Modules & VBA 06-27-2016, 11:46 PM
Replies: 8
Views: 408
Posted By Anakardian
Re: Hair is coming out (VBA HELP)

one way to get around a field not existing in the tbale is to use the normal import function in access to import the csv file once.
Let it create a new table for you. this ensures it names the...
Forum: Word 06-22-2016, 09:57 PM
Replies: 3
Views: 2,372
Posted By Anakardian
Re: Insert data from access into a word template but multiple fields

This https://msdn.microsoft.com/en-us/library/aa537149(v=office.11).aspx seems to explain it pretty well.
Forum: Word 06-20-2016, 11:13 PM
Replies: 3
Views: 2,372
Posted By Anakardian
Re: Insert data from access into a word template but multiple fields

To me it looks like you are doing some text insertion.

If so, consider concatenating it in access instead of inserting each line seperately.
That way you may get away with just doing a single...
Forum: Tables 06-10-2016, 09:55 AM
Replies: 7
Views: 765
Posted By Anakardian
Re: Question on large data table design

Have a look at a star diagram type database.
You would purposely de-normalise the database in an effort to make speed the priority.

This is a pretty specialised database design so it is...
Forum: General 05-27-2016, 12:03 AM
Replies: 3
Views: 268
Posted By Anakardian
Re: Document Filing System and authorise before publishing (noob question)

I believe it is posisble to do this but you need to set up something to run a few things.

Adding a new document is fairly easy.
When you do this, include a timestamp for when it was done or it is...
Forum: Queries 05-09-2016, 09:47 PM
Replies: 8
Views: 299
Posted By Anakardian
Re: Making a simple yes count!

You can always multiply the result with -1.
Forum: Modules & VBA 04-29-2016, 02:29 AM
Replies: 3
Views: 509
Posted By Anakardian
Re: Very Strange VBA Problem

You can also try to start the file with the /decompile flag.

Example: "C:\Program Files\Microsoft Office\Office14\MSACCESS.EXE" "Path to your file" /decompile

Save the above in a .bat file and...
Forum: Forms 04-27-2016, 11:38 PM
Replies: 6
Views: 675
Posted By Anakardian
Re: Records overwritten instead of saved as new

Why not combine your current method with another button that will carry over all of the variable data from the form to a new record?
That way there will be a way to make a record for each occasion...
Showing results 1 to 25 of 157

Forum Jump

All times are GMT -8. The time now is 11:51 PM.

Microsoft Access Help
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