Recent content by Jchristensen

Good Afternoon, i have been looking around to find a way to count come check boxes on a form. Currently on this form there is about 30+ check boxes, A operator will go in and check the boxes to rate the job on quality. What i need to do is count how many are checked on the page, then get a...

i tried the text box with the subform combination, and this is my results. I have a main form, with the project number text box for what the user would input the project number. Now, the subform has the project number as linked fields. There are two other text boxes on the subform that pull...

well, i dont want them to select something since they would have to scroll through a significant amount of data when they can easily type out a 8 combination of numbers and letters. Anyone have a better solution?

Good Morning, I have a simple question, that might have a simple answer yet i do not have any knowledge of it. My problem is this, I have a form that has multiple text boxes. One of the text boxes is a "project number". Some of the other fields are town, state, and another field called a...

Thanks so much for your input! I thought about aproaching it that way but had no idea how ;) Thanks again, Jon

So far this forum and everyone here has been a good help! Now, I want to have a form with one button. (others of course but this one button is special) that when someone clicks it, it prints multiple reports at once. BUT each report has a query obviously that searches out what records to pull...

I was wondering if anyone has seen a easy way to use a calender to select records rather than having to type in a "between such and such a date". Because what i have now is a qry that pulls data from a table between two dates. And i would like to make it more GUI rather than typing to prevent...

i dont know how to do this, if you could possibly show me an example of how this might be done id be happy. I CANNOT figure this aspect of the database out

Hello, So far you guys have been helping me through my database that i am building. Thanks so far! But at the moment i need help on one more aspect of this Database Job. Currently i have a database that supports and holds records for jobs that are under contract. That means we have certain...

I have a couple querys that rely on this statement: Now that makes a box pop up for the person to fill in specific information. Now, is there a way to make a form that a user can choose a job from a drop down box, which then when click "next" it will execute a query with what was selected from...

ok so looking here this is a "dlookup" as i know now instead of a actual number as the "orderID" is there a way to make it pull info from another text box within the form? could i do something like: or something like that -Jon

I have a large problem that i need to get figured out ASAP! I have a form text box (named actual cost) that needs to pull a specific record from a table Now in this table it has multiple rows according to each job. There is a text box (Project number) that has the project that this (actual...

Ok, i got this to change with the combobox but the only problem i have now is that on this form for each record the combo box stays the same for every record. So for record 1 i choose a peticular service. 1) "service A" Then when i go to record 2, it keeps the same choice as in record 1. and...

I am building a database with prices for different services. Now for example i have a drop down box with "service 1, service 2, service 3" that can be selected. There are different prices attached to each service like down below. Now in my form, say that i change the "service 1" to "service...