Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.25 seconds.
Search: Posts Made By: plog
Forum: Queries Today, 08:17 AM
Replies: 4
Views: 54
Posted By plog
Re: Query with multiple criteria in 2 separate tables

Here's how you construct strings:

var1="This is a literal inside a variable"
var2="this will be inside single quotes"

varSentence=var1 & " and this is an inline literal and '" & var2 & "'."...
Forum: Queries Today, 08:08 AM
Replies: 4
Views: 54
Posted By plog
Re: Query with multiple criteria in 2 separate tables

There's no reason to use a Dlookup in a query. Instead you bring in the datasources you need, link them appropriately and apply criteria. So ditch the Dlookup, bring tblInfo_StaffDates into the...
Forum: Tables Today, 07:01 AM
Replies: 1
Views: 37
Posted By plog
Re: How to automatically update/append Database Tables based on XML File being update

You can accomplish what you want with a macro inside Access and windows task scheduler (https://en.wikipedia.org/wiki/Windows_Task_Scheduler). The macro would do all the work and windows task...
Forum: Tables Yesterday, 08:20 AM
Replies: 8
Views: 146
Posted By plog
Re: Autopopulate empty fields with values from another field.

Can you please post sample data to demonstrate your issue? Give us 2 sets of data:

A. Starting data--Show what you begin with. Include table and field names and enough data to cover all cases....
Forum: Queries 12-09-2019, 11:29 AM
Replies: 7
Views: 95
Posted By plog
Re: Rank query returning same rank

That's not how computers work. They apply an algorithm. If that algorithm isn't well defined its not going to be able to make decisions by itself.

You need to better define how items with the...
Forum: Theory and practice of database design 12-06-2019, 09:10 AM
Replies: 5
Views: 139
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: 372
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: 212
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: 232
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: 346
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: 402
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: 168
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: 100
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: 216
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: 216
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: 204
Posted By plog
Re: Implementing of tables and relationships

Here's what I see:

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

Forum: Queries 11-23-2019, 11:04 AM
Replies: 11
Views: 200
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,722
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: 130
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: 618
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: 438
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: 438
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...
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 01:52 PM.

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