Search results for query: *

Worked great, thanks!

I have a form (frmvendorshow) with the following fields: vendorname / SAPNumber / Active What I need is to make vendorname a drop down box and once the vedor is selected, the correct SAPNumber and Active to appear. Currently, I keep changing only vendor name and all else stays the same. I...

yes... even when I go to properties, I see "Report Header", "Page header", "page footer" but no "report footer".

I'm using access 2010. Is there a way to insert a report footer if the header already exists? Everytime I click the reportheader/footer it wants to delete my header. All I want to do is insert the footer.

Combo, I have tried several ways with the formula you provided as it looks very promising but having problems. When I put the end "value" of 0159 in cell B1 and the beginning "value" of 0121, the formula returns: -0.0264

Mintjulep, Considering the other option, which is to type not only the colon but also "AM" or "PM", I would think it would not be too much of a burden and am going to go forward with that option. However, unfortunately, those using the file are "hunt and peck" typers, therefore, I foresee...

What would be the suggested way to calculate a time then? We need to be able to enter a start "time" and end time or something of that fashion, quickly. Reason being, to avoid the users from having to spend time to enter each ":" and "am" or "pm" and have a cell auto calculate the duration...

Need to speed up data entry. Currently they have to enter "1" then ":" then "21" then "PM" for 1:21PM and "1",":","59","PM for 1:59PM. This is so the next column can automatically calculate total time of 38min. I was hoping to get it to where they could enter a string like 0121 and 0159 or...

I am currently using the following input mask in Access to allow users to input military time: 00:00;0;_ Is there an equal excel input mask for excel? ... I tried using this in excel but says it is not a good mask and I have been searching but no luck with any of the builtin's. Any help is...

Is there away to find the last record of something in excel? The issue I am having is this... there are multiple rows where data is entered.. I.E. on row 2, color white shows a beginning balance of 300gal and ending balance of 400gal, but then on row 50 white shows a beginning balance of 400gal...

Basically, here is the issue..... 1) data is entered into a table via a form. (table = tblticketform) and (form = frmticketinput) 2) what I am trying to do is have a button that when clicked or "on enter" it will Append the data from (tblticketform) to (tblticket) then delete all the data from...

Think I will leave as is and let them discover this may not be the way to go and deal with it then. but thanks for the suggestios... from what I can tell there are more important items on their "list" that are more function vs "appearance" related that should be higher priority.

I have a continuous form that I have been asked to modify. On the form, there is a drop down box "Material" where they can select a variety of items such as Sand / Cement / Waste / Pallets / Customer. I used the below which works but it causes issues if the first record is "Sand" but the next...

I have been asked to find a way to format the labels at the top of a report on an angle vs just straight across. Currently, the only way I know how to do this would be to create a wordart item in word and import it as a picture but wanted to check to see if there is a way to do it inside...

Below is my current statement: Gross TimeM: IIf([Product ID]="Scheduled",0,([NetRuntime]+[UnschedDelay])/60) The problem is that due to someone's mess up I need to admend this for an exception for this month only. I need to make a statement that has all the following if [Product ID] =...

Thanks! Worked great!

The form's source is table X which has 99.9% of the data, however I would like to include field [value] from the table [tblLocalVariables] in text55 I have tried each of these in the "On Open" event, but none works: me.text55=[tblLocalVariables].[Value] me.text55=[value].[tblLocalVariables]...

How would that work? My bat experience is very limited and long ago. I am almost thinking to split the database, made the FE a mde file. Then have the FE on each computer compare something, like a version number or letter, from something on the FE to the BE and upload a new FE it they do not...

Bad news... I am not able to download - security. Any other thoughts or suggestions?

Any way to deactivate the "Restore Window" icon? I looked through the different posts and found to simply make the forms border style = "Dialog" and deactivated any "docmd.maximize" but when the form opens it still has the restore window option. Is there something in addition to the boarder...