Search results

Well I found the easier way to do it... but me using lookup fields finally bit me.... Once I modify my program and get rid of the lookupfields, it will work great.

Yea it didn't work. There has to be a way to do this! So I did take the dlookup out of the table. What I did was add 4 new fields to the table (dlu, dluexp1, dluexp2, dluexp3). If dlu is true, that means it needs to do a dlookup function. the ..1..2..3 are the parts that go into the dlookup...

ok the eval() may actually work so what i did was put the full code to open the report with the correct WhereCondition in the table under a field "SpecificIdField" The value of the field is: DoCmd.OpenReport "AirpackHistory", acViewPreview, , "Airpack = " & Dlookup("[ID]", "[Packs]", "[Dept ID]...

I guess I could have written the title better. I'm not executing a command per say. I'm trying to open a report with certain WhereConditions. Each report in the table has a different "WhereConditions". Some of the conditions need to look up information from a different table so I need the...

I have no idea if this is possible, but I think i can do a workaround if it's not. Bear with me as i'm going to try to explain this as best as i can. My program is growing and, instead of creating a bunch of buttons for each report, I decided to create a table containing the report name (what...

Can I declare lngErr and strDesc as global variables so I don't have to declare them on every sub? Or is that stupid to do that?

Ok yea that works now... Is there a reason why it's not working the old way? I'm confused why I have to do the extra coding... the newly declared variables are the same type as well.

Yea sorry... the file I originally sent has the code modified to skip the error... I must have been trying to figure it out and was playing around disabling certain code.... the one I just sent is the one that's broken. After tracing around, it seems like the error actually gets called when it...

I just click on "call / incident" and it pops up with the error... maybe I sent a bad copy of the database that I messed around and disabled something to try to figure out the problem. I reattached the file that I verified makes the error.

I need fix that MVF... You mentioned that in another post I did a few days ago.. Question about that... the form validation code doesn't trigger until the user clicks "Save" on the form. Why would that be causing the form not opening at all if the form validation function doesn't get called...

I didn’t think it had to be because it was in a module. I believe I have other functions that are not declared public in there and they get called from all the forms, and work. I’ll look at it and give it a try when I get back to my desk.

The subs calling for the function are under the "incidents" and "incidents_sub" form. The function is under the Global Function module I will apologize in advance that I'm not as advanced as some of you guys are in terms of design and coding. I know there are a lot of errors and I plan on...

My first thought: "Yea duh, of course I did".... but then I thought: "What a second, Did I?" I checked... yes I do :D

So I found a good function by Allen Browne that records any errors to a table. I copied everything exactly and put the following code into a global module I have in my database: Function LogError(ByVal lngErrNumber As Long, ByVal strErrDescription As String, _ strCallingProc As String...

Like I said before (maybe you didn't see the update as you sent this before I posted it) but maybe it's the way I went about creating the RI's that's corrupting something: creating the RI's before deleting the old data and repair/compacting (doesn't work) vs deleting all the records (starting...

Makes sense. I feels like a bug... but I'm sure I'm missing something ...

So playing around with it more: I have 2 copies of the same database (with the same sample data and no RI's created) Copy 1: I create the RI's (between incident_id & ID and between Personal & ID) then delete the data in the tables and do a compact and repair. Copy 2: I delete the data in the...

Thank you, that seems to have worked! I do have a couple questions though in regards to things you said prior. I heard about not using lookup fields at table level, and I plan on changing that. For now I'm going to deploy the program and work on that at home and update it at the fire dept...

Exactly! The names arnt random. They used to be records before I deleted them... why are they still pulling and from where? That’s where I’m stumped?

Correct, it’s not random and I know it’s supposed to pupulate with the data that’s associated with that ID but where is it getting that data? The tables are empty? Did it create a table in the background that it’s pulling from? If I delete all the records in both tables and create a new...