Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 402
Search took 0.02 seconds.
Search: Posts Made By: Infinite
Forum: Queries 04-28-2017, 07:28 AM
Replies: 12
Views: 468
Posted By Infinite
Re: Top of multiple columns.

Look at the attached image. I'm not sure how I can change that to any other format...
And that table is the one I'm using for this query as the rest of my data is kept in separate tables like...
Forum: Queries 04-28-2017, 07:10 AM
Replies: 12
Views: 468
Posted By Infinite
Re: Top of multiple columns.

Ok, I do have more than 3 columns. I have about 17 of them, and I want to get the top 3 and display them in a message saying "You lost money because of Cost1, Cost2, and Cost 3. But mostly Cost1."
...
Forum: Queries 04-27-2017, 07:37 PM
Replies: 12
Views: 468
Posted By Infinite
Re: Top of multiple columns.

I am going to bed now, will try all those in the morning. Thanks for the help! I'll let you know tomorrow if it works! Thanks!
Forum: Queries 04-27-2017, 04:19 PM
Replies: 12
Views: 468
Posted By Infinite
Question Top of multiple columns.

So, I have a table with 3 columns.

Item____Cost1___Cost2___Cost3
One_____$10____$14____$2
Two_____$3_____$17____$15
Five_____$1_____$6_____$7


What I would like to do is get something to...
Forum: Queries 12-21-2016, 08:57 PM
Replies: 6
Views: 873
Posted By Infinite
Re: Overflow error

That was the problem. There was about 15 records that had 0. After changing/deleting them it now works. Was about to smash my computer after the 10,000th time if seeing the Overflow error.
Forum: Queries 12-21-2016, 12:08 PM
Replies: 6
Views: 873
Posted By Infinite
Question Overflow error

Work: IIf([RT ID]="Amazon",IIf([RT Fulfillment Channel]="Amazon",0,[RT Gross Sales]+[RT Shipping Cost Received]/[RT Quantity]*0.15*[RT Quantity]),0)


I am trying to get that to work, but I am...
Forum: Queries 04-22-2016, 01:03 PM
Replies: 2
Views: 301
Posted By Infinite
Re: Combine 3 tables into 1 total

for "good" reasons :) I didn't say good because I know it's not the correct thing to do. Thus, it's not good, but, it is "reasons" for doing it.

I have decided to split a certain part of my sales...
Forum: Queries 04-22-2016, 12:47 PM
Replies: 2
Views: 301
Posted By Infinite
Exclamation Combine 3 tables into 1 total

Hello! I have 3 tables, and each table (for reasons) has individual sales, quantity, etc, etc. Now, how would I combine each of those into 1 total? Each of those has a different ID, and I have a...
Forum: Forms 01-28-2016, 10:44 AM
Replies: 2
Views: 409
Posted By Infinite
Question Set list boxes Multi select

As the title says, I would like to know how to change list boxes multi-select to either A: Simple or B: Extended. Also, through VBA. I have tried:

Forms("Order...
Forum: Queries 01-22-2016, 07:45 PM
Replies: 4
Views: 284
Posted By Infinite
Re: How to turn of Query auto calculation

Well, the 8 days was a overstatement, I meant that as a example, that way people dont...Well, im not sure, it was just a large number. But the only known way is to just create a table and import it?...
Forum: Queries 01-22-2016, 03:43 PM
Replies: 4
Views: 284
Posted By Infinite
How to turn of Query auto calculation

In this post, I would like to know HOW to stop a query for running.

http://www.access-programmers.co.uk/forums/showthread.php?t=283902

In that post, I apparently mistyped my first question, so...
Forum: Queries 01-22-2016, 11:46 AM
Replies: 6
Views: 452
Posted By Infinite
Re: How to turn of Query auto calculation

Thing is, that is the easy part. What I want, is the have to data already, and if I want the most recent data, then run the query. So lets say I have a frmQuery, and it is based off of qryQuery. But...
Forum: Queries 01-22-2016, 09:20 AM
Replies: 6
Views: 452
Posted By Infinite
Forum: Queries 01-16-2016, 04:41 PM
Replies: 6
Views: 452
Posted By Infinite
Re: How to turn of Query auto calculation

Well yes, I could just turn it into a append query, and append it to a (for instance) tblQuery1 instead of qryQuery1. But that quickly gets cluttered.
Forum: Queries 01-16-2016, 01:09 PM
Replies: 6
Views: 452
Posted By Infinite
Question How to turn of Query auto calculation

In excel your able to turn of the calculations from running, unless the user specifies to. Is that possible to do that with access? Thanks!
Forum: Forms 01-15-2016, 12:13 PM
Replies: 8
Views: 579
Posted By Infinite
Re: Save .txt file as .xlsx file

Is there any way you can upload a test database? Im not sure where to put my path and such. It does look like it should work though :)
Forum: Forms 01-15-2016, 09:17 AM
Replies: 8
Views: 579
Posted By Infinite
Re: Save .txt file as .xlsx file

Is that possible with VBA?
Forum: Forms 01-15-2016, 07:22 AM
Replies: 8
Views: 579
Posted By Infinite
Re: Save .txt file as .xlsx file

I want it to be saved using VBA from Access. Sorry about not being clearer when I first posted.
Forum: Forms 01-14-2016, 12:28 PM
Replies: 8
Views: 579
Posted By Infinite
Re: Save .txt file as .xlsx file

Sure! Its in the attached image:
Forum: Forms 01-14-2016, 11:02 AM
Replies: 8
Views: 579
Posted By Infinite
Exclamation Save .txt file as .xlsx file

As the title says, I am trying to save a .txt file as a .xlsx file. I have looked around a lot before asking this, and I cant find anything that is working for me.

The path for the file would look...
Forum: Queries 01-14-2016, 11:00 AM
Replies: 3
Views: 580
Posted By Infinite
Re: Import .xlsx files.

Any one found anything? I have been looking some more, but to no avail.
Forum: Queries 01-11-2016, 07:40 AM
Replies: 3
Views: 580
Posted By Infinite
Re: Import .xlsx files.

Yes, but I was hoping to do it WITH code. Is there any way for that?



Private Sub Command53_Click()
Dim LResponse As Integer
Dim FilePath As String


FilePath =...
Forum: Forms 01-10-2016, 12:05 PM
Replies: 13
Views: 526
Posted By Infinite
Re: Import anything with start name

Never mind. I got it:

Dim LResponse As Integer
Dim FilePath As String


FilePath = Dir("C:\Users\Joshua\Downloads\!Import Sales From Online\*.csv")


LResponse = MsgBox("Are you sure you...
Forum: Forms 01-10-2016, 09:26 AM
Replies: 13
Views: 526
Posted By Infinite
Re: Import anything with start name

Dim csvFile As String
csvFile = Dir("C:\Users\Joshua\Downloads\!Import Sales From Online\*.csv")


Dim KillFile As String
KillFile = "csvFile"
'Check that file exists
If Len(Dir$(KillFile)) >...
Forum: Forms 01-10-2016, 09:11 AM
Replies: 13
Views: 526
Posted By Infinite
Re: Import anything with start name

Quick question. How do I set a file path as a string? Im trying to get:

csvFile = Dir("C:\Users\Joshua\Downloads\!Import Sales From Online\*.csv")
csvFile As String
Me.Text51 = csvFile


But...
Showing results 1 to 25 of 402

 
Forum Jump



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