Search results for query: *

My customers want to be able to change a report's font. I know how to write the code for changing a font based on the results of a combo box, but I don't know how to make a combo box list all the fonts on the user's computer. I know I could just make a combo box listing the common fonts...

I'm designing a cooking database for elderly who prefer to mouse instead of type. I want to build 30 buttons and combo boxes in a small pop up form that have the most common words they'll use to insert into a single memo field on a second form. my form "frmRecipes" reads/writes directly to a...

I have a report that contains several text boxes. Some of these text boxes have an image that goes with them. Right now the report is designed so that whenever there is an image, a rectangle appears behind both the text and the image. The length of the text varies, as does the font size, which...

I've got a database I've built to be stand alone with runtime using Sagekey scripts. Built it using Access 2002. Unfortunately, it appears that the spell check built in to that database is not distributable to Windows Vista. Bottom line: All my customers with Vista don't get functioning spell...

Subject says it all really. I have a textbox in a report within our application - it's set to Can Grow and Can Shrink because the users of our application have to be able to enter in their own text. Looking at a preview of the report with some sample text in this text box, I've just noticed...

I have a piece of software that I've built in Access 2002. It contains many linked image files. (If I embed them the application will be massive.) I am using the Packaging Wizard to create a runtime version for my users. My problem is that when my user installs and runs the application on...

I've seen a similar issue posted back in '04, but there wasn't a solution that helped me, so... I'm in Access 2002 format. I have a form which contains a textbox. My problem is that no vertical scrollbar is appearing in the textbox, even when not all the text is visible, and even when I have...

I'm about to deploy (hopefully) several hundred copies of a runtime version of a database I designed in Access 2002. I'm a little nervous about Vista, though, just because I haven't tested it on the new operating system. This DB will hopefully be used for a number of years. Is it pretty...

I have a database in 2002 format that I need to make into an .mde file, but I seem to keep running into problems. I get it to a point where making the .mde works fine, but I'm still making a lot of changes and updates. It seems like each time I make a change to the forms I have built, when I...

I want to offer the user the ability to change font size in a number of report fields based on the font size selected in a form drop down menu. For instance, when the user selects "Large font", it will convert all fonts in a report to 14 point. "Regular font" makes it 12 points. "Small font"...

I'm using the Northwind method of adding pictures to my database. Problem is that navigating gets really unstable when the user tries to add a jpg image that's more than 600k, even though I'm linking (not embedding). It really doesn't need jpgs larger than about 200k to do the job. Is there a...

my database has a ton of reports that I want any of my clients to use. they are getting a runtime version of Access XP, but they will want to give these reports to others who may not have Access. i want to put a button on a form that will save the Snapshot Viewer program (I believe it's...

using Developer XP/Packaging Wizard, I've made a runtime version of my database. how do I set it up so that any user who installs my ap gets a shortcut automatically on their desktop that links to it? some people seem to have a problem understanding the Start/Program routine.

should be a nifty little ap. however, i'd like to set it up so the user can use it for only 30 days. after that he's got to buy the permanent access code from me or else the software freezes up. i'm not really sure i need to worry about making it super-secret/variable. it'll be pretty cheap...

I need to write a query that randomly selects two records for each customer service rep of an order history table for one day. In other words, if Joe and Keith each enter about 30 orders today, I want to randomly choose two orders from Keith and two orders from Joe in the same query. How do...

I need to convert data for output from standard currency, dates and other types of fields into a format that has zeros. For example: $4.57 outputs to 000457 12/24/99 outputs to 00122499 etc. I need to output them in a fixed width file format. Can anybody help?

I've got a sales analysis database used for outputting several report snapshots. It makes a snapshot for each of 25 sales reps (the report is actually a combination of 12 subreports--fed by several hundred thousand records). Right now I select each rep (Kathy W for example) from a drop down...

I've got a REALLY complicated report that involves about 11 subreports that all print out on the same page. I run this report once a month, and every month it ALWAYS forgets the custom page margins that I set for it, and defaults to 1" on all sides. I always fix it manually, but it's a real...