Recent questions tagged MS

0 votes

812 views

1 answer

ms access - insert query with sequential primary key

I am using an MS Access append query to append inventory transactions to my ERP database (MYSQL). ... D, qry_transaction_ID_generator AS T; See Question&Answers more detail:os...

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

0 votes

968 views

1 answer

ms word - PHP to clean-up pasted Microsoft input

I have a site where users can post stuff (as in forums, comments, etc) using a customised implementation of ... filter to rule them all. See Question&Answers more detail:os...

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

0 votes

811 views

1 answer

ms access - Why is my query not updateable?

I'm trying to build an updatable view in Access for a user. Basically, the underlying tables look like this ... writing views. Any suggestions? See Question&Answers more detail:os...

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

0 votes

715 views

1 answer

ms access - VBA: Difference in two ways of declaring a new object? (Trying to understand why my solution works)

I was creating a new object within a loop, and adding that object to a collection; but when I read back ... the first implementation was wrong? See Question&Answers more detail:os...

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

0 votes

913 views

1 answer

ms access - SQL Updating from an inner join

I'm using microsoft Access. If this query: (SELECT FERMENT.FermentId FROM FERMENT INNER JOIN [BELGIUM BEER] ON ... .FermentId ORDER BY [BELGIUM BEER].BeerId) a Question&Answers:os...

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

0 votes

999 views

1 answer

ms access - Difference between Microsoft.Jet.OleDb and Microsoft.Ace.OleDb

It has been a good number of years since I did some programming with Classic ASP and Microsoft Access where we ... Oledb" driver when you buy MS Access 2010? Question&Answers:os...

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

0 votes

1.0k views

1 answer

ms access - Syntax error in insert into statement - what's the error?

this is the full code here for a button to add data to 2 different tables the weird thing is that i ... & "')" clientssubform.Form.Requery End Sub Question&Answers:os...

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

0 votes

924 views

1 answer

ms access - create form to add records in multiple tables

I am new to access (I have only 2003 version) and I am getting crazy. Consider also that I am a novice with DB in ... of a main one, do I need queries, or what? Question&Answers:os...

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

0 votes

770 views

1 answer

ms access 2016 - How to design a query to give names of each related field linked to each set of data

I have a table that contains run numbers. This is then linked to a second table that contains the serial numbers of the ... 2 Is there a way to set this up? Question&Answers:os...

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

0 votes

1.0k views

1 answer

ms access - SQL Query - Using Order By in UNION

How can one programmatically sort a union query when pulling data from two tables? For example, SELECT table1 ... attempted on MS Access Jet database engine Question&Answers:os...

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

0 votes

763 views

1 answer

ms access - How to get matching data from another SQL table for two different columns: Inner Join and/or Union?

I've got two tables in MS Access that keep track of class facilitators and the classes they facilitate. The two ... needed...As described in this other post. Question&Answers:os...

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

0 votes

747 views

1 answer

ms access - What are the rules governing usage of brackets in VBA function calls?

I've just had an irritating 30 minutes on a "compiler error" in VBA (Access 2003) caused by my use of ... /forbidden, but can't find any clear guidelines. Question&Answers:os...

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

0 votes

1.4k views

1 answer

ms access - java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why?

I have created an MS Access database and assigned a DSN to it. I want to access it through my Java application. This ... "..");. Why am I having this Exception? Question&Answers:os...

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

0 votes

1.1k views

1 answer

ms access - SQL multiple join statement

When I had only one inner join in my SQL statement, it worked perfectly. I tried joining a second table, and now ... AND [course_number]='" & myCourseNum & "'" Question&Answers:os...

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

0 votes

879 views

1 answer

ms access - Combine values from related rows into a single concatenated string value

I'm trying to aggregate some instructor data (to easily show which courses an instructor taught in a semester), and up ... SQL selects or will I need to use VB? Question&Answers:os...

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

0 votes

920 views

1 answer

ms access - How does one decompile and recompile a database application?

I have an Access database application and I would like to know the proper way of decompiling and recompiling it. Question&Answers:os...

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

0 votes

916 views

1 answer

ms access - VBA to autofill image control from table/query column

I have a form that auto-populates text boxes from a table/query when a line in a listbox is clicked. ... /questions/65830018/vba-to-autofill-image-control-from-table-query-column...

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

0 votes

1.0k views

1 answer

ms access - Run multiple SQL actions in a single procedure

I'm still quite new to SQL so pardon bad terminology. I'm using MSAccess. I have a pass-through query ... .com/questions/65844440/run-multiple-sql-actions-in-a-single-procedure...

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

0 votes

858 views

1 answer

ms Access VBA using a string from another form?

I have a form called RetailEntry that has two columns I'm attempted to use as a string for when my users hit ... /questions/65892570/ms-access-vba-using-a-string-from-another-form...

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

0 votes

828 views

1 answer

ms word - Saving docx as a filtered HTML flattens some images to a height of 1

I've inherited a build system that uses chmProcessor to convert a docx file to a chm file. Not ideal obviously, and I ... -as-a-filtered-html-flattens-some-images-to-a-height-of-1...

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

0 votes

792 views

1 answer

ms word - Converting Email to PDF

I have expended a good deal of effort trying to convert emails to PDF. I am using Delphi 10.4 although ... from:https://stackoverflow.com/questions/65904761/converting-email-to-pdf...

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

0 votes

902 views

1 answer

ms access 2010 - Statement filter with control

Why the statement is no filtering with the variable Busca ? Private Sub Txt_busca_Exit(Cancel As Integer) ... ://stackoverflow.com/questions/65912867/statement-filter-with-control...

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

0 votes

1.0k views

1 answer

ms access 2010 - ACESS RELATIONSHIP

I have set relationship like this i can't edit in query shows error as like this when editing WO ... question from:https://stackoverflow.com/questions/65917062/acess-relationship...

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

0 votes

809 views

1 answer

ms access - SQL IF / CASE how TO

I've been trying research online on how to combine "If" statements into my query. Suppose I wanted to create a ... :https://stackoverflow.com/questions/65919605/sql-if-case-how-to...

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

0 votes

825 views

1 answer

ms access - Solution for virtualizing a VB6 application

Closed. This question is opinion-based. It is not currently accepting answers. question from:https:// ... .com/questions/65924024/solution-for-virtualizing-a-vb6-application...

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

0 votes

1.0k views

1 answer

ms word - phpword total pages not printing correctly from browser download

I am creating a phpword document that should have a "Page 3 of 8" style footer on each page. ... /65928786/phpword-total-pages-not-printing-correctly-from-browser-download...

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

0 votes

821 views

1 answer

ms access - How can i add data from table to other sql

i have 2 department and created new one, i want to update employee departmant but if that employees id equals one of ... /65935553/how-can-i-add-data-from-table-to-other-sql...

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

0 votes

900 views

1 answer

ms access - How to turn off proper-case correction on a specific field?

I have an Access-based Employee table and have a field to hold username values. The username format for the ... how-to-turn-off-proper-case-correction-on-a-specific-field...

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

Categories

Just Browsing Browsing

Most popular tags