Search results

hello SBM try to compact and repair the database tools:database utilities:compact and repair database... maby it will help are you trying to open the form whith a button in an other form?

somebody else helped my it has to look like this: Private Sub Button_Insert_Date_Click() If IsNull(Me![erlaedigt_am]) Then Me![erlaedigt_am] = Date End If End Sub

hi there ive got a little problem with VBA i have a command button and a text field in my form with the button i want to write the current date in the text field but if the field is not empty the button should do nothing here is my current code: Private Sub Button_Insert_Date_Click() Dim Date1...

ok, thx :)

hi i want to use a combobox in a inputbox istead of the normal inputfield is that possible ? if yes how ? :)

Now it works :D the expression after 'WHERE' wasnt exactly enough :D THX 4 HELP :o)

no upper and lower cas is not important this is the code im using now Function Find() Dim Table As String Dim Field As String Dim Criteria As String Dim RS As DAO.Recordset Dim DB As DAO.Database Set DB = Application.CurrentDb Table = InputBox("Enter table")...

yes in all fields unless its a memo field :rolleyes:

oh ^^ with ' it works too but i get no item found in this collection now ^^

yeah i did i type in the name of the table then the name of the field and then the text which i want to search eg. 'text' and if type in a field name like 'Trade Name' an error window comes up which says "Too few parameters"

ah now i know *gg* ok it works :D but i got all the records of the table not those who matches with the criteria :(

the thing i want is that i can search in any field of my database

hmm this does not work :( now the problem is 'syntax error (missing operator) in querry expression'

hi ive got a problem with a search function it only seems to work with constants not with variables ive tried to use the field and criteria as a constant and table as var this works but i need all of them as a var im using Access 2002 / XP with VBA 6.3 and MS DAO 3.51 Object Library Function...

its working :D thank you for the solution RuralGuy

stLinkCriteria two times on one button hi, i have a problem with the command stLinkCriteria. i want to open a form and filter it by matching data in two specific datafields. now my button code is loocking so: Private Sub F_Probendaten_subform_Open_Analysendaten_Click() On Error GoTo...