| Usenet Archive Index | first | prev | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | next | last |
| Screen Size (by Tom Conroy on 14 May 2004, 2 replies) |
|---|
|
I would like to be able to control the window size of my access 2002 application programatically. Is there a way to do this? I am writing an app for a tablet PC, but would like to size it correctly ... (more) |
| toolbar & view settings (by =?Utf-8?B?cm95?= on 14 May 2004, 1 reply) |
|---|
|
force the screen with the view: no sheet tabs, no formula bar, no column and row and on exit to reset to previous view but on exit only. In addition, I would like to force a customize toolbar to display and remove the regular one. ... (more) |
| Default values (by =?Utf-8?B?Q1JBSUcgS0VMTFk=?= on 14 May 2004, 1 reply) |
|---|
|
I have lots of forms which contain quite a lot of data, the majority of the datain each record will be the same, how can I set the fields so that when I create a new record it is populated with the value from the previous record, I know I can set a default value in the table but considering how many fields I have it will take ages, can I do this globally? A lot of my forms are linked to one main form by using subforms so when I create a new record it creates one for each form linked via the subform is there a way of copying the main form record so that it would copy all the subforms too? Lotus approach had this facility but i haven't found it on access as yet. ... (more) |
| How to Show Table Dates in Reports as 'X's'? (by xx on 14 May 2004, 5 replies) |
|---|
|
How do I get a query or report to change dates to 'X's' without messing up my original data? I have a data table with several dates that identify when various ... (more) |
| Phone input mask (by =?Utf-8?B?U3RhcnJsaWdodA==?= on 14 May 2004, 4 replies) |
|---|
|
I have entered a phone input mask such: "(703) "000\-0000;0;_ in the 'Input Mask' field on my text box. The output in the form view is (703) ___-___0 The '703' is fine, no problem. Where is the '0' coming from and how can I get it to go away? ... (more) |
| On Double Click (by =?Utf-8?B?Sm9obkx1dGU=?= on 14 May 2004, 8 replies) |
|---|
|
How can I format a subform combo box to open it's record with a double-click? Thanks! ... (more) |
| Error message (by =?Utf-8?B?R2VvZ2lh?= on 14 May 2004, no replies) |
|---|
|
"You tried to lock table 'table name' while opening it, but the table cannot be locked because it is currently in use. Wait a moment, and then try the operation again." Multiple click events from separate forms were running the same query. So I changed the layout so the click events run different queries of the same type. ... (more) |
| Decimal Places (by =?Utf-8?B?U2hhd24=?= on 14 May 2004, 3 replies) |
|---|
|
I have a field for exhange rate. It is set to number Field size is Long Integer Format is General Number Deciaml place is 2 ... (more) |
| having problem with table (by =?Utf-8?B?cmF3bGV5?= on 14 May 2004, 1 reply) |
|---|
|
I have the following tables: An Equipment Type table which denotes things like mixers, dust collectors, forklifts, etc. Then, I have an Equipment table (with a link between the Type ID of the previous table) that lets me use a pulldown to select a Type of 'Forklift' and then to enter specifically #1 ABC Forklift, etc. All this works fine. I want to use this data to enter information in when we do work on the forklifts, including the hours worked on the forklift. I want the table to have a pulldown from the Equipment table so that I can select which forklift was worked on. I tried linking the Equip Name field, but the best I can do is that all equipment shows up in the pulldown. I only want equipment that is a Forklift type. Any ideas on this one, or can I structure it a different way? Thanks! ... (more) |
| [MSACCESS] ADO/JRO and repliche (by Gianluca_Venezia on 14 May 2004, no replies) |
|---|
|
I need to connect two office and two laptop for sharing a database with access 2003; I'm on focus on replica statement, to manage via vbcode. ... (more) |
| Can't Find Query Error (by =?Utf-8?B?Um9zY28=?= on 14 May 2004, 6 replies) |
|---|
|
Can someone see my error in the following code. I get an "Access can't see query error on the OpenQuery command. The query is built in the proper place, however. Function RunQuery() ... (more) |
| Access Programmer (Dutch) (by Alan Sadler on 14 May 2004, 1 reply) |
|---|
|
I want to use a 3rd party access database. I need some custom report programming. The program is primarily in Dutch, although the data is all english. Any help out there? ... (more) |
| Re: Need Combo Box Help! (by =?Utf-8?B?cmF3bGV5?= on 14 May 2004, 1 reply) |
|---|
|
Tina...your reply helped partially answer one of my questions below: "Haing Problems with Table". However, even trying this my bound column isn't showing up (like it's supposed to), but my first visible column is supposed to say something like 'mixer' or 'forklift', but instead, shows a number. Any idea? Or, could you please take a look at my prevous question? Thanks! ... (more) |
| RE: Date Format Question (by =?Utf-8?B?U0NITllERVM=?= on 14 May 2004, no replies) |
|---|
| If you can, you can export it to excel, highlight the column and choose the text to columns feature of excel. Make sure you use the date field type, and YMD formatting, then import it into access. ... (more) |
| date (by =?Utf-8?B?am9z?= on 14 May 2004, 3 replies) |
|---|
| how to tell access what age somebody has. by using birthdate and systemdate? ... (more) |
| Web enabling Access 2003 (by =?Utf-8?B?TWlrZSBGaW5nZXI=?= on 14 May 2004, 1 reply) |
|---|
|
I want to take an existing Access database app and set it up with forms to add/edit data and reports to display/download data that are entirely accessed through a browser. From what I have been able to find, my options are to use Data Access Pages, and/or write my own ASP or php pages linked back to the mdb. Is there a way to make use of InfoPath to do all the forms? The intent is a fully web accessed app - no replication or distribution of front ends, back ends etc. I also would like to avoid writing all that code from scratch with ASP/php. Current app stats - 15 tables, 12 forms, 6 reports. ~500,000 records, not very dynamic data, mostly view, lookup uses. ... (more) |
| Jet database vs MSDE (by =?Utf-8?B?RGF2ZQ==?= on 14 May 2004, 6 replies) |
|---|
| I saw some threads here mentioned about Microsoft Desktop Engine (MSDE). I have installed Access 2002. How do I know I am accessing Jet database or MSDE? Appreciate some help please. ... (more) |
| Re: Using Access 97 to organise jpg files (by =?Utf-8?B?QWxleCBFbGJlcnQ=?= on 14 May 2004, no replies) |
|---|
|
Previous answer is correct if we are talking about jpgs. Note ,however, that function fileexists Public Function FileExists(varFullPath As Variant) As Boolean On Error Resume Next If Len(varFullPath) > 0& Then ... (more) |
| What' the message mean (by =?Utf-8?B?U2F2?= on 14 May 2004, no replies) |
|---|
|
Could not create; no modify design permission for table or query. 'Temps MSAccess Objects'. How do I overcome this problem Thanks ... (more) |
| Record Navigation bar images in a Data Access Page (by =?Utf-8?B?U2hhbm5vbg==?= on 14 May 2004, no replies) |
|---|
|
Ok, I'm not sure where this question belongs but here it is. I have several DAPs with the record navigation bar. The bar works but the images for the buttons are not loaded (displayed) when it is hosted. The images work running from the local server or the LAN through a direct link to the DB. I'm running IIS 6 as the web server. The OWC 10 is installed on the client system and even the server has the same problem if I go through the web service. The web server will host gif files and they load fine on the client pc. Where may I find the problem? What is the fix? ... (more) |
| Re: Need Combo Box Help! (by Mike Painter on 14 May 2004, no replies) |
|---|
|
How do I use a combo box to pull up multiple fields at the same time? Or do I use something else? For instance, in the Northwind database sample "orders" form, when you select a company name the rest of the address fields come up (street, City, State, Region, etc). I use MS Office 2000. ... (more) |
| Tab Issues with Subforms (by =?Utf-8?B?YmRlaG5pbmc=?= on 14 May 2004, no replies) |
|---|
|
I have main form "Account Information" This form has a subform "Location" and the Location Subform has a subform "Service Calls" I need help in getting tab order correct and figuring what is wrong. ... (more) |
| Re: Re: How to do a Specific Search with " " (by Miracle on 14 May 2004, 1 reply) |
|---|
|
Doug, Thanks for your response.. actually it is a database for a website in which product names have similiar names.. I have a product with an item code of "abc" and then other items with a code of "abcd", "abcde" and so on.. I am trying to do a search and replace to rename the ... (more) |
| office xp access (by ted medin on 14 May 2004, 2 replies) |
|---|
|
We have 3 pc's using a common access db. 1. What are the ramifications for locking (records pages ...) 2. We have been getting some disk errors referencing the db thru a wireless lan. We even got a sever error warning from access. What are your ... (more) |
| Import data from textfile! (by Niklas Östergren on 14 May 2004, 5 replies) |
|---|
|
Hi! I need some hint´s on how to import comma separated data from a textfile into a table. Any help is apreciated! ... (more) |
| Request an advice for best practice in multiuser enviroment (by Peter chin on 14 May 2004, no replies) |
|---|
|
Hi, There, I has a sales and stock system designed, i need an advice on how to update the order id ... (more) |
| Applying SP's to RT (by Luke Bellamy on 14 May 2004, 5 replies) |
|---|
|
Hi, I have an application using AccessRT 2002 that I distribute. To apply service packs I have to get them to go to windows update and install them. ... (more) |
| Using API calls (by ANSWER on 14 May 2004, 1 reply) |
|---|
|
Hi, I have developed dictionary (Eng, Ger, Fra, Ita) in Access. The word list for each is in separate table (Eng_Ger), (Eng_Fra), (Eng_Ita). ... (more) |
| Access 2000 and Access XP on the same machine (by Karibusz on 14 May 2004, 3 replies) |
|---|
|
Hi everyone! I have on my PC both Access 2000 and Access XP installed (in different directories). I need that the default ... (more) |
| Find an address (by Newone on 14 May 2004, no replies) |
|---|
|
I know this is not a matter of this group but i don=B4t=20 know who can answer my question please give me a hand. =20 I=B4m triyng to find an e-mail addres of someone i=B4m=20 looking for all over the wold but i=B4dont know how to do=20 ... (more) |
| POINTLESS USELESS """HELP""" FILES (by pdm on 14 May 2004, 5 replies) |
|---|
|
MS, why, after spending years defining and refining Access, why did you make it near useless by gutting the help files? Is it that you WANT to kill it? The Acc 97 files were a MODEL for others, so much better than all ... (more) |
| Switchboard Form (by Barbara Wolff on 14 May 2004, 3 replies) |
|---|
|
If the form created by the switchboard manager is deleted, how can you recreate it. All of the switchboard manager data is still there. ... (more) |
| Back Style Properties (by TERESA on 14 May 2004, 1 reply) |
|---|
|
I inserted a list box for a field called "completed date" on a form that I have created. When I try to change the properties of the "BACK STYLE" to "Transparent" as I have chosen for other field boxes; the Transparent is not an ... (more) |
| Oracle ODBC drivers NT vs Windows (by Lydia on 14 May 2004, no replies) |
|---|
|
We use Access to query an Oracle database via ODBC drivers. In rare instances we discover an instance where a query successfully completes on an NT machine and fails on a Windows 2000 box. ... (more) |
| How to ? (by Mike J on 14 May 2004, 3 replies) |
|---|
|
I am considering designing and coding a project for a customer. The project would be similar to how an organizer works -- keep track of appointments etc. Every hour would be split up into 8 min increments -- 12:00, ... (more) |
| Validation Rule (by gford@dodig.osd.mil on 14 May 2004, 2 replies) |
|---|
|
Trying to compare two fields called end dates and start date with a validation rule. I get a SQL syntax error - "cannot use muliple columns in a column-level CHECK constraint." I want the valiation rule to prevent me from ... (more) |
| update data via internet (by Ray on 14 May 2004, 1 reply) |
|---|
|
Can anyone please help? I am trying to make an Access App update the data in one table via internet. I have an Access 2000 or 2003 program for the customer. ... (more) |
| Accwiz.dll (by Ron Hughes on 14 May 2004, 3 replies) |
|---|
|
I've been having problems with the command button wizard regsvr3s.exe <path>\Accwiz.dll However,I get an error message saying "LoadLibrary failed- ... (more) |
| Entry Field for Report Execution (by Larry H. on 14 May 2004, 1 reply) |
|---|
|
HI, I have Access 2000 with a very large database containing two DATE fields (short date format). I have designed a REPORT to print out cetain criterion that was provided in ... (more) |
| Software Development Across Different Platforms (by John Reichard on 14 May 2004, 5 replies) |
|---|
|
I'm developing an Access database that will be 1. Do not have a version of Access 2. Have Access 97 3. Have Access 2000 ... (more) |
| New to the newsgroup and having problems (by Giuseppe Chirico on 14 May 2004, 3 replies) |
|---|
|
Hello, I have windows 2000 pro. using outlook express 6.0. I have one account on outlook and it runs fine but if I add another one it doesn't seem to work ... (more) |
| Graphic (by Fadoyo on 14 May 2004, 1 reply) |
|---|
|
Hi all, please I have a report with a graphic. Now the query is built under design, but I would like to build the query filtered between two querys. How could I do it with code? ... (more) |
| Undo Record via Sendkeys (by Wayne Robinson on 15 May 2004, 2 replies) |
|---|
|
I have a form that a user could mess up and want to add an "UNDO" button to. I am trying to use the "send" function (Ctrl+Z) and the access system is telling me to install the addin or re-install Access. I can't find the addin anywhere and re-installation does not have any options for add-ins. I have ... (more) |
| Tab delimited output (by =?Utf-8?B?YW1iZXJzb2Z0?= on 15 May 2004, 2 replies) |
|---|
|
Hi, I'm trying to create a tab delimited file from some access tables. I need to insert a 'tab' into one of the columns in a table. ... (more) |
| Font on Exported Queries (by JHL on 15 May 2004, no replies) |
|---|
|
Using Access97, XP machine When I export a query from Access into an Excel spreadsheet, the data comes into Excel always as ... (more) |
| Is it really impossible to control the update of a subfrom vs main form (by =?Utf-8?B?SmVmZnJleQ==?= on 15 May 2004, 5 replies) |
|---|
|
I have a main form with a subform. The practical example is Order header and detail. My experience is I can control how and when to write the header record to the table but cannot control the subform. What I want to do is to edit the header and detail (the subform may have several lines) and update the two tables at the same time. If I want to undo (cancel) the header update, I want to undo (cancel) detail lines also. Appreciate some suggestion. ... (more) |
| Any object that can check connections? (by =?Utf-8?B?Q2hyaXN0aW5h?= on 15 May 2004, 6 replies) |
|---|
| How can I check how many connections have been connecting to Jet or SQL server? Appreciate for advise. ... (more) |
| i need help (by dandy on 15 May 2004, 1 reply) |
|---|
| how to us newsgroup? ... (more) |
| Data Access Pages (by Mike on 15 May 2004, no replies) |
|---|
|
How do I publish a data access page to an FTP site using Access 2000? Must I have the database on a Web Server? ... (more) |
| Database Size out of control - 2nd Post (by Kentucky5 on 15 May 2004, 1 reply) |
|---|
|
Roger, Have you been able to find the solution that you were given for this issue? ... (more) |
| Size of Datbase out of control-2nd Post (by Kentucky5 on 15 May 2004, 1 reply) |
|---|
|
Below is from my original post, Roger said he had some solution I really need a solution since every embedded object is making this huge. I thought that I could import the pictures and maybe link them from there but that is ... (more) |
| MDE back MDB (by Bill Stone on 15 May 2004, 2 replies) |
|---|
|
Is it possible to convert a mde file back to the mdb file? Several years ago I wrote a report writer application for work. I distributed it, as a mde file, to several co- ... (more) |
| Switching Windows (by PeterM on 15 May 2004, 5 replies) |
|---|
|
I'm running Access 2003 using an Access 2000 file format. Program A minimizes itself and then calls program B ... (more) |
| opening balance - closing balance (by Greg on 15 May 2004, 3 replies) |
|---|
|
On my report I want to have an opening balance signifying all transactions up to the month selected and detailed transactions for the month selected and then a closing blance. ... (more) |
| Restoring full menus (by Malcolm H on 15 May 2004, 1 reply) |
|---|
|
I created a simple Access 2000 database for a client some months ago. In order simplify usage for the client I altered the Tools/Startup options so that full toolbars were not displayed. The client was therefore unable to change any 'Design' features. ... (more) |
| Re: Memory leak when printing report from VB (by rainerschulz on 15 May 2004, 3 replies) |
|---|
|
Hi, I have nearly the same problem. With every Printout I loose about 80 KB of Memory. I use Access 97. ... (more) |
| Avrupa Dilleri Sorunu (by Hamza Özdemir on 15 May 2004, no replies) |
|---|
|
yeni posta açtığımda avrupa dilleri metin desteği çıkıyor. yüklemek istediğimde bir süre sonra kesiliyor. ne yapmam gerekir. Şimdiden teşekkürler. ... (more) |
| Search word in sentences (by Him on 15 May 2004, 1 reply) |
|---|
|
In my database, there is a column, which the data in this column is a sentence. How can I find out the sentences which contain a particular word by creating a Query? ... (more) |
| Explorer Page Error (by Danny Quain on 15 May 2004, no replies) |
|---|
|
When Shutting down my computer I get the following message. "Performed an Illegal Act, will be shut down, `details` Explorer caused an invalid page fault Module Kernel 32. Dll at 017: bff7b9f5 etc, etc Danny Quain ... (more) |
| Technology is Growing... (by Kold_Fusion on 15 May 2004, 1 reply) |
|---|
|
just thought I would make my first newsgroup post a pointless one. discover the meaning of life. funny, how some people think that's a universal question. it only applies specifically. ... (more) |
| Usenet Archive Index | first | prev | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | next | last |