Easy Way To Show Path

Oct 2, 2006

Long story short, I need to have a command button (using xp) open up a folder where pdf's are stored, so the user can search. (orginally I wanted a pdf to open, then I tried having explorer open, so this is my last idea

I've tried a lot of the code in the archieves but none work exactly.

For example:

Private Sub cmdExplore_Click()
Dim stAppName As String

'stAppName = "C:Windowsexplorer.exe"
'above open in a tree view with my Documents; no explorer anywhere to be found

Call Shell(stAppName, 1)

Exit_cmdExplore_Click:
Exit Sub

Err_cmdExplore_Click:
MsgBox Err.Description
Resume Exit_cmdExplore_Click

any ideas?

View Replies

Should Be Easy For Someone - Show Only Last Customer Order, By Date?

Feb 22, 2006

Hi all, i have a query which will be used for reports, and only the last order placed by a customer is needed to be shown. Here's the table used in the query:-

tblCustomerPurchases
CustomerNumber
PurchaseNumber - PK,Autonumber
DateOfPurchase
SeasonID
TotalCost

So obviously for one customer there can be several orders, but i just want to show the latest one by the date field. I have tried grouping by the date field on both Last and Max, but with all the other fields from the table in the query (i need to have all the fields from the table for the report by the way) it still shows all the orders for a customer.

If i only include the customernumber field and dateofpurchase field and then group by date i have 4923 records, which is the correct amount, only one order per customer (the latest one) but adding any other fields to the query gives me the full 7000 odd orders (several per customer).

Any help would be much appreciated, many thanks in advance.

View 9 Replies View Related

General :: Hyperlink Location - Hide Entire Path In Backend And Show Only Name Of File

Sep 26, 2013

I have a field named Location of type Hyperlink. I have copied the respective filepaths in those location column.The location filed looks like

M:New1234.pdf
M:New1111.pdf
M:New2222pdf
M:New4444pdf

If the user clicks on this link then the respective file should be open..I don't want the front end users to see the entire path. So, I would like to have the names as 1234.pdf in the location column instead of M:New1234.pdf. Is it possible to hide the entire path in the backend and show only the name of the file. so that if users click on 1234.pdf then the file needs to open.

View 3 Replies View Related

Save Reports To Defined Path In Path Field

May 26, 2014

Till now I managed to publish and save all in C:Reports. What I'm trying to do is Save to path specified in Path. DB attached.

Private Sub PrintAll_Click()
Dim db As DAO.Database
Dim rs As DAO.Recordset
Dim MyPath As String
Dim MyFileName As String

[Code] ....

View 6 Replies View Related

Get "folder Path" From "file Path"

Jul 29, 2005

After some help from one of the threads here I managed to install a Browse button in a form that inserts a file path to a text box. What I need is the folder path from that file path in another text box. For example if the file path is
C:Documents and SettingsmixupSketchesowl.jpg

I would like to get either
C:Documents and SettingsmixupSketches
Or,
C:Documents and SettingsmixupSketches
in my second text box.

I do not have much experience with Access; therefore please give a little detail on how to accomplish this.

Thanks.

View 9 Replies View Related

Should Be Easy

Jun 1, 2005

I want to have code that disables fields based on the value of the contents of one of the fields. I wrote this code which goes on and on but it doesn't work. Can someone help?

Private Sub Form_Open(Cancel As Integer)

Dim Item_Number As String

If Me.Item_Number = "300123C" Then
Me.Batch_Lot_Number.Enabled = False
Me.Issue_Date.Enabled = False
Me.Production_to_BPT.Enabled = True

Elseif blah blah blah

else blah

Endif

End sub

View 3 Replies View Related

I Know This Must Be Easy!

Mar 22, 2005

I don't normally work in access so I am sure I am asking a really easy question.

I have a table that is connected to a form where users enter survey data. Currently they have a drop down form to mark the responses to the survey as "Fully Completed", "Partly Completed", etc.

On the table I want to add the text "Awaiting Completion" to all those without any entry so that we can find out how many are left to do.

I can filter the table to give me the correct records, and assumed I could paste the text directly into the column (as with Excel).

Can anyone please let me know how to update the column easily.

Thanks for your advice.

Chris

View 2 Replies View Related

