Search results

  1. E

    Deleting Records

    Hi, I have a problem, of course :p I'm making a deleting query, structured as: Field: Sheet.* Table: Sheet Delete: From Field: Number Table: Sheet Delet: Where Criteria: Results!Number in the query I've included only the Sheet table (because if I include also the Results one it says me...
  2. E

    Run-time error '3251'

    Already done :( What I would like to do is: - take the selected items in my listbox - delete the correpondent records of another table
  3. E

    Run-time error '3251'

    hi, I've a problem with this little code, I can't understand: Option Compare Database Dim numeriSchede As Variant Dim DbCurr As DAO.Database Dim tabella As DAO.Recordset Private Sub Delete_Click() Dim stringa As String Set DbCurr = CurrentDb Set tabella = DbCurr.OpenRecordset("Scheda...
  4. E

    Portrait/Landscape

    Hi, I made a report with several subreports inside. The whole main report is in a portrait form, but three of them must be landscape! How???? Thank you, Mara
  5. E

    How many fields?????

    Thank you!!!! :p :) :D :) :D :D :D :) :D
  6. E

    How many fields?????

    100% I need so many tables because they're 1->infinite with the main one!this the best you can imagine!!!imagine that I have even 25 forms connected to the tables!It's a mess, but I need them! :(
  7. E

    How many fields?????

    Hi :D , how many fields may I put in a query?Because I need to make a report with moe then 150 fields (bolnged to 15 differents tables)! Thank you very very much!
  8. E

    Tbles, Records, Code

    Hi!!!! A really easy question for you: How can I Open a Table, put in it new records and in a second moment delete all the records? Ah, of course, everything must be hidden to the user and I need to put this code in the event _click of a Button! thank you very much! Mara Meo
  9. E

    Help!!!Query too complicate

    :eek: :eek: I'm sorry, but I can't understand! :eek: :eek: In the first Form I have to show all the records, so I can easly connect the listBox (Where I show differents fields) to the main Table (TableSiteSheet). When I UpDate a Field in the searchForm the macro I use is: Re-excecute the...
  10. E

    Code By Code

    hi, I'm Mara!!! This'll be a really easy qquestion for you, but not for me! How can I put new records in a table writing code in Microsoft visual Basic in a Form??? I would like to insert (and in a second momento to delete all the records) in a table hiding my movements, getting dates from a...
  11. E

    Help!!!Query too complicate

    unfortunally this Db contains more then 100 field and they have to stay in different tables because they're 1->infinte case. So, in each Searching Form I have a list box where I show all my results, to save and use in the next form. What I could do is to take these results and put them in a...
  12. E

    Help!!!Query too complicate

    Yes, of course, I know I can't easly explain what I would like: TableSiteSheet number (as primary key) other fields TableLocationSheet number (connected with TableSiteSheet) PK (for each table) Language (text) other fields And other 17 tables like these Then I have of...
  13. E

    Help!!!Query too complicate

    :eek: Hiiii :confused: I'm Mara :D . I write you 'cause maybe you can help me. I'm making a data base with 18 tables all connected with the main one! Now, I need to search a specific record, introducing alla the needed fields passing through 9 queries. I've already tested the first 5 queries...
Back
Top Bottom