Search results for query: *

I have a cosstab query "cross1" that brings the result: placeID | 001 | 002 | 003 | 21 02 03 78 28 12 0 45 02 05 10 20 I have an unbound form with a combo box having the "placeID" options and another Combo box with the "items", beeing the items...

I have a table like this: ID Name Bcode Ccode 1 John 211 212 1 John 211 301 2 mary 020 025 2 mary 020 056 2 mary 020 059 3 cathy 112 115 And I need to count the records to show how many times "John"...

How can I edit the value of a specific field in a table through an unbound form. I tried something like that but it didn't work: Dim subm5 As Recordset Set subm5 = CurrentDb.OpenRecordset("pur_unit", dbOpenDynaset) With subm5 .FindFirst "location='" & Me.[location] & "'" If .NoMatch Then...

I have a form that it has been working fine to ADD data to the table "cleanup". BUt if by mistake the user types something over the field "computercode", it will mess up another table "units" that it should NOT! here is the SQL: SELECT Cleanup.ComputerCode, Cleanup.UnitCurrentGrade...

I'm trying to delete some records from my table "Btable" that has the same field [street] value in another table "owners". I tried: Delete * From Btable WHERE Btable.street=Owners.street and also Delete * From Btable Inner join owners ON btable.street = owners.street WHERE...

I have a table that looks like this: ID Name unit 1 john 104 2 Mary 301 2 Mary 302 3 Carl 405 3 Carl 407 3 Carl 409 And I was wondering If I can combine the "unit" field values, in another table/query...

I was wondering if there is a way to put on a excel spreadsheet a Function (or maybe a formula) for this problem: For every $100 add $5.50. Example: If I get $100 the result should be $5.50 If I get $157 the result should be $5.50 If I get $200 the result should be $11.00 If I get $201 the...

I'm having a problem with the following code that it seems to work but it does not find and Display the field searched. This is a form that you update records and once you submit the changes, it requeries another form and it is supose to find the record updated. here is the Code...

HI folks, I wanted to use one form (form1) to edit records in a table (tbl1) and after updating the record, the command button should open another form (form2), BUT ON the same record that he was updating on Form1, using the field "Media_cd" as the link. i.e. [Forms]![form1]![media_cd] =...

I have this Select Query listed bellow and that is the data source for a form "mainmedia". The problem is that I can not edit the records (values) through the form neither in the query view. Here is the SQL: SELECT MediaDetails.Media_cd, MediaDetails.Media_name, TOLLFREELIST.Toll_free_no...

HI folks, I have a Select query like this: SELECT COSTHIT.Media_cd, COSTHIT.Media_type_name, COSTHIT.CostHit_Jan, COSTHIT.CostHit_Feb, COSTHIT.CostHit_Mar, COSTHIT.CostHit_Apr, COSTHIT.CostHit_May, COSTHIT.CostHit_Jun, COSTHIT.CostHit_Jul, COSTHIT.CostHit_Aug, COSTHIT.CostHit_Sep...

what would be the SQL to run a query that updates a record in table with the data from a another table using the same primary key fields. Now, if the record (based on the primary key field) does not exist in the destination table, then INSERT the record! Source tbl: "inventory" destination tbl...

I have this code to limit the number of characteres in the text box: Private Sub LimitChange(ctl As Control, iMaxLen As Integer) On Error GoTo Err_LimitChange If Len(ctl.Text) > iMaxLen Then MsgBox "Limited to " & iMaxLen & " characters.", vbExclamation, "Too long" ctl.Text...

Is there a way to lock the "database window" in access, only for Admins? Or is there a way to use a form and a command button that would open that Window using the "acCmd...." ? I know about the special keys, but I'd like to block that too. Thanks for the help. Breno

HI Folks, I'm having an error: (runtime error '3188, could not update; currently locked by another sesion in this machine) whenever I'm updating a memo field in my table "units". That happens after that field is loaded with more that 2000 caracteres. I've seen some stuff on the internet...

Is there a way to count records from a different table or query other than the one that my report reads from?

HI folks, I have this query that I want it to bring ONLY DISTINCT folio numbers and the SQL viw is like this: SELECT DISTINCT guesttrack_clean.Folio, brochure.type FROM brochure INNER JOIN guesttrack_clean ON brochure.homephone = guesttrack_clean.HomePhone WHERE...

Hello again. How can I, after have a record deleted from a table, have a form opened ready for a new record to be insert? Or better: A form opened in a blank record and a certain data placed in a field. I have the record deleted using: DoCmd.RunSQL "DELETE FROM [owner's list] WHERE [owner's...

here is the Update procedure I have. It sends 3 items of one table (units) to another one (unitnotesarchive). But how can I delete only the data in [Notes], in my current form, from table "units" after updating the "unitnotesarchive" table? here it is: Dim subm2 As Recordset Set subm2 =...

I'm trying to add an empty string to be sent in this command, so that by using the code below, it will send the two combined text boxes ([text2] and [addnt])and also an EMPTY STRING or a CTRL ENTER (SendKey) to the one field (Notes) in my table "Units". DoCmd.RunSQL "UPDATE Units SET...