Recent content by yamus

Hi It is not necessary to be automated. But, i would like to have an idea of the any existing practical method Thanks in advance

Hi 1/ I just wanted to clarify using special characters 2/ Any method to help would be useful Once again, i hope that i made my request clear for the community so they can help me

Hello I want to export data from Word table to an already existing Access database. Is there a way to do that? I want to mention that the Word table is a sort of an equivalent to Access recordset. I'll try to explain in details: *My Access database is a sor like this -Equipement table...

Here is an example of my code private const HORZRES as Long = 1920 I want to make it something like this private const HORZRES as Long = screenResWidth screenResWidth is a function that returns Long output

I have clearly mentionned that i need to initialize constants not variables

Hello I have a VBA module within which i need constants to be initialized with the output of a function I got an error doing that and then i knew that constants should be initialized on run-time So, is there any solution or approach to deal with my requirement? Thanks in advance

Hello I am very grateful for your help sir. Thanks a lot

Hello Thanks for the help It worked very well Again, I appreciate your help

Thank you all for the help I found the reference at the bottom of the reference list

It says missing

Hello I have an Access app i made using Access 2013 When i copied the file on a different computer and when i ran the app, an error message popped that says Your database or project Micorsoft access contains incomplete or broken reference to the file "System.windows.forms.tlb" version 2.4 Any...

Hello I was wondering how to get screen resolution with VBA I found a solution on StackOverFlow Declare Function GetSystemMetrics32 Lib "User32" Alias "GetSystemMetrics" (ByVal nIndex As Long) As Long Sub ScreenRes() Dim w As Long, h As Long w = GetSystemMetrics32(0) ' width in points...

i want to choose the top entry position or to scoll the list box programmatically with VBA not with the mouse

Hello 1# I was looking for a method to get the top entry of list box programmatically with vba. 2# Is there a way to scroll the list box with VBA? Thanks in advance EDIT: I did not explain well my first request. I want to be able to select which item to be displayed as the list box to entry.

I am sorry because I forgot to mention that so i had to edit the after your reply I'll explain to you exactly what I need I want to display a tool tip below the text box when the user inputs a specific character