Recent content by benh76135

My force it to work method does function, I only have 6 color options right now, and its not hideous. I was going to post a pic but I dont have a way to link it. man, i just needed to scroll down and read. i'm better than that, thanks. i was just looking at the quick link picture icon above...

Five minuets after I made post I thought of a crude way to do this. I added another field called setcolor to the table for the list form which does translate to the detail data form and then put that field in the back and stretched it out and used conditional formatting on it. liek i said crude...

This is another odd question that I think is not possible, but have to ask. I am going to try and leave out as much info as i can to keep this short. In Mainform , I have List Sub Form and Detail Sub Form both subs are in continuous form view List form changes from week to week and can have 1 -...

yea i use goto, sorry very old habit from learning basic on ms dos i left out the colons when i was retyping in message i did try statics idea, the nz gave me nothing literally, so it didnt compair. some po numbers do have multiple part names on their po number, and i think that is what...

I'm not sure how to see if anyone has done this yet. I searched a bit with no results. My work log form has had a flaw pop up mostly due to the end users being dumb in my opinion but i know it can be programmed around so now to do it. the form works like this : hit some buttons to fill in...

I get what you're saying there. After update knows there is a change and on timer has to look for a change. Makes perfect sense. I'm kind of stuck right now I haven't had time to edit into my backend all the extra fields on main tables. Will have to do it after hours and im planning on buying a...

Honestly I hate posting on forums because it seams like an argument, I try to stick to just reading them. :( Yes everyone uses a front end switchboard that i call a startup form, which leads to forms to enter data. The back end tables are not viewed directly by anyone. If it helps, the back...

For an example to answer the first question..... Owner1 enters a purchase order for an item that does not exist Owner2 is supposed to create that item, and update. Guywhodoeseverything<me> comes in and edits that purchase order Log would show that I was the last person to edit that record...

After looking at how a few change logs have been made. I'm thinking of a different way to do it. Effectiveness aside, I can test it to see how it runs. My current idea is to have all the tables on my backend "worth checking" to have a user and date/time field added. Then run a query to find the...

I found the problem ,,, or a solution which ever you want to call it. I wish it was a lot more amazing but. i swapped the location of two fields . So very dumb I didn't realize this out 4 working hours ago. here is the fixed sample

Sure thing, I rebuilt it into a simple file. 2 tables to store the data, a query that consolidates it and adds a field for the label on the report, a form for entering and editing the data > i actually use other forms to automatically enter data and this form is for adjusting the report < , and...

I really didn't expect a reply because i have not found anything searching for this problem. The report in print preview seems to just order stuff how it wants to. half of the bars are stacked correctly behind, and half are stacked incorrectly on top. All the grey should be a background ruler i...

I got the design awhile back from someones demo for access 2000 I believe. I've managed to re-program it a lot to get what i wanted, all I'm missing is this small appearance problem. Does anyone know how to order objects to stack in vba. I have the grey bars sent to back in design view. They...

i use office 365, so yes newest version of access. I've messed with the mouse move and other mouse events. caused me problems.

in this instance I'm probably not following normal structure, but it is the only way i can think of to get the idea started before adjusting it to be more efficient... I have such a large program at the moment it confines me on how i can program this feature. i did adjust my starting query to...