Search results

Is your Logged_In domain full? Is the user field numeric or string?

ZS-RPB(30551)Sliding door handle mechani MID ("ZS-RPB(30551)Sliding door handle mechani",9,5) when we count from the beginning 9th character 3 We get 5 characters from 3. Conclusion What do you think happens? Wouldn't it be 30551? you are doing wrong somewhere. If you don't write the 2nd...

Dim result as String Result = Mid ("sampletext",9,5) will provide the document number in your sample data.

Hello, First, create 1 query, edit this query to bring 5 of your records (top 5), then save it. Name it QRY_END5. Create a normal query based on your table in the 2nd place, name it QRY_RECORD. Then set your form's registration source to QRY_RECORD. Place one command button on your form and...

What exactly is the code?

The following procedure completely deletes the folder and its contents. Sub ODeleteFolderAndFiles() Dim FileSys, strDir As String Set FileSys = CreateObject("Scripting.FileSystemObject") strDir = "D:\Test" 'Specify the path to the folder here If FileSys.FolderExists(strDir) Then...

I assume there are many relationships in the Purchase List and Sales Details table. Now create a subform for Vendor Details, set aside. Then create the Purchase List form. Add the subform you put aside to this form. Put a ComboBox in the Purchase List as a last operation Using the wizard, select...

Hi friends Set the line source of the combobox as the list of values at the beginning and apply the event that the dBguy has mentioned. Then type the code that will change the Row source to the event when the ComboBox is entered.

Way to exceed the ms access 2gb limit https://dba.stackexchange.com/questions/167731/bypass-ms-access-2gb-file-size-limitation

WHERE Quotations.OrderNumber ='J0032301'; ' J0032301 ' not so 'J0032301' there should be no space[/CODE]

So, I mean, when I examine the image you added, in some of the tables you have taken to the query design window, they occupy 10 lines, although there are 2-3 lines. If you resize other tables like this to fit the rows, the space is free and you can probably see it on a screen. how many tables...

Do you do exactly what you want with the shortcut menu?

I did not understand why you needed to variable. If you want to take all the years, I think there is no need for any criteria.

you can get the blanks of the tables you query.

The code below can help. Alt SaveAsWordToPDF () Dim strFileName As String WordApp Olarak Sönük WordAppApp strpath = "F: \ PDF Dosyaları \" strFileName = "ABC.docx" Set WordApp = CreateObject ("Word.Application") WordApp.Documents.Open strpath & strFileName...

Is the option to open databases with record-level locking checked in the tab with client settings in access options?

dear ksabai you can use the following code. Private Sub cmbSeller_AfterUpdate() Dim db As DAO.Database Dim rs As DAO.Recordset Dim sEMail As String Dim countrec As Integer Set db = CurrentDb Set rs = db.OpenRecordset("tblStaff") countrec = 0 rs.MoveFirst Do While Not rs.EOF If rs![duty]...

sEmail = DLookup("", "tblstaff", "[SellerID] = [cmbSeller] AND [Duty] = 2") what to take with space

Hello friends, You can convert a macro to VBA code. But as our plog friend said, VBA is from macros is much more powerful. I want to talk about an issue in Access's definition. MS Access offers you a number of wizards for programming, You write in a database with the help of wizards, almost...