Forms for Word using different records

[Oldsoftboss]

Or you could just press F7

 

[Splinters]

Or you could just press F7

Yeah - much easier!

Wow, I never realized that Access was this powerful! And to find such helpful folks in the bargain...I am indeed blessed.

I did some searching and did find that I can make a web page from scratch, or export the form to an existing page template. Haven't tried it yet, will let you know how it goes.

Stephen

 

[Splinters]

OK, one other quick question - I changed the Multi Select property in List0 of the Bowl page and I can now select all the bowls listed.

But how do I get it to copy all the selections to List2? I tried dblclicking, won't work.

I want to be able to do this so I can get a complete catalog of all the bowls. A lot harder to dblclick every one of the 100+ bowls every time!

I'm thinking that I could do a query to get the fields for all, then just build the catalog report directly. Or is there a way to put a selection option next to the list0?

Something like are on the import selection forms:

> Copies multiple selections
>> Copies all records


I was hoping there might be something like that in the extended controls, but don't see any - but some of the descriptions are a bit cryptic...

Stephen

 

[Oldsoftboss]

On the web subject - if you search for Data Access Pages (Accesses version of a web page) you wont find much info. I have tried several times, but the look very ordinary.

As for the multi select, I put arrows inbetween the list boxes.

I have an example here somewhere.

Dave

 

[Splinters]

On the web subject - if you search for Data Access Pages (Accesses version of a web page) you wont find much info. I have tried several times, but the look very ordinary.

As for the multi select, I put arrows inbetween the list boxes.

I have an example here somewhere.

Dave

I looked at the stuff I found on DAP - and it looks like a bit of work... I do know HTML, CSS & JScript fairly well, so I think that's looking like the best route for me on that. For one thing, I am getting the impression that exporting an Access form or report only transfers the text - not the graphics - so there is an obvious problem there. Also, I remembered that my server - run by a nephew and provided for free - is a LINIX machine, and I think he told me once I couldn't put any MS specific stuff on the server - and I understand that DAP is very much MS only.

And I wouldn't be having a direct link to my database anyway, just upload the current data & photos, so I don't see much advantage to going through Access.

I am still interested in what you have on the arrows - sounds exactly like what I need.

Stephen

 

[boblarson]

On the web subject - if you search for Data Access Pages (Accesses version of a web page) you wont find much info. I have tried several times, but the look very ordinary.

And just as an FYI, for anyone looking here, DAP's are not available in Access 2007.

 

[Oldsoftboss]

And just as an FYI, for anyone looking here, DAP's are not available in Access 2007.

Microsoft must have finally realised they were a ridiculous waste of your time.

 

[Oldsoftboss]

Getting back the the Db, I added the buttons as I mentioned before. The example I had didn't really do what I thought.

I also have an example of how to dynamically move items up and down a list, rather than having to go through and number each item. I will TRY (not sure how I will go) and incorporate this somehow.

Dave

 

[Splinters]

Getting back the the Db, I added the buttons as I mentioned before. The example I had didn't really do what I thought.

I also have an example of how to dynamically move items up and down a list, rather than having to go through and number each item. I will TRY (not sure how I will go) and incorporate this somehow.

Dave

That looks great, Dave - just what I needed.

Thanks,

Stephen

 

[Oldsoftboss]

The next update.....

In the Print order form we now have a listbox. The LHS column shows the sort order. If you add, then remove, then add, then remove items when selecting on the first form the sort order wont be sequential, but is an order. I left this column shown, but I suggest setting its column width to 0 after you see how it works.

Dave

 

[Splinters]

The next update.....

In the Print order form we now have a listbox. The LHS column shows the sort order. If you add, then remove, then add, then remove items when selecting on the first form the sort order wont be sequential, but is an order. I left this column shown, but I suggest setting its column width to 0 after you see how it works.

Dave

OK, that seems to work. Don't really need it with the description or price cards, since they are separated and placed with the specific bowl, but might be handy to have for the catalog, when the sorting hasn't quite got it right.

Thanks,

Stephen

 

[Splinters]

OK, Dave - sorry to bother you but I've got another problem.

I want to add the image of the current selected bowl in frmPrinting, to be sure that the bowl I want to print the card for actually has a valid picture - just as in frmSplintersProductsBowls.

I copied the image field from frmSplintersProductsBowls, then the code for the Form_current property from frmSplintersProductsBowls to frmPrinting, created an event link on Form_current in frmPrinting and copied that code from frmSplintersProductsBowls.

I get an error message that the "|" specified can't be found.

Here is the code in the form_current of the frmPrinting module:

Private Sub Form_Current()
On Error GoTo HandleErr

If Not IsNull([txtProductBowlImage]) Then
Me.Image6.Picture = [txtProductBowlImage]
Else
Me.Image6.Picture = "C:\BowlPhotos\Thumbs\NoBowltmb.jpg"
End If

Exit Sub

HandleErr:
If Err = 2220 Then
Me.Image6.Picture = ""
Else
MsgBox Err.Description, vbExclamation
End If

End Sub


I tried creating a List0_Click event in frmPrinting, using the same code, and got the same error.

As far as I can see, these forms are almost identical - why does it work in one, but not the other?

Thanks,

Stephen

 

[Oldsoftboss]

This is because the code is looking for the field [txtProductBowlImage] which is not on the form.

I inserted an extra column to the RHS list box so the rowsource now reads:

SELECT qryPrintProducts.intProductID, qryPrintProducts.txtProductBowlImage, qryPrintProducts.txtProductBowlCode AS Code, qryPrintProducts.txtProductHeading AS Product FROM qryPrintProducts;

Column Count: 4

Column Widths: 0cm;0cm;2.403cm;0.51cm

Then added code to the "After_Update" event of the listbox:

On Error GoTo Err_List2_AfterUpdate

If Not IsNull(Me.List2.Column(1)) Then
Me.Image6.Picture = Me.List2.Column(1)
Else
Me.Image6.Picture = ""
End If

Exit_List2_AfterUpdate:
Exit Sub

Err_List2_AfterUpdate:
If Err = 2220 Then
Me.Image6.Picture = ""
Else
MsgBox Err.Description, , " Splinters DataBase"
End If
Resume Exit_List2_AfterUpdate


Also if you add a label that says "No Image Available", position it over the image frame and go Format -> Send to Back, then when no image is available the label will show.

Dave

 

[Oldsoftboss]

You could do this to the LHS Listbox also if you prefer.

 

[Splinters]

OK, I tried that - and it didn't seem to work - but no errors.

I copied the code to list0, on click, same thing.

I suspect it's not finding the right path to the image yet...I'll play with it a bit in the morning (it's about midnight here & I've been up since 6AM) and get back to you on what I find.

Thanks for the fast response,

Stephen

 

[Splinters]

I just did a quick hard code of one of the images - and it worked just fine.

I'll fix the path in the AM.

Thanks

 

[Oldsoftboss]

Did you update the row source of List0?

 

[Splinters]

And that did it! Again, many thanks.

Stephen