Recent questions tagged MS

0 votes

509 views

1 answer

ms word - vba: return page number from selection.find using text from array

(Note: See below for solution.) I have been trying to retrieve the page numbers from pages that various ... greatly appreciated :-) Phil See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

542 views

1 answer

ms access - Is there any important difference between set dbs=currentdb() and using currentDB() directly?

I have inherited a lot of code that is essentially like this: dim dbs as dao.database set dbs = currentdb( ... other than simplifying the code? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

757 views

1 answer

ms access 2013 - Sending emails to multiple recipients using VBA

I have the following code which allows me to attach a report then send it to one recipient. How do I send ... = Nothing Set dbLocal = Nothing See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

589 views

1 answer

ms access - Exporting Recordset to Spreadsheet

Just getting to grips some VBA (this stuff's new to me so bear with us!) From query ... rsGroup.MoveNext Loop End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

881 views

1 answer

ms access - How to cancel a form close in Close Event?

I'm sure this is very simple, but I can't find it. In the close event of an Access Form, how can I ... So how do I cancel the close event? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

519 views

1 answer

ms word - read an MSWord file into R

Is it possible to read an MSWord 2010 file into R? I have Windows 7 and a Dell PC. I am using the ... software. Thank you for any suggestions. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

744 views

1 answer

ms access - VBA: Why must I set focus to control every time?

I am creating a personal Library Inventory system using an Access 2007 database. In code, whenever I ... m checking multiple conditions. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

421 views

1 answer

ms access - SQL to include condition in Where if not null

In access I have been trying to set up user filters on what is displayed in a subform which is a list of inspection ... ]![Filter_to]) ) ) ); See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

559 views

1 answer

ms access 2010 - Import two columns from Excel into existing Access2010 table gives error using transferspreadsheet

I have an excel spreadsheet, with 12 columns, where I only need to import data based on the last two (The ... the import work using a Macro. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

620 views

1 answer

ms access - Customized Auto-Number IDs for tables?

Is there a way to use my own number in a table like an auto-number; that is to automatically assign the next ... of numbers, Code B = another? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

607 views

1 answer

ms access - SELECT query does not work when converted to VBA - invalid SQL statement

I have been struggling with SQL statement when converted to VBA. Basically, I wish to add something to it ... unreadable SQL statement for VBA. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

615 views

1 answer

ms access - Find function in Form Code Module

I am to investigate many Acccess applications and it would make my life easier to make a script, if possible. ... to Form.Module. Please help! See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

522 views

1 answer

ms word - Regex code for any string containing BOTH letters AND digits and possibly underscores and dashes

My regex knowledge is pretty limited, but I'm trying to write/find an expression that will capture the following ... and at least one letter. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

893 views

1 answer

ms word - Error 462 in VBA : remote server machine not found

following code is to read a word file in vba. But its showing an error Error 462 in VBA : remote server ... End With End Sub Thanks in advance See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

591 views

1 answer

ms access - What are the limits for ADO data types?

I'm trying to determine the appropriate ADO Command Parameter data types to use for calling a SQL Server ( ... types for various data sources. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

580 views

1 answer

ms access - Escaping non-ASCII characters (or how to remove the BOM?)

I need to create an ANSI text file from an Access recordset that outputs to JSON and YAML. I can write ... #fnum, str_temp Close #fnum End Sub See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

600 views

1 answer

ms access - "Save as..." dialog box in MSAccess vba: how?

In MSAccess I've a mask with a button. When the user clicks on the button, the data in a table are exported ... export the data. Is it possible? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

725 views

1 answer

ms access - Navigating to a different tab in navigation subform

In an ms access 2010 database, I have a listbox whose afterupdate procedure needs (among other things) to ... different record in the listbox? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

718 views

1 answer

ms access - Repeat records according to a quantity field

I have an Excel sheet which I receive from my customer and I get imported to Access and I would call that ... right now I'm doing manually. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

609 views

1 answer

ms access - 64-bit Alternative for Microsoft Jet

Microsoft has chosen to not release a 64-bit version of Jet, their database driver for Access. Does anyone ... use any 64-bit functionality. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

557 views

1 answer

ms access - Using MsgBox without pausing the application

I need to display a message to the user. When I do this using MsgBox, the program stops until the user ... MsgBox without pausing the program. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

921 views

1 answer

ms word - Console log in Javascript Office Addin

I have a question about "console.log" in Javascript Web Office Addins. Currently I am working on Javascript Word ... Visual Studio. BR, Alexey See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

418 views

1 answer

ms word - How to add 5 business days to an existing value xslt

I have a string called "DateSet" with the value "16/10/2008". I want to add 5 business days to that ... ms:format-date and convert it somehow? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

591 views

1 answer

ms word - VBA WS Toolkit, how to get current File as Byte Array

Using VBA I want to send a copy of the current word document to a web service? How can is get the ... =) So simple answers are appreciated See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

951 views

1 answer

ms word - How to open document that contains AutoOpen macro with PowerShell?

My current PowerShell script: $document = "C:\test.doc" $word = new-object -comobject word.application $word. ... 2 Powershell Version 1.0 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

673 views

1 answer

ms access - ADODB Connection String: Workgroup Information file is Missing?

I have a few data sources in access that I need to connect to programatically to do things with behind ... there got some useful information? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

651 views

1 answer

ms access - How to get rid of VBA security warning

I developed a Access application using VBA. Everytime I open Access up, I get the following: I have to click ... not get rid of the warning. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

825 views

1 answer

ms access - Making "DoCmd.GoToRecord" function work on a subform

I have been using the function DoCmd.GoToRecord , , acNewRec successfully for creating and moving to a new record ... sbfrm_subform is nt open." See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags