sjvandevoorde
Last Activity: Mar 27 '07, 01:50 PM
Joined: Oct 30 '06
Location: Geneseo, Il
-
No it does not. I've played around with filtering also. Same results. I do not have enough experience to understand the coding to be able to fix. I have not been able to get this fixed.... -
Anyone out there got any ideas why this doesn't work? This is the only thing keeping me from finishing the database and they have been waiting for this for a long time and would like to have done - you know how it is - months ago. Thanks....Leave a comment:
-
Just can't seem to get this to work. No error messages and stills asks for a parameter and even if I do enter the value "Taskers" it brings up all records.
I have this code in the form's properties
EVENT: On Open - [Event Procedure]
This is what I have and what shows (I copied and pasted):
...Code:Private Sub Form_Open(Cancel As Integer) 'To open form and display only records with the project
Leave a comment:
-
Thanks again---
I tried that and it gave me the following:
DoCmd.OpenForm "frmTaskers_Sus pense-Edit/Search", acNormal, , "[Project List]='" & Me![Project List] & "'"
Error Message:
Compile Error: Expected: end of statement ((It had [typeproject] hilighted)
then -
Run-time error '2465'
MS Access can't find the field "TypeProjec t'...Leave a comment:
-
Thanks...
I tried what you sent for a code but I am doing something wrong. Here is what I have:
The form name is: frmTaskers_Susp ense-Edit/Search
The field Name is: Project List
The field Control Source is: ProjectID
I put the code in the form's property-
Event: On Enter - event procedure:
When I click on the command button to open the form I get the following error...Leave a comment:
-
Showing only records based on a specific value
Hello-
I need a little help. I don't think this is too difficult to do, however I have been away from any access development for some time and can't seem to figure it out. I've tried queries and filtering...... I give!
FIELD: Typeproject (Listbox)
VALUES: CSA, TASKERS, CONFERENCES, SIGNATURE
For example I want the form called TASKERS - when it opens - to show only records in which the value for the field... -
New Database - 2003 Version-Access
II am hoping someone out there will be able to give me some guidance, as I am about to give up. I have been working on this for some time and I think I have looked at it so much that I can't even think straight.
I am working on a database to help track projects. There are three different types of projects/screens that I need. What I have so far:
TABLE: Taskers (Screen/form 1)
FIELDS:
RMTaskerID – Autonumber/Primary... -
New Record/Currency field
I have a few questions, which I am sure are simple to fix, but I have not had any luck finding the solution in my Access book and nothing I have tried works.
1. How do I get a form to open up with a new blank record????
2. When entering information into a currency field, I have to delete the $0.00 which is dispayed before it will accept the new entry. Error messages reads:
The value you entered isn't... -
Form-text field updates to show Balance
I need some help with a couple forms/test fields. Bare with me I have been out of the field for some time and only consider myself an intermediate user.
The first one is a subfrom which lists records including Decrease and
Increase field. I have two text fields which are suppose to total each of these fields.
This subform is within another form which should be displaying the current balance.
The subform...
No activity results to display
Leave a comment: