Search results

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...

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...

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...

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.

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...