Search results for query: *

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...

hey guys, I have a database that keeps bloating over 500%, but not all the time. some days it stays the same size for 3 or 4 days then one day it jumps from 89M to 470M. since there is no accurate way to see the table space of tables or the amount of bytes they are using, I am looking to...

Thank you very much PHV, sorry it's taken so long to get back to this... too many other projects. I did use the code you provided me and it works perfectly. trendsetter, thank you for the suggestions on how to use the NOT IN statement in sql. will come in handy very soon i think. Thanks...

AWESOME!.. the easiest things are always the hardest to figure out... lol Thanks. Jared

i have a narrow report but it will list several 100 items, is there a way to have the data move over on the same page instead of going to a new page and wasting paper space? like creating a new column or something... thanks, Jared

excuse my ignorance, but i'm not aware of a NOT IN statement.. is there one? where is it used? here is the code i am using now... which works for what it needs to do, but i still want the available to not show the assigned. sqlAvailableSlides = "SELECT MoldVisualToolNumber FROM...