Search results for query: *

I am using an excel workbook that has a customized data refresh process. To refresh the workbooks contents (several sheets) you would press a "custom Refresh" button that is on the top ribbon. If I manually press the button the procedure runs. When I record a macro to see what the button is...

Hi I have some code that filters and cuts my master file into individual files. The code accomplishes this fine; however, in the NEW files generated - it references the master data file and does not have the filtered data (which is present in the target file). Can someone lend some assistance...

Hi I have some code that filters and cuts my master file into individual files. The code accomplishes this fine; however, in the NEW files generated - it references the master data file and does not have the filtered data (which is present in the target file). Can someone lend some...

I am trying to run a procedure to print my reports but I am getting a Runtime error 3141 - The Select Statement includes a reserved word or argument name that is misspelled or missing, or the punctuation is incorrect. Here is my code: Public Sub RunReports() Dim strRptFilter As String Dim...

When I run my code it runs through the report records but nothing is printing and it is not creating any folders to put the reports into. First it should create a folder for CompMgr and add uniquely named PDF files for each employee. VBA Experts can you please help me with this? Have been...

I could use some help trying to determine why this code is not adding the records to the table: When i run this I get null values... it should fill bx1, bx2, ect. based on the Nmbr field in the table. Sub AddBalls() Dim Bx1 As String Dim Bx2 As String Dim Bx3 As String Dim Bx4 As String Dim...

In Sharepoint Designer I see this code around a field that I need to change the FONT color or even the Field background color. How do I modify this code to show a different font color for that field? <[highlight #FCE94F]FieldRef Name[/highlight]="Plan_x0020_ID"/&gt Any help would...

I could use some help trying to figure out why I am getting a type mismatch error. My code: Public Function GetHit(Digi As Variant, Draw As Variant) Dim B1 As Variant Dim B2 As Variant Dim B3 As Variant Dim Var1 As Variant Dim Var2 As Variant Dim Var3 As Variant Dim Var4 As Variant Dim Var5 As...

Hi I have recently converted my access database tables over to SQL Server 2008 and in the process of converting my queries to views on the server as well. I am having difficulties converting this access vlookup function and could use some help with the SQL Syntax: DLookUp('Close','[ref_Stock...

I could use some help here with this small function. Checked all of my variable names so I am not sure where the zero in the results are coming from. Public Function GetTaxTable(TotalComp As Double, TargetComp As Double) As Double Dim LTIPercent As Integer Select Case [TotalComp] Case...

I am running this function in a query and I am getting zeros as the result which is not correct in all instances. Can you take a look and give me your opinion on the code: Public Function GetEESSI(YTDSS As Double, EstTax As Double) As Double Dim SSIMaxPay As Double Dim SSIEeBasis As Double...

Hi, I could use some help in determining why my TREND formula in Vba brings a differnt result than the EXCEL trend formula. I use the same parameters: (y,x, new x) I use a High and Low threshold value to compare to the Payouts at those threshold levels: Arg1(1) Arg2(1) Arg1(2)...

Hi Can you please offer me some help in getting my code to execute. I am getting a "Compile Error: Arguement not Optional" error. I am using a print button to call my print to PDF function: BUTTON CODE: Private Sub Comp_Statement_Click() DoCmd PrintPDF() End Sub FUNCTION: Function...

Hi, I could really use your help with getting my query to show the option selected in my print options form. There is an OPTIONS group that allows the user to select the currency conversion type to use in the query. The user can choose: Local = 1 USD = 2 Both = 3 I want the selected...

Hi I am not sure how to convert the results of my query so it can chart: Year, Item Type and amount My query results come out like this: Account, Item Type, Year1Amt, Year2Amt,Year3Amt Any suggestions so I can easily chart this in Access report?

I would apprecite your help in looking at this formla and helping to troubleshoot what I did wrong. I have tried many ways to get this to work. ? DLookUp("[Close] ","[ref_Stock Index]","[ref_Stock Index]![stockDate]= #" & [Grant date]+[vestdays] & "#") Stockdate - in the look up table...

Hi I have been trying to piece together some code that would easily allow me to move named ranges (picture tool) images to specific slides in Powerpoint. My excel tabs that has all the ranges is "Copy_Charts". My powerpoint presentation is QBR.ppt. The current Code I am using does a go job...

Hi, Please, I could use som help with a access database connection error. I have a few users who copied the database to their desktops but for some reason they are getting this runtime error -but the file works fine on my desktop: Run-time error '-2147217865 (80040e37); The Microsoft Jet...

I could use some help with a vba database connection error. I have a few users who copied the database to their desktops but for some reason they are getting this runtime error: Run-time error '-2147217865 (80040e37); The Microsoft Jet database engine cannot find the input table or query...

I am not that advanced in coding and trying to modify someone else's code but getting SQL Command Not properly Ended Error. I would appreciate it if someone would help me by taking a look and see what I am overlooking. Here is the SQL Code: select...