Search results

I know there has to be a better way. I use combo boxes frequently whose 0 width, bound columns are integers. When I want to diplay the results (associated text) in a list type format, using a text box, I know I can display the results in a combo box, make my control 0 width, and the it will...

Things to think about I don't have time to look at your code, but we created a similar db, except with Vendor/Product images. We also used a subform on the mainform. A couple of things to think about. 1. Make an "Add Image" form where the source is the same table as your subform, on closing...

Normalization Thanks for the reply, and for the post I referenced, it really did change the way we design our Apps. Rube

Autonumbering Question Pat, if I could throw an Autonumbering question at you? A few years ago I hastily threw together a poorly designed database using the autonumber as my PK. After that time, you replied to a post stressing the importance of normalization, good data mgmt, etc. which I took...

Mile-O-Phile Question Is there an advantage of using the API call over a Common Dialog Box? I normally use Dim varFileName As String cdlOpen.cancelerror =true varFileName = cdlOpen.FileName I was just wondering if there is a known problem doing it this way or the way you mentioned is better...

Hope this helps You can use or modify this to your needs.. We use this in one of our apps, it basically will take an image and copy based on an Autonumber Primary Key to a subdirectory. It pulls the image type (extension), and assigns the name based on this PK. You can clean out the fat you...

Thanks for the replies. In my icon make program, there is a "transparency" setting I use for my background, but I think you are right, it must be the same color as the form background. The image I posted will also appear with the background if I change the color scheme on the computer I designed...

Does anyone know why when I create an icon with an icon maker and put it on a button, it looks fine, unless I go to another machine on the network that has a different color scheme, I then see the transparency in the background color of the computer I originally created it on. Standard Access...

Only when conditional Thanks for looking at it Wayne. I knew I have used this in other Apps. When you wrote me back, it told me there had to be a problem with my app somewhere. I made another copy of the form and got rid of all the code except the delete, same issue. I made another form and...

I have a simple form where I need to delete the current record. I can delete the record via DoCmd.RunCommand acCmdDeleteRecord or using the Menu Commands just fine. DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 The problem...

Hit the Mark Once again, hit the nail on the head! I do appreciate the time you have spent posting a reply to this and other posts. Thanks again Wayne, Rube

Sorry, I thought I attached it.. Rube

Grouping Mark, Thanks for the reply. I left out an important piece of information, I apologize, the reason I went to separate queries, was when a Contact did not have a Class, Activity, etc. no records would show, as long as there was a Class and Activity and ..., it would then show. I...

I have a Main Table for Contacts, on the form for my Contact, I have subforms to keep track of Classes Taken, and Activities, (etc.) which are tables linked by a the Contact Primary Key. I need a Report that will pull the Classes and Activities info. I know I can put the subreports on a Main...

If the Report is already in Preview Mode you can also, DoCmd.SelectObject acReport, "Report" DoCmd.RunCommand acCmdPrint This will give you the option of the dialog box, and should also keep the focus on the Report Preview. Wayne gave me this code and I use it quite a bit. The only thing is...

Is there a way to dictate the icon that appears in the Add/Remove Window in Control Panel? I want users to see our custom icon rather than the standard access icon in Control Panel List. Thanks for any input, Rube

Error# Rich, thanks much! Worked like a charm. Thanks again...

I am running into a problem returning a 0 when there are no subform records. I usually use a hidden total text box at the bottom of the subform, and just pull this to the main form. When there are no records I get an Error#. I have tried to use.. =Nz(Sum([Log]))...

Print Dialog When printing a Report I use the Print Dialog Box. DoCmd.SelectObject acReport, stDocName, True DoCmd.RunCommand acCmdPrint is there a way to insert the Criteria in this case like one would with Print Preview? DoCmd.OpenReport stDocName, acViewPreview, , stLinkCriteria

This will select the report and bring up the Print Dialog Box. The only thing I don't like is it will bring up the database window, unless it is a run-time version. DoCmd.SelectObject acReport, stDocName, True DoCmd.RunCommand acCmdPrint