Threads Replies Last Post 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13   Current database Location Can someone tell me if there is a property to find the location of the database that is currently open? I want to determine the path location of the file so I can set a variable to upload an Excel file. I was hoping to use some code like the following: Dim sPath as String Dim db as database Set db = currentDB() sPath = db.FileLocation Thanks, Tony ... 7 31.03.2006 16:50:00 extract list of forms name from another access project I wrote an Access Project Application... All I need is to get the list of forms existing in an external access project (adp). Any suggestion, please? ... 2 31.03.2006 14:14:04 Database Module How do I access a database with a module that is contained in the database? I keep getting a message that the database is being used. I can access a database from another database but not from the database that contains the module. Thanks for your assistance. -- Rick... 6 30.03.2006 17:07:27 Trouble with a rather simple function Hi all! I have a problem while trying to use a rather simple ADO function. Here is the situation: Server: SQL Server 2005. I have all permissions on this server and its objects, databases... Database: TEST_ADO containing one table as follows: Table: Table_1 with 2 columns: COL_1(primary key, integer, not null) COL_2(nvarchar(50), null) The database also contains a stored procedure: ... 3 30.03.2006 12:15:28 Microsoft Document Image Printer - MODI Registry Settings Does anyone know what are all the available registry settings for MODI? Through much searching in google (msn search finds nothing) I've found the following the following ' Write to File Only (uses current save folder and Note####.mdi as file name) SetKeyValue HKEY_CURRENT_USER, "Software\Microsoft\Office\11.0\MODI\MDI Writer", "PrivateFlags", 1, REG_DWORD ' Don't Show Popup Window ... 1 30.03.2006 01:05:20 Layered Do...Loop problem (Access 03) I have two recordsets which are getting the appropriate data. The first recordset, rsAddress, is a list of IDs (and other data) found in the second recordset, rsAltAddress, which need to be deleted from the second recordset. set rsAltAddress = MyDB.OpenRecordset("Select * from IndivsAltAddress Order By IndivsAltAddress.IndivID") In IndivsAltAddress, IndivID is an indexed ... 2 29.03.2006 17:24:02 Editing or adding a record I'm trying to edit a record. First I connecto to an excel spreadsheet and then to a sql server table via odbc. I load the first row of the spreadsheet, find the record in the table, if it exists. If it exists, then I want to edit it. If it doen's exist I want to add it. Here's my code so far. This is just a small test of the edit. It doesn't like this. Also when it cannot find ... 1 29.03.2006 16:02:05 DAO a ADO Hola, necesito convertir el siguiente código a ADO: Dim DaoRs as Dao.recordset Set DaoRS = Forms!frmTLP!sfrmTLPVidaMes.Form.RecordsetClone DaoRS.OpenRecordset Esto funciona, pero lo necesito en ADO u obtener los datos desde la consulta (parametrizada) de la que el formulario recibe los datos (en ADO). Estoy utilizando: dim rs as new ado.recordset sql="select * from consulta"... 1 29.03.2006 09:32:04 Form To Report Hi again, I have another question that someone may be able to help with, My D.B is all to do with producing Rota's for the coming 24hr period(s) If you imagine I have on my screen a staff record, it gives me all the info I need about them, I can then click 'Call Out' and this brings up a pop up form with Name and Phone Number, Role and Location, these are filled from combo boxes, what I w... 1 29.03.2006 09:28:01 can Nz() be used in VBA? I have this in an SQL where clause. I'm getting an error, and I don't see it. ((" & Chr(34) & Nz([orders].[Paragraph], "") & Chr(34) & ")=" & Chr(34) & Nz([Forms]![OrdersUnbound]![Paragraph], "") & Chr(34) & ") I've never used Nz before, can it be used or do I have to evaluate the Orders.Paragraph with an If before the SQL is evaluated?... 5 28.03.2006 17:52:02 Combo Box-txt box combination Hi All, I am at present putting a Form together that lists different people into different roles using combo boxes to look up a name from a query specfic to the role they perform, what I want to do is put a txt box next to the combo box that shows the selected persons phone number when they are selected, I can do this in excel but for some reason I cant get it to work in access, any h... 3 28.03.2006 14:35:01 Getting all fields for a certain table Hi, Is it possible to dynamically get a list of all the fields for a specified table? If so, how is it done. Many thanks in advance. Arthur. ... 15 28.03.2006 12:26:02 Transfer 2 related tables into 1 tab del text file Hi There, I've got an annoying problem in that I have more than 255 varaibles, hence I've had to split and link the various tables. I was wondering if it could be at all possible to export and append these tables into one tab del test file? or even csv? as this appears to be my only option to have one file with all the variables. Any assistance will be greatly appreciated! Thanks J... 2 28.03.2006 12:24:57 getting data from AS400 I am working on a front end in MS Access, but ALL information is currently entered and stored in an AS400 mainframe at this point. So users get the data by us using Showcase, having it export data into a .csv file, and then us distributing a .xls to users. There HAS to be a better way. I would like to have users use an MS Access front end to somehow query and view the data in the AS40... 4 27.03.2006 08:47:01 Import multiple tables I have to import 4 tables from each of 15 branch applications for a total of 60 tables. Since it would have to be done every time I bring in data, I set it up in VBA as follows to import the tables: DoCmd.TransferDatabase acImport, "Microsoft Access", strPCMan, acTable, "tblEmployees", "tblEmployees" The only issue I have is that when I do it manually, I can connect to each branch ... 1 26.03.2006 22:57:34 Obtain Autonumber value after record creation. When adding a record to a table whose key field is an autonumber field how can I obtain it's value with 100% confidence. Sure immediately afterwards I can read the last record in that table and 99% of the time be sure it's the one I have just created but there is still a slight posibility that another proceess may have created a new record between my create and my read. -- Regards ... 12 23.03.2006 02:00:35 Populate a form with a recordset I've got three books on programming ADO, and I don't see a clear cut and dry way to populate a form with a recordset. I have populated a test form. but I'm not sure how it happened. I used: For Each Ctl In Me vartemp = Rst.Fields(Ctl.Name).Name If Ctl.Enabled Then Ctl.Value = Rst.Fields(Ctl.Name).Value End If Next fro... 2 22.03.2006 22:12:34 SELECT with WHERE with .FINDFIRST I am trying to select all records from table T_Availability where ITEM = E_ITEM, SEVERITY = E_SEVERITY, however I can't get the following to work. I get problems on the WHERE. I get a "Data type conversion error", however both ITEM & E_ITEM are both strings - If I remove the WHERE clause then it works fine but then when the .FindFirst is done it returns nothing - help. Dim rst As DAO.R... 6 22.03.2006 08:29:27 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:19 ¤ China ZhongZhan Aids Mei Mei Killer! http://onfinite.com/libraries/175399/440.jpg elmar@digi-art.de ... 1 21.03.2006 12:48:13 Trap SQL Server Error 4060 I'm using Access 2003 and conneting to a SQL Server Database. When the database first opens, a vba function is called and creates the dns-less connection and it works great if the server name and database name exists. If I change either the servername or database name to a non-existant one,is there a way to trap the default "SQL SERVER Error: 4060" message in VBA? The on error go to tra... 3 21.03.2006 04:26:29 correct code please I apologise if this is considered a repost, I posted below about the method of Object... I got a response and spent the past 4 hours trying every combination to not get that error and the only way is to omit the criteria. This is the code I have that I think should return one record and is giving me the error. CntStr = "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data Source=C:\Traffi... 8 20.03.2006 22:32:37 Newbe- method of object_recordset failed I am trying to get used to working on an unbound form, I can open a recordset without conditions, no problem, but when I try even a simple condition I get the error in the subject. I am just trying to open a recordset to check for duplicates, so I would expect that if the condition isn't met I would get an EOF. I've built the sql in a query that works, so I know the syntax is right, a... 4 20.03.2006 18:21:52 Ink Sorry guys. The spam stuff was not my intent. I do oppoligies and won't happen again. I have never been on newsgroups before and not sure how to work them. I hope you guys can forgive a bad choice. Murphey... 1 20.03.2006 12:25:48 Map drive "on-the-Fly" I need a way that when a file is created that it will be sent to a directory that is on a dialer. Problem is that if user is using db and doesn't register before hand the path, then error will occur, was wondering if there is a way that I have like an on the fly mapping of the drive and after completion have that drive delete from user pc. thanks... 3 20.03.2006 08:04:40 13 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13