| Discussion Groups Index | first | prev | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | next |
| Re: Migrate VIEW from Access to SQLserver (by Mary Chipman on 03 Jun 2004, no replies) |
|---|
| Delete them and create SQL Server views or stored procedures instead. ... (more) |
| Re: i need Query find field On Access 2000 (by John Vinson on 03 Jun 2004, no replies) |
|---|
|
I do not understand your question. What do you want to find? Please describe your table, and tell us which field you want to search and what you want to search for. ... (more) |
| Access disconnecting from server? (by Diane Yocom on 3 Jun 2004, 2 replies) |
|---|
|
<<sorry for the cross-post, decided to post somewhere with a little more traffic.>> I have an Access 97 database sitting on a Novell server. It currently has ... (more) |
| Replica (by Jean-Pierre Hermans on 3 Jun 2004, no replies) |
|---|
|
Hello, I've created a replica from a db. When i synchronize then the master is changed to replica and i ... (more) |
| eu gostasria de foto (by Leonardo on 3 Jun 2004, no replies) |
|---|
|
Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.693 / Virus Database: 454 - Release Date: 31/05/04 ... (more) |
| Hyperlinks (by TracyG on 3 Jun 2004, 1 reply) |
|---|
|
Does anyone know how to use a field from a form containing an email address which, when the hyperlink is clicked, have it automatically open outlook with the address in the TO: box. I am exploring hyperlinks but am unclear on how they work. ... (more) |
| copy tables in different DB (by Alejandra Parra on 3 Jun 2004, 2 replies) |
|---|
|
Hey Well I have a question ... (more) |
| getting a number from a form (by Andy Levy on 3 Jun 2004, 2 replies) |
|---|
|
Hi 'The value of myTextBox on my form is 106666789.99 ... (more) |
| Help! How to change mouse icon into crisscross? (by JM on 3 Jun 2004, 2 replies) |
|---|
|
Hi, I need to change the mouse icon into a criscross. ... (more) |
| Re: Drawing Shapes on Forms ? (by Adam on 3 Jun 2004, 1 reply) |
|---|
|
Unless I'm missing something too, the facility for drawing on forms in Access 2000 is very basic, and is limited to straight lines and rectangles. But what you can do, without having to import an image, is to insert a Microsoft Draw object on a form. Do this via 'Object...' on the Insert menu. ... (more) |
| Access 2003 less functional than Access 97? (by George Hester on 4 Jun 2004, 2 replies) |
|---|
|
http://support.microsoft.com/default.aspx?scid=3Dkb;en-us;258644&Product=3D= acc Now we know that using Microsoft Office 2003 we lose the Microsoft Photo = ... (more) |
| MobilePhone software (by zlst on 4 Jun 2004, no replies) |
|---|
|
Brief Description: MobilePhone 2 PC manager, easy-to-use with Phonebook, SMS, Logo, RingTone etc.. Key Features: a.. Phonebook and contact management d.. Personalize logos of your phone ... (more) |
| access link text field as memo (by Andy Levy on 4 Jun 2004, 1 reply) |
|---|
|
Hi I have a strange problem. I have two tables in a MySQL database. Both tables have text type fields - however for one table access shows that the ... (more) |
| displaying query results (by =?Utf-8?B?TWF0dGhldw==?= on 4 Jun 2004, no replies) |
|---|
| I have a query that calculates the percentage of votes each contestant has recieved what I would like to do is be able to display the results of my query on my .asp page. The name of my database is "pollresults" and the name of the query is "pollquery" ... (more) |
| Trying to read a binary image in a SQl db (by =?Utf-8?B?QnJhZEBaZWxsZQ==?= on 4 Jun 2004, no replies) |
|---|
| Can Access read a column of 'image' data type in a SQL db. ... (more) |
| Ctrl-C doen't trim anymore (by Osgood on 4 Jun 2004, 1 reply) |
|---|
|
I have accidentally hit some keys that have changed the way Ctrl-C copies. It not copies a group of spaces after a name instead of just copying the name. ... (more) |
| gregorian date (by jane cline on 4 Jun 2004, 1 reply) |
|---|
| how can code converting a date field to the gregorian date ... (more) |
| sharing code between mdb's (by thriveni on 4 Jun 2004, 3 replies) |
|---|
|
I have an access database that has a SQL server backend. I need to create another database that is linked to different tables in SQL server but has a lot of common functionality with the current database that I have. ... (more) |
| Error trying to get database properties! (by Tim on 4 Jun 2004, no replies) |
|---|
|
ms access is unable to load the database properities No explanation or anything! Anyone got any ideas? ... (more) |
| InStr (by gr on 4 Jun 2004, 5 replies) |
|---|
|
intInString = VBA.InStr(aAvailable(inty), strRowSourceSelected) intInString returns always 0 even when ther's a matching ... (more) |
| Combine Multiple Reports to send in Email Attachment (by Steve on 4 Jun 2004, no replies) |
|---|
|
I have multiple reports in my Access application. I have created a macro that will produce all the reports in preview or print mode. I need a way to attach all the reports to an email. I created a macro to format the ... (more) |
| Does not switch from VBE to Access Main Window (by Tony_VBACoder on 4 Jun 2004, 1 reply) |
|---|
|
In Access 2002 (SP2) with WinXP, has anyone noticed a strange behavior where if you open a Form in design mode and select a control on your form (ie: a combo box) and then select the Properties (F4) of that control, then go ... (more) |
| Repair Corrupted Database (by Anne on 4 Jun 2004, 1 reply) |
|---|
|
How can I find someone who specializes in repairing corrupted databases. Ours is in Access 2000 & we are receiving error message 3343 "Unrecognized database format..." ... (more) |
| Data Access Pages (by Tony on 4 Jun 2004, no replies) |
|---|
|
I am creating a data access page linked to a small table in ACCESS...all seems to go ok BUT when i try to change the data in a field, i get a message that the data cannot stored in the source table...i have checked every property ... (more) |
| OT: Bookmarking posts and viewing via the web interface (by Duncan Edment on 4 Jun 2004, 3 replies) |
|---|
|
Is it possible to bookmark a post on trhe web interface, so that you can go to it automatically? It's becoming a pain trying to view a post made some weeks ago, having to go to a page number, and then moving back until I reach ... (more) |
| No Not In List (by Frank on 4 Jun 2004, 2 replies) |
|---|
|
I have a combo box that has a list of employees names. I want to be able to update it without actually having to go to the table and edit from there. I was told to go to the On Not in List event under properties, but I am ... (more) |
| Has anyone EVER seen this message? (by Jerry on 4 Jun 2004, no replies) |
|---|
|
"The Wizard is unable to open your form in Form view or Datasheet view, possibly because another user has a source table open in exclusive mode. Your form will be opened in Design view." ... (more) |
| access 97 .mdb run-time error when open with access2000 (by Michael A. on 4 Jun 2004, no replies) |
|---|
|
Hi, Run-time error '2046' the command or action 'Import' isn't available now. ... (more) |
| Opening database with shortcut (by Chris on 4 Jun 2004, 1 reply) |
|---|
|
I have an Access 2000 database on a network share. One of my users cannot open the database with a shortcut. If she opens Access and then opens the database that way, it works fine. I had her create a fresh shortcut by using ... (more) |
| Access conflicts with Windows ME? (by andrew on 4 Jun 2004, 2 replies) |
|---|
|
Hi, I purchased a health club management software package which uses Access as the database. I have been having ... (more) |
| unspecified error (by akbar_nasr on 4 Jun 2004, 1 reply) |
|---|
|
I develop web application in asp.net with c# language and access database. In some case I recieve "Unspecified error". In my code when db tier is created my connection is open ... (more) |
| access97 and 2000 on one pc - problem (by mla on 4 Jun 2004, 1 reply) |
|---|
|
I installed Access97 upgrade version (we used this version for Office97 Standard) on Windows XP with Office2000 preinstalled. During installation I changed path default path to ... (more) |
| saving in Access (by =?Utf-8?B?Q2F0aHkgVA==?= on 4 Jun 2004, no replies) |
|---|
| In Access 97, when I try to do a Save As an External File or Database, Excel is not listed as a File of Type I can choose. How can I correct that? ... (more) |
| Access 2003 --> 2002 compatibility (by Ken on 4 Jun 2004, 2 replies) |
|---|
|
I'm developing a simple database application in Access 2003. While I recognize that I can't run Access 2003 on a Windows 98 machine, can my Access 2003 .mdb file be opened in Access 2002? Will I lose any functionality? My app includes the usual assortment of tables, forms and ... (more) |
| Code (by =?Utf-8?B?VmljdG9y?= on 4 Jun 2004, no replies) |
|---|
|
I´ve selected de Microsoft DAO 3.6 library and i have the code from here http://www.mvps.org/access/tables/tbl0009.htm Now i don´t know where the codes are saved or if i need to save it in a macro or module ... (more) |
| Linking Tables (by =?Utf-8?B?RGFy?= on 4 Jun 2004, 1 reply) |
|---|
|
1) How can I keep the link to the Oracle tables alive after I've closed down Access? Now, if I close Access down, when I open it up again and run the report (which uses the link to the Oracle table that I get my info from, it asks me for the Oracle instance name, userid, and password again. My users don't know, or need to know, this info everytime they want to run the report in Access. How can I keep that info saved for the linked table so that the users can run the report without having to provide the connection info to the linked Oracle table everytime? 2) How can I automatically refresh the linked Oracle table everytime the users run the report (so that they get the most updated info out of my Oracle table? ... (more) |
| .adm files (by =?Utf-8?B?RXJpaw==?= on 4 Jun 2004, no replies) |
|---|
|
Hello! I need a .ADM fil for outlook 2000 and office 97. Is it somebody how knows where i can download that kind of files. I must have it to set a group policy for alla users. ... (more) |
| Outlook Signature on SendObject (by Techsupport on 4 Jun 2004, no replies) |
|---|
|
Hello....is it possible to use the SendObject method and have the user's outlook signature automatically added to the e-mail? Thanks ... (more) |
| memory-problems with SQL-Query (by Wolfgang on 4 Jun 2004, no replies) |
|---|
|
can you help me? when i run this function,my mdb-File is 140MB bigger than before. i can´t use the importXML - function, because i need the whole xml-File ... (more) |
| displaying units in access number field (by =?Utf-8?B?Z2FsbmV3ZWluaGF3?= on 4 Jun 2004, 2 replies) |
|---|
|
I want to add units to my Access forms that use numbers. I found how to add % sign but I can't figure out how to add mm or deg F or any other kind of units to my numbers without changing it to a text field Can anyone help me? ... (more) |
| List Box (by =?Utf-8?B?TWF0dA==?= on 4 Jun 2004, 4 replies) |
|---|
|
Hey, I have a list box and a query that is connected to the list box like this...[Forms]![Interface]![List169] When I run the query the results come up perfectly. But when I want to select multiple selections in the list box and run the query, it comes up with a blank screen after setting MultiSelect to Simple. Any ideas?? ... (more) |
| Autonumber -Reset to a lower number (by =?Utf-8?B?TWlrZQ==?= on 4 Jun 2004, 2 replies) |
|---|
| I have an autonumber field which is the primary key linked to other tables. I want to set the autonumber field to a lower number i.e I started at 90000 and and now have exceeded 99999, six digits wont work for me. I want to reset to 50000. I have tried the append method, but the autonumber still increments from the highest number 100004 ... (more) |
| frefreshlinks (by =?Utf-8?B?VmljdG9y?= on 4 Jun 2004, 2 replies) |
|---|
|
Excuse me, where do i need to put the code (fRefreshLinks) to run it ? I´ve inserted it in a module and appears a Compile error (i´m using acces 2000) User_defined type not defyned. I hope that you can help me because i´ve used access just a few times ... (more) |
| Command Button Opens blank record of seperate form with certain field pre-filled (by =?Utf-8?B?Q2FybmVnaWUyMw==?= on 4 Jun 2004, no replies) |
|---|
|
I want to add a command button to a form "TenantsForm". The command button opens up a form "PaymentsForm" but automatically goes to a blank PaymentsForm with nothing but the "TenantID" field filled in. The TenantID should automatically match the TenantsForm TenantID. If I try to use the wizard, it only takes me to pre-filled forms or a completely blank form. ... (more) |
| Shared DB access (by =?Utf-8?B?YXJjaGFlb21hcGdpcmw=?= on 4 Jun 2004, no replies) |
|---|
|
I created a shared database at work with security and user groups and all that. Everything is working with one exception. Whenever I open the db and modify or input data, other users on their own computers can't access the DB later on. They get the message that the database can't be found. The shortcuts are still correct. I have to open Explorer and move the DB from it's original file to the desktop (or another folder) then back again before anyone can open it. Why is this? Is there a way to fix it? I can't keep doing this everytime. I know it's not a password thing, I can open the Db on my computer under their username and it opens fine. Any suggestions? Thanks! Mo ... (more) |
| QUERIES - USING 3 EXISTING TO MAKE 1 COMBINED (by =?Utf-8?B?VFhURUFNU1RFUg==?= on 4 Jun 2004, no replies) |
|---|
| I HAVE 3 QUERIES FROM 3 TABLES THAT I NEED TO MERGE ALL THAT INFO INTO 1 CAN THIS BE DONE W/BEING A PROGRAMMER? ... (more) |
| frefreshlinks (by =?Utf-8?B?VmljdG9y?= on 4 Jun 2004, 1 reply) |
|---|
|
Where do I need to put the code If the form is not set for the startup In a module, macro or what ? I´m sorry for wasting your time. ... (more) |
| Anybody know about Access and SCC? (by =?Utf-8?B?S3dhbGl0eSBBc3N1cmFuY2U=?= on 4 Jun 2004, no replies) |
|---|
|
Is it supported in Access 2003? I've tried everything and the only way I see any source code control is to open your items (forms, macros, etc) in VB and do the SCC commands from there. I've installed all of .NET along with all of the developer tools including the developer extensions which is the equivalent to what you needed in Access 2002 to get SCC enabled. Anybody, anybody at all know? Thanks in advance. ... (more) |
| HELP! ACCESS 97 NOT WORKING IN WINDOWS XP (by =?Utf-8?B?U3RhblI=?= on 4 Jun 2004, 2 replies) |
|---|
| I get a message that says: "Microsoft Access can't start because there is no license for it on this machine." I have tried to cure the problem by changing the registry "font" as instructed in the Knowledge Base Article 141373, which does not appear to apply to Windows XP, and I have not been successful. Does anyone know how I can by-pass this error message and get Access 97 to work on XP? Please help. I have important databases on Access that I need to use. ... (more) |
| Access Conversion from 97 to XP2002 (by =?Utf-8?B?ZmVsaXggdGhlIGNhdA==?= on 4 Jun 2004, 1 reply) |
|---|
|
In the Control Source of a text box of a report I typed ="To: "&[OtherNames] & [Report]![Name] When I preview I get #Error ... (more) |
| user defined functions (by =?Utf-8?B?dmljdG9y?= on 4 Jun 2004, 1 reply) |
|---|
|
where are saved these functions ? o how do i save one ? and how can i run it with a command button ? ... (more) |
| Size of Excel file Access db exports to. (by =?Utf-8?B?VGFzaGE=?= on 4 Jun 2004, no replies) |
|---|
|
I have an Access db that exports about 350 queries to a specific Excel file. This is done on a weekly basis then monthly basis. The db and exporting works great. However the size of the file. The size of the file after the save is as large as my largest month of data which makes sense. Is there anyway to compact an Excel file like you can in Access to get reclaim space that may be used in the monthly data but not in the weekly data? The weekly data was making the file about 26 MB. After I ran the monthly data it ballooned to 36 MB. All but about 20 of the queries are created through code. Would it be best to duplicate the code and have monthly run to one file and weekly run to a different file? (The size of the db is not a problem its only about 400 kb after compact because the data is kept in another db and just linked to.) ... (more) |
| New record data is empty in Report View (by Dave on 4 Jun 2004, 3 replies) |
|---|
|
Okay, I have created a database in Access 2000. I have a small problem with entering data and printing the report for it. I enter data into the fields of a new record. When I click the form's Print ... (more) |
| Re: multi-user conflict due to ODBC settings? (by david epsom dot com dot au on 4 Jun 2004, no replies) |
|---|
|
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Jet 4.0] "Threads"=dword:00000003 Try changing this registry value to 1 ... (more) |
| BEEL (by JENNIFER HATFIELD on 4 Jun 2004, no replies) |
|---|
| SAM REPLY ... (more) |
| create registry entry? (by fred rosenberg on 4 Jun 2004, no replies) |
|---|
|
hi, what is the current, best way to create and read a registry entry from Access (VBA)-- a way that will work for all versions of access since 97, and ... (more) |
| About aspx (by ÌìÍâ¹Öħ on 4 Jun 2004, no replies) |
|---|
|
I use C# to develop webapplicatin.I put some edittextbox in WebForm.aspx.However ,when I distribute it in IIS5.0+, It is quite different,the edittextbox disappeared. Can any kind one help me? ... (more) |
| bulk compact and repair (by Jack Handy on 4 Jun 2004, 1 reply) |
|---|
|
We have a whole bunch of databases that need periodic compact and repair run on them. Is there a way to do many files at a time? Thanks, ... (more) |
| Hello (by fkm_liu on 4 Jun 2004, no replies) |
|---|
| Hello!! ... (more) |
| Adding a column of numbers (by Peter Jay Salzman on 04 Jun 2004, 2 replies) |
|---|
|
A friend and I were comparing Access notes. When she needs to add a column of numbers, she exports the column to Excel and adds them that way. ... (more) |
| Discussion Groups Index | first | prev | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | next |