A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Search Forums
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Showing results 1 to 25 of 100
Search took 1.05 seconds.
Search: Posts made by: PieterLinden via AccessMonster.com
Forum: Running & Setting Up Queries June 6th, 2010, 04:51 PM Posted to microsoft.public.access.queries
Replies: 8
Views: 2,509
Multiple tables search

naveen prasad wrote:
Hi all,
Kindly solve my problem.

I have a mdb file.
tables created t1,t2,t3,t4.

fields are almost same in all tables, but the data is different in all...
Forum: Using Forms June 6th, 2010, 03:21 AM Posted to microsoft.public.access.forms
Replies: 6
Views: 2,217
SubForm, or something Else?

JMay wrote:
I have Chosen (big Grin) to utilize the new Multivalued fields option offered
in Access 2007. But, as always, I get started very excited, but am unable to
finish...

Let me put it...
Forum: Running & Setting Up Queries June 5th, 2010, 01:43 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 401
Querying for most recent value

dhinton wrote:
I am rather much of a novice when it comes to developing Access databases,
but have found myself in a situation at work where I have had to develop two
recently. I have a...
Forum: Running & Setting Up Queries June 4th, 2010, 04:58 AM Posted to microsoft.public.access.queries
Replies: 1
Views: 393
Total by certain time period

First off, you have to use DateDiff() to determine the number of time units
between the two dates.

e.g.
DateDiff("q", FirstDate, SecondDate) will return the number of quarters
between FirstDate and...
Forum: Using Forms June 3rd, 2010, 04:39 AM Posted to microsoft.public.access.forms
Replies: 5
Views: 725
Combo Box Adding Button to edit list items

JB10 wrote:
I have a form which is designed to enter information about jobs we have
completed. It has 3 combo boxes for different types of contacts that are
pulled from different tables. I want...
Forum: Using Forms June 3rd, 2010, 04:10 AM Posted to microsoft.public.access.forms
Replies: 2
Views: 409
Holiday Time Logging

disneygoof wrote:
Greetings All...Happy June!

I am looking at ways to log Holiday time into my Time Tracker Program and I
am looking for Ideas???

For example, recently (Monday) was Memorial...
Forum: Using Forms May 30th, 2010, 08:48 AM Posted to microsoft.public.access.forms
Replies: 4
Views: 409
Employee Barcode scan IN and OUT using Access 2007

