Search results

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

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 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 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

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" ?

Hi all; I have 2 tables with 96 fields each, tabelaA and tabelaB I need to update the tabelaB where some 96 fields of data are different from tabelaA Is possible? can help please?

Hi all; The first photo do not appear in the report, why ? Please check mdb in attc;

Hi all; I need to sort the 60 numbers of the listbox and delete one by one, but the numbers deleted reappear. Any idea, please ?

Generate Bingo Game Cards 60 balls. Download

Hi all; That cod need not repeat the numbers. How to not repeat ??? In module; Public LançarAleatorio As Variant Public NumAleatorio As Variant Public Function GeradorNumerosRandomicos(X As Long, Y As Long) As Variant On Error GoTo ErroLinha Dim LNumAleatorio As Integer Dim Llançar As...

Hi all; My table in 100 fields and did not want to copy 100 times the INSERT INTO. It aims to do for all 100 fields, with only one line of INSERT INTO ? Private Sub MyButton_Click() Dim dbs As DAO.Database Dim rst As DAO.Recordset Set dbs = CurrentDb Set rst =...

Hi all; I want to update from the bottom up (descending), but this loop is doing from top to bottom, as reverse ? Private Sub PreçoUnitário_Exit(Cancel As Integer) DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 On Error Resume Next Dim strUP As String Dim db...

Hi all; I hide tables so, and to hide all querys? Dim Tb As TableDef For Each Tb In CurrentDb.TableDefs If Not Tb.Attributes And dbHiddenObject Then Tb.Attributes = Tb.Attributes Or dbHiddenObject End If Next MsgBox "All Tables have been occult. ", vbExclamation, "Aviso " Else For Each Tb In...

Hi all; I want to open a report on the last page, but this code does not work, why? Access 2003 Private Sub Command10_Click() Dim I As Integer On Error Resume Next DoCmd.OpenReport "Report1", acViewPreview I = Reports!Report1.Pages SendKeys "{F5}{Delete}" SendKeys I & "{ENTER}" End Sub

hi all; Vba code, how to import all modules another mdb ? Access 2003

Hi all; Gives error in the sum of a texbox in continuos form footer. how can I solve this problem ? See the attc please

Hi all; vba code, accdb how to open another database .accdr with password ?

Hi all; Where can I find a lists of ActiveX controls for Access 2007

Hi all; Why is the word "Local" is reserved for Ms Access ?