Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. legs00

    Common Dialog How to?????

    Hi, In the application, my db is split from the forms. Now in my mdb which contains the interfaces, there is also a copy of the tables from the db but with only default values in them. What I want to do is by the press of a button allow the user to export the sample tables from the application...
  2. legs00

    Edit ComboBox in Subform

    Hi Everyone, Ok...this problem got a little worse! This is the thing. My form and subform are connected to this table "Assignment". In my form I have a ProjectID textbox and in my subform I have a combobox ResourceID. Both make up my primary key in the Assignment table, ProjectID &...
  3. legs00

    EDITING A FIELD IN A SUBFORM!!!!!!!!!

    Hi, I have this subform that is based on a recordsource, and the user can make modifications. My problem is, I have to make a validation using the combo box before and changes are made to the table!! What I want to do is keep in memory the initial value in the combo boxes of each record so when...
  4. legs00

    Cursor Position!!!

    I am working with an access application, in which my subform is displayed using a recordsource. The user can make modifications to a specific record by selecting a record and pressing the modify button, which opens another form. Once the user completes their modifications, the subform is...
  5. legs00

    Date Problem!

    Sorry about that! Pezamystik, my last reply was for you. As for Jim, the reason I am using "UNION Select '' From RejectTimeSheet" is so I can get an empty entry in my combo box. Usually you would see '(All)' as the first entry in the combo box, but I can't put (ALL) because it is a...
  6. legs00

    Date Problem!

    Hi Jim, I tried what you suggested but I get this error message: The ORDER BY expression(WEEK) includes fields that are not selected by the query. Only those fields in the first query can be ordered in an ORDER BY expression. Therefore I rearranged the query to, cmbWeekReject.RowSource =...
  7. legs00

    Date Problem!

    James I have another question for you. Everything works fine with my UNION and Date but now I would like to order my date for past to present. Although what I get is: 02-Nov-2001 03-Aug-2001 10-Feb-2002 27-Dec-2001 I have a feeling the reason why the order by doesn't work is because of the...
  8. legs00

    Date Problem!

    Thanks alot James33!! You are fantastic!!!;-)
  9. legs00

    Date Problem!

    Hi Pezamystik, I tried what you suggested but i still don't get what I want. When I initially open the form, the value in my combo box has Medium Date format and so does the values when I drop dowm the combo box. BUT when I select one of the dates the value I get in the combo box is Short Date...
  10. legs00

    Date Problem!

    In one of my access forms, I have a ComboBox that contains Weeks which come from a table in my access database. In the ComboBox there is a blank entry which allows the user to choose it and it returns all the weeks in that table. My code is as follows: cmbWeekReject.RowSource = "SELECT...
  11. legs00

    Big Problem With Write Conflict!!!

    In my Access application I am having a problem updating modifications being done in a form. The process is like this: I have a form "ViewActivities" where the user enters criterias and the information is displayed in a subform "ActivitiesSubform". From here the user can...
  12. legs00

    Subform and ControlSource!!!!

    I have this form (let's call it ACT) where the user enters their criterias which then leads to a subform(Let's call it ACTSUB) that displays various records. The textboxes in ACTSUB are bound to a table (ACTIVITY) except for one textbox. Now that is my problem!!!! What I would like to do is...
  13. legs00

    BeforeUpdate Event Question!!!!!

    Hi Jebry, Well thank you!! I put my boolean variable private in my general and did the rest as you suggested and everything works fine!!!! s-)%-)*:->* Legs
  14. legs00

    BeforeUpdate Event Question!!!!!

    Hi, I have a form where the user can choose an activity they would like to modify, which opens a MODACT form. In this form the user can make any modifications and cancel at any time. My problem is that my code has a Form_BeforeUpdate() event and if the cancel button is clicked the...
  15. legs00

    Displaying recordset values to unbound textbox!!!!!

    Hi, I am having a problem with my subform. I would like to know if there is another way of displaying a recordset in a subform without having bound controls (textboxes). I do not want the subform to have a recordsource. If anyone could please tell me if this is possible. Thanks, Legs
  16. legs00

    Getting error "Written Conflict"!!!!!????

    Hi, I have this form (ACTIVITIES) where the user enters criterias and they are shown in the subform. The user can then choose a record in the subform and modify various fields. This opens another form (MODIFYACTIVITIES) where the user makes changes. Once the modify button in pressed an error...
  17. legs00

    How to add an "ALL" in Combo Box

    I have a form that has two combo boxes one is for the project number and the other is for the week. Once the user chooses his criterias, there is a query that runs and the results are shown in the subform. The extra option that I would like to give the user is the ability to choose all of the...
  18. legs00

    Problem with TransferSpreadsheet Method!!!

    Hi, I am trying to tranfer a excel spreadsheet to my access application the process work fine if I choose the excel file I wish to transfer and press "OK". The problem is that if I wish to exit by pressing the "Cancel" button I get an error message: "Run-Time Error...
  19. legs00

    How to add an "ALL" in Combo Box

    I tried the "all" but I get an error. "The value you entered isn't valid for this field For example, you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits." Now the information that is in the combo box are dates Medium...
  20. legs00

    How to add an "ALL" in Combo Box

    Hi, I have a combo box that is populated from a recordset. What I would like to do is to add another row in the combo box that is blank which means the same as ALL. Is it possible to do that?? If so, can you please help me with it. Thanks Legs

Part and Inventory Search

Back
Top