Recent questions tagged ms

0 votes

886 views

1 answer

ms access - How to create parameterized queries in vb.net?

Using parameterized queries with ms access 2003 integration. To search any data according to different criteria. See Question&Answers more detail:os...

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

0 votes

962 views

1 answer

ms word - Select page in docx using C#

I'm currently getting the entire word document in a variable as below: docs.ActiveWindow.Selection.WholeStory(); docs ... select page by page. See Question&Answers more detail:os...

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

0 votes

920 views

1 answer

ms access - Handle TransferText Errors

I have an Access-2007 application, I use Visual Basic to export/import tables from text file. DoCmd.TransferText ... import fails. Any idea ? See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

ms office - Making Word document embedded in a web page editable or read-only

I'm embedding some Word documents into our web page using iframe like this: <iframe src="ftp://ftp. ... an web server without Sharepoint?) See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

ms access - get 65K records only listed in combo box from a table of 155K records

I have a table of 155K records. I can scroll only 65K records in combo box of a form having recordsource ... all records outside of the form. See Question&Answers more detail:os...

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

0 votes

814 views

1 answer

ms access - Aggregate multiplicate function

I have a table of the following: 1 X 10 2 X 30 3 Y 5 4 Y 2 ...etc I need to turn it into: ... *multiply**(field3) from t group by field2 Thanks See Question&Answers more detail:os...

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

0 votes

597 views

1 answer

ms access - Does ACEDAO support row level locking?

There was a problem with DAO 3.6 in that it didn't support row-level locking. For details, see this ... ACEDAO supports row-level locking? See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

ms access - What is the fastest way to insert 100 000 records into an MDB file in C#

I know this questions is rather general, but I have searched the whole day and I haven't been able to find ... proper way to do this faster? See Question&Answers more detail:os...

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

0 votes

654 views

1 answer

ms access - Call function for specifying columns in SQL TRANSFORM query

Here is my query: PARAMETERS ... TRANSFORM ... SELECT ... ... PIVOT Mytable.type In ("Other","Info"); ... a vba-function inside the sql-query? See Question&Answers more detail:os...

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

0 votes

632 views

1 answer

ms access - How to use LIKE condition in SQL with numeric field?

I'm using this query to get some specific data: "select * from emp where emp_name LIKE 's%'"; emp_nam is ... emp_id is numeric field. Thanks, See Question&Answers more detail:os...

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

0 votes

949 views

1 answer

ms access - Getting "Too many parameters for command", when calling WinSCP command-line from VBA

Upload file via FTP from Excel VBA was very helpfull, I'm using the code to synchronize a local folder to my FTP ... can I do to prevent this? See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

ms office - Word VBA and Multiple Word Instances

Good morning. I am having a problem with getting my code to find other instances of word and ... objWordDocument.Name Next objWordDocument See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

ms access - VBA: OpenRecordset .AddNew method runs slow

I have an Access application which has a table (AuditTrail) linked to SQL Server 2008. I am trying to add records ... I can lower the this time? See Question&Answers more detail:os...

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

0 votes

571 views

1 answer

ms access 2010 - MS Word, Import Table with Query Condition Based on Merge Field

I'm creating a compliance mailing for my organization, the mailing will include merge fields that identify the ... the SiteId merge field? See Question&Answers more detail:os...

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

0 votes

797 views

1 answer

ms access - Active X Error With Excel 2016 And Late Binding

I have Microsoft Office 365 Business installed on my PC and am attempting to run Access VBA to create an Excel ... was stated in the comments. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

ms access - Duplicate Record with New Primary Key (VBA)

I have a very large record that I'm trying to duplicate, then open a form with the new version with a new ... fields to copy the data? Thanks! See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

ms word - how to create docx files with python

I am trying to take my data and put it in tables in either microsoft words or libreoffice writer. I need to be ... easier for me to learn it. See Question&Answers more detail:os...

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

0 votes

722 views

1 answer

ms access - SQL, combining the result

I am using Access and have this SQL SELECT land.id, land.official_name, vaksiner.vaksiner FROM land INNER JOIN (vaksiner INNER ... 2 b A, B, C See Question&Answers more detail:os...

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

0 votes

589 views

1 answer

ms access - Creating a report that will display a number of images from filenames in a table

I have a VBScript that I use to read an XML file and populate a couple of tables in Access 2010. The ... filenames to display on the report. See Question&Answers more detail:os...

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

0 votes

666 views

1 answer

ms access - Exporting data into a pre-formatted file

I am using Access 2007 and I wish to export my data into a text file with a '.' separator. I don't seem ... so I could have my '.' separators. See Question&Answers more detail:os...

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

0 votes

697 views

1 answer

ms access - Time comparison in VBA: inequal while same time

I'm moving a database from Microsoft Access to SQL server, and am validating data equality between the remote and ... simple way to avoid this? See Question&Answers more detail:os...

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

0 votes

922 views

1 answer

ms word - How to extract text inserted with track-changes in python-docx

I want to extract text from word documents that were edited in "Track Changes" mode. I want to extract the ... , python 3.4, Win7 Thanks See Question&Answers more detail:os...

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

0 votes

899 views

1 answer

ms access - Inconsistent results when checking for Null values (Jet DAO vs. ACE DAO)

In a VB6 program accessing an MDB file, the following SQL query is being executed: > Select * FROM [table1] ... DAO accessing older MDB files? See Question&Answers more detail:os...

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

0 votes

823 views

1 answer

ms access - error code 3021 either bof or eof is true or the current record has been deleted

I have an Access 2003 database with some visual basic code using ADO calls in it. When I do a strsql0 = "SELECT ... me what I am doing wrong? See Question&Answers more detail:os...

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

0 votes

876 views

1 answer

ms access - CDate type mismatch error

I'm trying to convert a text field into a date using CDate() in a recordset but keep getting a type mismatch ... rst = Nothing Set db = Nothing See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

ms access - bind checkbox with a bit column in a SQL Server linked table

I'm trying to bind a checkbox with a bit column in a SQL Server linked table. I had an error about the type at ... Bit. all I want is a Boolean. See Question&Answers more detail:os...

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

0 votes

673 views

1 answer

ms access - Passing Query Parameter to Sub-Report

It has been a long time since I have worked with MS Access and am not sure if I am doing this right. I ... use that site.) Thanks for the help See Question&Answers more detail:os...

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

0 votes

829 views

1 answer

ms access - VBA how to run a string as a line of code

Is there a way to convert a string into an executable line of code? something like: Dim Line1 as String ... tips would be appreciated. Thanks See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags