Search results

Please help me how to shorten the VBA below, I don't want every column I have to make another VBA, maybe use a loop? but I don't understand how. If you can give me advice The next problem is how to make the name of the export data look like in the column: A1 = Export Data Range C.xlsx A2 =...

I am looking for example of splitform with View , Edit , Delete see photos Thank you in advanced

Dear All, Could you please help how to make the text on textbox little bit to the right zie foto Thank you

Dear All, With below vba when i print the report i get result Invoice Number 1.PDF ( voor invoice number 1) I Would like the result is : Invoice Number R10001.PDF (see fictur) Private Sub PRINtPDF_Click() Dim FileName As String Dim FilePath As String FileName = Me.Invoice Number & " " &...

Dear All, Could you please help how to disable New (blank) record on Continuous Forms Thank you

Dear All, I hope you can help me, I make data entry in the way if I click in the data All data in the cell will appear in the form I use below VBA to save the data en clear the form Private Sub Worksheet_SelectionChange(ByVal Target As Range) On Error GoTo ExcelVba...

Dear All, How to update Unbound textbox when value on another textbox change First Date Of Current Month = Default Value =DateSerial(Year(Date());Month(Date());1)+[ExtraDay] example if on ExtraDay =2 on First Date Of Current Month = 3/10/2022 is working but I need to close the form and open...

Dear All, I have a form where I have a 7 checkboxes. I want if the value on DateToday the same as the value on FirstDate the checkboxes must be uncheck els check. please help how to resolved this issue, I use below VBA Option Explicit Private Sub Form_Load() If Me.DateToday.Value =...

Dear All, I tried to create a sub folder I got an error "Run time error 9 Subscript out of range please help how to resolved this issue I use below VBA Sub Knop1_Klikken() Dim sv, i As Long Set sh = ThisWorkbook.Sheets("Data") sv = Cells(1).CurrentRegion For i = 1 To UBound(sv) If...

I have 2 different databases: 1 Master Data 2 Data Backup Please help to create a VBA command button to copy the result of the search in database called "Master Data" to Table called "BackupData" in another database called "Data Backup". My data is ON C:\Kirana\Data access Thank you in...

Please help how to resolved this issue I made Command button to clear the value on search by date and showing all data again I get an error 2580 I use below VBA Private Sub CDMClear_Click() Dim task As String Me.DateFrom = Null Me.DateTo = "" task = "select * from qrySearch order by...

Dear All, I'm attempting to protect the entire worksheet except for a set column "H" can be editing I use below vba the problem is all entire worksheet is protect please help how to : Sub Lock_data() Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.Protect...

Dear All I would like to know how to either disable or remove the close button from the title bar in Access if this is even possible. Thanks

My form contains a text box and a combo box. I would like only When a value is selected from the combo box I want it to be displayed msgbox "Date Entry Required" if in the text box (Date) is empty. The combo box contains a list I would greatly appreciate help on this. Thanks in advance

Dear all, How to programatically set Textbox to be required? If value on Status on the textbox Datum must be required Thank you in advance

How to Select Multiple hyperlink Records to be Printed in a Report in Microsoft Access. Select Several Rows. If I want to print invoice I have to click one by one in the hyperlink number op the invoice How to select multiple hyperlink to print those invoice

I'm having a little trouble with the form filter in Access. I'm using the listview in a few forms and the user needs to be able to filter there. all data is from combo box please help how to resolve

Dear All, I would like When the invoice status is selected approve, an invoice number is given. Now an invoice number is given with all entered words, do you know how this can be solved Thank you in advance

Dear All, With this vba I try to do a search with the date I get an error What mistakes did I make I use below VBA Private Sub cmdSearch_Click() Call Search End Sub Sub Search() Dim strCriteria, task As String Me.Refresh If IsNull(Me.followupFrom) Or IsNull(Me.followupTo)...

Dear All, How to show the data from combobox on listbox Example Combobox 1 Afgehandeld 2 Ingediend on my database listbox showing 1 instead op Afgehandeld Please help how