Search results

Thank you!!! Added to your rep wayne

I am trying to insert a time stamp of when a form was last updated. I added a DateModified field to my table and added that field to my form. Here is a copy of my code Private Sub DateModified_BeforeUpdate(Cancel As Integer) On Error GoTo BeforeUpdate_Err 'set bound controls to...

Guys you were right. It was difinitly more appropriate to use a Dlookup in this situation. I am posting the code I used to do this because while it works great for some reason when i use the dropdown menu to chose the ID number for the manager the Name and Phone Number Fields do not update...

yes of the combo box

its also not saving i copied in your code and changed the names and whenver i go back in its just your code...

it gives me an error box that says there is no macro called me

Ok I will try that and let you know how it goes Thanks!

Not yet but i guess I am going to have to but what i want is for the number to store in a table

I might need you to dumb that down a bit...... where would i be putting the code? and does me stand for the field name?

Is there a way to have a combo box that has two fields in it save to two seprate fields in a table For example my combo box will have the name of a manager and the managers phone number. Is there a way to save the name to the manger name field in my table and the phone number to managers phone...

I have an excell spreadsheet with member names the member names are duplicated up to 6 times each depending on how many months from october - march they have been members. The excellspreadsheet looks like this Member name Member number October care level November care...

I Need to run a query that will not show duplicate records. For example if joe smith is listed five times i only want the most recent date of membership. Does anyone have any ideas?

your going to have to dumb that down a bit. where exactly would i be putting that expression?

I Have a combo box i want to list a name in one column and a number in the other I want the number to transfer from the combo box to another field that i figured out fine. but how do i get the first column with the name to save to a certain table? thank you for the help

When I open up my database i get a securoty warning that says opening"filr name" this file may not be safe if it contains code that was intended to harm your computer. would you like to continue? Is there anyway of getting rid of that warning. It's not a huge deal but its one extra step at...

Ok I got that part down the problem is is that on two of my forms i need to use a combo box to pick the recruiter. then the need to choose an option of either all candidates or only candidates n the running. do you or does anyone know how i would tie the recruiter together with the two command...

I need to create a form that will open up to a report. the form is going to have two options. one option will open up a report that will show all candidates submitted the other option will open the same report but only show the candidates that have not recieved a no from the employer. does...

this is the sql view of my query SELECT Joborders.CUSTOMER, Joborders.[DATE Entered], Joborders.ORDER, Joborders.Recruiter, Joborders.OPEN, DateDiff([d],Now(),[DATE Entered]) AS DaysOpen FROM Joborders WHERE (((Joborders.OPEN) Like "Y")); i m oved the date diff function from criteria to field...

its not sql its just part of my query which i need to make into a report. theres four fields plus the expression i need to make. I don't know if im titling the expression wrong but it just opens a enter parameters box when i run.

I get one of those enter paramerter boxes when i try to run the query.... i have this as my field name Expr1: [DaysOpen] sorry to be a pest you've been a big help