Search results for query: *

Thank you for the help Thomas

Is it possible to make this without java script?

This Question may sound easy - and I'm sure the solution is but it seems that I'm just too stupit too get it. I have a frameset with 4 Frames. My problem is that I need to have a link or something that changes the content in two target frames. For example - I click on a picture in the navigation...

How can I ensure that when I call a form from another form that it is opened (and if possible remains) in the restore down mode? Greetings Thomas

Thank you Paul, that worked. Greetings Thomas

Hmmm, ok, but how can I get the value of a certain field, for example the value of the active (current) row and the second colum? Greetings Thomas

Hello, I need to read the value of a particular field of a current record in form. I think the currentrecord method only gives out the number of the record, so that it will not possible to use this. I need this to creat a directory with a certain name. For example: If I enter a new customer I...

Is there anything like an actionlistener or oncommand in VBA? My Problem is: every time a new datasheet in Access is created I want a subprocedure to run. So from the principle the thing would work like this: If (methodidontknow) Then GoTo Sub easyloop Sub easyloop () MsgBox "New...

Maybe you could manage that with the RunSql method. For example DOCMD.RunSQL "UPDATE examplerow FROM exampletabel WHERE criteria" If you want to have a complete VBA code then you have to use the update methode. For example With variab !example = muster .Update...

Thank you - that worked. Greetings Thomas

@junior1544 Thank you for the offer and I will take it with gratitude. I insert the code in a module, here is the complete code: Public Sub EasyLoop() 'declaring variables Dim conMan As ADODB.Connection Dim rstMan As New Recordset Dim strSQL As String Dim outPut As String...

Yes, like that, the content of the field in the database. For example the field contains the word "example". So the name of the directory should be C:\example .

I want to creat a direcotory with the name of the content of a certain field of an access - database. The trouble I have is that the MkDir"" method of VBA wants a String as path. I tried to do it like outputSQL = "SELECT name FROM table1 WHERE key = 1" MkDir...

I have following problem: I have an Access database and every time when I insert a new datasheet a folder should been created on the harddrive. For example: I insert a new customer or whatever into my database and simultaneous a new directory is created on my harddrive. My problems are: 1...