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

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

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

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

Hi I have a form that contains a subform, which displays rows of records according to criterias chosen. Now this subform has a select statement in its recordsource. By default the cursor goes to the first record in that recordset. I must choose the record I would like to delete and press...

Hi, I am having a problem...whenever I delete a record in my subform and the subform requeries my cursor is positioned at the first record of the recordset. Is it possible to position the cursor at the recorde previous the one that is being deleted??? If so, how do I do this. I tried the...

I am having this constant problem! I created an Access application where I wrote a query that uses fields from a table, put them in functions and tranfers the result from the query to an excel spreadsheet. Now the problem is that my select query (at times) gets deleted. The moment the transfer...

In my form, where the user could remove the authorization(checkbox) from a record. Before it can be removed, it must reach a specific criteria. The children of that record must not be authorized, and if they are the user recieves a message where they can remove all authorization of all children...

I am working this form that retrieves certain fields from a table using two criterias. Now once the information is displayed I can choose to view this information in a report. What I want to do is transfer all that is in my form and put it in the report. But when I tried to change the properties...

I am working this form that retrieves certain fields from a table using two criterias. Now once the information is displayed I can choose to view this information in a report. What I want to do is transfer all that is in my form and put it in the report. But when I tried to change the properties...

I have a subform that retrieves specific fields from a table depending on the criteria the user enters and the projectid that they select. Now I don't understand why it doesn't work!!! Here is the code that I wrote when you press the Search button: Private Sub cmdSearch_Click() Dim...

I am having a problem with me application. I am using an Docmd.outputto to output information from a table to an excel spreadsheet. I keep getting an error message: Run-Time Error 3066: Query must have at least one destination field. And in my query I an trying to retrieve specific variables...