Ask Experts Questions for FREE Help !
Ask

Search:

Type: Posts; User: mcleyn

Search: Search took 0.00 seconds.

  1. Question: Decimal Places

    by mcleyn
    Answers
    2
    Views
    468

    Thank you very much. That was the exact problem.

    Thank you very much. That was the exact problem.
  2. Question: Decimal Places

    by mcleyn
    Answers
    2
    Views
    468

    Decimal Places

    Hi there,

    I have a form with a text book that is bound to a table. I would like to keep two decimal places when I enter a number inside the textbox. For example, $47.12
    I have set the properties...
  3. Question: Parameter Query

    by mcleyn
    Answers
    2
    Views
    570

    Yes I agree with you. However, I will see what I...

    Yes I agree with you. However, I will see what I can do with this article. Thanks again.
  4. Question: Parameter Query

    by mcleyn
    Answers
    2
    Views
    570

    Parameter Query

    Hi there,

    I have made a parameter query that is linked to a report, prompting the user with [What codes are you looking for?]. The Code field contains a variety of codes. However, when the...
  5. Question: Report Sum totals

    by mcleyn
    Answers
    7
    Views
    641

    Wow! Thank you so much ScottGem. My query column...

    Wow! Thank you so much ScottGem. My query column that I made had spaces in the name which was why it was not working. I did not know such a small thing could make such a big problem. Thank you!
  6. Question: Report Sum totals

    by mcleyn
    Answers
    7
    Views
    641

    Both names are the same. In the query I have...

    Both names are the same.
    In the query I have made a column called Total Funding Requested which adds funds over four years.
    In the detail part of my form I have a Total Funding Requested text...
  7. Question: Report Sum totals

    by mcleyn
    Answers
    7
    Views
    641

    I have triple-checked the object name and both...

    I have triple-checked the object name and both are correct.
    What else is do you think the problem may be?
  8. Question: Report Sum totals

    by mcleyn
    Answers
    7
    Views
    641

    Report Sum totals

    Hi there,

    I have made a report from a query. I want to sum the totals from a totals column. I have had luck summing the totals from my other columnms by putting a text box control source to...
  9. Answers
    4
    Views
    528

    Ok thank you very much for your help!

    Ok thank you very much for your help!
  10. Answers
    4
    Views
    528

    Ok wonderful. That works perfectly. Is it...

    Ok wonderful. That works perfectly. Is it possible to have this textbox that holds the answer of the totals to have another control source that puts this answer back into my table?
  11. Answers
    4
    Views
    528

    Getting a Total from 4 textboxes.

    Hi there,

    I am trying to produce a total sum text box from four text boxes inside a form.

    I have tried writing the following macro for total sum text box but it does not work:
    ...
  12. Answers
    6
    Views
    2,025

    I needed to take the password off in the back-end...

    I needed to take the password off in the back-end as well.
  13. Answers
    6
    Views
    2,025

    Thank you very much. I have solved the prolem.

    Thank you very much. I have solved the prolem.
  14. Answers
    6
    Views
    2,025

    It's a regular .mdb file database. I never had to...

    It's a regular .mdb file database. I never had to make any new file for it... would you have any ideas how to solve it otherwise? I'm in a huge pickle.
  15. Answers
    6
    Views
    2,025

    Error 3031: Not a Valid Password

    Hello,

    I have an Access 2000 database.
    I recently set a password to the database by going to Tools > Security > Set database password.
    When I open the database it asks for a password so I put...
  16. Question: Adding Tables

    by mcleyn
    Answers
    1
    Views
    471

    Adding Tables

    Hi,

    I am using Access 2000. I have a database with a front-end and back-end. I currently have 4 tables that are linked to the bank-end.

    I want to add a new table but I also want this table to...
  17. Answers
    1
    Views
    787

    Tabs or Command Buttons

    Hi,

    I am using Access 2000.
    I have a form that allows users to input information quicker.
    My question is: My form has gotten to long and cluttered. Is it possible to have tabs at the top of the...
  18. Question: Run-Time Error.

    by mcleyn
    Answers
    13
    Views
    1,171

    This is the only WHERE clause in all my code: ...

    This is the only WHERE clause in all my code:

    sql = sql & "WHERE (" & Me.Filter & ") ORDER BY tblMain.ProjectCode;"

    So should I add the WHERE (tblFiscalBudget.FiscalYear.. to this?

    Yes I am...
  19. Question: Run-Time Error.

    by mcleyn
    Answers
    13
    Views
    1,171

    Ha! I see! So I shoud add this: WHERE...

    Ha! I see!
    So I shoud add this:

    WHERE (FiscalYear = '11/12') ORDER BY tblMain.ProjectCode;

    to the original code that I posted?
  20. Question: Run-Time Error.

    by mcleyn
    Answers
    13
    Views
    1,171

    Ok so I have Debug.Print sql and this is what I...

    Ok so I have Debug.Print sql and this is what I was given:

    SELECT tblMain.ProjectCode, tblMain.EventDate, tblMain.Status, tblMain.OrganizationName, tblMain.Province, tblMain.ProjectType,...
  21. Question: Run-Time Error.

    by mcleyn
    Answers
    13
    Views
    1,171

    Exactly I thought so to. So I debugged the error...

    Exactly I thought so to. So I debugged the error and it gives me a highlighted: 'Me.RecordSource = sql'
    This highlighted area is below the sql that I just posted. Then I assumed the error was...
  22. Question: Run-Time Error.

    by mcleyn
    Answers
    13
    Views
    1,171

    I understand what your are saying but am still a...

    I understand what your are saying but am still a little unsure of how to correct it in my sql statement. Again the error specifies it is in the FROM clause of my sql statement, however what fiscal...
  23. Question: Run-Time Error.

    by mcleyn
    Answers
    13
    Views
    1,171

    Thank you very much. I just changed the name to...

    Thank you very much. I just changed the name to Fiscal_Year and I no longer get the error.
  24. Question: Run-Time Error.

    by mcleyn
    Answers
    13
    Views
    1,171

    Run-Time Error.

    Hi,

    I am using Access 2000.
    I have a form that shows all the projects being held inside my database.
    I have made drop down boxes in the form with VBA to filter the projects.
    I am getting an...
  25. Answers
    2
    Views
    496

    Thank you.

    Thank you.
  26. Answers
    2
    Views
    496

    Multiple Records in one Field

    HI!
    I would like to save up to 5 records in one field. What is the best way to do so?
  27. Question: Mulitple Combo Box

    by mcleyn
    Answers
    3
    Views
    631

    Ok sounds I comprehend everything your saying up...

    Ok sounds I comprehend everything your saying up until that I have to assign a handler.
    How exactly do I do that?
  28. Question: Mulitple Combo Box

    by mcleyn
    Answers
    3
    Views
    631

    Mulitple Combo Box

    I have seen before in a database a certain combo box.
    I am using MS Access 2000 and Visual Basic.
    This combo box had 5 choices, all these choices had a control source to a field called Initiatves;...
  29. Question: Multiple Combo Box

    by mcleyn
    Answers
    2
    Views
    1,046

    Thank you however I have tried a listbox with a...

    Thank you however I have tried a listbox with a multi-select property, it allowed me to choose up to 5 options but they did not show up as new records in the field.
    Perhaps you are right about the...
  30. Question: Multiple Combo Box

    by mcleyn
    Answers
    2
    Views
    1,046

    Multiple Combo Box

    I have seen before in a database a certain combo box.
    I am using MS Access 2000 and Visual Basic.
    This combo box had 5 choices, all these choices had a control source to a field called Initiatves;...
  31. Question: Undefined Function

    by mcleyn
    Answers
    3
    Views
    588

    My apologies for the quote asking you how to copy...

    My apologies for the quote asking you how to copy the module, I have figured it out. Thank you very much for your help indeed.
  32. Question: Undefined Function

    by mcleyn
    Answers
    3
    Views
    588

    OK thank you very much. Could you explaing how I...

    OK thank you very much. Could you explaing how I copy the module so the query will work?
  33. Question: Undefined Function

    by mcleyn
    Answers
    3
    Views
    588

    Undefined Function

    I have a form called, frmDetail, which is one of my main forms.
    Inside the frmDetail I have a drop down box with a list of different choices.
    All of the choices inside the combo box are different...
  34. Answers
    1
    Views
    1,597

    Multiple Choice Combo Box

    I have a combo box with three choices; Innovation, Competitive and Amenities.
    The Control Source field for these choices is called; Initiatives.
    I want the user to be able to choose 1, 2 or even 3...
  35. Answers
    12
    Views
    1,302

    Ok thank you very much, your help is very...

    Ok thank you very much, your help is very appreciated.
  36. Answers
    1
    Views
    438

    Taking Links Off Tables

    If you have tables that are linked, and you want to make a new file of an original database. How do you take the links off the tables, so you can delete record in one file without the records being...
  37. Answers
    12
    Views
    1,302

    Actually I was thinking. I just want to put new...

    Actually I was thinking. I just want to put new records in for my tables and front end stuff as well. I mine as well just copy over the front end stuff like forms, queries and reports and then just...
  38. Answers
    12
    Views
    1,302

    Ok I copied the front end and then imported the...

    Ok I copied the front end and then imported the tables but they still are linked. Can you explain how to unlink the tables?
  39. Answers
    12
    Views
    1,302

    OK yes now I understand the links. I found out...

    OK yes now I understand the links. I found out the names of the back ends by looking in the Linked Table Manager. So no that I have done this; to make a new copy should I break the links? How do I...
  40. Answers
    12
    Views
    1,302

    Do you mean make sure there are no relationships...

    Do you mean make sure there are no relationships between the tables? How do I make a copy of the back ends?
  41. Answers
    12
    Views
    1,302

    Acutally it didn't work. I copied the file and...

    Acutally it didn't work.
    I copied the file and then opened it and started to delete my records. When I opened the original file the same records were deleted.
    Is it possible to copy the file and...
  42. Answers
    12
    Views
    1,302

    Thanks, works!

    Thanks, works!
  43. Answers
    12
    Views
    1,302

    Duplicating a File.

    I currently have a database with MS Access 2000.
    I want to make a new database that has the same fields and forms etc. as my current database the only thing different would be the data.
    So...
  44. Thank you Perito for all of your input. I have...

    Thank you Perito for all of your input. I have found the problem, I was missing a few commas is some of my sql statements. Thanks again!
  45. These are the sql for the two queries I have. ...

    These are the sql for the two queries I have.

    tblMain query:
    SELECT tblMain.Province, tblMain.ProjectTitle, tblMain.ProjectDuration, tblMain.ProjectType
    FROM tblMain
    WHERE (((tblMain.Province)...
  46. I have pasted here the procedure that I am having...

    I have pasted here the procedure that I am having the error with, you can see below the highlighted line of code that is giving me the problem. Is this what you are asking for?


    Private Sub...
  47. Thank you very much for responding. I have looked...

    Thank you very much for responding. I have looked over my code and I have declared the sql variable as follows:

    Dim sql As String

    I have used single quotes where necessary however I am still...
  48. Run Time Error'3075': Syntax Error(Missing Operator) in query expression

    I am running a database using MS Access 2000 along with Visual Basic.

    Inside the database I am running a specific tracking summary form that takes information from a populated main table.
    ...
Results 1 to 48 of 48