Search results

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

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

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

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

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

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

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

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

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

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

Is it possible to manipulate the command button icons that come as the standard choices for a command button? And are there more than the standard list you get when you use the picture builder? Thanks for any input... Rube

We are getting ready to deploy an App tomorrow. Right now we are just using the Packaging Wizard with Dev Ed. It works fine, but every App we have distributed comes up with an error at the end of the installation. Path/File Access error. An unexpected setup error has occured. After this you...

I read a good post about registering multiple ActiveX components where they suggested you copy/register all ActiveX components to make sure a broken reference doesn't occur. My question is, if one does this, do you risk the possiblity of overwriting an existing file and making another App...

I have a Code that pulls the Executable for an External Program. When I try to run the program, it runs just fine, but does not pull the actual file, though I know the path is correct. (i.e. P:\Image\Compaq Presario 1200.jpg". If I append the filename, "P:\Image\Compaq~1.jpg", it works fine...

I have a box that is a calculation of a line item, [txtPrice],[txtPercent], and [txtQuantity]. This is called the line item total. This form subLineItem, is a subform of frmTicket. The problem is the calculation differs depending on if it is a wholesale or retail base price. Is there a way to...

We have a database that populates an ImageBox. The problem is, if the user jumps back and forth between images, the program will eventually just close even with Error Handling (though I must not be using correct EH). Is there a code that could force a delay before allowing another selection...

Does anyone know the coding for the MSCommon Dialog Box? I would prefer this over the accmdprint. I just cannot find any coding in any reference or on the web. I want to print a Report.

How do you use the Print Dialog Box with a Report? I do not want to put the code in the report itself. I added a Common Dialog Box, and it works, except if the user hits cancel, it then prints anyway. I have about 8 good Access Books but they do not discuss the Print Dialog Box except in...

How do you use the Print Dialog Box with a Report? I do not want to put the code in the report itself. I added a Common Dialog Box, and it works, except if the user hits cancel, it then prints anyway. I have about 8 good Access Books but they do not discuss the Print Dialog Box except in...

I have a multiple category query. Each field is assigned criteria from a Function. The five criteria from the Query Form, are not all required, so if they are marked "Not Selected", I want to accept all records for that field. In the query I have ProductCategory1() In the module, Function...