Threads Replies Last Post 225 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>   Dialouge box pops up while savinf access report as pdf file Hello, I have a VBA code which used to store more than 100 Access reoprts as pdf file . Location to store the file is defined in the code.Recently It statred asking for the location (dialogbox for saveas) to store the pdf file. Interestingly it is not asking the same (dialog box)for one of the user.I am using Acrobat writer 5.0, Adobe distller. Does anyone know how to fix this probl... 2 21.09.2006 00:10:43 Convert Word doc to PDF Corruption At the risk of repeating this question and irritating some folks, but I have read and searched for a solution/code that will accomplish what I need and so far it isn’t looking hopeful. I inherited a database that I converted to Access 2003. There is a button that creates a word document and saves it to a directory. What I would like to do instead is convert this word document to a p... 2 20.09.2006 20:31:02 iterate through records I would like to use a "For Each" statement to interate through records in a subform. Can this be done? i.e. how do I specify the object and collection? Thanks so much!! -- sam... 2 20.09.2006 20:23:45 memo field corruption HI I developed an app (Ac2000/FE/BE) some time ago and all was fine. Suddenly the BE is getting corrupted when updating a memo field. I've tried updating via ADO CMD object, Docmd.runsql and now via an ADO recordset. I've seen some postings that suggest problems when memo size gets over certain number of chars. That sound correct because some records now have large (<2K)ammounts a d... 8 20.09.2006 21:50:01 Edit recordset without updating database I'm working with VBA and Excel and using DAO (it's an oooold app and I'm just trying to make a temp change). I'm connecting to an Access database and creating a recordset via a query to OpenRecordset. I then loop thru this rs and retrieve some IDs. I then connect to a SQL database via a query (using the IDs I've retrieved) to OpenRecordset. I then am trying to loop thru both recordsets and ed... 2 20.09.2006 20:14:02 Why this error Hi in a function i have this code If Not rs.EOF Then Dim db3 As DAO.Database Dim rs3 As DAO.Recordset Set db3 = CurrentDb() Set rs3 = db.OpenRecordset("tilmelding") rs3.Index = "kursusplanid" rs3.Seek "=", rs2("kursusplanid") rs3.Edit rs3("kundenr") = rs("kundenummer") rs3.Update rs3.Close End If it works fine now in another functio... 3 20.09.2006 19:23:02 Verify folder exists I found two techniques on this forum to verify if a file or folder exists: Len(Dir("c:\myfolder\", lngType)) is greater than zero Dir$("c:\myfolder\") does not return a zero length string. Neither of these techniques will detect an empty folder. Anyone know how to verify the existence of a folder that may be empty? -- Message posted via AccessMonster.com http://www.accessmons... 3 20.09.2006 19:18:51 How to delete "Open a shared calendar" when I am the only user Somehow the Calendar will only open when I right click and indicate "open in new window. I can find no way to correct that there should not be a "shared calendar" Thanks you... 1 20.09.2006 19:12:02 SQL db Linking issues I have two questions about my Access 2000 db and the tables are linked to an SQL db. 1. Can I add a field to the SQL table then update the linked tables while other people have it open with MS Runtime. 2. I tried to change the data type in the SLQ table and I get this error: 'tblTrackingData' table - Unable to create index 'PK_tblTrackingData_1'. ODBC error: [Microsoft][ODBC SQL Serve... 4 20.09.2006 18:01:02 building an array from a table I'm storing invoice entries in a table. Since that table contains mulitle entries with the same invoice number, I wish to build a separate table with just one copy of the invoice number stored. I envision reading each record in the master invoice table, keeping only the first instance of each invoice number and then storing those numbers in another table for easy lookup features for re... 3 20.09.2006 18:01:01 IsNull after a time period Is there a way to change the value of a specific field to Null after a certain period of loosing the focus. Thanks in advance for your help. -- Manuel... 3 20.09.2006 16:43:02 Memo field in my replace function Hi all I have a problem with my function. This function cut my variable StringIn on 255 long char. But variable value StringIn is as memo type. For examle 800 long char... Function ReplaceText(StringIn As String) As String Dim NewString As String NewString = Replace(StringIn, "+++", "<li>") ReplaceText = NewString End Function Hepl me please....... Thanks.. --... 2 20.09.2006 15:57:52 Help coding a VBA script for a search feature I'm trying to create a VBA script that will allow a search feature in a dialog box. Basically I want to be able to search for any field and then apply a filter so that only the records that contain the inputted text. Example: I want to search for a record that has "dog" somewhere in the record, and every record that has "dog" in it would be visable. I know this is probably hard to ... 4 20.09.2006 15:50:02 User add link I want my users to be able to safe a link to other documents in the access database. Any ideas?... 3 20.09.2006 15:40:32 Can Someone Help Me Write Want code to execute: File, Get External Data, Import, H:\Inventor\ (So I want this to open dialog box in this directory so user can pick file to Import), Files of Type - Microsoft Excel (Again, would like this to be the default) Thanks so much! Tony ... 2 20.09.2006 15:13:02 Last Record overwritten using .AddNew I am sending information from and Excel Spreadsheet to Access 2003. The connection is fine, the recordset opens fine. When there are no rows in the table, the scripting fails stating Either EOF or BOF is true or a current record is required. When there are records in the table and I run the script in Excel, the last record in the table gets over-written. I can not figure out what I am doin... 3 20.09.2006 15:03:55 A Access macro for comparing the less of 2 values In Microsoft Access, we need a macro for comparing the lesser value of 2 values in separate fields and for the results to populate in one field.... 2 20.09.2006 14:43:02 Copy of File in filesearch result I'm using the filesearch in Access VBA to determine if a specified Excel file exists within a specified subdirectory using the following: With Application.FileSearch .NewSearch .LookIn = strSrceFolder .FileName = strFile When a copy of the Excel file has been created through Excel (opening the file as read only and saving), the filesearc... 7 20.09.2006 14:41:01 Preventing updates to tables not working I have a database that has a table, tblDBUpdateInfo, that stores details about when the database was last updated. One of the fields in that table is AdminLocked, a yes/no field, used to indicate if someone else is updating the database. This table is tied to a form, frmAdminFunctions, that users access to update the database. By pushing a command button, code is executed to determine if... 2 20.09.2006 14:40:46 Multiple If Conditions I'm a newbie to VB coding so any help is great! I have a form with six checkboxes. I need some VB code where if the first five boxes are checked, it will automatically check the sixth box. I can get it to work where if a single box is checked, it will check the master box with the following code: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull([RMATask1]) = False The... 7 20.09.2006 14:39:02 Assigning a Query as Report Record Source I've almost got the answer to my question by reading previous posts, but still need a little help. I have learned that the best way to assign a record source,on the fly, for reports is with the report's Open Event with code such as below: me.RecordSource=SQL However, I'm not sure how to address the query. For example, if the query name is "MyQuery", how should the 'Me.RecordSourc... 2 20.09.2006 14:29:08 Access 2003 Report to WinFax in Code Access 2003, WinFax 10.04, Windows XP I have the following code I pieced together from several posts I have seen on a button on an Access form. I am sorry I can't credit the developer(s). I am trying to print a filtered report to WinFax filling in the cover page with data from an Access form. This works but not together. I get one cover page with name, fax number and company filled in ... 1 20.09.2006 13:54:37 Setting up a specific date I have a "Date Sent" field and "Date Due" field. I want to have the "Date Due" field automatically set 15 days from the "Date Due" field. So if I enter 09/18/06 in the Date Sent field the Date Due will automatically state 10/02/06. Any Ideas???... 3 20.09.2006 13:19:41 Question about ALTER TABLE and ALTER COLUMN Group: I am using Access 2002. I want to add a column to a table (MasterData) in the backend database and then specify that it be an integer with a default value of zero. I am using the following statement to add a column to the MasterData table, but I would like to further specify that the column be an integer with a default value of zero. Can someone suggest the proper syntax for a... 7 20.09.2006 13:06:51 Reporting on Access database query hierarchy Hi there. I've written some (very bad!) Visual Basic that trawls through the Access data dictionary tables and produces a hierarchical report of all queries and what other queries/base tables each one uses, with what join criteria and so on. It works, but runs *very* slowly (because it's written so badly). Does anybody have anything that does a similar job but is written properly, recurs... 1 20.09.2006 11:26:01 225 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  >>