Search results

That would be to simple LOL.. Only problem with that is if I put decimal places at "0" it rounds up how can I tell it to not round up if over or equal to .5?

Hey I dont know how to tell you to write this code but I downloaded this and cut and pasted it into one of my forms and renamed some of the code fields and it works perfectly. Maybe you can use it to. It's compliments of Develop.co.uk

I'm trying to show someones age in a form using a text box. I have a form and it has a textbox "Birthdate" and a textbox called "CurrentDate" and I want to use another textbox "Age" to display the age. If the form is searched and displays another date it would change the age as the "Birthdate"...

I inrted that code in place of mine in the attached database. It tells me that no matter what I enter in the field not a valid member. After messaging you several times I figure I take this in steps. This is exactly what I'm looking to accomplish in step 1: Enter the number in the form...

Adam, I appreciate your willingness to help and you are correct knowone learns anything from someone else doing it for them. That wasnt my true intention even though it appears that way when re-reading my original post. I have been trying to get the form to just search the table MemberList and...

I understand what you are saying. I know what I want and I can do queries, ropeort and forms based on tables and queries myself. I can do very basic VB code, like close form and open form when this form closes etc but I do not know how to do insert code etc. You are correct I do not know how to...

I would use buttons it is easier to manipulate and use code... Disable the Navigation on the bottom of the window (I have learned people seem to always get around codeby using thems and it somehow in my databases at least screw with the data they see being accurate.

Here you go DoCmd.RepaintObject , "WHATEVER (FORM OR FIELD) YOU WANT TO REPAINT HERE" Or me.Repaint

Where are they selecting the record from? A Combo, or List Box?

By reading all your notes and comments it doesnt sound like the table you are discussing will grow very quickly at all. Also historical data is great for business trends etc.

Looks like you have what you were looking for in general. Why dont you maybe redesign the form so it is a default background and see if you can change pages by using the Calender you have on your form and have it switch automatically to that specific date by using the filters to fancy it up...

What about the Event "On Change" add the code "me.requery"? You didnt give us a sample database to work with and test but maybe that or repaint will do what your looking for.

Ok now I'm looking at your database creating a form that will show the Summary but I'm unclear what you want to display a Grand Total Summary of each column in Query or a detailed list of Grand Totals by Date?

I wil look at it.. Idea 1: You could use that paramiter Query in your process and add a Start Date and End Date and End Date to your Main Form and then Maybe have an Update button that will update the data in the subform based on those dates. Idea 2: same as above but it your eventProcedure...

How to Start a form/Query? I would suggest creating a query with the results you want first. I would then on the form you want add the Query as a subform linking the date on the Drop Down of your main form to the Date in the subform. If I'm correct (With a little more detail but rather...

Good Afternoon all, This is very complex and a little out of my ability at the time. Can someone help me out with the code or maybe create the form for me? I have attached the proper pieces of the database to work with. Also this database is much more complex than this as it displays picture...

Save & Insert Script Help I will be happy to post the script here when it is complete. As I stated I figured out how to grab the webcam but I'm not working in this thread to save the image to complete the project. I don't think it would be right to post an incomplete script do you?

I resolved this issue thanks for the help.

DBEngine Out of curiousity why wouldn't u just use the Get External Data Function and Link to the Tables (Simple and Quick to me)?

Ok I had a previous post about accessing a camera (Logitech) via access in a previous post that I was told wasnt possible. I have solved that issue :cool: TY Lord it was a success after 2 days of working on the issue. I now have another issue (must be having some brain farts this weekend or...