Search results
-
N
How to retrive db filename
Hello! How can I retrive the database filename (and path) of the current database? tnx noccy- noccy
- Thread
- Replies: 6
- Forum: Modules & VBA
-
N
If a field is Blank I want the default data to be taken from a field in a table
Maybe you could do somethink like this on Form load: Dim MyNewValue As String MyNewValue = Dlookup ( YOUR VALUES, SEE HELP FILE) If Me.txtLastModified = "" Then Me.txtLastModified = MyNewValue good luck noccy -
N
Dlookup with OLE Objects
Hello In a table I have a field with OLE Objects (pictures) Is it possible to use Dlookup from a form action to make the right picture to be displayed in the form? If so, how would the declarations be? Dim MyPicture As ? MyPicture = Dlookup("[Picture]", tblPictures, "[PicNo]" = 1) And then... -
N
Display the result of an sql string in a text box
Hello How can I diaplay the result of an SQL-string in a txt box let's say my SQL is SELECT Adress FROM People WHERE Name = "Smith" and my txt box is txtAdress suggestions? -
N
Show only filename from a path String
Hello! In a table I have a a field that contains a Path As String. In the field next to the path (In the query) I want only the filename to show. Path: c:\MyFiles\Myfile.txt Filename: Myfile.txt How can I make this happen? tnx noccy