Forms for Word using different records

[Oldsoftboss]

But, since I really love turning bowls, it's well worth the work & hours - and might even pay for itself!

Thanks,

Stephen

And you get a custom product that does what you want, not some generic program that you have to compromise to achieve the results you want.

Give us a shout when you start on the next phase of your Db

Dave

 

[Splinters]

Give us a shout when you start on the next phase of your Db

Dave

Will do - probably with some more questions!

Stephen

 

[Splinters]

OK, finally got back to this - and found a question!

Dave, I've modified Example to use the txtPreductCode as the key (This is because I need to keep the codes in order in the table and on the query's & reports). Can't get it to drop the need for intPreductID altogether, but that's another problem...

I tried to enter a new picture for a product, and hit an "User-defined type not defined" error for FileDialog in the following code:

Private Sub cmdAddImage_Click()
On Error GoTo Err_cmdAddImage_Click

Dim dlg As FileDialog

On searching I found that FileDialog isn't valid Access 2000...Guess I should have mentioned I'm using that version.

I found a number of workarounds, but they are very long and convoluted - any suggestions?

Or, another way - probably much easier - would be to simply concatenate the txtPreductCode I am using as the key into a string with the path, and append the ".jpg" on the end - and eliminate the txtPreductImage field entirely. Since it will just be me using this, and I can easily load the photo into the folder, this might make more sense. In fact, it occurs to me that it could be useful to put the path text in a table - then I could change it as I needed to.

Anyway, if you can suggest a fix on this it would be appreciated.

Stephen

 

[Oldsoftboss]

You can use the Common Dialog box to do the same thing, just that the file dialog box is much easier to use as you dont need an extra module. I will do the above Db with the common file dialog, but if you have made bulk changes, post you latest effort and I will update that.

Dave

 

[Oldsoftboss]

On a second note, have you set a reference to OFFICE 10 object library (not Access 10 Library)

Dave

 

[Oldsoftboss]

Using windows common dialog.

 

[Splinters]

You can use the Common Dialog box to do the same thing, just that the file dialog box is much easier to use as you dont need an extra module. I will do the above Db with the common file dialog, but if you have made bulk changes, post you latest effort and I will update that.

Dave

Here's the current file - I did add a dummy image path for any record without a bowl image.

And I checked the reference list, no OFFICE 10 object library listed. I am working with the standard version of Access 2000, so it may be something in the pro version.

Also, the Example5 file comes through as a php, not a zip.

Thanks,

Stephen

 

[Oldsoftboss]

Not sure whats going on with the PHP

Try this.

 

[Splinters]

Try this.

Nope - same error.

Access 2000 doesn't use FileDialog, that was implemented in a later version. And like I said, the examples of how to do it in A-2000 are a bit overwhelming at my stage of VBA programming.

I'm thinking the best course for me at this point would be the dynamic loading of the filename with the product code - it should be a clean way, and I really don't need to have to wander around trying to remember "where that image is". For this, it's all going to follow a pattern, so might as well use that to best advantage. I'll always load the picture I want in that folder, so if it can be automatic so much the better.

I should have all weekend to get this to a higher stage, but the dogs are insisting that that's it for t'night.

Thanks for the help, it's a great service - and I really do like keeping what hair I have left!

Stephen

 

[Splinters]

OK, just tried the "new image" from the main product form - and it worked!

I'll check the code in that section in the morning.

Stephen

 

[Oldsoftboss]

Opps.
Changed the code in the products form, but forgot about the "Add New Product" form.

Dave

 

[Splinters]

Opps.
Changed the code in the products form, but forgot about the "Add New Product" form.

Dave

Dave, you do great work - now you've removed all my justifications for not getting the rest of this thing done...Sigh

"Yes, dear, I'm working on it!"

Thanks ,

Stephen

 

[Splinters]

Dave, I've spent most of the week working out the bugs, and finally have close to what I need.

Somehow, I'd forgotten how intense this sort of activity can become... But, on the other hand, it can also be very satisfying when it all falls into place...

I tried attaching the demo, but it seems it is too big - so I have uploaded it to http://www.splinterscraftworks.us/demoCopySplintersDataBase.zip.

What I have is a simple system that ties all of my current tasks into one foundation. I still have to add suppliers and vendors, plus a few small tweaks, but it does seem to function pretty much as I need.

The wood data has been stripped to reduce size - since we are not looking at that area now.

A couple of problems that do still remain:

When the bowl inventory form frmSplintersProductsBowls first opens, the mouse wheel can scan the records - but after I select a record it won't. Also, the scroll bar seems to not do anything!

The other problem, most important, is that the printouts are all centered in the page - the vertical spacing is spot on, but I can't seem to get 2 columns to show. (Just ignore the text formating, still need to fix that.)

Also, I found that the original forms allowed me to make changes to the records - sometimes when I didn't want to change that record! So I added an "Edit This Record" form and disabled the fields in the main form. But that grays the text out and is harder to read. Is there a better way to do this? Perhaps some code to detect when text has changed and ask it that was intended - before it gets saved in the record? This is especially important when a bowl ID code is changed.

