Search results

  1. gillbates21

    trying to create a report but wizard creates a new form

    query has 4 columns, first 3 from 1 table, last from a second table. the query works fine. when using the report wizard, i select to make a report from that query, but after selecting all needed field, the wizard askes "how do you want to view your data" and options "by table1" and "by...
  2. gillbates21

    error 2115, can i get around it?

    I have a problem like thisone I tried to setfocus to a textbox and then write there some value in an afterupdate event. Although i got the error, the text in the textbox was correct. Is there any possibility to get around that error? (so it wouldn't be displayed, but the code would still be...
  3. gillbates21

    Run-time error '2115'

    I had the same error in a same situation. I tried to setfocus to a textbox and then write there some value in an afterupdate event. Although i got the error, the text in the textbox was correct. Is there any possibility to get around that error? (so it wouldn't be displayed, but the code would...
  4. gillbates21

    can't get a combobox to show the value i want

    Thanks :) Still, there was 1 line missing... in form load event Combo2.value = null
  5. gillbates21

    can't get a combobox to show the value i want

    heh, figured it out somehow :P The access 2000 file attached.
  6. gillbates21

    can't get a combobox to show the value i want

    you are right, the category needs to be in a separate combo. the music table has the category field set to numeric, and the category table has the corresponding string values. the second combo is needed to change the songs category (using UPDATE query under a commandbutton)
  7. gillbates21

    can't get a combobox to show the value i want

    It's not exactly cascading combos... I already have all the right values in the combos. OK, i try to explain: combo1 has values from table music table (first colum is MusicID and hidden) the values are like "artist ; song" (2 columns) combo2 has values from table category (first column is...
  8. gillbates21

    can't get a combobox to show the value i want

    i searched for similar combobox features, nut didn't find any that helped. i have 2 unbound combos that get heir values from different tables first combo1 gets its values from a query SELECT [tbl_music].[MID], [tbl_music].[Artist], [tbl_music].[Song], [tbl_music].[CID] FROM tbl_music; combo2...
  9. gillbates21

    Passwords fields wont empty

    Have U tried: Username.SetFocus UserName.Text = "" Password.SetFocus Password.Text = "" Or UserName.Value = Null Password.Value = Null
  10. gillbates21

    do I need relationships?

    When I use onlySQL and INSERT, UPDATE and DELETE queries to manipulate data in my tables then do I need relationships :confused: For example, if I insert data from a form, I use as many INSERT queries as needed to insert all the data to all the tables. All SQL.
  11. gillbates21

    getting a strange error 2108

    lol, thanks, that select line was indeed not necessary. EDIT: And in another situation the afterupdate event was the right one to use. Thanks KeithG But can anybody say, why can't I declare this: Dim db As Database ??? Also no additem property for a combobox :confused: and for example Dim...
  12. gillbates21

    Adding Items...

    if you type ListJ. then do you have the additem option in the opened list? i strangely don't and here is an opportunity to ask wiser people, what could be wrong with my access? i also can't declare this: Dim db As Database
  13. gillbates21

    Receiving runtime error

    nope, i get error on Dim db As Database line saying that user-defined type not defined. I have done all the updates to my access 2000, but somehow i can't use some of its objects. (DAO 3.6 is checked)
  14. gillbates21

    getting a strange error 2108

    I have the following code: Private Sub cboUsername_BeforeUpdate(Cancel As Integer) cboULevel.SetFocus cboULevel.Value = DLookup("ULevel", "tbl_users", "[UID]=" & Me.cboUsername.Value) End Sub Getting the strange error 2108 (save the field before using SetFocus) The error is...
  15. gillbates21

    Receiving runtime error

    query problem I'm trying to set combo's cboULevel value to the result of the query. The parameter query itself works. I'm getting error 3061 (too few parameters. expected 1) with this code: Private Sub cboUsername_BeforeUpdate(Cancel As Integer) Dim sql As Recordset Set sql =...
Back
Top Bottom