Recent content by maikon

Hi people, Do exists a way to a query return what doesn't into other query? For example: SELECT * FROM table WHERE "NOT INTO" (SELECT * FROM table WHERE ... ) Someone understood?! Thanks a lot!

Please see it: https://www.access-programmers.co.uk/forums.xf/index.php?posts/354939/

Well, if I understood what do you want... Sub AddButton() Dim a, b, c as String a = TextBox1 b = TextBox2 c = TextBox3 DoCmd.GoToRecord , , acNewRec TextBox1 = a TextBox2 = b TextBox3 = c End Sub

Did you try something like: Sub Report_Load() If Report = Null Then OtherReport.Show End Sub It's an idea..........

Well, I've a recomendation to you: The better place to you begin your research is on the Access help. Start your job, and when you have a question come to here and share your doubts. Good Luck.

I guess you need to requery your query... For example: TextBox1.Requery []s

Well, I guess something in this way could functions: Sub Form_Load() Dim MyControl as Control MyControlList.Clear 'MyControlList is a ComboBox For Each MyControl in MyForm.Controls MyControlList.Add MyControl.Name Next MyControl End Sub After this, you can create a button...

It's function: SELECT [Customer Table].CustomerID, [Customer Table].Name, [Customer Table].Address, [Customer Table].Telephone, [Customer Table].Email, [Customer Table].Company FROM ([Customer Product] INNER JOIN [Customer Table] ON [Customer Product].CustomerID = [Customer Table].CustomerID)...

Frankly, I don't need accurately sequential number, but I thought I didn't need to waste that numbers that autoincrement waste everytime I locate the table in a new record...

Try it: Form_frmMain.subWebLCSel.Requery Why: "Form_frmMain" is the VBA form name, and not the access form name (normally frmMain). []s

What's the sCriteria function? I think "Where 1=1" always returns an error... Please, say what do you want with your code...

Jo, I did that code quikly, but appearly functions... Private Sub Command0_Click() FirstSpace = InStr(1, Text0, " ") FirstWord = Left(Text0, FirstSpace - 1) SecondSpace = InStr(FirstSpace + 1, Text0, " ") SecondWord = Mid(Text0, FirstSpace, SecondSpace - FirstSpace) MsgBox...

If I understood, you want go to other form, to include a new customer type, is it? If yes, you can put in your form package a combobox to list the registered customer types, and if user don't found the customer type, he click on "New Customer Type" button and register a new record.

Hi there, I've a button that position the table on a new record: DoCmd.GoToRecord , , acNewRec And I create a button to cancel that action: Me.Undo But the code field (autoincrement) continues autoincrementing! Explaning: 1. I click on "Add" button 2. The table's positioned on...

You can use that code: Sub ShowDate() 'Don't forget to define the YourComboBox.RowSource to YourTable Set x = YourForm.RecordsetClone x.FindFirst "[YourCodeField] = " & YourComboBox If Not x.EOF Then YourForm.Bookmark = x.Bookmark End Sub Call that Sub on the YourComboBox...