Search results for query: *

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

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

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

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

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

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

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

Thanks alot James33!! You are fantastic!!!;-)

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

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

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

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

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

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

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

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

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

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

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

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