And, can I make the image a link - so that clicking on it would bring up a larger image? That would help.

If you need to strip everything except forms containing any changes to send it, please feel free to do so - or just tell me where I need to make them.

BTW, is it possible to reproduce the bowl form as a web page? Don't code it, just a hint will be fine. I never expected as complete an answer to the first question as you provided - saved me a lot of time, thank you.

If you see some other changes that might make this more functional, please let me know.

Thanks,

Stephen

 

[Oldsoftboss]

Will have a look

 

[Oldsoftboss]

Quick one (or two)

In the main menu properties, put something in the "Caption" field. This will stop the display of frmSplintersFrontEnd: Form

Set the "Record Selectors" to NO. This will remove the bar on the LHS

Set the Scroll Bar property to neither. This will get rid of the grey colored areas on the RHS and the bottom

And I always set the Border Style to Thin

 

[Oldsoftboss]

When the bowl inventory form frmSplintersProductsBowls first opens, the mouse wheel can scan the records - but after I select a record it won't. Also, the scroll bar seems to not do anything!

This is because the focus is on the listbox, not the fields in the form

The other problem, most important, is that the printouts are all centered in the page - the vertical spacing is spot on, but I can't seem to get 2 columns to show. (Just ignore the text formating, still need to fix that.)

Once the report is open, right click and select Page Setup. Set the left to about 10
2nd Tab – select A4
3rd Tab (Columns) No of Columns = 2, Column spacing – 0.3cm

Go to design view of the report
In the report design, move all the fields to the top, and drag the Page Footer bar up as far as it will go.

You can push the display around using the properties in the Page Setup

Also, I found that the original forms allowed me to make changes to the records - sometimes when I didn't want to change that record! So I added an "Edit This Record" form and disabled the fields in the main form. But that grays the text out and is harder to read. Is there a better way to do this? Perhaps some code to detect when text has changed and ask it that was intended - before it gets saved in the record? This is especially important when a bowl ID code is changed.

See What I did…

And, can I make the image a link - so that clicking on it would bring up a larger image? That would help.

Done. Double click on the image.

BTW, is it possible to reproduce the bowl form as a web page? Don't code it, just a hint will be fine.

Probably, but when you search here for that sort of stuff, there isn’t much info.

See what you think....

Dave

.

 

[Splinters]

This is because the focus is on the listbox, not the fields in the form

Makes sense...should have seen that one...

That works, the reaction to the scroll move is a bit slow - may have something to do with the size of the table, over 100 bowls.

But the mouse wheel still has no effect - is this normal for Access?

Once the report is open, right click and select Page Setup. Set the left to about 10
2nd Tab – select A4
3rd Tab (Columns) No of Columns = 2, Column spacing – 0.3cm

Go to design view of the report
In the report design, move all the fields to the top, and drag the Page Footer bar up as far as it will go.

You can push the display around using the properties in the Page Setup

I made these changes to the price card report, worked just fine - after I realized that you meant the left to be set at 0.10, not 10.0!

The horizontal looks great now, will tweak the vertical on the description cards.

See What I did…

Yep, this is a lot better. I tried locking & enabling separately, didn't think to do them both.

Done. Double click on the image.

OK, just what I wanted - another "If I'd just thought about it a bit longer...".

I think I'll have it go to a form instead of going to my default image viewer though, shouldn't be a problem now. I'll also want to strip the "tmb.jpg" & substitute just a ".jpg" so it will show the larger image - again, no problem now that you have shown me the way.

Probably, but when you search here for that sort of stuff, there isn’t much info.

See what you think....


Dave

.

Yeah, I was hoping that I could just dump the bowl directory form into the web page feature of Access - something to look at this weekend while it's raining.

OK, thanks again for the help. I should be able to get this fully functional in a few days - which is good 'cause I need to get some products to the galleries before the Christmas season begins...from what I saw at the mall the other day, I may already be too late.

Stephen

 

[Oldsoftboss]

That works, the reaction to the scroll move is a bit slow - may have something to do with the size of the table, over 100 bowls.

But the mouse wheel still has no effect - is this normal for Access?

If you search here for mouse scrolling you will find that most people are trying to stop the mouse scrolling, so I am suprised that yours doesn't work??

 

[Splinters]

If you search here for mouse scrolling you will find that most people are trying to stop the mouse scrolling, so I am suprised that yours doesn't work??

Well, this is the mouse wheel, not the mouse itself. The mouse seems to work fine now.

I'll do some searching later for info on it - not a great problem.

Right now I am working on getting all the photos & text for over 100 bowls into the DB so I can make the cards & get (some of) them to the galleries. Lots of fun... - and I really could use a spell checker in the text! Anyone have one that will work on text boxes in Access?

 

[Oldsoftboss]

I really could use a spell checker in the text! Anyone have one that will work on text boxes in Access?

Where would you be without me..

When you have a form open, right click on the menu bar at the top and select customise.

Select the Commands tab

In the Categories listbox scroll down and select Records

In the Commands listbox (RHS) scroll right to the bottom and find spelling.

Drag and drop this icon onto the menu bar at the top (beside Help)

Done!!