Search results

Close form without saving if incomplete Supercharge - First off Thanks for all your help. I have everything just about set. One final question - Is it possible to setup a command close button that will not save the record unless certain criteria are met. In other words how do I setup a "Close"...

Option group question Thanks supercharge - I'm trying to get my brain around this but I'm still having some trouble. I've attached a screen shot of my survey so you can see what I'm doing. If you look you'll see the "Office" option group. I want the remainder of the questionaire to hinge off if...

Required Option Answer I have my questions divided up on tabs dependent upon what they are referrencing - General Info - Workplace - Job Specific - etc. In order to control the survey answers a little I want to make "Office" which is on the first tab a required option to answer before moving...

I'm creating an employee survey database and I'm using option groups for collecting general information such as office, department, etc. My question is can I make it a requirement for them to answer an option group before moving on to other questions? I'm trying to control and track how many...

Additional Information I've tried adding the line below to the query in the report for the field SADDR1 but for some reason it doesn't like this statement. My filter screen comes up and allows me to make my selections but then I get another dialog box asking me for a SADDR1 value. Still working...

I have been asked to make changes to a database report that I had nothing to do with when it was created. Now normally that would not be a big deal but this particular database and report are different. We currently have a sales report that is pulling data from our SQL server. There is a macro...

Emp Timesheet Thanks Sammy B but I don't know if that's going to work for me. I've created a form screen of what I think it should look like and attached it here. I don't know if its possible to do - and I'm probably lacking in the needed skills to do it - but I need to create an interactive...

I've searched through this forum and found one thread that I thought would help me but have not heard back from the post I left requesting help so I thought I would try my luck here. What I am trying to do is create a very simple timesheet for our employees to use. Basically we turn in...

What does it mean when I get a compile error "User-Defined Type Not Defined" error. Here is my code but it looks like it sticking on the Dims. I am a novice so please don't be to hard on me - thanks. Private Sub Command4_Click() 'Preview Report Dim db As Database Dim Q As QueryDef Dim sql As...

It looks like your right about this. Question is how do I get around it. The query that this subform uses has calculations between two other queries so I can't see how I would make it so it could have additions. If you have any ideas please let me know. Thanks.

Have a strange problem. I've created a form with multiple subforms and if there is a record for the subform to display everything looks fine. However, if there is no record for the subform it does not show anything on the screen or if printed. I would like for the fields on the subforms to show...

Thanks Pat. I'm giving your suggestion a try but my weak point with Access is VB. With regards to your line "SomeKeyField = " & Me.SomeKeyField would I refer to one of my table fields? I have tried multiple different combinations and nothing seems to work. Let's say I wanted it to key off my...

Thanks ghudson. I have a question with your solution. Haven't tried it yet but need to know if I can make it visible or invisible dependent upon a choice say like a toggle switch on the form? Also I have another question which is on the same form. I have multiple subforms within this form and...

Exclude subform Thanks Pat but I need to use this form unless there is a way to setup a button on the form that will transfer the current record to the report and print it. This is for upper management and they want to see the data and push a button. Not enter items on the form then go out and...

Need to know if there is a way to exclude a subform from printing when I print forms? Here's what I'm trying to do - Have a form that contains multiple subforms that are linked back to the master form. One of these subforms is a memo which they would like to see on the "preliminary or draft"...

Thanks for your input RV. I did take your advice and use the second approach (even changed the like to =) and everything is working correctly. Thanks again for everyone's input here - I've got exactly what they've been looking for now. Regards, Chester Campbell

Thanks for looking at it ThreeCrow but when I run it I still have problems even on the one I sent you. Take a look at the Master table and find the number of entries for Joseph Hitt. Then run the report and just select him and nothing else. It only returns 5 entries instead of 6 found in the...

Stripped Database Here is a stripped down model of our database. I deleted all reports/queries/forms that did not apply. Let me know if you have any questions. FYI: I tested the report again with this database to see if it was bringing all the data back and it also let some entries off. As an...

Question? Everything looks to be working correctly but one thing. When I choose just a salesperson's name and nothing else it's not giving me all the entries for that person. I tested this with one salesperson using another query and compared the findings with the report. My concern is that...

Thanks! Thanks ThreeCrow for all your assistance. My report is working great and all the sales people are happy so that's a good thing. Thanks again, Chester Campbell