Threads Replies Last Post 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17   Run-time error executing a query from within a function I am trying to execute a append/insert query as part of a function in access 2000. I have tried docmd.openquery and docmd.runsql and both give "Run-time Error 4286: You can't cary out this action at this time". I am calling the function from within a query, which works fine if I take out the docmd lines. My docmd query is trying to insert into a seperate table not associated with the cal... 3 19.01.2006 16:37:14 How to Set a Default Output Folder in VBA Module In an Access 2003 application we often use the Tools > Office Links > Analyze it with Excel (or Word) with queries to generate spreadsheets. On one server, Acces tries to create these spreadsheets in a folder which is not accessible to the users - so an error occurs. The Tools > Options > General > Default Database Folder option is not an option - we are using an MDE app... 2 19.01.2006 00:07:02 Problems Multiplying First, I would like to thank all that post here and all that answer questions here. I have been reading and learning here since about 1997. I have created an application using Access 2000 in Windows 2000. I have been using access for about 10 years and have never had this happen before – and I am stumped. Application is one form (there are no tables) where user enters 2 dates (beginn... 8 18.01.2006 20:58:05 RecordSet error message Hi, I am trying to use Recordset to get a particular field called Priorities, with two condition (atype (this is a string pass in from the function/module) and DDate (this is a date field in the table)) and I would like to assigns this priorities to textboxes, eight different textboxes. ProgramIPT and DDate, Priorities are fields in the table. See the code below.....from the code below... 2 18.01.2006 17:49:10 Newbie, set warnings off does not work Hi I've created an application using AccessXP in Windows XP, when I upgraded to Access2003 every time I open the database it shows various warnings messages about code and security issues, I've tried placing Set Warnings off in the autoexec macro, but with no success, everything was working fine in AccessXP, can anyone help me? Best Regards ... 3 18.01.2006 05:24:33 How to shut down the computer from access in winXP Res. All, I was using an API to shut down the computer right from access application via a click of a button. It was working well in win98 and now I have upgraded my computer to winXP. That functionality does not work in this platform. Is there a new API for winXP? Please help Thanking you in anticipation Sorry for taking your time Yours Prashant ... 4 18.01.2006 02:11:34 Recordset ? Hi, what is the function or how can tell the number of items in a recordset, that is the number of row in a recordset. thanks t ... 4 17.01.2006 17:55:06 Recordset help Hi, I am trying to use Recordset to get a particular field called Priorities, with two condition (atype (this is a string pass in from the function/module) and DDate (this is a date field in the table)) and I would like to assigns this priorities to textboxes, eight different textboxes. ProgramIPT and DDate, Priorities are fields in the table. See the code below.....from the code below... 2 14.01.2006 15:35:54 Export only works in step mode or manually Ver03 Hi All, When I run the code containing this line in my procedure and step through each line it runs perfectly. DoCmd.TransferDatabase transfertype:=acExport, databasetype:="Microsoft Access", _ databasename:=strDB & strWkOrd & strCaseCode & ".mdb", _ objecttype:=acTable, SOURCE:="WkDt", _ Destination:="WkDt", structureonly:=False When I take out the break point and let it run from ... 3 13.01.2006 16:31:04 Lock out users when running a make table query I need to run a make table query on a backend db and it won't run unless everyone else is not using the system, of course. Any ideas on how to handle this. I thought of duplicating it on the local systems and having it update as they log in but I'd rather not unless that's the best I can do. The data is on batch updated daily the first thing in the morning but some of them are on the sy... 8 13.01.2006 15:26:51 How to detect database type Howdy, Does anybody have a good idea for how to detect what kind of database one has connected to. I'm using DAO and a connection string, but I could use ADO if necessary. The database could be Oracle, MySQL or PostgreSQL, and maybe even an mdb file. I would like to write a select case statement to do different things depending on the capability of the database. Thanks, Mattias... 3 12.01.2006 21:19:33 export to email addressbook Hi, how can I export my access 2002 database information to a Eudora Addressbook? It uses lidf format in Eudora. Any ideas? Thanks Octavee ... 2 12.01.2006 12:35:24 Send Report via Outlook I'm using Access and Outlook 2002. I have a Maintenance work order database with a form that creates a work order report. I have a command button to submit the work order report via Outlook. I'm trying to use the following code to send a report via Outlook: DoCmd.SendObject acSendReport, "rptMaintWO", FormatTXT, "email address", _ , , "Maintenance Work Order", , False I also h... 2 12.01.2006 12:12:03 Syntax error - (Missing Operator) in query expression help Hi, I am getting syntax error message from this Insert Into queries...this is a jet database Accomplishment is a text type, ImsRef is a number type, [Key] is a radio button, [Date] is a date type, ProgramIPT is a text type. This different queries are all the same but I am getting error messages from them all. CommandText = "INSERT INTO tblAccompliment(" & _ "Accomplishment, ImsRef, [Ke... 3 11.01.2006 15:11:07 DoCmd.SetWarnings creates error? In all my years of programming Access, I haven't run into this error before: "The command 'SetWarnings' isn't available now." Anyone out there have a clue what might be triggering this behavior? Some context: This, coming from an application that has been running like a happy hamster for months on a daily basis without much complaint. The only salient change made to the program wa... 1 11.01.2006 14:43:01 Wait within VBA code in a module Does anyone have a trick to allow me to simply wait for a specified time within a module (I'm in a public function within a common module). I want to be able to wait 10 seconds to allow some external thing some time to complete. This external thing is not under my control and will not do anything to signal completion (to me, at least). This external thing is not a shell function. When ... 3 10.01.2006 17:20:53 Problem With FileCopy Statement I am writing a little backup routine to copy and compact mdbs. Unfortunately FileCopy quits if the mdb being copied is open by another user. Is there some way to force a copy to take place? And Name doesn't work either. Thanks.... 4 10.01.2006 15:45:10 Code to produce HTML from Query I have a query that produces membership information, used for posting on the internet. If we run the query to export as HTML, the output is loaded with HTML tags, that really aren't necessary. I can cut the file size by 75% by removing these tags. Removing the tags is presently being done manually. Is there a way to control the tags that Access puts into an exported HTML file or perhaps cod... 2 08.01.2006 21:08:36 Setting a temporary lock on a record I have a front-end / back-end application in which has several places where the program (in the back-end) needs to set some sort of temporary lock, perform two or three database changes in different areas, and then release the lock. [The application is totally form-driven (beginning with a startup form)and everything is done in forms that the user opens by clicking buttons (with VBA code b... 6 08.01.2006 17:15:02 /excl clarification I have a front-end / back-end application with three computers sharing a database on a server. The user coordinator requested me to come up with something that locked out the user if he tried to open two copies of the FE on one computer (i.e., if the user clicked the icon too many times --- I guess that would be 4 times). Anyway, I received such a request. So I was looking at the /excl c... 5 07.01.2006 20:31:44 How to save a form after programmatically changed? I'm trying to save the value of a public variable in a MSAccess2000 database, so that when its closed it retains the last user defined value, somewhere in the mdb. Well, just like a default value.. I think this could be easily done using a specific 'uni-row' 'uni-field' table for the storage, but I don't consider this to be a 'clean' solution, and so I was looking for a way to store... 3 07.01.2006 09:05:41 Powerpoint from Access Hi, I have two questions. 1.) How can I use a template for a PowerPoint generated through Access. 2.) I would like to insert a graphic or picture in the PowerPoint slides I generated from Access with the code below. Dim pptApp As PowerPoint.Application Dim pptPres As PowerPoint.Presentation Dim pptSld As PowerPoint.Slide Set pptApp = New PowerPoint.Application Set pptPres = pptA... 3 05.01.2006 12:38:17 Access 2003-Broken reference-not finding library in subdirectory MSKB article 824255 says that as its last step in resolving a library reference, it will look in "The folder that contains the .mdb file ... and any subfolders. This does not seem to be the case. I thought I had set my application up cleverly by providing a Library subfolder which contained the libraries I need. (It would be nice if it checked this path first instead of last, but th... 5 05.01.2006 00:49:04 Date formats in Excel extracts I created an Excel extract of my Access database for a client. My database has several date fields (all defined in Access as "Short Date"), but these ended up in the spreadsheet with a format of "General". Is there a way to have these wind up with Excel's "Date" format so the spreadsheet can sort properly? Bob. ... 3 04.01.2006 21:41:34 sql statement returns wrong value Hi, i have a very strange problem: when I run a sql-statement (code below) in VBA, it returns the wrong value. When i run that same sql-statement in a query, it returns the right value. Anyone knows what the problem could be? Please help. Kind regards, Nico. Dim rstRecordset As New ADODB.Recordset With rstRecordset .ActiveConnection = CurrentProject.Connection .Ope... 7 04.01.2006 11:05:03 17 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17