Wrox Programmer Forums
| 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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 26
Search took 0.01 seconds.
Search: Posts Made By: Jonas
Forum: Access July 25th, 2007, 02:01 PM
Replies: 3
Views: 767
Posted By Jonas
alright, i have normalized my database to help...

alright, i have normalized my database to help smooth things along. however i still cant figure out how to work my query.

i now have a seperate table for "jobs", "team members" , "workdays...
Forum: Access July 24th, 2007, 08:00 AM
Replies: 3
Views: 767
Posted By Jonas
well you hit the nail on the head im afraid. ...

well you hit the nail on the head im afraid. that is the exact structure of my table. and yes john smith can come up where ever the user wishes, as the first, second, third etc team member on any...
Forum: Access July 23rd, 2007, 10:46 AM
Replies: 3
Views: 767
Posted By Jonas
Challenging Query

Hi everyone, here is one of the tougher problems ive had to deal with.

i have a number of fields, called teammember2, teammember3 etc..to teammember12. This is done because on the form, the...
Forum: Access June 12th, 2007, 10:27 AM
Replies: 28
Views: 2,768
Posted By Jonas
hey Kevin, sorry for the late response, got...

hey Kevin,

sorry for the late response, got tied up in meetings. I did not try the second code, as I have everything working as it should. but thanks all the same!

Jonas
Forum: Access June 11th, 2007, 02:44 PM
Replies: 28
Views: 2,768
Posted By Jonas
kevin, i think i got it! finally it is doing what...

kevin, i think i got it! finally it is doing what i want, and yes there is always a record in the subform.

oh theres just one more thing, is there anyway format the subform to pull all the...
Forum: Access June 11th, 2007, 12:57 PM
Replies: 28
Views: 2,768
Posted By Jonas
i double checked the spelling of all the fields...

i double checked the spelling of all the fields and tables. and no message box comes up, nothin happens when i click the button. is there any other reason this wouldnt work?
Forum: Access June 11th, 2007, 12:30 PM
Replies: 28
Views: 2,768
Posted By Jonas
hey, here is the code attached to the button....

hey, here is the code attached to the button. does it look right?

Private Sub Command2_Click()
Dim rs As Recordset
Dim rs1 As Recordset
Dim db As Database

Set db = CurrentDb
Set rs =...
Forum: Access June 11th, 2007, 11:44 AM
Replies: 28
Views: 2,768
Posted By Jonas
well i used the button, but it didnt do anything...

well i used the button, but it didnt do anything :S i am still having the same problems as before. when i click the button nothing happens, is there suppose to be some event i am missing?
...
Forum: Access June 8th, 2007, 03:08 PM
Replies: 28
Views: 2,768
Posted By Jonas
eh kevin, used the code on a button and it gave...

eh kevin, used the code on a button and it gave the message:
"run-time error 3078: the microsoft jet database engine cannot find the input table or query 'sub'. make sure it exists and its name is...
Forum: Access June 8th, 2007, 02:24 PM
Replies: 28
Views: 2,768
Posted By Jonas
K, here are the names of all tables, forms and...

K, here are the names of all tables, forms and relevant fields.
the fields that will be on the report are:

1. "Project Name"(from the table "Project Management")
2. "Assigned To"(from the table...
Forum: Access June 8th, 2007, 02:09 PM
Replies: 28
Views: 2,768
Posted By Jonas
what do you mean by which 1 is on both? and...

what do you mean by which 1 is on both?

and the data is going on a report which displays the current status of a project. the current status is the other field in the sub form, and it corresponds...
Forum: Access June 8th, 2007, 01:25 PM
Replies: 28
Views: 2,768
Posted By Jonas
yes, thats correct

yes, thats correct
Forum: Access June 8th, 2007, 12:28 PM
Replies: 28
Views: 2,768
Posted By Jonas
I'm still having a little trouble. I want to pull...

I'm still having a little trouble. I want to pull the most recent date from the "status subform" pulls the project "name" from its main form. i will illustrate below what i would like to see:
...
Forum: Access June 8th, 2007, 08:18 AM
Replies: 28
Views: 2,768
Posted By Jonas
yes, i set the date to =Date() as the default...

yes, i set the date to =Date() as the default value
Forum: Access June 8th, 2007, 07:51 AM
Replies: 28
Views: 2,768
Posted By Jonas
hey kevin, here is the code that is on the...

hey kevin,

here is the code that is on the query, as of right now it is pulling the correct record from the subform, however it is only taking it from the first main form record. my report has...
Forum: Access June 7th, 2007, 02:34 PM
Replies: 28
Views: 2,768
Posted By Jonas
query problem

hey all,

i am having a problem with a certain query which pulls records from two tables. one table contains info entered into a main form, and the other has information entered into the subform. ...
Forum: Access June 6th, 2007, 11:25 AM
Replies: 5
Views: 1,170
Posted By Jonas
perfect figured it out. thanks for the help...

perfect figured it out.
thanks for the help kevin!
Forum: Access June 6th, 2007, 09:59 AM
Replies: 5
Views: 1,170
Posted By Jonas
sorry, i should have made that clear. it is one...

sorry, i should have made that clear. it is one form, with page breaks seperating each kind of information the user is inputting. all info is added on to one form, the page breaks and corresponding...
Forum: Access June 6th, 2007, 09:29 AM
Replies: 5
Views: 1,170
Posted By Jonas
button command for page change

hello all,

i am creating a form and i need to have 3 seperate pages, one for profile, data, and workloads. i tried using a tab control but that does not work as i will need to have a tab within a...
Forum: Access August 14th, 2006, 01:03 PM
Replies: 2
Views: 1,738
Posted By Jonas
hi Mike, Thanks for the reply, but that...

hi Mike,

Thanks for the reply, but that just gives me the total number of claims. what i need is the number of different claims names (IE claim-1, claim-2etc) even if theirs 100 different claims...
Forum: Access August 11th, 2006, 08:28 AM
Replies: 2
Views: 1,738
Posted By Jonas
Count Distinct

Hey all,

I have a query pulling up many different claims and corresponding payments. My question is how to get a count of each different claim ID, not total number of claim ID's. For example: ...
Forum: Access VBA August 4th, 2006, 10:29 AM
Replies: 1
Sum
Views: 1,350
Posted By Jonas
Sum

hi all,

wonderin if u could help me out with this problem. i currently have a database consisting of a form, and built within that form is a subform. the form takes down personal info on...
Forum: Access VBA August 4th, 2006, 09:11 AM
Replies: 2
Views: 1,101
Posted By Jonas
Error in Counting

Hey everyone,

Im having a problem getting access to count the correct number of records when i run a report. The problem is that i have a subform within a main form , which records payments made...
Forum: Access August 4th, 2006, 09:07 AM
Replies: 4
Views: 1,365
Posted By Jonas
hey mel thanks for the tip. ill give the other...

hey mel thanks for the tip. ill give the other forums a shot, but since im here how would i be able to count report objects? because i have tried using a count function on the report footer but it...
Forum: Access July 31st, 2006, 08:16 AM
Replies: 4
Views: 1,365
Posted By Jonas
Thanx Trab, but i do know how to count records...

Thanx Trab, but i do know how to count records but this time im havin trouble, ill give u a better idea of wut im talkin about.

i have a form in which insurance claims are entered (including...
Showing results 1 to 25 of 26

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.