Search results

I have this: Private Sub GetTotal() Dim ctl As Control, intScore As Integer For Each ctl In Me.Controls If ctl.ControlType = acCheckBox Then If ctl = True Then intScore = intScore + ctl.Tag End If End If Next...

I have a split database and up till now it was fine. It made a lock on the be and left the fe open to use. NOW it locks the fe and not the be. ANY ideas y?

Record Locking Level, Run-time error '2448' Hey, I get this error: Run-time error '2448' You can't assign a value to this object. sometimes when I run a form. The form has a dropdown which when a value is selected opens a form to that record. I found this site describing the error and...

Hey, I have a form (1 that I know about n3way) which I made NO changes to but during an update 1 aspect of the form failed to work on the other computers but , yet, works on mine. The issue is that there are 3 dropdowns. when the first is populated, the next is populated based on the selection...

I have (for this post) 2 tables. department ==================== pk | d_id -------------------------- | d_fund fk1 | d_status_code_id | d_department fk2 | d_building_id fk3 | d_contact_id fk4 | d_note_id | d_modified | d_user contact ==================== pk | c_id...

I am currently using Outlook 2003 (Microsoft Outlook 11.0 Object Library) and everyone else is using OutlookXP (Microsoft Outlook 10.0 Object Library). How can I have Microsoft Outlook 10.0 Object Library as a reference in my Code view > Tools > references without installing outlookxp? Thank you.

Hey, I am updating a switchboard from someone elses work. I get the error on other peoples computers (but not my own) that there is an "error loading DLL" and the I get "The expression On Click you entered as the event property setting produced the following error: The expression you entered...

Desperate - error Popup on close Hello, I have a form that has in the original db many popup forms linked to (not the best but i had no choice) but there are 2 problems. I need to have the autonumber field on the form to feed the popups so when the form closes it says this: ENTER PARAMETER...

I need to create a report off of the date the client started with the organization by month and year. (See pic) the date can be found in client under Date_Entered. Can someone please help with the setup? I tried and failed horribly. ~Thanks!

I have this code for a button, what to I need to add to make it open the form to a new record? Private Sub cmd_Open_Add_Client_Form_Click() On Error GoTo Err_cmd_Open_Add_Client_Form_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmClient"...

I AM IN A HURRY!!! FRIDAY IS MY LAST DAY!!!!! I am trying to get a chart to work on a form, I want the 'Results' to be the data shown (lines), over the date range (bottom), with value range (left) I can't get it to do this though... can someone please help.... THANK YOU! :o

I am opening a report froma form using the following code: Private Sub cmdFedRPT_Click() Dim dd As Integer Dim MyDatabase As Database Dim MyQueryDef As QueryDef Dim where As Variant If Nz(Me.cboFedDateBegin, "") = "" Then MsgBox "You must select a...

oh, finally I am close to what i need I have the report in the included db. there are 2 problems though. 1 the subreport DOES sum the total for each outlet if there is one, BUT it includes a row for each outlet, therefore repeating up to 3 times. ex: if EN-02 and EN-05 have values 1 and 3...

I have a report from a cross tab query. it is selecting "EN-02", "EN-04", "EN-05" as a value. The problem occurs because there is no control source for a value in the crosstab. The problem is that if the query returns and there is no value for "EN-02" then the report fails and say that it...

I need a report based off a query to look like this: Date Sampled EN-02 EN-04 EN-05 ============================== March 8, 2004 0 No Flow 20 March 11, 2004 1 No Flow 10 and so forth. With the query I have included I was only able to have the form produced as: March 8, 2004 EN-02 0 March 8...

I am trying to build a dynamic query using : 'build a dynamic search clause to retrieve the information. where = Null If Not (Nz(rec!Matrix, "") = "") Then where = where & " AND tblWater_Sample_Temp.Matrix = '" & rec!Matrix & "'"...

I have a form which won't format the date properly in 2 parts. 1) the dropdown, the date won't format as "mmm-yy" when it drops down. 2) the date won't format for when I append it to the RE section. I have included the db

In the attached database there is a report: "rptIndividualPointsTotal" which is based off of the query: "qryPointsTotal". the report has each person listed under the a point total. currently it lists the point total from least to greatest. Is there a way to have that report list the points...

I have the following db and form on my computer. I have checks and sql in the code to try the insertion but it simply throws a error. The code is at the bottom of the main form. if you open and run it it will throw the error for you. I REALLY need help on this, I have been trying for...

I have a table with the followig fields where I do all the work on imported data. I then need the data to be sent to their permanent tables. Some of the below data is repeated in that there are many of the same sample no and client id to the different results. The permanent tables solve this...