Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 83
Search took 0.01 seconds.
Search: Posts Made By: Odeh Naber
Forum: Access June 1st, 2011, 03:49 AM
Replies: 8
Views: 1,286
Posted By Odeh Naber
Ah ok! Now I understand :) I did like you...

Ah ok! Now I understand :)

I did like you asked but the parameters list was empty in both versions of the database that were included in the zip file. Can I use the parameters to give me only the...
Forum: Access May 31st, 2011, 03:28 PM
Replies: 8
Views: 1,286
Posted By Odeh Naber
I am sorry I didnt understand your question. Do...

I am sorry I didnt understand your question. Do you mean if I placed that SQL text in a query? If so, then yes I did.
Forum: Access May 31st, 2011, 12:02 PM
Replies: 8
Views: 1,286
Posted By Odeh Naber
Ok folks! I am really close now! :) The following...

Ok folks! I am really close now! :) The following crosstab query gives me what I need but for all years - how can I make it select only the chosen year??

TRANSFORM...
Forum: Access May 31st, 2011, 11:24 AM
Replies: 8
Views: 1,286
Posted By Odeh Naber
Thank you for your reply! Could you give me a...

Thank you for your reply! Could you give me a heads up on how to start creating the crosstab for the database I am creating? I have the dates listed like this:

31.01.2011
28.02.2011...
Forum: Access May 31st, 2011, 03:54 AM
Replies: 8
Views: 1,286
Posted By Odeh Naber
Current Month and Year-To-Date

Hiya folks!

Heres the problem - would appreciate any help:

I have three tables related in a one-to-many relationship:

TABLE ONE: StatisticPeriod
TABLE TWO: StatisticProperty
TABLE THREE:...
Forum: Access August 25th, 2010, 07:55 AM
Replies: 3
Views: 1,182
Posted By Odeh Naber
I just figured out the solution regarding the...

I just figured out the solution regarding the CrossTab Query!

I created a Public Function GETYEAR:

Public Function GetYear(FormName As String, FieldName As String)
GetYear =...
Forum: Access VBA August 25th, 2010, 07:55 AM
Replies: 3
Views: 1,488
Posted By Odeh Naber
I just figured out the solution regarding the...

I just figured out the solution regarding the CrossTab Query!

I created a Public Function GETYEAR:

Public Function GetYear(FormName As String, FieldName As String)
GetYear =...
Forum: Access VBA August 25th, 2010, 07:54 AM
Replies: 1
Views: 880
Posted By Odeh Naber
I just figured out the solution regarding the...

I just figured out the solution regarding the CrossTab Query!

I created a Public Function GETYEAR:

Public Function GetYear(FormName As String, FieldName As String)
GetYear =...
Forum: Access VBA August 25th, 2010, 06:47 AM
Replies: 1
Views: 880
Posted By Odeh Naber
CrossTab Query Issue - Where Condition

Hiya folks!

I am having a minor issue with the following CROSSTAB QUERY:

TRANSFORM First(BasicStatistics01.Measurement) AS FirstOfMeasurement
SELECT BasicStatistics01.Category
FROM...
Forum: Access VBA August 25th, 2010, 06:46 AM
Replies: 1
Views: 1,451
Posted By Odeh Naber
CrossTab Query Issue - Where Condition

Hiya folks!

I am having a minor issue with the following CROSSTAB QUERY:

TRANSFORM First(BasicStatistics01.Measurement) AS FirstOfMeasurement
SELECT BasicStatistics01.Category
FROM...
Forum: Access VBA August 25th, 2010, 06:35 AM
Replies: 3
Views: 1,488
Posted By Odeh Naber
Regarding the solution, there is one minor issue...

Regarding the solution, there is one minor issue I am trying to overcome with the CROSSTAB QUERY:

TRANSFORM First(BasicStatistics01.Measurement) AS FirstOfMeasurement
SELECT...
Forum: Access August 25th, 2010, 06:34 AM
Replies: 3
Views: 1,182
Posted By Odeh Naber
Regarding the solution, there is one minor issue...

Regarding the solution, there is one minor issue I am trying to overcome with the CROSSTAB QUERY:

TRANSFORM First(BasicStatistics01.Measurement) AS FirstOfMeasurement
SELECT...
Forum: Access August 25th, 2010, 06:27 AM
Replies: 3
Views: 1,182
Posted By Odeh Naber
I managed to create the first report! I...

