Search results

You're right, each new revision could close out the previous. That seems like a much better approach. I'm not sure where to stat with setting up the code that would increment the revison number, close out the previous revison, clear the comments field and copy the rest of the record...

How to What keywords should I be searching on to find similar examples? I can't figure out how to click on a record, have the record duplicated, the revision number incremented, and then have all the revisions show as closed once the final (number 4 in my example) is "approved" Since I'm...

Thank you for your suggestion, it is a much better strategy that what I was planning on using. So would this be the table structure you are suggesting? Basically all the data that doesn't change being in the first table and any data that does change being in the second table. The tables would...

I'm having difficulty designing the structure of a datebase that will track product submittals. My submittal table has the following fields: tblSubmittals: Submittal_ID (Autonumber) (Primary) Type Contractor Description Status Revision# Comments Here's my dilemma. If the submittal is...

Success (No Refresh or Requery) Here's the code that finally works. I had to give up on the Requery/Refresh route. Thanks to all of you for your help. Private Sub OptionGroupSelectName_Click() Dim MyDb Dim qDef Dim DefStringDateSpec As String Dim RSDateSpec As String Dim RSCountSpec As...

It's not that don't want to try the recordsource method, but I really would like to get the method I'm working on to be successful. I think it would be a better learning expierence. Do you think my initial concept is flawed? Someone please let me know if I need to abondon my first plan and...

Still having problems No, I am not throwing any errors. I have tried every combination that has been suggested here and in other forums. Is there a way to manually requery the subforms when in form view so that I can check to make sure a requery is what I really need? By the way, when in...

I'm sorry I should have mentioned that I've already tried the following suggestions and they didn't work either: Forms![MainForm].[Subform1].Form.Requery Forms![MainForm].[Subform1].Form.Requery Me.NameofSubform.Requery I will try the parent/child link when I get a chance. By the way, why are...

I have a main form with 2 subforms. Subform 1 shows the results of query 1, subform 2 shows the results of query 2. Query 2 uses query 1 as a starting point. Query 1 is updated with an option group on the main form. In other words, when I select an option on the main form, qdef for query 1...

Worked great - Thanks for the help.

I got it, finally I was making it too difficult and I also read about the chr$(34) trick to get quotes included. Here is the code that works: MyfileShell = Chr$(34) & "C:\Program Files\Microsoft Office\OFFICE11\excel.exe " & Chr$(34) & " " & Chr$(34) & Myfile & Chr$(34) Call...

Thank you. The information looks very helpful and I will give it a try. I'll let you know if I have any success.

I am using transferspreadsheet to output a query to an excel spreadsheet. I then want that spreadsheet to open automatically. If I code the filename in the call shell command it works fine, as in: Call Shell("C:\Program Files\Microsoft Office\OFFICE11\excel.exe ""C:\Documents and...

I have a tblWorkoutLog which contains workout data (body focus, excercise, date, etc.). I have a listbox (populated from a table) which allows a user to select a/several body focus (arms, legs, etc.). Once the selections are made, a query is created with the IN command to filter based on the...

Worked Great - Thanks Wow, that sure was easy. I almost wish it wasn't so straightforward so that it would give me another reason to learn more code. Sorry I posted this in the wrong section, should've been in the query fourm. Thanks for the help!

I have a database that I use to track my workouts. I am very new to Access and am just starting to learn some simple VBA code. I have the following tables: tblBodyFocus Body Type tblExcercises Excercise_ID Excercise Body Type (Foreign) tblWorkoutLog Log_ID Excercise_ID (Foreign) Date...