Search results

Hello, I am trying to update a continuous form with multiple records with a unbound text box. I have tried the following on click event and I am only updating one record on the continuous form. Here is my on click event vba: Private Sub cmdarea_Click() Area = txtupdate End Sub Any...

Hello All I have a question. I currently am using Access 2007. Basically I have a excel report I receive from another dept with incomplete data. I import the excel to a table I call Lease. The Lease table has 3 fields, ID (Auto-Number) Equipment (Hardware Description) SerialNum...

Hello, I am trying to edit my query and keep getting the error Record set is not updatable. Is any one able to assist me with this issue Here is my sql SELECT Inv.[ID], Inv.[Area], Inv.[Hosting], Inv.[Type], Inv.[Ser_num] FROM Lease INNER JOIN Inv ON Lease.Serial = Inv.Ser_num; Thanks

Hello all, I have a question I have table with the following fields listed below Inv () ID Area Hosting Pc_SN Montior_SN Montior3_SN 1 Houston d13 1 5 9 2 Houston d18 2 6...

Hello all, I keeping a the error (Access can't find the 'FrmSearch' referred to in your expression in a form) Can anyone point me in the right direction. Here is my code: Private Sub Search_Click() Const cInvalidDateError As String = "You have entered an invalid date." Dim strWhere As...

Hello, I am using Excel 2007 and I have about 20 pivot tables on my sheet. I am using a Microsoft Query to get me the data I need form a Access Database. But, everytime I refresh the date groups I set up ungroup and some of the data I select in the dropdowns reset. Is there a way for me to...

I keep getting the run-time error 3709 when I run this code. Can someone help me figure out what I am doing wrong. Private Sub Text114_Click() Dim ar As adodb.Recordset Set ar = New adodb.Recordset ar.Open "SELECT Count(1) AS Total, tbl_referral.[Prod Specialist #]" & _...

I am working a school project which is a simple split database with form that performs many calculations. Currently, I am using Dlookups but it is very slow in processing, is there a quicker way to perform these calculations or a better approach at stream line my code. Here is my code...

Hello all, I am trying to build a simple search form which will allow a user to enter a product id, perform the search and then and open another form with product details but every time i try to run it i get the 2501 error and it does not open the form. The Product ID is 9-15 digits long...

I have a question I have a pivot table which has you can drill down by month in it. What I would like to do is click a button and make it select the next month with me selecting it. Example the pivot table is show May's Data I click a button and the the pivot table selects June. Is that...

Hello all, I need some help with my code. I have this code on the after update in a text box called Text0. What I am trying to do is have the user type in their ID number and the code will run summing up certain fields and display them in other text boxes in on the form. The problems I am...

Hello all, I have a simple table called tblProductCode, with three fields Product, Payout and Value. What I am trying to do is write a simple If statement that will check to see if the cbo box Approved has the word “approved” in it and also compare the value in txt Gear with the Product field...

Hello all, I have a few questions. I built a form and I want to upgrade it. I want to make certain fields required before a user can save. Also I want to automate a process I currently have. The user makes a selection in a cbo box which has 2 options (approved or denied). I have an update...

I have a form called Totals which has 2 text boxes. One you enter a ID number. The textbox is called txtPS. The other has my Dcount code. Called txttotals. Code: =DCount("[APPROVED]","tbl_sales","Seller =" & Forms!QuickStats!txtSeller And [APPROVED]="Approved" And [DATE REFERRED] Between...

I have a problem. I built a simple Cascading Combo Box, which is not picking up my forms statement correctly. Can anyone see what I am doing wrong? Here is my Row Source code for the Combo Box: SELECT DISTINCTROW Table1.zip FROM Table1 WHERE (((Table1.city) Like...

I have been working on a form to do so quick calcuations for me. I built a SQL stament and a form for me to enter the data. I have a txtbox called txtNumber, where I enter the number of the Seller and run the query which will display the totals for that seller in my form. The problem i am...

Hello all, Is there a way to improve my code? Here is my code: Private Sub STATUS_AfterUpdate() If Me.STATUS = "CLOSED - INVAILD" Then Me.TimeStamp = Date End If If Me.STATUS = "CLOSED - FUNDED" Then Me.TimeStamp = Date End If If Me.STATUS = "CLOSED - DENIED" Then Me.TimeStamp = Date End If...

Hi all, I have a question; I am trying to build a form which a user can enter their ID#, press the button OK and the form will filter the query so the form can run some basic calculations for the user. I can’t seem to get ID to transfer to the query correctly. Any help would be greatly...

Hello All, I need some help with a form problem. I have a main form which reads data from a sub-form called tbl_referral1. The problem I am having is when there is no data in the sub form I get the #error on a txtbox in my Main form designed to read from the sub-form. I have tried using...

I have a question I keep getting a error when I try to fun my SQL Statment. Access says I tried to execute a query that does not include the specified expression 'Time Closed' as part of an aggregate function. Here is a sample of my Statment: tbl_referral.[Time Closed], tbl_referral.[MBR...