Search results for query: *

Right click the form in design mode and choose sorting and grouping. Choose Location as a sorting field, check group footer. Then put a text box in the footer that will appear, choose client name, or some field that is always there. In the data source for the text box type...

Hi kvest - Now that I've stopped wandering, I've had a chance to read your previous posts a bit more carefully. I think the most important thing you said is that you don't want to invest a lot of time. With that as a given, the Excel link route is still the route I'd suggest. To get the...

Will be back home around 6 Jan, will try to respond shortly thereafter. Access makes all things possible. It even makes them intelligible

I could give you some help, but not for a couple of weeks, because I'm far from home and don't have easy access to the internet. Pse post again if you can wait till early January. Access makes all things possible. It even makes them intelligible

I don't think that SQL can evaluate an inner join within a left join. I think you may need to redesign your tables to allow two left joins. Access makes all things possible. It even makes them intelligible

belovedcej - see that Reuel got there before me. Are you fixed up? You can also use movefirst, movenext, movelast, etc commands instead of GoToRecord. And don't overlook .BOF - another useful attribute. Access makes all things possible. It even makes them intelligible

You could also test the EOF property. Use a Do while not .eof loop perhaps. Access makes all things possible. It even makes them intelligible

DefaultValue property in the help file will sort you out, I think. Here's the example they give: This example uses the DefaultValue property to alert the user of a field's normal value while prompting for input. In addition, it demonstrates how new records will be filled using DefaultValue in...

How much RAM do you have? This has an effect on Corel. Another factor is how many processes you hasve running. Access makes all things possible. It even makes them intelligible

I had a quick look at ini files. I don't think you would be able to do what you want by dll/ini manipulation. You'd have to be able to decompile the native code, I suspect, and I don't think it would be worth the effort, assuming you could get it to work reliably. if you think about it, Corel...

You guys are quite right aboout normalizing. If Knicks decides to take that pain, then I'd suggest that he migrates to a table with nothing but long integers in the fields: RegionID QuestionID ResponseValue Use RegionID/QuestionID as Primary key and put RegionName and QuestionText in related...

It's an Avis/Hertz situation. you can achieve most everything in both, but you get used to one or the other - each have quirks. In kingpin's situation, personally I'd put up with the Photopaint limitations. Nothing would ever persuade me to try to open Photoshop from within CorelDraw. It's a...

This is a job for a Visual Basic module. You need to create a temporary table with 6 fields, RegionId, Severity1 thru Severity5. Then you use code to create a 5 element array, read your base table, sorted by region. Loop through the fields 1 thru 43 in each record, add 1 to the array element...

The quick fix is to link to the Excel file and print it. The more robust method is to use Visual Basic coding to do the necessary calculation to create a temporary table based on whatever data has been input by the users and then run a report based on that temporary table. if you are...

To achieve this, you'd almost certainly need access to the CorelDraw source code - not a task to be lightly undertaken. I guess you'll just have to carry on exporting tif files. Access makes all things possible. It even makes them intelligible

Why on earth would you want to do this? Access makes all things possible. It even makes them intelligible

You're up against one of the limitations of Access. The brief answer is that you have to find each occurrence and change it for yourself. You could search the Internet for an add-in which automates the job to some extent. they do exist, but will probably have a cost. There's really no...

...table first, because it's quicker to do this than to delete all records in an existing table: Sub CreateLocalTable() Set DB = CurrentDb '*** Delete local table DB.TableDefs.Delete "tblOrderedReceived" '*** Create local table Set TD1 = DB.CreateTableDef("tblOrderedReceived")...

I had a look at his website and can think of ways around the limitation, but they are complicated and therefore prone to run time errors. I'm probably going to abandon this quest and get my client to buy one copy of Access 2003 to do just this job. Fortunately they operate a front end/back end...

Hi dhookom - I had a look at Steven Leban's web page. His code works fine for a label, but I can't see how to apply it to a text box, unless I write code to turn the contents of a text box into a label caption, which I think might be slow and prone to error in terms of positioning. Any other...