Search results

Mile-O-Phile Thanks so much, you are the Bomb! I appreciate the detailed explanation. I also want to tell you thanks on a label post you gave a while ago. I use raised images and labels for all my commands in lieu of command buttons now to give it that "web" based effect. Thanks again, Rube

Explanation? Rich, Thanks for the reply. Would you mind elaborating a little? What do I bind the frmActivityInput to? And will this automatically update the PK (StudentID), as well as the StudentActivityID for the activity? On the form where I input the activities, I just need to select the...

Is there a way to add multiple records at one time. Say you have a parent table called Students containing 10 students, w/ the Primary Key StudentID. There is a child table, tblActivity that contains activities for the students. The students are divided in half, groups A and B. Say you want to...

Command Buttons We stopped using command buttons. We build icons with a simple icon builder, then line them up horizontally like on a toolbar, and raise them as a command button when moused over, pressed, and perform an action on release. It gives it more of a "web" type feel, also we got tired...

Thanks for the input John. Good advice. One of our Apps we developed for a present client and packaged and sold it so we have several copies all over the country, since that time we have several updates to it and would like to offer to those that bought it. The biggest thing is we are getting...

Thanks Thanks Pat. May I ask how you handle this or do you have access to your previous Apps. Also, if you are still working on your book, I mentioned earlier how you greatly helped us in the area of Normalization. If you could a chapter in there for real world apps, giving your database a...

What is the best way, or how should one go about handling upgrades and enhancements to a previous Application? For our local customers, we usually just copy the data or table into the new database. I know on the front end, we can just repackage it as there are no tables, or only temp tables...

Thanks for the reply Wayne. Yes, it was the strangest thing, it caught my eye because we are getting ready to deploy this app, and this happened everytime I put in this particular client, which was very close in spelling the first four letters. I did not write it down and have been trying to...

Is the value of the DaysToKeep going to vary? Private Sub DaysToKeep_AfterUpdate() Me.KillDate = Me.DocType + Me.DaysToKeep End Sub

I use a lot of combo boxes to help users prefill information if possible. I noticed yesterday that sometimes, depending on the list, as the user keeps typing it will push the text to the right instead of trying to identify the correct value in the list as you continue to type. I wish I had an...

One more question Pat, I am not sure if you will get/see this or not, but if you would entertain one more question along these lines. Is it better to use an Autonumber or Generated ID? The reason I ask is if you have several tables that feed off of an Autonumber, and the db crashes, and you...

Comparison Thanks for the reply. We use this too, some to change color/border, giving it an Outlook type feel, and others we raise. In this app, we take an image and "turn" it into a button, the speed is the same as a regular button as you said, no degredation, but the command button snaps back...

In an attempt to dress up one of our apps, we have been using custom icons and the Mouse Move/Up/Down to give it more of a "web" based feel where the buttons (images) rise when you mouse over them. We used to use command buttons, but with the custom icons, you would get the "edge ring" around...

In case you need it In case you do ever need it (I use hyperlinks a lot) When you use a hyperlink but don't want to show the toolbar DoCmd.ShowToolbar "Web", acToolbarNo 'Prevent the web bar from appearing

New Form Instead of opening the form in the add mode, with the associated code, an easy way to do this would be to build a new form, and open it in the "Add Mode". It just has to provide a new Primary Key, Title, and image path (depending on your table/form). If there are many images for one...

Example Here is an example I quickly threw together for you, hope it helps, I added a ChangeDate field, to record when the change took place. You would just need to add a call to open the form based on the PK criteria. I will try to add this as a zip file. Rube

Attachment When you submit a post, there should be the option to attach it at the bottom, your file size may have been prohibitive. You might try to zip it next time. Rube

Thanks dcx693, that worked, thanks. txtBox =[cboBox].[Column](1) Would you mind showing the difference M-O-P, or is this way (adding the text box w/source, hiding the combo going to be the quickest?) Thanks again, Rube

Quick Solution One thing you could do quickley is just copy the original table, tblProduct, tblProductChange, same with the form, frmProduct, frmProductChange (using whatever name). Then, just open the Product Change Form when the Change button is pressed. In the tblProductChange, Change the...

More Information Are there pieces in particular you want to record, or just every single item? You could have another table altogether that uses the PK off of the original table. You could then use a subform, or another form (i.e. frmChange), that draws the PK off of the original, along with...