Search results

Hello, I thought this would be simple. I am trying to divide each unique value in a column by the total column; so sales by total sales . . what am I doing wrong, please? [sales]/sum([sales])

Hello - using Access 2010. I have a select query. Column one is "Zone", Column two is "Sales", and Column three is "Sales Goal". Column two and three are currency. Column four is a division of column two and three - so "sales" / "sales goal". So column four is a percentage. Where I need...

Hello, I have a crosstab query with a column heading of the name of the month. The proble is that when I run the query, the months are not sorted according to their natural progression. Of couse sorting asceding and descending will not work. I would appreciate any ideas. Thank You!

Hi All, I used a code to prevent the user from pressing the shift key to access the menus on the Database. I placed a textbox in a form that allows me to enter a password that would then enable the shift bypass key. Due to some error I don't understand, the form opens up blank with no...

Please delete.

Hi, When I run this code, it works fine, but I get a value of "#Deleted" in the controls. What am I doing wrong? Thanks! If MsgBox("Are you sure you would like to delete History" & _ " from this record only", vbQuestion + vbYesNo,= vbYes Then Dim cmd As ADODB.Command Set cmd =...

Hi Everyone - I have a DB that I need to send out today. I have code that once runs - keeps giving me error "object invalid or no longer set" What does that mean please! The error appears when I try to requery a form that exists and is open. Please help!

Hi All, I have this code behind a cmd on a report. It works great. I would like to offer the user the option to choose a name for the pdf file and allow them to choose where to save the file. Can anyone perhaps provide some guidance on how I can begin to do this. I know I have to envoke the...

Hi Everyone, I have a small issue. I have a pop up from with some command buttons and one textbox. One of the command buttons imports data from Excel into Access - that works fine. I wanted to place a date in the textbox everytime data is imported into the db. The text box is unbound...

Hello - some time back I read on this forum that it is possible that when a person clicks on the Access Icon on the Desktop, when Access Launched, you can have a custom picture appear rather than the standard MS Access Spash Screen. I can't seem to find that thread now. Can anyone help...

Hi All, I've tried several tactics to see if I can check if the workbook in the code exists before running the actual code - I can't seem to get it right. Can anyone please help? Thank You! Rem OPEN WORKBOOK Dim XL As Excel.Application Dim xlwkbk As Excel.Workbook Set XL = New...

Hi All, I have a module in my Access Database that opens Excel and runs an Excel Macro. As it stands now, the user can see Excel opening / closing. I don't want the user to see this. In Excel there you can use appliction.screenupdating = false to prevent this type of thing. I can't...

Hi All, I have a form which looks fine except the data and controls on the form take up about half the size of the screen - so when the user opens the form there is this wide, empty area on the right of the screen. Do I have any design options to remove this w/out making the form a...

Hi All, I can't understand why this is not working. DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, "qryMyResults", "K:\SouthWest\Analysis DB\Weekly test\Book1.xlsx", True The code saves the file, but when I try to open it, I get an error message for an invalid format or...

Hi all, I have a query I am having a tough time resolving. I have a dozen IDs. Each ID is a client that owns 5 different types of Assets. Asset A, Asset B, Asset C . . .ect. I am trying to create a query that would count how many of each asset a client owns. A crosstab query didn't...

Hi Everyone, I need a bit of help with a simple error handles. I have this code in a dbl click event of a listbox. The error occurs when there is no records to match the filter. On Error GoTo MyErrHandler Rem FILTER BY SELECTION Me.Filter = "[StockPrice] = 'UnderV' And " & "[" &...

Hi All, I attempted several tactics but I couldn't figure this out - I keep getting the error. I am sure it's something simple. Thanks for any help! Dim MyStr as Variant MyStr = ">= 0.75" Me.Filter = "[Ratio Type] = 'Acid' And" & "[" & MyFldName & "]= " & MyStr

Hi all, I know I must have the syntax wrong. Also, I am trying to filter a form with a query as the record source. The second filter criteria I have, "Asset Type", is not on field on the form, only in the Query. I am not sure if I have to have the actual field on the form in order to...

Hello! I am not sure how to go about doing this - though I am sure it is an easy issue. I have a Query with hundreds of rows. One of the Fields is Cost Center. In a table, I have two fields, Cost Center and Cost Center Number. I would like to add "Cost Center Number" to the Query. How...

Hi, I am not sure where I went wrong here, but I keep getting NoMatch when there is a match. The record source for this form is a query. Thank you for any help! Private Sub txtFind_AfterUpdate() Dim rs As Recordset Set rs = Me.RecordsetClone rs.FindFirst "[Number]=" & "' &...