Search results

Good day! I heavily use: dim db as dao.database dim rst as dao.recordset set db = db name set rst = Db.OpenRecordset(recordset) set rst.index = xxx ............ etc. Can I declare all these values once only and then refer to them within my code? thanks in advance

Hi great people! I need to get the current position of the cursor (vertically) as relevant to the start of the page but in CENTIMETER I tried this code: Selection.Information(wdVerticalPositionRelativeToPage) it gives me, as I thought, the position but in points. To make it clearer: If I'm in...

Hi All, If I need to search two words (non consecutive) in a paragraph, what to do whether by code of normal find. Is there any special character to use in search criteria as (^p) ...etc. Thanks heros

Hi, I'm using the following code to format the text after the column sign (:) as bold. The issued is that it goes through the whole document, while I need it to run on selected range only (table, paragraph(s)...etc). Thanks for your usual support

It seems impossible. However, it's significant to me. if my current document is located in: (D:\works\123) for example. I need to create a folder under the upper (parent) directory (works) in this case. How to create such folder. NB: Parent folder changes (like: D:\projects\reports) ....etc. It...

Good day! Please! I'm using word 2003. I need a vba code to show a custom toolbar. Thnaks

Thanks for your usual support! Now, I have a specific and distinct word (say: CAPSHO). I's use this word at the beginning of a text block AND and the end of that block. I need a code that searches for that CAPSHO and make specific format between the two words, then removes first and last...

Good day! I need a vba code to get the number of columns or cells in current (selected) row in MS word. NB: the number of cells are not the same in each table row. Thanks in advance

Good day! Is it possible to make a query based on a table (employee_details) and under the criteria of the field (city) put the following criteria: like * reference_table * Reference_table always has one record only. Can the query fetch the data from another table? Thanks in advance

Good day! I have a field "Description" and other four fields "field1", "field2", "field3" and "field4" The field "Description" has numerous data. Now, I want a code to go to first entry in "Description" and insert it into "field1" then goes to the send entry in "Description" and insert it into...

Good day! I'm writing the following code in Word 2013 VB to connect to MDB database dim db as database dim rst as recordset set db="db path" set rst= db.openrecordset("Table Name") In this stage I'm getting the error message :run-time error '4029' activex component can't create object" I...

Good evening all! I use the following Ribbon XML code in a UsysRibbon table. I got it from these forums. I need to remove the (File) menu and also to remove the title that appears at the top of the database (which displays the file name and path). Thanks in advance <customUI...

Good day! I use the follwoing code to filer a filed on a form Public Function FilterForm() On Error GoTo errlbl Set SelectedButton = ActiveControl Me.Controls(ActiveControl.Tag).SetFocus Me.Recordset.MoveFirst DoCmd.RunCommand acCmdFilterMenu Exit Function errlbl: If Err.Number =...

Good day everyone! I need urgently to remove the gap between form detail section and form footer, either by vba code or changing the properties. Need your urgent help please

Good day very helpful people! I've a custom shortcut menu bar in my reports. I need to add a button that prints directly (2 copies) to default printer. I've tried the code: newMenu.Controls.Add(1, 15948, , , True) newMenu.Controls.Add 1, 12499, , , True But both lead to a dialogue box. Any...

Good day! if a text box property includes "can grow" then its border appears taller than other textboxes, how to dynamicllay change the height of remaining text boxes in the form where a text box height changes?

Good day gentlemen! I'm using (F6) key with fields on form for specific purpose. it works fine with textboxes but doesn't work with any comboBox? Here's my code If KeyCode = 117 Then dosomething End If Any ideas!!!

Good day! I need to change the property "Pop up" for all forms depending on user name. i.e. if username is "abc" then all forms pop up property will be "yes" otherwise, it will be set to "no" Thanks in advance

Good evening! I need a code to link a table from an external database (protected with password) so that the linked table will be in ReadOnly mode in the destination database. Thanks in advance

Good day! I have a back-end database which is protected with password. the following code imports one table only, I need a code to: 1) Link all tables in the back-end database; 2) Link particular tables. Code: Dim db As DAO.Database Dim tdf As DAO.TableDef Dim strConnect As String Dim...