Forum Widgets
Latest Discussions
VBA Code Slow in Exporting HTML Files
After today's updates (which may have included older patches), every HTML page is taking several seconds to export (using VBA code within the Open Event of a form that is automated to run using a looping Batch Script START command and exports an HTML versions of reports). It may simply be the numerous updates that may be affecting the server CPU. But I'm also wondering if this is a known issue.SolvedScottLamondNov 04, 2024Brass Contributor60Views0likes1Comment- tim-asiaNov 04, 2024Copper Contributor81Views0likes2Comments
开元棋牌开户-17300435119
选择编程语言:许多编程语言都可以用于访问 Web 数据库,如 Python、Java、PHP、Node.js 等。以 Python 为例,它有丰富的数据库访问库,如 SQLAlchemy 和 PyMySQL。安装数据库驱动:根据所选择的编程语言和数据库类型,安装相应的数据库驱动程序。例如,如果使用 Python 连接 MySQL 数据库,需要安装 PyMySQL 驱动。如果是连接 PostgreSQL 数据库,可以安装 psycopg2 驱动。tavahshjgvNov 04, 2024Copper Contributor47Views0likes0CommentsAccess to Word Document
Office 365. I have an Access report with one image (logo) and 4 subreports as a Print Preview. I need to save it as a Word .docx. Would it be best to just use the export to word command on the Print Preview tab or should I try to set it up as a merge document? It would require subdocuments, I believe. I will need to give it a unique name, based on the data in the report. Once it is in Word, can I make changes from Access? Can I re-open the Word document from Access at a later date to edit it? OR is there a better way??? Please help. Thanks in advance.Maxine14062Nov 04, 2024Brass Contributor182Views0likes6CommentsError message 'Microsoft Access can't open the form 'Temp.''
I work with an Access database designed 30 years ago with which I've had no problems with until today. Suddently, when I try to run some functions (crosstab query or design a query) I'm getting this error message: "Microsoft Access can’t open the form ’temp.’ It contains data that Microsoft Access doesn’t recognize. Re-create the form or, if you maintain backup copies of your database, retrieve a copy of the form.’" Sometimes the query has time to run before the message appears but once it does, the application freezes. Click OK or close the box or press Escape, the result is the same: Access closes. The form 'temp' isn't one I've created and doesn't appear on the preview pane. I can highlight it using 'analyze performance' under 'database tools' but then I get an error message 'Application-defined or object-defined error' and again the application closes. Exactly the same messages appear when I try to run archived versions of the database which I'd not opened or altered for months - so I think it's an interface issue between the design of my database and a freshly updated version of Access? I've tried the obvious (compact and repair, safe mode, re-downloading Office 365) but nothing changes this. I have tried creating a new very simple database and can run cross-tab queries in that OK.owenjohnsontreesNov 03, 2024Copper Contributor144Views0likes3CommentsAccess - how to joining two queries with different data without doubling data
I'm not sure how to phrase my issue, which makes finding a solution also difficult I'm trying to combine two different queries so I can run a report that shows all of the crops FarmerID is growing as well as the number of livestock . One query is labeled qryCrops and the other qryLivestock. Both queries have the same FarmerID (the unique key). The problem is I have a variety of scenarios: some farmers have multiple crops and only one type of livestock, other farmers have one crop and multiple types of livestock, some have multiples of both, etc. Whenever I try connecting the data, Access automatically doubles the information (see example below). I've tried joining data which hasn't worked. A query with a left join won't duplicate the crops, but will duplicate livestock. A query with a right join won't duplicate the livestock, but will duplicate the crops. I've tried running a left and right join query separately, and then combining both queries into a Union query, and my data still is getting doubled (I suspect that's not the right option as I'm not comparing apples to apples). Nothing seems to work! I've tried searching the internet and have been unsuccessful at finding a solution. Here is what I want; I want access to leave fields blank if there is no data: FarmerID Acres CropType LivestockNum LivestockType Farmer A 6 Pasture 3 Cows Farmer A 10 Hay Farmer B 15 Pasture 2 horses Farmer B 100 chickens This is what I get when I combine the data: FarmerID Acres CropType LivestockNum LivestockType Farmer A 6 Pasture 3 Cows Farmer A 10 Hay 3 Cows Farmer B 15 Pasture 2 horses Farmer B 15 Pasture 100 chickens Any thoughts? Our reports are currently set up to show the farmers and all of their crops, then the next section has the farmers and all of their livestock. I want a report that's grouped by the farmer so it shows all of their information in one place (without doubling data), then moves on to the next farmer. I'm hoping the query solution mentioned above will solve that. Thanks in advance!nicoleethierNov 02, 2024Copper Contributor199Views0likes8CommentsODBC Timeout Problem
Hi, I am calling a SQL Server stored procedure from my MS Access program and am getting the ODBC timeout error. When I run the stored procedure from SSMS, it executes in less than one second. I am passing no input parameters and the results are not returned from the stored procedure - they are written to a table instead. How can I avoid the timeout error? Dim cnn As New ADODB.Connection Dim cmd As New ADODB.Command connString = <all the usual stuff> cnn.Open (connString) With cmd .ActiveConnection = cnn .CommandType = adCmdStoredProc .CommandText = "usp_GetUnbilledItems" .Execute ---Times out here. End WithAccess_JimNov 01, 2024Copper Contributor171Views0likes3CommentsOpening Excel from an Access Command Button
I am trying to open the MS Excel Application from a Command Button in Access. the Code I am using is Private Sub MicrosoftExcel_Click() Dim App As Object Set App = CreateObject("excel.Application") App.Visible = True End Sub When clicking on the Command Button, I can see Excel start to run in the taskbar, but it immediately closes. I have no problem starting Word using Private Sub MicrosoftWord_Click() Dim App As Object Set App = CreateObject("Word.Application") App.Visible = True End Sub Anyone have any suggestions?SolvedMichaelB200Nov 01, 2024Copper Contributor150Views0likes3Comments- SYAIFULNIZAMSHAMSUDIN-01Oct 31, 2024Copper Contributor134Views0likes0Comments
ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for...
ODBC --call failed. [Sage][Support] (40190) Data conversion algorithm not supported for SQL_BIT to SQL_TYPE_DATE. (#40190) I'm trying to execute an update statement in MS Access using the following, but keep getting an error message: Any ideas what I'm doing wrong here? Appreciate any feedback.SolvedJayS555Oct 31, 2024Copper Contributor148Views0likes6Comments
Resources
Tags
- Access1,591 Topics
- Office 365349 Topics
- 2016191 Topics
- Developer177 Topics
- Access Web Database96 Topics
- Access Web App54 Topics
- 201350 Topics
- SharePoint49 Topics
- 201041 Topics
- Admin39 Topics