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 22 of 22
Search took 0.07 seconds.
Search: Posts made by: xps35
Forum: New Users June 3rd, 2010, 07:14 AM Posted to microsoft.public.access.gettingstarted
Replies: 2
Views: 1,960
Posted By xps35
Selecting the last 10 records from a specific date

=?Utf-8?B?c2VtbWlzb24=?= wrote:


I have a date field and name field, I want to return the last 10 Name records
entered from a specific date..... ie: Count back 10 records in the date field
...
Forum: New Users June 2nd, 2010, 07:46 AM Posted to microsoft.public.access.gettingstarted
Replies: 3
Views: 2,027
Posted By xps35
Query help

=?Utf-8?B?UmljaGFyZA==?= wrote:


I have a form with (2) textboxes StartDate & EndDate also a command button.
When the command button is pressed a query captures the (2) dates and then
...
Forum: Running & Setting Up Queries May 25th, 2010, 09:07 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 487
Posted By xps35
Parameter queries that allow users to choose items from a list

=?Utf-8?B?dmVuYWpvZQ==?= wrote:


Dear Access 2007 VBA Gurus,

I have a "Worship Song" database. The tables a
tblWorshipSongs
tblAuthorFirstNames
tblAuthorLastNames
...
Forum: Using Forms May 25th, 2010, 08:55 PM Posted to microsoft.public.access.forms
Replies: 3
Views: 406
Posted By xps35
Overflow

anthony wrote:


Why does the last line in this code lead to the error message
"Overflow"? The figure in question is 33764 which is the value of
txtPhotoID before trying to assign it to...
Forum: General Discussion May 24th, 2010, 10:59 AM Posted to microsoft.public.access
Replies: 6
Views: 242
Posted By xps35
Can some tell me where my formula is going wrong please

=?Utf-8?B?QWxhbg==?= wrote:




can some please tell what wrong with my dsum

