Search results

Thank you. Resolve.

Thank you for help. Works fine, but to long ago not it was necessary to save in html, there was a change in Access or i.e. ? Regards

Hi all; This instruction on my form, not preview doc, appears dialog box, open and save, why ? Me!WebBrowser1.Navigate "c:\text.doc" Access 2007 Regards

Yes no problem, as long to enter the correct name.

Perfect, worked a charm The word Date and Time are not being used, just in example. Thanks and Merry Christmas

Yes VbaInet , never. Only has one input and one output.

Thanks for responding VbaInet. Friend, in field exist the one time lower and one higher which corresponds to the entry and departure from the employee, I need to separate by date and employee and insert in another table (for example).

Hi all; I have a table with 2000 records. I need to put the last hour of the day and employee for the field EndTime. It is possible for vba cod? Look at the picture in attached, please.

Hi; Can use this statement to queries hidden; Private Sub Command0_Click() Dim stDocName As String stDocName = "Usys" & "Query1" DoCmd.OpenQuery stDocName, acNormal, acEdit End Sub

Work a charme; thank you very much.

Hi all; why is it that the transaction does not work CommitTrans ??? Private Sub SubDeleteAllTables(DataX, DataY As Variant) On Error GoTo Parar_Err Dim NUm As Long, X As Integer, S As String Dim Ws As Workspace, db As Database Dim td As TableDef Dim rst As Recordset...

Hi man; It works perfectly, but you have to put in VBA event by pressing a button on your form, not the event to open your report.

Thanks for response.

Try demo please;

Thanks ; Code it works, but does not save the Value list. I have this code and it works, but equal, does not save the Value list when I close the form. Private Sub moveBetweenLists(lstBoxFrom As Access.ListBox, lstBoxTo As Access.ListBox) On Error GoTo err_list Dim counter As Integer...

Hi all; I have the ListBox1 and ListBox2 The ListBox1 has Value list= "A" "B", "C" How do I insert an item selected ListBox1 in the Value list of ListBox2 and delete item the ListBox1 ? Access 2003 or Access 2007

working a charme. Thank you

Hi all; In VBA, how to open .lnk file ? Regards

Hi all; For vba cod, how to delete all records from a table tbltest, except the last 6 records where field 1 = "xpto" ?

I can not make this sub work Please help me Public Sub UpdateTable() Dim dbs As DAO.Database Dim rs As DAO.Recordset Dim rst As DAO.Recordset Set dbs = CurrentDb Set rs = CurrentDb.OpenRecordset("Select * from auxBancoScheda order by [SK Nº] ASC") Set rst = CurrentDb.OpenRecordset("Select *...