Search results

Hello, Im trying to open the attachment menu that you get for clicking on the paperclip and such via code... I want it to open basically when I press a button Ive tried: Private Sub picture_Click() Me.SeriesPicture.SetFocus RunCommand acCmdManageAttachments End Sub But its telling me method...

May of got this one on my own... Im learning lol I have: Private Sub Form_Load() If IsNull(Me.SeriesPicture) Then Me.InsideWidth = 5700 Else Me.InsideWidth = 10260 End If End Sub

ya, I find myself trying to do duplicates at times... a hard habit to break. 2 questions on picture storage in general, on my series picture for instance there would only ever be 1 picture. Does that mean it safe to store that picture in tblseries? Also having played with the paperclip on the...

for the pictures idea you said about making its own table... I coudl use the same table and expand the ability to include series's couldnt I? For instance have 3 fields, picture attachment, SeriesID, ComicID and then fill in the one that it applies to... a blank field wont hurt anything will it...

lol ya I thought I had it planned out but I keep adding :p

to the: Edit: One thing just came to mind. If you're planning on marking a box as being full arbitrarily rather than by the number of comics in it, then yes, you'll need to include BoxIsFull as a field in your Boxes table. Yes... I would need that ability since sometimes I would put in double...

so having thought about what you said on things being easier to do now as opposed to after I have a working database... Ive decided I should add the ability to do a few more things, things I thought after I learned more I may add... or had thought of in passing thinking it would be cool... well...

Im still trying to get my head around this... So in the value table, each comic could potentially have multiple rows in that table then right? Sorry for some reason Im really slow when it comes to understanding whats going on there ... sometimes I catch on quick sometimes slowly I guess...

interesting, thank you As to your comments about value earliar... thinking long term it would be nice to be able to track value from year to year so I could graph increases or decreases in value over the years... "ideally" I could have a form set up when I pull up a record for a specific...

so another dumb question since I just found the 10 commandments lol and wish I woulda read those earliar... :p Thou shalt split thy databases. what does that mean? does that mean just dont do a flat 1 table database? and what are sendkeys and smart codes etc... that im not suppose to be...

oh to answer my own question possibly... is the use of a subreport inside the primary form a possibility?

ya I think Ill use tabs... for some reason I wasnt thinking about alternatives instead I was thinking in terms of 1 form again... wish I could blame that on me knowing excel first like most my problems with this system lol... but I think this was just a case of me being dumb and not thinking...

Ok I read through that and I think on some level I was already trying to figure out a way to do it like that... after I posted here I did decide that having series name, issue, and volume in addition to comic id was pointless since Ive established what comic = what comic ID in another table...

even if thats impossible I suppose I could just delete the series volume and issue from the storage box table... technically I all I need there is the ID number and the box... since I could reference the ID number via tblcomics and know which comic it is. I do still have a problem even if I use...

So Im in the process of working on my database, I have my tables pretty much worked out, what they will do, even some of my forms done now.. However there are a few tables Im having issues with... I have 1 table, call it tblcomics which has the primary key as ComicID, then its next 3 fields...

ah I figured it out for anyone whos curious it goes as follows If CurrentProject.AllForms("frmseriesadd").IsLoaded = True Then Forms![frmseriesadd].[frmseriesadd_pubcombo].Requery End If

Not sure if this is in the right forum but as this is VBA Ill try it here... I have a form that could be accessed from a few different locations and I would like it to be able to requery all those locations on the chance that one or more may be open at that time. I know you can go like this...

I have a few buttons that load a separate form which does various things, then on that form I have an exit button... is there a way to put a macro on that that will not only exit but also refresh all forms that are currently open? I know I could close and then reopen a form before closing the...

ok, thank you!

I was pretty sure the bound column wasnt blank so I figured I would add what you had in stages starting with the Chr(34) and it fixed it right away simply by adding the Chr(34 to what I already had leaving my code: Private Sub Command32_Click() If IsNull(Me.addpub_publist) Then MsgBox "Please...