Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: plog
Forum: Theory and practice of database design 12-06-2019, 09:10 AM
Replies: 4
Views: 100
Posted By plog
Re: Calculated Fields and Breaking the Rules

You should have only had to write your equations in just one query (let's call this BaseQuery). Then instead of writing the equation in another query you would instead use BaseQuery as the...
Forum: Queries 12-03-2019, 08:48 AM
Replies: 25
Views: 345
Posted By plog
Re: How to Split a field from a database in Access

With the data as you have it you are what we called "screwed". Even with a few shortcuts that I can show you this is going to take a lot of manual work on your part to fix.

So, can you get this...
Forum: Queries 12-02-2019, 02:26 PM
Replies: 12
Views: 205
Posted By plog
Re: SQL Query help

Smells like homework--which is fine. But what have you tried?
Forum: Forms 12-02-2019, 01:41 PM
Replies: 11
Views: 220
Posted By plog
Re: Combo Box works for New Records but not for Record Updates

I made 2 points in your prior thread (https://www.access-programmers.co.uk/forums/showthread.php?t=307809) that you seem to be disregarding. I'm not certain if that was intentional or not, so I will...
Forum: Forms 11-30-2019, 02:33 PM
Replies: 7
Views: 112
Posted By plog
Re: Button to create new form with same field.

This really has 2 components--the data part and the form part. You first need to do some data work, then you can open the form correctly.

Lets call the second table and form tblB and frmB...
Forum: Tables 11-30-2019, 09:41 AM
Replies: 12
Views: 334
Posted By plog
Re: Looking for some advice about structure and importing data

You've over normalized your data. Tables with only 1 real field of data (autonumbers aren't real data) do not need to exist.

Since all those 1 field tables are on the 1 side of the...
Forum: Queries 11-27-2019, 08:45 PM
Replies: 23
Views: 395
Posted By plog
Re: Total group / sum bug?

Can you post a database that demonstrate s this?
Forum: General 11-27-2019, 11:59 AM
Replies: 4
Views: 181
Posted By plog
Re: HELP! How to autogenerate jobnumbers sequence

What is a "job number"? You have no field named that in your tables.

Why won't an autonumber data type work?
Forum: General 11-27-2019, 08:38 AM
Replies: 8
Views: 167
Posted By plog
Re: Customer Order Database

Isn't that true of all data, everywhere, all the time? I don't see how violating normalization will prevent mistakes. And who's to say this new method doesn't get mistakes added to it as well?
...
Forum: Queries 11-27-2019, 08:00 AM
Replies: 5
Views: 99
Posted By plog
Re: Dates are throwing off my query

Please provide the SQL and some sample data that the query returned demonstrating the issue.
Forum: SQL Server 11-27-2019, 07:41 AM
Replies: 12
Views: 211
Posted By plog
Re: Unique Record Identifier

Actually, you are not hosed if you need to add/edit/delete this data. You just link to the individual tables that comprise this View and add/edit/delete them.
Forum: SQL Server 11-27-2019, 07:36 AM
Replies: 12
Views: 211
Posted By plog
Re: Unique Record Identifier

Access doesn't know it's a View. Access just sees an external data set and couldn't automatically detect a primary key.

If you only need to read this data, carry on everything will work. If you...
Forum: General 11-24-2019, 08:13 AM
Replies: 8
Views: 202
Posted By plog
Re: Implementing of tables and relationships

Here's what I see:

Attributes
attr_ID, attr_Type, attr_Value
1, Category, Truck
2, Category, SUV
5, Color, Black
6, Color, White

Questions
Forum: Queries 11-23-2019, 11:04 AM
Replies: 11
Views: 199
Posted By plog
Re: Display grouped results with and without a WHERE clause

Here's how you can help us, help you: Provide us 2 sets of data--starting data from your tables and expected results from you query.

2 sets of data:

A. Starting data from your tables. ...
Forum: Forms 11-20-2019, 05:33 PM
Replies: 19
Views: 11,718
Posted By plog
Re: Converting Decimals to Fractions

I was going to wait until 2037 to reply, but here you go:

Pounds = 2.20462 * Kilograms

Stones = 0.157473 * Kilograms
Forum: Queries 11-19-2019, 11:15 AM
Replies: 6
Views: 129
Posted By plog
Re: IIf Error Expression in Query

Mostly incorrect. Records where Charges=Contractuals will return #Num!

Use that in conjunction with Gasman's advice
Forum: General 11-18-2019, 06:43 PM
Replies: 23
[SOLVED] Single form
Views: 325
Posted By plog
Re: Single form

When you post about forms its assumed that it will interact (edit/add/delete) data. Especially since you used input looking areas for the data coming from tables. So, the length of this thread is...
Forum: Tables 11-18-2019, 10:24 AM
Replies: 34
Views: 600
Posted By plog
Re: Table Design & Relationships

First and foremost, I wouldn't concern yourself with forms at this point. They are the last portion of Access development. After you set your tables, you should move on to Reports and the queries...
Forum: Tables 11-18-2019, 08:46 AM
Replies: 28
Views: 428
Posted By plog
Re: Help with Spare Parts Database - I'm New!

You build a query with every table you need data from, as well as any that are between them in your relationship. JOIN them via the way you have in your relationships and bring down all fields you...
Forum: Tables 11-18-2019, 08:32 AM
Replies: 28
Views: 428
Posted By plog
Re: Help with Spare Parts Database - I'm New!

I think your relationships look good. I too will caution you against non-alphanumeric characters in names. Only use letters, numbers and underscores; otherwise it just makes coding and querying...
Forum: General 11-18-2019, 08:19 AM
Replies: 23
[SOLVED] Single form
Views: 325
Posted By plog
Re: Single form

I think the relationship you posted initially is correct (does not include 1-1 relationships). I also think you can get very close to the form you posted, but not exactly: (A) I don't think data...
Forum: Queries 11-17-2019, 01:12 PM
Replies: 18
Views: 340
Posted By plog
Re: Undefined function 'Nz' in expression

theDbguy got it right in post #3

Query1 runs fine for me

Form1 shows error in Num input when I open it initially

Form1 shows 0 in Num field when when I change the Name of the input box to...
Forum: Theory and practice of database design 11-16-2019, 10:48 AM
Replies: 31
Views: 2,486
Posted By plog
Re: Normalizing (and fixing) a large, messy DB

Both relationships look good. This is really on you to decide which is correct because you know your data better than us. It comes down to what permits relate to. Do they relate to a climb...
Forum: General 11-16-2019, 06:13 AM
Replies: 3
Views: 136
Posted By plog
Re: Qt connection for andriod

Yeah, I would go elsewhere for real advice, but here's my near-ignorant advice:


mydb=QSqlDatabase::addDatabase("QSQLITE");
//mydb.setDatabaseName("C:/Users/Kas/Documents/KFinance/KFinance.db");...
Forum: Tables 11-15-2019, 12:13 PM
Replies: 34
Views: 600
Posted By plog
Re: Table Design & Relationships

Also,



Your so close to the data, you've lost sight of what actually is data. PRS11 represents a product line, therfore it is data. Data goes in as values in fields, not in field names. It...
Showing results 1 to 25 of 500

 
Forum Jump



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