Search results for query: *

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 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...

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...

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

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 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...

I have a report that has an 13 digit Number but the First Eight Digits represents a City Name How can I show the Name of the city instead of the number. I have 9 different citys to show. Iam using an experession to get an accurate average. But when there is a 0 in the Sum The average shows as a...

I have 2 questions 1. I have a record with 3 choices on one column meaning you can choose a , b or c. Now i need to sum each one of the choices can someone help? 2. I have a check box and i want to sum up everytime it has been checked i keep coming up with a negative number how can i make it...

I have a query i am using to generate a report but my averages are getting diluted because some of the feilds have 0 which shows no data in them but it is being counted when doing the averages how can i fix the averages to skip all feilds that have 0 in them?

I have two questions. First is I have an excel spread sheet with alot of subtotals I would like to add a blank row after each subtotal,is it possible? Second is the same spread sheet I have formulas on the spread sheet too but when I paste the formulas on a Column it will give 0.00 in the column...