Should Be An Easy One...I Think!

Mar 30, 2006

Warning - Complete newbie post!

Hi all,

I have 2 Access databases setup, each containing 1 table. Let's call them A and B. These two tables contain some of the same fields.

Table A is used for collecting new client registration info through our website and gets updated by SQL.

Table B is on a different server and is used for company newsletter mailings.

Table A is the one which is automatically being updated so I don't need to do anything with that table. Also, some fields in Table A are auto-incrementing numbers so we can differentiate a clients interest and provide a more informative newsletter for them specifically on their selected interest.

Whenever an entry in certain fields of Table A is made, I would like the same fields of Table B to be updated with that same information automatically. For example...

Client subscribes to our newsletter on our site and selects their interests, the email field now contains the subscribers email address and the various 'interest' fields contain a '1' telling us they are interested in that particular area of our business. As this takes place on Table A, it needs to be also replicated to Table B.

Surely this is possible, but how?

View 1 Replies View Related

This Is Probably Easy To Do

Apr 18, 2006

As I am an SQL novice I need some help

I have 3 tables

Table - Fields
SalesLedger - TransactionID, ProductID
Vouchers - TransactionID, Voucher_Ref
Products - ProductID, Product_Description

The Salesledger has fields TransactionID and ProductID

The Salesledger is linked to the Products table by the ProductID field

The SalesLedger is linked to the Voucher Table by the TransactionID field

How do I produce a query to list all the items in the Salesledger but if there is a Product in the Products Table matching the ProductID the Product details, and if there is a TransactronID in the Voucher Table list the VoucherRef.

At the moment, it only shows transactions if there is a corrosponding TransactionID in the Vouchers Table

Probably not explaned this at all well. I will try to elborate if required.

View 1 Replies View Related

Easy If You Know How

Jun 24, 2005

Hi all,

I am making a query which sorts birthdays into chronological order.

I have used the DatePart function to determine the month:

DatePart("m",[DATE OF BIRTH])

But I want to know how to display the month in CAPITAL LETTERS, i.e. instead of reading 1 it reads JANUARY

Thanks in advance

View 7 Replies View Related

Probably Easy To Do But.....

Feb 16, 2006

I have a list in Xcel of approximately 1100 client #'s that I have to match to our master list of 10000's.

I can create a query to pull these Clients, but I'd like it to only pull the 1100 requested. Is there a way to import an excel file to bump up against a query so that it only pulls the requested clients?

IE do I have to create a table and bring that data in then use them both in the query?

Sorry if this is a simple question, I'm just being thrown into the fire and have very little access background.

View 1 Replies View Related

Easy One...

Mar 2, 2006

To start: Running Office 20003. I have created a survey with Frontpages wizard. Basically It has a topic and the end user rates that topic on a scale of one to five like so:

1. Work Environment
a. I enjoy my work place. 12345
b. I think my office has a good reputation. 12345

1-5 are radial buttons. It takes the users input and stores it in an access database as im sure you all are aware. Looks kinda like this:

1a 1b 2a etc.
3 5 1

What i would like to do is this: When the users are done submitting i would like to go back and take results. I.e. we had this many users select option 3 for question 1a and we had _ number of users select option 2 for 1a, etc.
The thing is i was wondering if there was a way to create a query for it. I know i could just put =1 or =2 but that would require running 5 queries on each question.... not fun. Anyway, any help would be appreciated.

Thanks,

Viko

View 1 Replies View Related

An Easy One I Think ?

Mar 22, 2006

Hi - I think this can be quickly sorted.

I use the following code in my query to merge together my customers details to 1 field:

LeadName: [Title] & Space(1) & [FirstName] & Space(1) & [LastName]

I want to do it for their address, what do i use instead if SPACE so that i get a NEW LINE each time rather than1 space to the right?

Thankyou

View 1 Replies View Related

This Is Probably Easy To Do

Apr 18, 2006

View 3 Replies View Related

Probably Easy But I Don't Know

Dec 1, 2006

Hi all. I need to know if there is a way to show the last entry for a record. In my database there is a set of numbers i.e. 3000, 3001, 3002 etc which have multiple valuation figures with them i.e. 3000 could have valuation 1 �1000, valutaion 2 �1245. So as mention what i need is my query to show the last valuation entry for the selected reference number i.e. 3000 and valuation2 only.

