Search results for query: *

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

Hi, I have to make a report that connected to a query that have criterias, I have a graph linked to the same query. The problem I am having is when I run the report it ask me 4 different times for the criterias before it will show the report. This only happens when I the graph is inserted...

I have found the answer!!! First you must go to Define view for this folder and make a new veiw with the New form you created set it up the way you want your table in access to look. Then name it and save it. Then on the bottom left side of the Define Views window there is a check box that says...

This is great for what I am planning on doing I have one Problem I have created a unique form in outlooks. I currently have all email with this form going to one folder then I linked the folder from my access data base but am not getting any of the fields I have created from that form in the...

I have read up where you can write VB code to extract a task from access to outlooks task. My question is I have 8 fields on an outlooks form that I want the data in those feilds to transfer to an access data base does anyone know the VB code to do that? Thank you for any suggestions

I have a form with 2 subforms the Main form creates a record number that is put in to a table then in subform that record number is put into another table and then if i click on a tab to another subform that creates another record in yet another table. how can i create a One button on the main...