Search results

Thanks I'll give it a try.

Hello All, I'm working with a large spreadsheet that will need to be distributed to several people. There are specific rows that each person is responsible to complete. All of these specific rows are open for editing. I would like to prevent inadvertenant errors by "locking" the rows that do not...

Thanks ray705 for the response. I will wait a few days before redesigning to see if anyone else may have a solution.

I hope I have your setup correct, just guessing fro your info, but here goes: ParentTable: ParentTableID(autonumber and primaryKey), other fields ChildTable: ChildTableID(autonumber and primaryKey for childTable), ParentTableID(longInteger, foreignKey, no autonumber), SortOrder (longInteger)...

I have posted a question in the "Forms" forum and have received no response. If I could just get an expert to tell me that what I'm trying to do is not possible, I could try another avenue. I just feel like one of you would have the answer I need. The post is called "Paste from Excel Not Firing...

OK Here you go! In the properties sheet for the subform, remove whatever you have for a recordSource. In the OnLoad event for the parent form set the subform's recordsource to a query that calls for all recipes (sorted however). In the AfterUpdate event of the comboBox, set the sunform's...

No one knows everything. ALL contributions are welcome. ElGoober and I need all the help we can get!

It's probably a good idea to have a button that says "Show Data". Until this button is clicked, the subform does not have a recordsource (recordSource in properties sheet is blank). OnClick event should write the SQL statement that will be assigned to the subforms recordSource. Use variables to...

Leave the rowSource blank in the properties sheet. In the AfterUpdate event of the "New/Old" control write something like this: If new/old = New then Forms!<ParentFormName!<subformName>.Form! <comboBoxName>.RowSource = "<queryName for list of New>" Else...

Create fields on the parent form to enter the StartDate and EndDate. Don't assign the recordSource of the subforms until these fields have been updated.

frmSplash:button: "New Job" OnClick DoCmd.openForm "frmJobInfo" ,,,,acFormAdd Forms!frmJobInfo!ClientNumber = me!ClientNumber <You can assign values to any of the other fields on frmJobInfo here> DoCmd.close acForm, "frmSplash"

Help! Have I not explained the problem properly:confused: Is there no one out there that has seen this problem?

Don't assign the record source to the subform until a selection has been made then have your code write the query that will be assigned based on the selection criteria.

Here's a snippit of a sub I wrote. The user has 3 list boxes to make selections from. In this first part, the user has NOT selected any specific MODELS or ESNs or Modules. In the "EsleIf" part, the user has made selections in the listModules and the code will loop through the items in the list...

Write 2 queries as RowSource for the combo box. After user indicates "new" or "Old" set combobox.rowsource = appropriate query

Capture new SortOrder and recordID in variables. Query the records for the RecordID and SortOrder field >= variable as a recordset. Loop through the records. If RecordID <> recIDVariable then SortOrder = SortOrder+1

Create a new field in the subtable called "SortOrder" Have subform and parent link as necessary through the indexes but DISPLAY the records in order of the "SortOrder" field. User has created records #1,2,3,4,5 and now needs to add a new #3 and move all the others up one. Let user add new record...

I have structured a subform as a datasheet to allow users to copy and paste from Excel into the database. Datasheet has numerous fields and 18 rows. I have set up recalculations of other data in the AfterUpdate event of the fields in the datasheet. This works perfectly until the user copies...

Is there such a thing? I see the "ApplyFilter" event but I need certain events to occur when the form's filter is removed. It seems I must not allow users access to the built-in shortcut buttons and create "Show All" buttons of my own. Is there an easier way? Thanks in advance for any help. Gail

I have written a small program to automatically synchronize a design master and its replica every night at about 4 AM. The program logs whether or not the synch was successful, any error numbers and descriptions, and reports a count of record conflicts in the design master. I was wondering if...