Search results

Thank you Cronk! Not sure why this code worked for Master Jitsu and not me but, nevertheless, you nailed it.

Hello Friends! I've been investigating a method to in-cooperate images to a database I created for tracking manufactured product defects. Thankfully, I stumbled upon Access Jitsu's lesson for using VBA & DAO to replicate the built-in functionality of Access's attachment dialog...

June, Sorry for the late reply as I took a much needed break from Access over the holidays. :) Looking back, you are correct in stating that I'd like to have the users assign a priority on a case-by-case basis. My apologies. I'm still struggling with how to get the claims to print in the...

Pat, Thanks for the reply! I'm going to do some experimenting and I'll report back if I have any questions. Since I posted my latest question, I actually did add a priority column to the tblDefectCount table. I've been playing around trying to make this method work. Glad that you confirmed...

Need to make one more post in order to PM so here it is! :)

Hi June...I'm shooting you a PM.

I know someone here can do a solid and help this guy out! Please!? :(:p

Hope that worked!!! :o

Screen shots of a few items to help in understanding what I'm trying to do... EDIT - Guess I need to post some more in order to be able to upload images. So sorry for the links! :) Edit 2 - See below!

Hey guys, I'm stumped and I'm hoping that you can 'un-stump' me. :p So far, I have a Make-Table Query which, when executed, asks the user to input a mm/yyyy, makes the 'tblDefects' table & then pulls in the info required to perform the 'SortOrder' action on a form which utilizes DB's...

Thanks guys for the help and words of encouragement. If I run into another brick wall, I know where to go to get the help that I'll need.

Oh, please keep in mind that less than three months ago, I had never once even opened Access let alone created a database from scratch. I'm just learning as I go, reading as much as I can and using the advice of fine folks such as you guys.

That's the idea. I have a query that pulls all of the 'Warranty Claims' within a user inputted mm/yyyy. I then have another query that takes all of the 'Warranty Claims' in that set month, organizes them into 'Defect' categories and then sums each specific defect occurrence. I then would like...

Hi DB...I'm still 'debugging' trying to get it all to work correctly. I'm currently trying to get the data, from a query populated report, into a table so that I can use it to populate the 'Prioritize Report' form that is more or less a replica of your demo button form. The 'Prioritize...

DB...one last question my friend. I now have a form where I can set the priorities just as you explained in your demo. Now, how can I utilize this new priority order on the report? Currently, the report is sorting the 'Defects' by 'Defect Total', highest number of Defects to lowest number of...

Fantastic! Thank you!

Thanks DB! I'm going to play around and see what I can come up utilizing your demo. Actually, I do have a make table query that generates and stores all of the information needed for the report. What I don't know how to do is to get the query to delete the previously stored info and add the...

All... Before I wave the proverbial 'white flag', I wanted to ask the 'experts' for some guidance as I'm stumped. Here goes... I'm in the process of creating a 'Warranty Database' for tracking customer claims. At the end of every month, a report needs published detailing all of the claims...

Hi Peeps! First time poster but a long time lurker. Just wanted to say THANK YOU for all of the help that you've given me, even though not personally, over the years. I have learned a ton by reading a lot of posts on here. Now that I've run into an issue that I can't wrap my head around, I...