Search results

ah never mind I figured it out... had to set it as a control not a string

Ok, but how would you integrate that variable into the last 2 lines of code, thats where Im having the most issues... that and If IsNull(Me.publistList) Then it keeps popping up errors when I try in the case of the isnull it does a improper use of null error and the other 2 lines have...

So this is probably a dumb question but Im having issues getting it set up right. I will be using a certain code multiple times on various forms so Im trying to set it up to be as easy as possible to move it to a different form so Im using more variables then Im used to... that way I can edit a...

well got it working.... not entirely sure why it works now but it does lol I threw in a Me.publistList = Null and everything started working fine, weird. luckily, while I was trying to figure out the issue I found another issue in my code as well and fixed it too lol, there was a problem with...

could it be that you have active content disabled? I know I had to click the top to enable content when loading the first time.

weird... why would it do that to you yet work for me?

If you go into my pubisher list form and edit one of the publishers.... now without closing the form edit the same publisher again See if it bugs for you.... for me if I say edit a publisher named 'test' to 'Test3' 'Test3' will show up on my listbox but when I go to edit it a 2nd time the name...

frmPublisherList updates my tblPublishers, and no I suppose I dont need to have the word Publisher in there as much, its more for me so I know quickly which parts of my code refer to either variables or my table. I'll give option explicit a try, for the most part my variables seem to work...

Ok so 2 questions, hopefully simple ones.... first off Ive started altering my code like you suggested and its going fine, I had to add another variable for some reason, Im not entirely sure why I NEED a Publisher_Edit_SQL but I couldnt get it to work without it for the life of me.... looks...

I was leaving the exit sub for now till I add more forms, so I can add some if statements to refresh whatever forms may need to be refreshed.... I cant enter anything into that sub just yet. Thanks :)

This version only has 1 form but its the form Im working on so that works... Im adding more as I go, I had like 4 in my original version but haven't got them all transferred over yet. But luckily for this question we only need the 1 form lol here ya go, had to compress it since its already...

On the 2nd code above.. I suppose I could remove Case 0 ... its not really needed with the else in case else.... What really bugs me though is I couldnt figure a way to only do the docmd.runsql line once... had to duplicated it since I also needed to check for duplicate entries in the whole...

Ok updated this post... Now I just need some help with making my code look right... unless you see some major flaws. Question about Scripting however... what is more efficient, to set variables only certain things if they are applicable, ie certain criteria are met... or to just set them at...

Well I think Im recovered enough to be off my pain pills mostly, which means im finally in my right mind again. So what Im working on is simple I think... I have a code where Im trying to add a value with vba ... its to a table that only has 1 field that isint an autonumber...Im doing this for...

Sorry for no updates... got sidetracked with a kidney stone... getting it removed monday... lucky me lol

hmmm Guess I can get started on my forms again... expect more questions soon lol

You know what may just be easier... If I treat each Volume as a separate series, then in tblseries I could add in a issuestart and a issueend or something along those lines would probably make everything a lot easier.... would make it hard to know total number of volumes for each series but...

I would add a new tblsomethingoranother and that would have a few fields in it, it would have SeriesID_FK linked to SeriesID_PK, then it would have Volume, then a field like start issue, and final issue Theory being that way I could easily know how many issues were in a volume of a series...

I am trying to get it all right before I get too far into my forms and reports... I only have like 4 forms done so nothing is very hard to change at the moment.... thats why I stopped all progress on my forms and an seriously thinking out what I want in my tables before I go any further... If I...

So, Out of curiosity... Since my current setup bunches all the volumes in the same series... which has merit but if I wanted a way to track for informational purposes the start and end of each volume would I do that with an additional table... in that tbl have say seriesID, then Volume, then...