Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 25
Search took 0.03 seconds.
Search: Posts Made By: eddix99
Forum: General 09-20-2018, 10:35 PM
Replies: 9
Views: 353
Posted By Pat Hartman
Re: I'm worried for future versions of Access

That isn't necessary. If you must keep your data in a Jet/ACE BE, you can split the data into multiple BE's. The downside is that you cannot enforce RI across multiple physical BE files. So if you...
Forum: General 09-20-2018, 10:10 PM
Replies: 9
Views: 353
Posted By Pat Hartman
Re: I'm worried for future versions of Access

I took my first programming job in 1968 and then spent 25+ years working with various IBM mainframe programming languages (mostly COBOL) and various data bases such as IMS/DB, ADABASE, and DB2 as...
Forum: General 09-20-2018, 03:57 AM
Replies: 9
Views: 353
Posted By Lightwave
Re: I'm worried for future versions of Access

Firstly I would recommend looking at SQL Azure databases which is the first step into experimenting with web databases.

I am essentially echoing Gizmo - experiment with Web but I wouldn't...
Forum: General 09-20-2018, 12:19 AM
Replies: 9
Views: 353
Posted By CJ_London
Re: I'm worried for future versions of Access

My own belief is the future is a toss up between client based systems and web based systems but there is a need for both.

Each have their advantages and disadvantages and it very much depends on...
Forum: General 09-19-2018, 11:18 PM
Replies: 9
Views: 353
Posted By Gasman
Re: I'm worried for future versions of Access

If you can get by with what you already have, I would not be that concerned.?
Short sightedness perhaps, but I am still using Quicken 2004, the last version in the UK.
It handles mine and a charity...
Forum: General 09-19-2018, 11:07 PM
Replies: 9
Views: 353
Posted By Uncle Gizmo
Re: I'm worried for future versions of Access

The same question has bothered me periodically over the years. At one stage I was actively looking at moving over to everything Google. I was deceived by their "Do No Harm" message but it turned...
Forum: Queries 09-19-2018, 10:17 PM
Replies: 3
Views: 90
Posted By JHB
Re: Appending Data - Using Dlookup to retrieve Primary Key value to insert into Forei

Why not linking the 2 tables together?

SELECT DlookupTest2.DTest2_ID, DlookupTest2.Person_Name, DlookupTest2.[Building Number_2], DlookupTest.DTest1_ID
FROM DlookupTest2 INNER JOIN DlookupTest ON...
Forum: General 09-09-2018, 12:24 PM
Replies: 2
Views: 675
Posted By Uncle Gizmo
LinkedIn article which might amuse!

I've just posted an article on LinkedIn which might amuse!

Moving from Excel to MS Access - Three problems to Avoid!...
Forum: Modules & VBA 10-10-2017, 11:54 PM
Replies: 5
Views: 354
Posted By arnelgp
Re: VBA attachments procedure - hopelessly stuck

i think this will do it.




Sub objAtt1()

Dim db As DAO.Database
Dim recSet As DAO.Recordset2
Dim recSet2 As DAO.Recordset2
Forum: Modules & VBA 10-10-2017, 09:25 PM
Replies: 5
Views: 354
Posted By JHB
Re: VBA attachments procedure - hopelessly stuck

You update the first recordset, try by removing from your code.
recSet.Update
Forum: Queries 07-24-2017, 08:04 AM
Replies: 7
Views: 367
Posted By MarkK
Does that sub query work as a stand-alone query? ...

Does that sub query work as a stand-alone query? Make sure that works first.

Then, in your WHERE clause, you can't use '<>' to compare a single field value in the main query against a sub query...
Forum: Queries 07-23-2017, 07:52 PM
Replies: 7
Views: 367
Posted By MarkK
You may want to GROUP BY the fields that are...

You may want to GROUP BY the fields that are duplicated, then find the Min(ID), something like...
SELECT Min(ID) As MinID, Count(*) As DupeCount, CompanyName, ZipCode
FROM Table
GROUP BY...
Forum: Queries 09-21-2016, 08:56 PM
Replies: 5
Views: 336
Posted By sneuberg
Re: Access SQL Sub-Query Help/Advice Needed

