Search results for query: *

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

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

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

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

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

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

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

I have 2 list boxes on my form. (lstAvailableSlides & lstAssignedSlides) lstAvailableSlides are pulled from tblHardware and lstAssignedSlides are pulled from tblToolingSets i have an "ADD" button and a "REMOVE" button that adds any selected slide from lstAvailableSlides to lstAssignedSlides...

Is there a way to view the size of a table in access? i have several tables and i want to see how much space they are taking up, either in the database or in general. Thanks, Jared

hello.. :) i have a txtbox on an unbound form i want various input masks on, depending what was selected in a few previous lstboxes. i have my input mask strings in a table, i call those on the after update of the last lstbox. the correct input mask is in the txtbox. not a problem. :) my...

is there a way for a control tip pull from a field of a table? i have a form i am building, the text boxes are coming from the feature field from tblFeatures, that table has a featuredescription field for each record, can i have the control tip text show what is in the feature description field...

I have a form that i need to show several different values, some are calculations, others are just stored data. because of this i can not use a query as my control source for my form so i am trying to use sql for each of my text boxes. i have tried several different approaches, here is an...

I know i have seen this before, i've even done it before, just can't remember it right now... i am trying to take 8:43 and change it to 8.72 or 8:30 to 8.5 etc basically changing the time to decimal. i know you divide the minutes by 60... but thats all i can remember... can someone help...

is there a way to have a textbox display the name of the report? thanks, Jared

I pretty sure there isn't a way to do this, but i thought i'd ask, just to make sure... is there a way to have certain fields in a record be a different format in a datasheet form? or should i use the continuous view? i have 4 columns, TransDate, TransDesc, TransAmount, Verified (this...

I have a table called tblMain in which there are several different clients and an amount field, among others... I have a form using tblMain, with a sub form using different filters. (depending on which button the user selects on the parent form, they can see different dat ranges) there are...

is there a way to have two seperate flashing text boxes in a form flash at different intervals? here is what i have in the form timer ... Me.lblIdleAlert.ForeColor = vbYellow Me.lblIdleAlert.Visible = Not Me.lblIdleAlert.Visible that works for the one text box... but i want another text box...

Is there a way to display the password typed in an inputbox as asterix? i have a form that has a button on it, when clicked, the input box asks for a password, if it is correct, another form opens, if it is not they get an error message. just want to protect that password a little. thanks