Recent content by elbowman

Beetle, Once again you come through for me! Thanks so much! Must go put children on buses...Sigh. Lance

Beetle you were probably wondering what happened to me. I thought I attached my db file, but apparently it was too large, and I didn't see the error message. Here's a zipped file that gets under the size wire. School starts tomorrow! We're SO busy! See my original note, above. Lance

Here's where I am so far, Beetle. I tried doing your suggestions, and I've obviously screwed up the SQL in the Issues query. I'm up to a$$ in alligators, and will check back with you as soon as I can. Thanks! Lance P.S. Beetle you were probably wondering what happened to me. I thought I...

The school year is growing ever nearer, and my plate is filling fast. I tried adding your suggested corrections, and met minimal success. The suggestion for item #1..."I didn't catch that before, but I have the same issue with the copy I have. I was able to resolve it by repeating the macro...

Beetle, Two issues related to this change. One, in the IssueNew form if I exit the saved form and then go back into the record the Category field appears blank, and Priority retains it's selection (either Minor or Major). If I click in the Priority field, then the value originally...

Problem resolved! I can't believe what the head-banging problem was all along! A misplaced = sign. In the Priority field macro I had an equal sign preceding the Control Name in the Requery portion, Control Name =[Category]. Removing the equal sign so it was, Control Name [Category]...

I don't know how I get myself into these things! :banghead: I think I've done everything you suggested. I edited the Category field to include the ID column. I edited the Issues table to include the Priority field from the Priority table as a number field. I edited the Issues table to...

First, we're still in the testing phase using dummy data. Second, Priority and Category tables are setup like in your example with integer and string portions in separate columns. Priority is a two record table, with IDs 1 and 2 relating to strings, Minor and Major. Category is a four column...

Remember me, Beetle?! Since I work for a school district things had stopped on this project you helped me with over the summer. Now, a new school year is approaching and my boss has thrown a new feature request at me. Since I got myself in trouble with this template previously by changing...

Tip....When you're working on Name/Data macros and struggling, like I was, you will see at the bottom of your table a notice that there are errors. Click this link to open the database's System Application Log. You will see a table that lists all the errors being thrown and where they are...

Success!!! :D Beetle is da' man!

We had a work emergency today, so I'm not going to be able to work on it. I'll get back with you, hopefully, tomorrow. Thanks!

Sean, I'm stumped. The error log reports the Email is erroring in the Named Macro, Issues.EmailToAssigned. It says, "The identifier '[varTransAdmins]' could not be found." in the context, "SetLocalVar varTransAdmins, [varTransAdmins] & ";" & [Users].[Email]". There is no statement...

Sean, I received the database last night, just prior to the end of my shift. I didn't have time to do anything but extract the zip, and take a quick look at the macros, etc. This morning I loaded up my test record and clicked the Email button to see what would happen and got errors. I'm...

Sean, I think you attached the wrong zip file. Thanks so much for all your help! You are correct I was working with a Microsoft Template file. Being a real rookie, as I'm sure you could tell from my footprints in the template, I didn't try to change too much in fear I would break...