Recent content by JaredTaylor74

cool, thanks guys... i knew it had to be something easy like that. 'preciate it. Jared

i have the same thing... on my form that opens first i have this on the load section Private Sub Form_Load() DoCmd.OpenForm "frmDatabaseIdleTime", acNormal, , , , acHidden End Sub hope that helps. Jared

I have a list box pulling data from a table... the column i am having trouble with is called "StopPin" the data entered has this input mask: 9.000 the character to the left of the decimal is not required, but the 3 to the right are, even if only a 0 is entered. no problem there. and even...

Perfect Ken, did the trick. :) Thank you. Jared

Hey all, i have a column in excel with data that looks like this... 15-02BD 15-02T 15-04NP 15-07SSD 15-08NP 15-12SSBD The information I need is the text after the first 5 characters. the BD, T, NP.. etc my column is 8000 long so i'd rather not do it all manually. ;) any formula's out...

in the properties of my list box there is a "column heads" property that you can have yes or no. i selected yes, and it puts headings on my columns in my listbox, they are left justified, just wondering if there was a way to have them centered. if not, no biggie, i was just curious if there...

you don't type the text of the header of a list box... do you?

is there a way to center the headings of a list box?

cool thanks! yep, will always have the same headings, so this works perfectly. 'preciate it. Thanks, Jared

I have a list box who's data comes from a crosstab query, is there any way to adjust the columns in the list box? in the query i can move the "SLIDES" column to come before the "SHUTTLES" column, but in the list box, the "SHUTTLES" column comes before the "SLIDES" column. don't want it that...

cool. works for me. Thanks. Jared

i have a table that has 2 columns that i need to make one. Here is some data in the orig table SetName Base Tooling ToolingType 15-02BD 15-02 1-2 SHUTTLE 15-02BD 15-02 15-02 2A/B SLIDE 15-02BD 15-02 15-02 1A/B SLIDE 15-02T 15-02 27-28 SHUTTLE 15-02T 15-02 29-30...

ahhh... eye sea... ;) thanks PHV later, Jared

drctx, Thank you for the perfect solution. it works great. the only thing i changed was the timer... at 1000, it was recording about 100 records or so, so i changed it to 60000, so i only get 1 record each time. but that was easy. :) one quick question though... why "1048576" on the file...

I have a list box pulling from a query, I want to put this list box on multiple forms and filter it by the moldsetid on each form. I don't want to have a bunch of queries that are the same except for the filter... so i want them all to pull from the same query, just filtered by the form...