Recent content by ZeoGel

Thank you both for the quick response. It work great with both codes. "BTW: I would change the name of Combo47 to make your application more self-documented." by dhookom I normally do change the names but i was in a bit of a newbie laps. hehe Thanks again both of you guys. Ron

I am tring to update fields on a continoues form, on only certian records. Here is my code but i keep getting a "Syntax Error (Missing operator in query expression" Private Sub Combo47_AfterUpdate() Dim db As DAO.Database, sSQL As String Set db = CurrentDb() sSQL =...

Hi I have an unbound field that once a variable is selected I want it to input it into a text box on a Multipage form. Currently I have the current code and it works only for the first set of records or the record that has focuse is there a way to set it on all the records that show on the...

I have tried by inputing in the criteria section of the query itself, problem is it keeps asking for the criteria even when i specify it.

I am having trouble getting a report to email that have criteras. I am trying the below code but keep getting an Object required error. Any suggest are welcome Private Sub Command9_Click() On Error GoTo Err_Command9_Click Dim stDocName As String Dim stLinkCriteria As String Dim...

Sweet!!!!!! You Rock! Thank you for the help it has only been a week i have been trying to get this to work. Very Appreciative of your Assistance Ron.

here is what i did stLinkCriteria = ("[Class]=" & Me![Class] & " AND [Manager]= " & Me![Manager])

I have tried it and get the same error missing operator. But thanks for the suggestion.

I am tring to create a report with multiple criterias from a form. I have tried this code but keep getting a " missing operator error" with can someone show me where iam going wrong? Private Sub Command7_Click() On Error GoTo Err_Command7_Click Dim stDocName As String Dim...

-DNG Oh I am sorry, Yes we have Active Directory and I would like to get it there. -Sheco I am tring not to have to people not double input that is why I want to get info from an Active Directory.

I am think of the first and Last name of the user who is access the ASP page. What i have is a Form on the page to be filled out. I would like to get their user info.

Hi I Like to have a field in my ASP page that would State the Name of the Current user. And a hidden field that would retrive their UserID & input it into a database when they submit a Form. Is there a way with either ASP or VB script to reteive this information? Thank's

Are you using your forms to input the criterias?

Lordshogun, Create your report the way you want. And connect the report to the query. Then in your query in the fields you want to have your criteria in type in Form!(Your form Name)! Field you want them to get the criteria from. In your report insert a graph and put it where you want it. Right...

Thank You all for the input. GingerR i am using the Form!FormName!txtSubmitDate for my report and it is working great. Thanks for all the help Crowley16 and GingerR