Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.52 seconds.
Search: Posts Made By: plog
Forum: General Yesterday, 09:29 AM
Replies: 1
Views: 94
Posted By plog
Re: Consolidating data based on headers

You lost me here:



So there could be 2 'FirstName' fields in the same file? Perhaps you can demonstrate this with data.

One of my gigs is consolidating mailing lists from 60 sources every...
Forum: Modules & VBA Yesterday, 04:38 AM
Replies: 4
Views: 72
Posted By plog
Re: Using DateAdd with DLookup

Find out. Isolate and test.

Does the DateAdd expression work? Does it return a date? Isolate and test.
Forum: Queries 05-21-2018, 09:11 AM
Replies: 9
Views: 138
Posted By plog
Re: Help normalize my Union Query

Now I am looking at your query closer and it makes no sense. What are you trying to do?

That' query is going to produce essentially static data, with 5 rows. Why not just make a table and call...
Forum: Queries 05-21-2018, 09:05 AM
Replies: 9
Views: 138
Posted By plog
Re: Help normalize my Union Query

A UNION query should simply UNION data together. No more. The SQL in it should be uber-simple:


SELECT Field1, Field2 FROM Source1
UNION ALL
SELECT Field1, Field2 FROM Source2
UNION ALL...
Forum: Queries 05-21-2018, 04:41 AM
Replies: 12
Views: 251
Posted By plog
Re: duplication of records with query with multitables

In Access go to the ribbon, click on 'DATABASE TOOLS', then Relationships, add all your tables and then connect them appropriately.
Forum: Modules & VBA 05-18-2018, 07:57 AM
Replies: 9
Views: 121
Posted By plog
Re: html - colspan not working

I don't really understand--are you trying to view HTML within Access? How?

HTML is just a string of text that let's whatever is displaying it, how to display it. So, if its not being displayed...
Forum: General 05-18-2018, 07:47 AM
Replies: 3
Views: 680
Posted By plog
Re: Total/Subtotal Calculation from Subform

DSUMS must look into a table/query, not a form. Read the documentation

DSUM("[FieldNameHere]", "TableQueryNameHere", "Criteria=Here")
Forum: Modules & VBA 05-18-2018, 07:40 AM
Replies: 9
Views: 121
Posted By plog
Re: html - colspan not working

It all looks good to me--I thought you might have snuck in an extra or missed a <td> in another row or forgot a closing tag, but its all correct.

My only recommendation is to not use...
Forum: General 05-18-2018, 07:22 AM
Replies: 3
Views: 680
Posted By plog
Re: Total/Subtotal Calculation from Subform

I would do a DSUM:

https://www.techonthenet.com/access/functions/domain/dsum.php
Forum: Modules & VBA 05-18-2018, 07:06 AM
Replies: 9
Views: 121
Posted By plog
Re: html - colspan not working

Really need to see the rest of the table html to see if its colspan. Can you post the rest of the html down to the closing table tag?

From what I see you have an unopened italics tag and the font...
Forum: Queries 05-18-2018, 04:44 AM
Replies: 12
Views: 251
Posted By plog
Re: duplication of records with query with multitables

Probably not. First, can you give me an explanation of the real world system this models? No database jargon, explain to a 6th grader what it is your organization does. Then, 1 more paragraph...
Forum: General 05-17-2018, 09:02 AM
Replies: 29
Views: 1,503
Posted By plog
Re: Bang and dot?

Question mark. Never heard question point.
Forum: General 05-17-2018, 08:48 AM
Replies: 40
Views: 1,452
Posted By plog
Re: Auto increment of numbers with alphabets

A page back it was dictated from the mountain. 16,347 by any other name, even if it includes weird characters and is suffixed with a letter representing a year is still the same: An identifier.
...
Forum: Queries 05-17-2018, 08:00 AM
Replies: 12
Views: 251
Posted By plog
Re: duplication of records with query with multitables

I on the otherhand have no regard for my work computer so I downloaded your database (the story would be different if I was at home). I don't think your tables are set up correctly. You have so...
Forum: Forms 05-16-2018, 01:48 PM
Replies: 15
Views: 295
Posted By plog
Re: Combobox filter by month

Please post sample data to demonstrate what you are trying to accomplish.
Forum: Forms 05-16-2018, 11:44 AM
Replies: 15
Views: 295
Posted By plog
Re: Combobox filter by month

Your initial post wanted to filter without regard for year:


Could you help me to figure out how can I filter by month not only for the current year but for past years as well?

I'm lost as to...
Forum: Forms 05-16-2018, 07:32 AM
Replies: 15
Views: 295
Posted By plog
Re: Combobox filter by month

You are missing a double quote at the end of this line:

Me.subfrm_Invoice_Tracking.Form.Filter = "Month(InvoiceDate)='" & Me.cboMonth & "'

However, you shouldn't need to escape taht at all. ...
Forum: Forms 05-16-2018, 05:41 AM
Replies: 15
Views: 295
Posted By plog
Re: Combobox filter by month

No where in that code do you use the Month() function.
Forum: Forms 05-16-2018, 04:49 AM
Replies: 15
Views: 295
Posted By plog
Re: Combobox filter by month

Can you post your code for the filter using the Month() function?
Forum: General 05-16-2018, 04:47 AM
Replies: 40
Views: 1,452
Posted By plog
Re: Auto increment of numbers with alphabets

What happens in 2018 after record A002AA999A? Why must these numbers reset every year? And you didn't answer Ranman--what letter is going to be used in 2034? Or 2035 if I am off by one?

A lot of...
Forum: Tables 05-16-2018, 04:40 AM
Replies: 12
Views: 218
Posted By plog
Re: Build account tables for different companies

You kinda lost me with all your words, but from what I gather you are trying to set up a table to track a balance. The way this is done is with a simple table, a simple query and then the running...
Forum: Forms 05-16-2018, 04:31 AM
Replies: 15
Views: 295
Posted By plog
Re: Combobox filter by month

What value does cboMonth hold? Is it a name or a number?
Forum: Forms 05-15-2018, 12:09 PM
Replies: 15
Views: 295
Posted By plog
Re: Combobox filter by month

Use the Month function (https://www.techonthenet.com/access/functions/date/month.php).

Month([InvoiceDate])=Me.cboMonth
Forum: Modules & VBA 05-15-2018, 11:17 AM
Replies: 6
Views: 135
Posted By plog
Re: Help with repeat rows based on number field

Can you set up your relationships tools and post a screenshot of it back here? Try and show all fields in all tables.
Forum: Modules & VBA 05-15-2018, 10:41 AM
Replies: 6
Views: 135
Posted By plog
Re: Help with repeat rows based on number field

Inventory tracking is a solved problem. I would search this site or even google for database that do that. You're reinventing the wheel and throwing in some right angles. Essentially you create a...
Showing results 1 to 25 of 500

 
Forum Jump



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


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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