Search results

Hello all, i have a form tha has a button which execute a macro in the onclick. in some computers this button works and in others no. we don't receive any error message. we simply press the button and nothing happens. i already set the macro security to low but the problem persists. this...

Good afternoon, I have a problem with the security level macros in Access. If i change the security level (tools - > macro - > security) and press ok, this new configuration is not saved if i open access again.Appears like the old configuration. If i do this procedure with the rights...

hi all, i´m having a problem with a form that has 9 subforms and this subforms don´t show the values. i set the source for this subforms with this code when the form opens: StrsqlPen = "select bri,tot,totdes,totreu from " _ & "TotalBrigRen where flag=" &...

hi list, i´m trying concatenate a subform name without success. i have 6 suforms with names ConsultporBrig_subform1,ConsultporBrig_subform2,.... i have a loop recorset and the recorsource for this subforms depends on current recordset value. i already try some code(with some ideas found in this...

Hi list, i´m having a problem with querydef and connections. i have a function with th path for my database and in the load form i call this function to create a connection 'this is the code Dim cnch3 As ADODB.Connection Set cnch3 = New ADODB.Connection cnch3.Mode = adModeReadWrite cnch3.Open...

Hi all, in my tables i have decimal values with comma but when i try to make some operations with vba code, i get a error because the comma. i have this code to substitute the value but if the value is 0,612 for example, my pe variable gets the value 612. i already try with double but i get...

Hi all, it´s possible get a label showing intermitent? tks in advance

Hi all, i have a macro to delete a file first and then the folder that has this file. What happens it's when i run the macro the first time it works fine, the second time it gives me the error Path/File Access error on the line to remove the folder. if i run again( 3ª time) it works fine again...

Hi list, i apologize if this is not a thread for this forum but i can´t open my access database. i already look for some utility to recover the DB but i didn´t found nothing ( unless i have to pay). i experience some utilities but they only recover the tables, not the forms( and vba code). This...

Hi list, I have a form based on a table but when i insert a value on a textbox, this value it´s not assumed in the table, i have to click in next cell for this value be assumed. I´don´t know if somebody have already this problem before. It´s possible do a click on next cell with vba or somebody...

Hi list, I need you help or you opinions and ideias. All the code that i have in vba was building inside Access; now i wanna migrate the code to vb but continue use my BD. My questions are: I have a module that have a variable for db ( dim db as database) and in all forms i have set...

hi all, i have a code to delete a row if a cell has a 0(zero) value, this is the code: For i = 1 To 1000 If .Cells(i, "E").Value = 0 Then .EntireRow(i).Delete enf if next what happens it´s that if i had 2 cells with 0, i.e. cell(1E)=0 cell(2E)=0 it...

Hi all, i´m trying send a report by mail as attachement. The problem is that i have to save the report first in a directory and then in the code to send the mail it looks for the attachement in this directory. Have somebody knows how to save the report automatically with the name of a control...

Hi list, I have two combo boxes and if one is blank, i.e. if the combo don´t show any text, and the other shows any text,it runs one query,if not it runs another query. My question is: How do i know if the combo don´t show any text? i already test this code: if ((isnull(combo_name1.value)=true)...

Hi all, It´s possible change the default printer by vba code? i have a button that when user press, i wanna assign a specific printer for that action and when the report already is printed, i wanna change the default printer for the printer he has before. i run this code but it´s wrong because...

Hi all, I have two reports that need to be printed together, because i print the reports to a pdf printer. i have a button with this code: stDocName = "report_A" DoCmd.OpenReport stDocName, acNormal stDocName = "report_B" DoCmd.OpenReport stDocName, acNormal of course this print two...

Hi all, I have two reports that need to be printed together, because i print the reports to a pdf printer. i have a button with this code: stDocName = "report_A" DoCmd.OpenReport stDocName, acNormal stDocName = "report_B" DoCmd.OpenReport stDocName, acNormal of course this print two...

Hi all, I don´t know how to do this or if is possible, so this is the question. I have two reports and i wanna the second report continuous the first report number page, i. e. if the first report end on page number 2, the second report must have his first page number start a 3. My second...

hi all, does anybody knows how to create a text box with vba code? tks all

Hi all, I have to build a form that depends of the records that´s are retrieved by a query that is made to DB. The form must have the number of lines with some text box's as many the records is retrieved from the query, i.e. if the query brings me 5 records, the form must have 5 lines with some...