Search results

  1. A

    Setting field formats for linked tables

    Hi, I have a linked xls file which contains bills of lading along with other details. Bill of lading could be either numeric or alpha-numeric (starting with an alphabet). In the current setting my database ignores (blanks) out all the alpha-numeric bills of ladings and retains only the numeric...
  2. A

    Formatting a field in an access query

    I need to format a field in my query as a number. Does anyone how this can be done? Thanks!
  3. A

    Change Password Form.

    Hi, I have a change password form on which there are 4 text boxes and a button. Text Box1= login name (windows username of the user picked up automatically) Text Box2=oldpassword (user enters the old password) Text Box3=newpassword (user enters the new password) Text Box 4=newpassword1 (user...
  4. A

    Selecting all columns after a specific number of columns from a cross tab query

    Hi, I have a cross tab query that is based on monthly data. I have another select query based off of the crosstab query. At the end of each month the crosstab query gets a new column with the data for that month. The crosstab query also has details such as name, type etc in addition to the...
  5. A

    InitVars Sub or function not defined

    I have the following code for the report. When I run the debugger I get an error saying Sub or Function is not defined and InitVars is highlighted. Option Compare Database 'Use database order for string comparisons Option Explicit 'Constant for the maximum number of columns generated by the...
  6. A

    Limitations on number of queries looking at a form text box for parameters?

    I sorted it out. It was an issue with the way I was calling the query from the form. Thanks Kryst51 for your response.
  7. A

    Limitations on number of queries looking at a form text box for parameters?

    I have a database with a number queries containing monthly performance data for each person. I use a form to specify the criteria such as Name of the person, role of the person and the period and have prompts in the queries which look at the form for this criteria. (all these queries look at the...
  8. A

    Storing the result of a field expression to a variable

    Acutally, no don't understand VBA at all and that's why I looked here for help :) Anyways, I corrected it and it works fine! Thanks! Btw is there a way I can turn off the MyNewField from getting displayed in the second query result?
  9. A

    Storing the result of a field expression to a variable

    ok, here's what I did for the first part, Option Compare Database Function NormFactor("NORM_FACTOR" As String "ForecastNormalization" As String)As Variant NormFactor = DLookup("NORM_FACTOR", "ForecastNormalization") but it highlights Function NormFactor("NORM_FACTOR" As String...
  10. A

    Storing the result of a field expression to a variable

    The first query calculates the normalization factor for the current period so it will always be unique. Here is what I have so far, What I intend to do with the following code is to store the value in the column NORM_FACTOR in the query ForecastNormalization to the variable strNormFactor...
  11. A

    Storing the result of a field expression to a variable

    Hi, I have a query that calculates a normalization factor based on the number of days in the current month. I need to use this factor in another query however these queries do not contain common fields that I can use to join them. The only way I guess I can do it is if I save the normalization...
  12. A

    Query does not work on one computer

    Hi Mike, I would guess they are the same, but how can I check just to be sure? Thanks.
  13. A

    Query does not work on one computer

    Hi, I have a sheared access database built using Access 2003. The query in this database has parameter prompts (for criteria) set in it which prompt the user to enter from and to dates. This works fine for everyone trying to run it using Access 2003 as well as Access 2007. However there is one...
  14. A

    Dynamic Reports

    Hi, I have a query which contains monthly data. Every month a new column is added to the query. All the calculations are being done in the query and I am using the report just as a means to present the data. I will however need to have dynamic textboxes/labels on the report which will...
  15. A

    Building a report off a query with dynamic column and criteria prompts

    Hi Hitech, In the RptCrosstab2k database you have a report which has a number of unbound textboxes in the report. What is the control source for these text boxes? I mean what tells them "where to pull data from?" Thanks.
  16. A

    Run time error 2001

    Thanks Pbaldy. Appreciate all the help!!
  17. A

    Run time error 2001

    Thanks for the link. How do you force someone into runtime mode? Also, in runtime mode the user will not be ableto see the code? I would also need to hide the table containing passwords so that no one finds it...any idea how I can do that?
  18. A

    Run time error 2001

    Thanks guys!! I took that line off and it works fine!! What is the syntax for DLookup if the criteria is a variable generated in the form? I mean I want to use a variable which is generated in the form to lookup a table and return a column. Also, what is the best way to lock the code so that no...
  19. A

    Run time error 2001

    Here it is. I dont mind if I have to remove the UserID field altogether. It is not required.
  20. A

    Code for using a variable generated on loading a form to lookup a table and based on

    I have a form which when opened reads the username of the person that is logged on to the computer. The user is stored as a variable. This variable is called strUser I have a table in the database which contains the windows username and key among other fields. I want to write a code which will...
Back
Top Bottom