Search results

i have 2 tables that have the same fields. one called "students" one called "studentsinhold" for Each table i have a form. now i have 2 buttons for the form "studentinhold" What I want to do is that when i press the Accepted button it well save the record in "students" table and delete the...

not working or i did something wrong i get error "You have written a subquery that can return more than one field without using the EXISTS reserved word in the main query's FROM clause. Revise the SELECT statement of the subquery to request only one field. (Error 3306)"

i have a table todo list in my table there are 2 dropdown fields one called main Categories and the second called sub Categories now i want to restrict the sub Categories by the main Categories example if i choose in the main Categories finance it well restrict the sub Categories to the value...

ok i solved it. I created a query using the find duplicates query wizard. then i insert this code in "form close" Dim db As DAO.Database Dim rs As DAO.Recordset Set db = Application.CurrentDb Set rs = db.OpenRecordset("qry_Duplicates") Do Until rs.EOF rs.MoveFirst rs.delete rs.Close Set rs =...

thanx for the reply. let me explain more. i used the build in duplicate records query in access 2013 and add some criteria to the the query as show only last 7 days record. now if i use table i will have to use "dcount" my query have 5 fields so i only want to do "dim" my query and use "if" '...

hi: i build a query for duplicate records onbeforeupdate form in need to run a vba code if the record is already in the table. then delete the last record Dim qry As QueryDef Set qry = CurrentDb.QueryDefs("duplicate records") if (i'm stuck) >0 then (again stuck) move last delete MsgBox "The...

my db is 42mb i can't upload this size let me explain the record in the table is moving to the last but the textbox showing the first value of the table. i did "go to record" on every event

tnx for reply didn't get it what to post and how

the record go to the last but the textbox insert the value in first record

Hello everyone I built a database of maintenance. Database work so that students report a fault by a few simple clicks on the buttons. The buttons have fixed values like location, sub-location, type of fault I used this code Private Sub pic5_Click() Dim rstCategories As Recordset Set...

There are more than 700 students I can not do box list because there are too many values I need every report ends in 4 clicks Anyway the code I published works fine Dim rstCategories As Recordset Set rstCategories = CurrentDb.OpenRecordset(Name:="my table"...

no i mean simple button and i need a code for it i found that one Dim rstCategories As Recordset Set rstCategories = CurrentDb.OpenRecordset(Name:="Categories", Type:=RecordsetTypeEnum.dbOpenDynaset) With rstCategories .AddNew ![Category Name] = "Better software" !Description = "5...

can i get help plz:banghead:

What I mean is that the field table will receive the value of a button Then I will run a macro that saving, closing and opening the next form

Hello everyone I have a question. I have an endpoint for students so they can report any faults in the compound I want to build a form that contains buttons of a certain value so that a student clicks on the button Is fed directly to the table and pass to the next form to another value table...