Search results

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

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

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.

Hello Is there a way to dynamically with VBA show tool tip of a text box after key down event ? I want the tool tip to be displayed without having to hover over the text box control

Hello My question is about how i can programmatically with VBA restore(Maximize) an opened folder that is minimized Thanks in advance

Hello How can I center an access form on the screen for different display resolutions? I tried auto center property from design mode but this property centers the form only horizontally Thanks in advance

Hi I have a button on the header of a form. when i press it, i get back to the main menu I want the button to disappear once i'm on the main menu. but i get an error message when i set the visibiity to false from within the button event. The message says "can't hide active control". Is there any...

Hi How can I edit form title (with VBA or from design mode)? Thanks in advance Edit: I want to set the title to empty string

Hi My questions is simple(i hope the answer woule be the same 😀) Can i remove an item (a row) from the recordset only(not from the database table)?

Hello I don't know how it happened. But when i open the database file i get the error messsage saying ' "id" is not index on this table ' Can anyone please help me

Hello I want to know how to create dynamic reports from scratch using VBA I want to have absolute control from VBA code(Creating header and footer, formatting fields, etc...) Thanks in advance

Hello I want to know how to make Application Forms Responsive so it can fit all screens Thank you

Hello I have a form with multiple levels of subforms Within the sbFrmA subform on the last level, I have a button "Report" that calls a report where i have dragged a built query that takes its parameters from combo boxes in sbFrmA. Then, I hided the the ribbon and the navigation pane and the...

Hello I have 2 forms: frmA and frmB. frmB is a subForm of frmB frmB has a close button. I used the DoCmd.close command attempting to close frmB but what happens is that frmA also closes. What can I do to prevent frmA from closing? In other words, I want to close only frmB

Hi I have a ListBox that shows search results based on some criteria What i want is that after each click on the search button (new search) to remove the focus (highlight) generated on the listbox after clicking on it Thanks

Hi So i have a database created using powerdesigner modeling tool. I saw a tutorial online about how to generate an access database from the sql script generated by powerdesigner. The method described in the video tutorial requires using an access file (.mdb). My issue is that this...

Hello I have a small inventory management app and i made the following: - i set the login form as the default form when opening the app - i removed the navigation menu from file-options-current database - i removed the ribbon using the doCmd.showToolbar command - i removed the security warning...

First of all i want to point that i seek directions Well, within my small app u have search forms that display search results based on different criteria. I initially worked with listbox to display results and now i want to add the feature that allows users to edit or delete each record. In...