Search results

Froth as for the wishlist, honestly I was considering adding two fields to tblseries call them say wishliststart and wishlistend that was one of my solutions before I asked on here :) and rain, ya the title may be a good idea, not all have em but some do, I honestly dont ever notice em but...

so if I wanted a wishlist the best route would be a new table for it?

so how does this look?

what about all unowned comics from a specifc series and a specific volume number? lol that would be the ideal way to have a wish list and ya I guess I can see where that would be better... just have to get used to the idea lol

since Im redoing a few chunks of things question on how you would approach something. Say after its all said and done I would like to be able to print off a report of what comics Im missing from a certain volume, also be able to print off between ranges as well in a certain volume then Id like...

so basically the priority is to minimize database size... not worry how many processes the db has to use to complete an operation... For instance if I had in tblseries the publisher name itself when I made the form for that series they db would have to access that record, then read the...

Ill change my system to match this... I still don't understand why certain things are necessary but Ill just get used to doing it till I do understand it all lol.

I guess I should change up how my tbl publisher interacts with tblseries then too atm tbl publisher only has 2 fields: ID, and Publisher Then via form when setting publisher in tblseries my form makes a list by listing off all the fields from t he publisher column in tblpublisher So I should...

ok I figured out my previous question... basically what it does when Im looking at the various storage boxes available it allows me to see the total boxes of that type available as well as the capacity of whichever box I have selected at the time... Heres the code Private Sub list_Click()...

oh just in the table itself I hid that column so I wouldnt see it... its not something I use Thanks for that code btw frog I'll change mine up with it, its handy :) ty

ya sorry ID is primary Key... I know its needed for access, I just wont be using that field so I have it as a hidden field.. Say in my series form, I wanted to have a box that listed how many comics I have in that series, what would be the best way to show in that form how many instances of...

Ok I figured it out and if someone selected cancel then it would set it to null but there was no way to select nothing and click ok, thats fine though I just went ahead and added more more command button and set it to delete picture that works just as well... heres my code for my pictures...

ok... check that question I think I figured it out mostly, I really am getting better then I realized lola lil googling to get me in the correct direction and Im learning how to edit code more and more... The following code is working well, I click the add edit picture it brings up a file...

So in an effort to find a better solution to having a picture but not having access store them I tried using a regular short text field and typing in the filename and directory into t hat txt filed, then using that as the control source for a regular image in the form design screen. That would...

basically I woudl want it so that you could quickly see what something was about without having to open the file... that way you could go through many files quickly looking for the correct record to open

Im unsure if this is even possible but no harm in asking... So I have a listbox full of stuff, is it posisble that if one of those items were hovered over that a popup form like a tooltip could popup showing an image or a description? I have both image and description in a table so the info...

Ok running that didnt work since when I made my attachment element invisible I couldnt access it causing an error if I ever wanted to click the button to add a picture... I solved thsi by adding a 2nd attachment element into the form also linked to the same place, however I made this one tiny...

this is the code I used to achieve what I was talking about above... if anyone sees something horrible please speak up lol Private Sub Form_Load() If IsNull(Me.SeriesPicture) Then Me.InsideWidth = 5700 Me.Picturescreen.Visible = False Else Me.InsideWidth = 10260 End If End Sub Private Sub...

ok sorry about the thread that I solved myself... just figured that out too... that was more simple then I realized... the first I think I got lucky figuring out... in case anyone was wondering the answer on the 2nd was this: Me.Picturescreen.Visible = False Nothing I hate more then when I...

wow that was fast my next try got it so that first question is done... answer was: Private Sub picture_Click() DoCmd.GoToControl "SeriesPicture" DoCmd.RunCommand acCmdManageAttachments End Sub