I managed to create the first report!

I first created a UNION QUERY:

SELECT "NumberDaysMonth" AS Category, StatisticDate AS MeasurementDate, NumberDaysMonth AS Measurement
FROM...
Forum: Access VBA August 25th, 2010, 06:24 AM
Replies: 3
Views: 1,488
Posted By Odeh Naber
I managed to create the first report! I...

I managed to create the first report!

I first created a UNION QUERY:

SELECT "NumberDaysMonth" AS Category, StatisticDate AS MeasurementDate, NumberDaysMonth AS Measurement
FROM...
Forum: Access VBA August 23rd, 2010, 04:43 PM
Replies: 3
Views: 1,488
Posted By Odeh Naber
Problem Creating Monthly Comparison Report

Hiya folks!

I am having difficulty creating some business statistics reports - it seems very simple but I just can't figure it out. Here is what I am trying to do:

I have the following...
Forum: Access August 23rd, 2010, 09:42 AM
Replies: 3
Views: 1,182
Posted By Odeh Naber
Report Monthly Comparison

Hiya folks!

I am having difficulty creating some business statistics reports - it seems very simple but I just can't figure it out. Here is what I am trying to do:

I have the following...
Forum: Access November 26th, 2009, 05:31 AM
Replies: 9
Views: 5,333
Posted By Odeh Naber
Solution

So here is what I did - in this case the duration was not stored :) (I am not a pro at this so please let me know if there is something that wasnt clear and I will do my best to explain!) Cheers!:...
Forum: Access November 25th, 2009, 01:44 PM
Replies: 9
Views: 5,333
Posted By Odeh Naber
Thanks! I was thinking of storing the duration...

Thanks! I was thinking of storing the duration in order to avoid having to program the same procedure for a report as well :) Like this at least the report will be easier to recreate. But I do...
Forum: Access November 12th, 2009, 06:23 AM
Replies: 9
Views: 5,333
Posted By Odeh Naber
I figured it out! Sorry - So I managed to combine...

I figured it out! Sorry - So I managed to combine the date and time fields, and then using DateDiff I was able to calculate the number of minutes between the two dates. I then used MOD to convert...
Forum: Access November 12th, 2009, 05:52 AM
Replies: 9
Views: 5,333
Posted By Odeh Naber
Sorry for not explaining - so the StartTime,...

Sorry for not explaining - so the StartTime, EndTime and TimeDuration are all exactly the same. Basically, the below is an example of what I am trying to achieve:

StartTime: 21:00 (only minutes...
Forum: Access November 11th, 2009, 11:16 AM
Replies: 9
Views: 5,333
Posted By Odeh Naber
Cheers for replying! I tried to setting up...

Cheers for replying!

I tried to setting up an afterupdate code on both the StartTime and EndTime controls on the form. So after the user updates either the StartTime or EndTime, the following...
Forum: Access November 11th, 2009, 06:50 AM
Replies: 9
Views: 5,333
Posted By Odeh Naber
Difference Between Times Past Midnight

Hello!

On an Access form I have three controls:

StartTime
EndTime
TimeDuration

They are all 'Short Time' formatted and are bound to fields in the same table. The user inputs manually...
Forum: Access March 26th, 2009, 05:18 AM
Replies: 13
Views: 6,604
Posted By Odeh Naber
Could it be the way I named the modules

Could it be the way I named the modules?

I have each part of code named separately as Module1, Module2, Module3 and Module4.

I tried to rename them as:

Module1
InitToc
UpdateToc...
Forum: Access March 26th, 2009, 04:39 AM
Replies: 13
Views: 6,604
Posted By Odeh Naber
Hiya folks!

Hiya folks!

Any more suggestions? I created a new database from scratch - just to make sure that it isnt something wrong with the first database that I was using. Very small file with just a few...
Forum: Access March 23rd, 2009, 08:57 AM
Replies: 13
Views: 6,604
Posted By Odeh Naber
Done but still same problem

Hi again!

Ok I made a backup of my Access database - and then I deleted all records except for 10 of them (I had over 600 records before the deletion). Each of the ten now have different unique...
Showing results 1 to 25 of 83

 


All times are GMT -4. The time now is 12:22 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.