jfire wrote:
Within Access, you can have as many forms as is practical open, subject of
course to your available memory. In order to see what is happening on
[quoted text clipped - 5...
Forum: Running & Setting Up Queries May 29th, 2010, 05:34 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 471
Please help with access expression

joe_G wrote:
Hello,

I was hoping someone could assist with the following expression in
access that combines the Left function and Len function:

I have column called ID, which has about...
Forum: Setting Up & Running Reports May 29th, 2010, 05:19 PM Posted to microsoft.public.access.reports
Replies: 2
Views: 2,023
report in access (Count)

M.K wrote:
If i have data in CSV file and it show like belwo

Column1 Column2
ABCD Saturday
ABCD Saturday
EFGH Sunday
ABCD ...
Forum: General Discussion May 29th, 2010, 02:50 AM Posted to microsoft.public.access
Replies: 6
Views: 440
getting data from a text file

Dorian wrote:
Your file is in the wrong format for automatically importing to Access.
You need to get your file into a format like a spreadsheet where you have
the field names going across and...
Forum: Database Design May 29th, 2010, 02:13 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 489
Changing values

Jeffrey Marks wrote:
I have a many-to-many relationship between Outings (with a primary key
of EventID) and Members (with a primary key of MemberID). There is a
table that ties the 2 together,...
Forum: Running & Setting Up Queries May 29th, 2010, 02:07 AM Posted to microsoft.public.access.queries
Replies: 5
Views: 528
Random Function for Selecting Records

esn wrote:
Also, I just noticed Access redraws the random number every time I
click in one of the records of the query results, and seems to
struggle with recalculating (often tries to display the...
Forum: General Discussion May 29th, 2010, 01:24 AM Posted to microsoft.public.access
Replies: 7
Views: 272
A Great Big Thank You!

Albert D. Kallal wrote:
Thank you so very kindly, it really is appreciated.

In a a few days the lights go out here. This place has been great little
kind of coffee shop in cyber space. I...
Forum: Using Forms May 28th, 2010, 11:17 PM Posted to microsoft.public.access.forms
Replies: 1
Views: 306
Associate a form button to a query

Anita wrote:
I have an existing form associated to a table. In the form I would like to
associate a button to a query instead of the whole table. Can this be done?
Thanks, Anita

You want the...
Forum: Running & Setting Up Queries May 28th, 2010, 10:47 PM Posted to microsoft.public.access.queries
Replies: 0
Views: 349
query data from a parent-child table

grupy wrote:
Id like to know how I can query lets say a specific record from a parent-chil
table

For example, lets say parent table is Products using ProductID as the primar
key and its...
Forum: Running & Setting Up Queries May 28th, 2010, 10:39 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 337
Dropdown choice eliminated from selections

Erinayn wrote:
I have a simple scenario...

We have a list of 20 items and I'd like people to identify the top 10 to
them. I created a dropdown but was wondering if I can make it so that when...
Forum: Running & Setting Up Queries May 28th, 2010, 10:37 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 337
Dropdown choice eliminated from selections

Erinayn wrote:
I have a simple scenario...

We have a list of 20 items and I'd like people to identify the top 10 to
them. I created a dropdown but was wondering if I can make it so that when...
Forum: General Discussion May 28th, 2010, 03:42 PM Posted to microsoft.public.access
Replies: 6
Views: 415
Desingner question

Amin wrote:
John just want to find out if u recommending that i buy the v1&2 of the
access 2002 handbook.

Hi may i know which course i will need to study to become a professional
...
Forum: Database Design May 28th, 2010, 12:06 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 410
Employee Training Help

Lkay107 wrote:
Hey Y'all,

I am creating an employee training database where I can run reports and
queries about who has taken what type of course.

What kind of relationship should be created...
Forum: Running & Setting Up Queries May 27th, 2010, 11:22 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 401
two level make table query and sorting???

tcek wrote:
I am creating a table with a "make table" query. I want to query by customer
number than by date of order. I want the customer number to be ascending
while the date of order to be...
Forum: Running & Setting Up Queries May 27th, 2010, 05:08 AM Posted to microsoft.public.access.queries
Replies: 4
Views: 956
Criteria to return all records if selection from form is null

Sue Pari wrote:
Hi,

I'm trying to pass multiple query criteria from form controls. I'm using
the following type of syntax for the criteria:

Like Nz([Forms]![ViewEdit Completed...
Forum: General Discussion May 27th, 2010, 01:15 AM Posted to microsoft.public.access
Replies: 4
Views: 459
Access 2007/Word 2007 Mail Merge Opens Second Instance

btibbet wrote:
I have an Access 2007 database where I can launch a Word 2007 merge
document whose data source is a query that looks back to a control on
the form for a parameter.

I am forced to...
Forum: General Discussion May 27th, 2010, 01:06 AM Posted to microsoft.public.access
Replies: 16
Views: 657
Remote Database and Office Database

Thomas Kroljic wrote:
Is this the right forum to post this message?

Hello,

[quoted text clipped - 37 lines]
Thank you,
Timothy

David Fenton must be busy... dig around for his...
Forum: General Discussion May 27th, 2010, 12:52 AM Posted to microsoft.public.access
Replies: 3
Views: 399
Update prices in access from Excell

David C. Holley wrote:
Yes, if the values in the spreadsheet can be matched to products in the
database for example by using a Product Number. Its a simple matter to loop
through the rows in the...
Forum: Using Forms May 27th, 2010, 12:10 AM Posted to microsoft.public.access.forms
Replies: 8
Views: 540
employee ID into text box, need to show all ID's that have ck in on same form

jfire wrote:
I have a problem, I enter employee ID into text box, I need to show all ID's
that have ck in on same form. I have table with employee ID info. I need
to show all employee's on the...
Showing results 1 to 25 of 100

 
Forum Jump

All times are GMT +1. The time now is 08:12 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.