Consider an aggregate query of the join of tblDRInvLineItem and tblDRRecM2M grouped by the DRInvLineItemID_PK and DRInvLineItemAmount and the sum of DRRecAmount or

SELECT...
Forum: Queries 09-21-2016, 08:40 PM
Replies: 5
Views: 336
Posted By MarkK
If you need to move data around in tables in...

If you need to move data around in tables in order to process it, you almost certainly have a table design problem. You should be able to draw directly from your stored data to process your result...
Forum: Forms 09-08-2016, 01:58 AM
Replies: 5
Views: 508
Posted By Simon_MT
Re: Help with creating a Debtor invoice allocation form

Heres how I would approach the problem. Ididn't go down to line items as I was dealing with high value goods. The prinicple would be the same. When processing the cash slect the invoice and...
Forum: Forms 09-07-2016, 04:42 AM
Replies: 5
Views: 508
Posted By plog
Re: Help with creating a Debtor invoice allocation form

Yes you have. And again, my points were more thinking out loud than saying "you've absolutely done this wrong". The things I saw, just seemed to make things more complicated than they needed--but...
Forum: Forms 09-06-2016, 04:58 AM
Replies: 5
Views: 508
Posted By plog
Re: Help with creating a Debtor invoice allocation form

A good rule for forms is that for every table whose records you want to act on (add/edit/delete), then there should be 1 form . You have 4 tables in that relationship, so it would necessitate 4...
Forum: Forms 09-06-2016, 03:50 AM
Replies: 9
Views: 541
Posted By Galaxiom
Re: Total of subform in form achieved but how do I set the row source to update table

One thing I should have mentioned with VBA. Make sure to to include the declaration Option Explicit in all modules. This forces all variables to be declared and avoids a lot grief if you happen to...
Forum: Introduce Yourself 07-25-2016, 11:36 PM
Replies: 5
Views: 577
Posted By Lightwave
Re: G'day from Adelaide

Edd get stuck in - even if you can't do everything you will have a better understanding of what products you do need which represent good value for money.

Welcome to the forum
Forum: Forms 07-07-2016, 08:07 PM
Replies: 9
Views: 541
Posted By Galaxiom
Re: Total of subform in form achieved but how do I set the row source to update table

There are definitely grey areas and it depends how much you want to do to normalize the data. A fully normalized GST system has a tax table that records the date when the rate changes so calculation...
Forum: Forms 07-06-2016, 11:25 PM
Replies: 9
Views: 541
Posted By Galaxiom
Re: Total of subform in form achieved but how do I set the row source to update table

A rule of thumb with databases is to never store a calculation unless in use you find that it is unacceptably slow. Even then, poor performance can usually be tracked to other reasons such as...
Forum: Introduce Yourself 03-19-2012, 07:43 AM
Replies: 0
Views: 81,073
Posted By Jon
New Member? READ ME FIRST!

Welcome to the Access World Forums!

To get the best out of them, at a minimum I encourage you to do this:

1. Introduce yourself here - not this thread but by clicking the New Thread button -...
Forum: Queries 02-15-2012, 05:16 AM
Replies: 7
Views: 4,908
Posted By Mr. B
Re: Splitting positive and negative figures into seperate columns

You can create one query but use two columns in your query.
One column would be:

Credits: IIf(Table1.Transactions > 0, Table1.Transaction,"")

The second column would be:

Debits:...
Forum: General 05-21-2009, 06:28 AM
Replies: 137
Views: 152,304
Posted By gemma-the-husky
Re: The Ten Commandments of Access

DC asked the Oracle "how much are these commandments?"

The Oracle said "They are free"

DC said "Then I will take ten"




but note that I have broken this commandment with regularity, and...
Forum: General 05-21-2009, 03:38 AM
Replies: 137
Views: 152,304
Posted By DCrake
The Ten Commandments of Access

Thow normally not in the right section, I felt, that as all newbies visit this section first this is the best place to address the above.

The Ten Commandments of Access

And it came to pass that...
Showing results 1 to 25 of 25

 
Forum Jump



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