Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 244
Search took 0.02 seconds.
Search: Posts Made By: Dairy Farmer
Forum: General 10-16-2015, 08:04 AM
Replies: 22
Views: 7,757
Posted By Dairy Farmer
Re: Setup Form with Backup Button - Help!

What extension are you using for your backend? It should be ACCDB. If it is something else, change the code to reflect that.

fs.CopyFile source & "*.accdb", str

Also the file to backup must be...
Forum: General 11-27-2011, 10:43 AM
Replies: 7
Views: 1,551
Posted By Dairy Farmer
Re: How Omit Zeros From The Average Function Formula

Why not use median rather than average. It is more representative of the "average" as it tends to "ignore" those numbers that are way out.

Now why Microsoft chose to not include this function that...
Forum: Forms 11-18-2011, 08:26 PM
Replies: 6
Views: 834
Posted By Dairy Farmer
Re: Duration

How are you getting [SumElapsedTime] ?

If the input fields are in Date/Time format why not use
DateDiff("h",[SatrtDateTime],[EndDateTime])
Forum: Forms 11-17-2011, 08:31 PM
Replies: 5
Views: 846
Posted By Dairy Farmer
Re: Local TIme on form

You can get the computers time zone (GMT offset bias) from the registry

Goto HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\TimeZoneInformation\Bias

Use a simple read registry function to...
Forum: Forms 11-15-2011, 07:58 PM
Replies: 2
Views: 768
Posted By Dairy Farmer
Re: How do i minimise/control the size of the form to the centre of the screen?

MoveSize - either via a Macro or via VBA. Look in the Help files it is fully explained.
Forum: Macros 11-15-2011, 07:44 PM
Replies: 17
Views: 2,879
Posted By Dairy Farmer
Re: Entering a Search Function on a Form

This may not work for your application, but others searching this forum looking for a simple search function may find it usefull.

A very simple way to do searches is to use combo boxes. These have...
Forum: Forms 11-15-2011, 07:14 PM
Replies: 3
Views: 742
Posted By Dairy Farmer
Re: How to Include Formula in formula

Something like Excel's networkdays?

See http://www.access-programmers.co.uk/forums/showthread.php?t=37245
Forum: Forms 11-15-2011, 07:20 AM
Replies: 12
Views: 1,649
Posted By Dairy Farmer
Re: Calendar icon in Access 07 & higher

Not directly.

First save the .mdb as accdb
Once its an accdb you can make it an accde
Package Solution (Developer) will make the accde an accdr if you want it to and bundle it up in an .msi...
Forum: Forms 11-15-2011, 01:53 AM
Replies: 12
Views: 1,649
Posted By Dairy Farmer
Re: Calendar icon in Access 07 & higher

You mentioned in your OP that you are running the app with Runtime07. Why keep going back to 03? Just keep developing in 07 and distributing the app as accdr or accde.

The Package Solution Wizard...
Forum: Tables 11-14-2011, 06:03 AM
Replies: 24
Views: 2,373
Posted By Dairy Farmer
Re: Changing a table

I thought that Normalization meant dividing large tables into smaller tables and defining a relationship between them.

Well if you take this example:
Everything related to the invoice is in one...
Forum: Tables 11-14-2011, 05:36 AM
Replies: 24
Views: 2,373
Posted By Dairy Farmer
Re: Changing a table

Looking at the pic I would definatly split using something like the Invoice (something common but unique):

Table1
Invoice No
Date

Table2
Invoice No
Tester
Forum: General 11-14-2011, 05:24 AM
Replies: 12
Views: 701
Posted By Dairy Farmer
Re: Having the same date show up on each form

Here is something to get you started
Forum: General 11-14-2011, 04:42 AM
Replies: 12
Views: 701
Posted By Dairy Farmer
Re: Having the same date show up on each form

Maybe the easiest way would be have a main form with a tab control. In the tab control are all the sections (forms) of the audit. The main form needs 2 fields: date and farm.

Use linked fields...
Forum: Sample Databases 11-14-2011, 01:06 AM
Replies: 1
Views: 8,174
Posted By Dairy Farmer
Updated: 30 Day Trial with Registration

I just did a bit more work on the file:

Fixed some of the comments in the code
Fixed the imput masks that were not quite right
Split the single Module into 4 modules. Easier to work out the...
Forum: Tables 11-13-2011, 07:14 PM
Replies: 24
Views: 2,373
Posted By Dairy Farmer
Re: Changing a table

I use the Excel method only on testing or once off cases.

I didn't mean that normilising the database should not be done. Sorry if my responce came off the wrong way.
Forum: Tables 11-12-2011, 08:18 PM
Replies: 24
Views: 2,373
Posted By Dairy Farmer
Re: Changing a table

If you want the keep the table as is and ignor bparkinson the is a "down and dirty" option.

Shut the database down.
Export the current table to Excel (tab1)
Export the new data to Excel (tab2)
...
Forum: Forms 11-12-2011, 07:49 PM
Replies: 3
Views: 1,395
Posted By Dairy Farmer
Re: Sequential Numbering Auto "Bar-Code"

Remember that if you are going to actually make bar codes then they cannot simply be sequencial (simplified answer). Unless certain formats are used (i.e. Coad39 bar codes).

Bar codes should have...
Forum: Forms 11-12-2011, 07:37 PM
Replies: 11
Views: 1,044
Posted By Dairy Farmer
Re: Default Values

So why not set your default values via VBA.

Form:

AllowAdditions = False

2 buttons on the form:

Button1 imports data
AllowAdditions = True
Forum: Forms 11-12-2011, 07:23 PM
Replies: 10
Views: 1,619
Posted By Dairy Farmer
Re: Sum of a Calculated Field

Here is a sample using both Query method and Direct Table method.

Are you try to add 10%?

If so then the code sould read:
([NoItems]*[Price])*1.1
Forum: Forms 11-12-2011, 07:04 AM
Replies: 10
Views: 1,619
Posted By Dairy Farmer
Re: Sum of a Calculated Field

So would you rather calculations are done in a Query than in a Form? Better database structure?

I would tent to go for a Query where there are a lot of records, as I would have some kind of filter...
Forum: Forms 11-12-2011, 05:24 AM
Replies: 10
Views: 1,619
Posted By Dairy Farmer
Re: Sum of a Calculated Field

@ vbaInet

Ah I see.

I normally put the calculation in the Query not the form. The form's data source is the Query not the Table. Therefore the sum() comes from the line total field not the...
Forum: Modules & VBA 11-12-2011, 05:05 AM
Replies: 16
Views: 1,471
Posted By Dairy Farmer
Re: Eliminate Duplicates

Email harvesting?
Forum: Macros 11-12-2011, 04:50 AM
Replies: 5
Views: 1,751
Posted By Dairy Farmer
Re: SendObject to fill out addressee

Oops, macro not VBA. Sorry.

here is the code in VBA. Maybe someone can change it to a Macro for you.

Dim EmailAddress, Subject, MessageText

'EmailAddress = "my@mail.com"
...
Forum: Forms 11-12-2011, 04:34 AM
Replies: 10
Views: 1,619
Posted By Dairy Farmer
Re: Sum of a Calculated Field

You need to use the name of the text box in your formula.

That is:
If the name of the text box in Detail is "RetailCost", the formula in Footer should read
=sum([RetailCost])

The way you have...
Forum: Forms 11-11-2011, 07:38 PM
Replies: 4
Views: 754
Posted By Dairy Farmer
Re: Refreshing Forms (Via Embedded Button)

Private Sub RefreshButton_Click()
Me.Requery
End Sub
Showing results 1 to 25 of 244

 
Forum Jump



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