Any ideas?

View 4 Replies View Related

This Should Be Easy???

Dec 28, 2007

Hello,

I dont know if my brain is not working today....but I have a query that is prompting for user input....if the user clicks cancel it shows "Action Failed" "Halt". How can I get this to just close when cancel is clicked?

Thanks

View 2 Replies View Related

Might Be Easy

Feb 21, 2008

Hello,

I working with different business groups who have vendors assigned to them. I have table of vendor names for each business group. I'm getting data from different sources with vendor names that are unlike table. example: ABC company, ABC. Even through these are different they are they same vendor. Is there a formula, criteria, etc. to pick these up? I will be updating the vendor table occastionally.

Thank you

View 4 Replies View Related

This Should Be Easy

Feb 18, 2005

i need to show a group of donators details in a report. i want to have one donator per report page, but at the moment its sticking three to a page.

any ideas???

View 1 Replies View Related

An Easy One For You

Jun 23, 2006

HI

I do not know what I have done but I am banging my head against the wall, I have three tables in this recruitment db im making and I have a problem that I know is so simple but is killing me off.

In one of the forms (add new vacancy) it has a drop down box that selects the name of the company from table called (company main) within the company main I have two columns (company) & (company no).

now back in the add new vacancy form I have a box that should collect the informtion of the company no whenever I select the company from the drop down list, but you guessed it, its not finding the information please help before i go mad.

View 2 Replies View Related

Easy One!

Dec 3, 2004

I think I have an easy one. When entering records in my table I would like the date to be automaticaly entered. If I use the Date() function the date changes with the system date, I would like it to remain as the orgingal date. How do I do that?

Thanks,

Greg

View 2 Replies View Related

Easy One For Somebody!

Aug 19, 2004

Hi all,

Quick Question:

I need to generate a query that pulls all the employees that ordered paper trays for their
workstation. The quantity of paper trays they ordered is the data for the field "paper trays". Some
people did not order any. How do I tell the query to pull all the employees that ordered and not to list
the employees who have no data in the field?

I need to print this report like now!!!

Thanks for your help!!!
Liz

View 2 Replies View Related

Probably Easy Question

May 24, 2005

Hey, I need to print a report on 11x17 paper. I cant seem to find in the page setup where I could change it to this. Is there a manual way to change it to 11x17. I've checked all the network printers around here under the page setup and none give me the option for 11x17, but I know you can print this size on our printers. Thanks.

View 4 Replies View Related

Easy Parameter Qry

Jun 15, 2005

Set Start & End Dates

I have a list box that lists the 52 week numbers of the year

week 1 being 26-03-2005 to 01-04-2005
week 2 being 02-04-2005 to 08-04-2005....etc.

My aim
By choosing a week no all the records within that date will be returned

I am trying to do away with having to type the start and end date each time a search is carried out

I need to be able to click on the week no and from that the results are shown. perhaps in another list box or something

Any thoughts on how to make this sort of thing work?

thanks

View 9 Replies View Related

Easy Question...I Think??????

Aug 19, 2005

I have completely forgotten how to create a form that will olny allow the user to add a new record into a table...and will not let them view or change any of the existing records.

Kind of like a sign up form. Where they enter their info, hit enter and it stores in an existing table as a new record.

I'm sure this is elementary, but I'm a dummy :confused:

Thanks for your help!!!

Dan

View 6 Replies View Related

This Has To Be An Easy Question

Apr 16, 2006

i have a access application that does a simple filter

here is my code..

dim filter as a sting

filter = "CenterName = '" & NameSel.Value & "'"

DoCmd.OpenForm FormName
DoCmd.ApplyFilter , filter
DoCmd.close acForm, FormName2

This function works fine UNTIL
NameSel.Value = "Adult's"

And the reason is b/c there is a single quote in the value...what is the best way to solve this? Any help would be great. thanks.

View 3 Replies View Related

Quick And Easy One

Jun 20, 2006

HI

I am creating this bloody db and I have created a form and when I open it, it shows, record no one, what I want it to do is open blank ready for a new bit of info to be put in. I know this is an easy one but im sick of the sight of access this week

With thanks

View 5 Replies View Related