=DSum("[Amount6a6fs]","[Sales Analysis]","[Posting Date Period] = '" &
[cbMonth] & "' And [Revenue Stream...
Forum: Running & Setting Up Queries May 21st, 2010, 09:11 AM Posted to microsoft.public.access.queries
Replies: 3
Views: 605
Posted By xps35
Crosstab queries, <> and null values

Edwinah63 wrote:


Hi everyone,

I have a crosstab query attached to a graph on a report. It shows
quantity of widgets produced by each employee for a specified period.
The client wants...
Forum: Setting Up & Running Reports May 19th, 2010, 12:29 PM Posted to microsoft.public.access.reports
Replies: 4
Views: 364
Posted By xps35
Creating a printed report containing multiple counts

jim_s via AccessMonster.com wrote:


Hi All,

Been trawling around for a solution to this problem. The problem is pretty
straightforward, yet surprisingly complicated to solve.

I have...
Forum: Database Design May 18th, 2010, 09:20 AM Posted to microsoft.public.access.tablesdbdesign
Replies: 1
Views: 461
Posted By xps35
How to change existing table record value by VBA and How to add new

K wrote:


Hi all, I got table in my database with name "tbldata" and i have two
fields in that table with the name "Ticket_No" and "Amount". In
"Ticket_No" filed column i have value "SD001"...
Forum: Setting Up & Running Reports May 17th, 2010, 09:14 PM Posted to microsoft.public.access.reports
Replies: 3
Views: 362
Posted By xps35
Many to Many Relationship Report

=?Utf-8?B?U3RldmUgRA==?= wrote:


Good Afternoon,
I am hoping this is possible, any help is appreciated:

I have 2 tables:

Table 1
CC# Router#
Forum: Running & Setting Up Queries May 12th, 2010, 09:34 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 172
Posted By xps35
filtering data

=?Utf-8?B?SmFu?= wrote:


I have a database set up for a consignment shop. I'm trying to print a list
of crafters that had sales during a time period that I enter. I'm able to get
the info,...
Forum: Database Design May 12th, 2010, 08:54 PM Posted to microsoft.public.access.tablesdbdesign
Replies: 2
Views: 531
Posted By xps35
Table design question

=?Utf-8?B?TWFyaw==?= wrote:


Hi All,

I just wanted to see if the design of some fields in the table are standard
practice.

The database admin set up a Code_Desc table with fields...
Forum: General Discussion May 12th, 2010, 06:38 AM Posted to microsoft.public.access
Replies: 4
Views: 111
Posted By xps35
Expression

=?Utf-8?B?VGVycnk=?= wrote:


My first table with expressions worked after I messed with the relationship
of the tables I had such a mess that I started over. Now the expressions
aren't...
Forum: Using Forms May 11th, 2010, 09:13 PM Posted to microsoft.public.access.forms
Replies: 5
Views: 779
Posted By xps35
Add consecutive dates w/ command button & parameter boxes

=?Utf-8?B?RmxvcGJvdA==?= wrote:


Hi,

I have an unbound form [Frm Volunteer Opportunities] with a sub form [SubFrm
Vol Opportunities]. The subform has the fields [Event ID] and [Event...
Forum: Running & Setting Up Queries May 11th, 2010, 08:28 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 228
Posted By xps35
Daily Make Table Query

=?Utf-8?B?SkQ=?= wrote:


I have a Make Table Query that I will need to run every morning. Is there
anyway to have the query add today's date to the name of the table (without
going in and...
Forum: New Users May 10th, 2010, 09:55 AM Posted to microsoft.public.access.gettingstarted
Replies: 4
Views: 381
Posted By xps35
Updating Data in Multiple Tables

=?Utf-8?B?Sm9obk0=?= wrote:


Could any one advise me please

I have two tables that contain some fields that are the same.

I have also two forms to enter data into the seperate tables
...
Forum: Running & Setting Up Queries May 8th, 2010, 12:47 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 176
Posted By xps35
two access table in one query

=?Utf-8?B?QWhtZWQgU2FsZWVt?= wrote:


i design a report with access database i prepare a query with two table
without joinning but the query return data more than one time

Please solve my...
Forum: Running & Setting Up Queries May 6th, 2010, 03:41 PM Posted to microsoft.public.access.queries
Replies: 2
Views: 156
Posted By xps35
Query Help: Average of Columns Per Row

Idgarad wrote:


I have a table:

DATE, Region, HOUR0, HOUR1, ... HOUR23
1/1/10,ABC, 123, 231,...,141


I want to write a query that returns not only the records filtered by
Forum: Running & Setting Up Queries May 6th, 2010, 09:58 AM Posted to microsoft.public.access.queries
Replies: 2
Views: 168
Posted By xps35
Create a query for specified text in a field

=?Utf-8?B?SmFjcXVlbGluZSBfTmVv?= wrote:


Hi there,

I have a number of fields in my query. They are Customer, Document, Title.
In this query, i have include a input dialog for the user to...
Forum: Running & Setting Up Queries May 5th, 2010, 12:16 PM Posted to microsoft.public.access.queries
Replies: 5
Views: 222
Posted By xps35
Make Table query, but remove character from field

=?Utf-8?B?QW5keQ==?= wrote:


Thanks for your reply. Could you clarify a little more please as I usually
write things in design view and am not very good with SQL view. Also, what
are T1 and...
Forum: Running & Setting Up Queries January 6th, 2010, 08:55 PM Posted to microsoft.public.access.queries
Replies: 3
Views: 111
Posted By xps35
One prompt for Four Queries

=?Utf-8?B?V2VuZGVsaW4=?= wrote:


I have four queries that are used as subreports in a summary report.

All four queries use the same prompt (for the same field): [Enter Patient
Contact...
Forum: General Discussion December 13th, 2009, 08:11 PM Posted to microsoft.public.access
Replies: 2
Views: 95
Posted By xps35
trim to first "-" character

On 13 dec, 20:58, Keith wrote:
Sorry if this is posted again, but I couldn't find my post.

How do I trim off everything to the left of the first "-"? The...
Forum: General Discussion December 10th, 2009, 04:36 PM Posted to microsoft.public.access
Replies: 11
Views: 139
Posted By xps35
Help Please

On 10 dec, 17:11, O.... wrote:
I have a table with Name, PostDate and amount.
John 1/1/2009 10.00
john 1/2/2009 20.00
john 1/3/2009 50.00

I need to...
Showing results 1 to 22 of 22

 
Forum Jump

All times are GMT +1. The time now is 10:25 PM.


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