Search results for query: *

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

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.

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

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

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

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

Anyway to have 5/1/2010 minus 4/1/2010 = 1 (month) I am trying to add a formula to automatically caclulate the number of months since the begining month and the current month. This way, when I update the current month in the file, the # of months will automatically update. I.E. when the cell is...

Tried using "CopyDatabaseFile" but get the error of not avilable at this time. I have been directed to make a certain DB public, but I would like to have a backup, so I was looking for a way to have a back up created each time someone opens the database. Copy the database to my...

Question: How do I do a if statement on a main form to reference a field on a subform? I.E. Subform = CP2Criteria Field in Subform = BeginingMonth Field on Main form = CP2BM (unbound) need: if me.cp2criteria.beginingmonth=1 then me.cp2bm="April" else if me.cp2criteria.beginingmonth=2 then...

Any possible way to tell an excel chart to plot a series as a line when it moves from primary axis to secondary? Reason being... Series 1 - 4 are currently (by default) ploted on the primary axis as bars and the remaining 3 series on the secondary axis as lines. I am okay with the first 3 on...

What I am needing to do is a "if and" statement. I.E. =IF(D11="Waste Disposal",E11-M11-O11,IF(D11="Property Taxes"& A11="1105006",ROUND(+E11*G11,20)+20000,IF(D11="Depreciation" & A11="1105006",ROUND(+E11*G11,20)+54000,ROUND(+E11*G11,20)))) Without the "&" portion of each if it works great but...

In excel 2003 how do I do a sumif if i need to have 2 criteria vs one? I.E. Range E1 thu K1 is dedicated to week one Cell: F1 = "A", G1 = "B" and so on (These are "Crews") Cell: E1 = 1 (week number) this changes a Range E5 thru K5 is dedicated to week two, so Cell E5 = 2 and F5 = "A"..... Range...

I am extremely new to CrossTabs and even after searching and trial/errors, I am having trouble getting what I need. To start, I have a table "MADKPI" that has the fields [Group] / [MonthID] / [MAD]. What I need to do is make a query that will list out all the groups in the rows and across the...

Tried using: Private Sub GroupFooter2_Print(Cancel As Integer, PrintCount As Integer) If Me.SubGroup = "Scheduled Time" Then Me.GroupFooter2.Visible = False Else Me.GroupFooter2.Visible = True End If End Sub But does not work. Now, I can hide all the data in groupfooter if the criteria is...

Currently have a macro that runs 3 querys then the report, however each query ask for a set of criteria between [beginingmonth] and [endingmonth] and [fiscal year]. Currently entering the same data 3 times as each query ask for it (2 make table querys) and a select query that brings it all...

Sorry if this is a duplicat post but had a "glitch" and explorer went "mad" for a moment. Having a problem getting a update query to work properly and think it is a simple fix but unable to find any examples to go by. Need to update the field PPM on the table MonthlyPPM with the data from...