| Usenet Archive Index | first | prev | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | next | last |
| Help!! withdrawing materials from a stock. (by Chris on 26 May 2004, no replies) |
|---|
|
In a form, i have a command button with a code like below, which is making a sellection from a query (which represent the current state of a stock) to display it in a form. How can I make to add these selected data to a table (the table of withdrawings from the stock), instead displaying in a form? In ... (more) |
| Adding selected data (using code atached to cmd button from a form) to a table (by Chris on 26 May 2004, no replies) |
|---|
|
In a form, i have a command button with a code like below, which is making a sellection from a query (which represent the current state of a stock) to display it in a form. How can I make to add these selected data to a table (the table of withdrawings from the stock), instead displaying in a form? In ... (more) |
| Excel File Corruption when Linking to Access Database (by =?Utf-8?B?Q2hpcHN0ZXIgTC4=?= on 26 May 2004, 1 reply) |
|---|
|
Is there a fix for this problem? When I Link an Excel file to an Access database (Office 2003), the file will usually get corrupted if I try to run any queries on it. The only way I have been able get around this is to first save the Excel file as an Excel 5.0/95 file type, which limits the features. Is there any way to fix this so I can use current versions of Excel? ... (more) |
| error no current record in access 97 (by Coppens Hans on 26 May 2004, 3 replies) |
|---|
|
I get an error "no current record" when i am trying to make a report or form with the wizard. I am using access 97 on Windows XP. When i am logged in as administrator, everything works ... (more) |
| size access window (by adolfo on 26 May 2004, no replies) |
|---|
|
How to give a deliberate size to access window during the opening of a *db*. Thank you ... (more) |
| opening query error (by SBoyko on 26 May 2004, no replies) |
|---|
|
An error occured while loading 'Manage Tables' Do you want to continue? And after answering yes a couple of times it will open ... (more) |
| ouverture access (by adolfo on 26 May 2004, no replies) |
|---|
|
comment donner une taile voulue a la fenettre d'access lors de l'ouverture d'une db. Merci a tous ... (more) |
| re: screen resolution (by Suec on 26 May 2004, no replies) |
|---|
|
I have a problem with access 2000 and access2003. When I open up an database (this happens regardless of the database), the screen resolution is automatically changed to 400 X 800. When I leave Access there is a brief pause ... (more) |
| parameters (by Susie on 26 May 2004, 1 reply) |
|---|
|
This is going to be a difficult question to ask. I have a report that requires choosing a category which I have used a form with a dropdown list for the user to choose. I have used the traditional form attached to the query and ... (more) |
| Expression Builder, how where to learn? (by Joe on 26 May 2004, 1 reply) |
|---|
|
Hello, I am using Access a bit, but do not know code. Some of the things I want to do some people have pointed me to use the ... (more) |
| Deleting a Record From a Linked Oracle Table (by Roger Guo on 26 May 2004, 1 reply) |
|---|
|
Does anyone know how to delete a record from a linked Oracle table in MS Access? I tried to delete such a record without much luck. When I linked this Oracle table, I used a schema which own this table. It should ... (more) |
| maximize 2nd database on open (by Allie on 26 May 2004, 1 reply) |
|---|
|
After a check box on a form is selected in database1, the code to open a form in database2 runs. Problem: database2 opens behind database1, and most users ... (more) |
| forms and outlook - help (by anonymous on 26 May 2004, 1 reply) |
|---|
|
I have a database and use a form to enter the data. When the client has entered new records he would like to e-mail it to others. Here's my problem, I added a command button to run sendobject, which works except it attaches the ... (more) |
| labels (by Mike E on 26 May 2004, no replies) |
|---|
|
How do I find and use the label wizard that access help claims was installed? I am running Win2k on a Dell Latitude C840 with Office XP. ... (more) |
| running total in access (by Benoit on 26 May 2004, 4 replies) |
|---|
|
Hi, suppose you have a table like this ... (more) |
| combine two tables with same fields (by JR on 26 May 2004, 1 reply) |
|---|
|
I am trying to merge two tables that have the same field names and properties, different sets of data in the records, and a total of 84,309 records (48065 and 36244). ... (more) |
| Gender Field (by Allison on 26 May 2004, 6 replies) |
|---|
|
How can I estabish a VBA code to determine the gender by the first name field in my make table query. First Name is Sex ... (more) |
| Switchboard (by Amal on 26 May 2004, no replies) |
|---|
| How do I had the toolbars in a switchboard form? ... (more) |
| Reading in information from a machine? (by anonymous on 26 May 2004, no replies) |
|---|
|
I have a card reader that can hook into a computer through the com1 port. Is there any way to take that information and put it into an Access database. That way we can just scan the number into the system. ... (more) |
| Can not make a system.mdw (by redburns@ameritech.net on 26 May 2004, 11 replies) |
|---|
|
I wanted to create a new database or open one I made at the office in Access 2002, an error popped up. Workgroup Administrator couldn't create the workgroup information file. Make sure that you have specified a valid path and ... (more) |
| Back up Access files (by Ron on 26 May 2004, 1 reply) |
|---|
|
Due to a virus I have to reformat my hard drive. How can I back up my Access 2000 data files to an external hard drive? ... (more) |
| checboxes in Access -- would like to be able to check several checkboxes (by Deborah Ellis on 26 May 2004, 1 reply) |
|---|
|
When you create a drop-down list in a table or form, you can only pick one of the things in the list and that shows up in the form or report or table. But what if you want to be able to check more than one of the options in ... (more) |
| Update (by nl on 26 May 2004, 2 replies) |
|---|
|
I need to create a query that will delete the decimal point only: Example: 309.54 update to: 30954 (no decimal point) All records have different dx. Just need to delete the ... (more) |
| Conditional Formatting (by Antonio on 26 May 2004, 2 replies) |
|---|
|
I am using the Conditional Formatting tool to make certain data fields change their back color when the data field contains a specific word "Admitted". I am using the following expressions in the following way ... (more) |
| Importing (by Andy on 26 May 2004, 1 reply) |
|---|
|
Are there genric /customizable import scripts that will allow for a text manipulation at the field level?? Thanks ... (more) |
| Can asset tracking template calculate depreciation automaticly (by Oussama El-khoury on 26 May 2004, no replies) |
|---|
|
Hello, Can the Access Asset tracking template calculate the monthly depreciation automaticly? ... (more) |
| Extracting part of a text value (by =?Utf-8?B?SmVyZW15?= on 26 May 2004, 3 replies) |
|---|
|
I have the following list of numbers, and i want to remove the last two characters (In Access) 11110A01 9895A01 ... (more) |
| strange things happening with data entry in table (Access 2003) (by =?Utf-8?B?a2F5?= on 26 May 2004, 2 replies) |
|---|
| entering data directly into a table; started OK, but after about 10 records, but when enter is pressed at the end of the row this record suddenly becomes a copy of the previuos record. After that, clicking on any previously entered record causes it to become a duplicate of the one before it! Is this something auto that needs to be unchecked? a bug in access? a corrupt file? (it had been saved on a thumb drive). ... (more) |
| changing letter case in selected columns (by =?Utf-8?B?RGVubmlz?= on 26 May 2004, 1 reply) |
|---|
| I have a database with a mixture of records entered in all upper case and some in title case. I'd like to convert all records to title case, but it's not possible in Access 2000. Is it possible with Access 2003? ... (more) |
| automatically updating the next field?? (by =?Utf-8?B?S2VsbHlG?= on 26 May 2004, 1 reply) |
|---|
| In my form I have a list of cities listed in a drop down menu. I want to know if when I select a certain city, the Zip code is automatically inserted that correspondes to that city. For example, if it is CityA then the Zip is automatically inserted to 12345, while if I select CityB from the drop down menu, the Zip is automatically changed to 54321. Does that make sense??? ... (more) |
| Problem passing Hyperlink to Outlook (by =?Utf-8?B?a2JyYWQ=?= on 26 May 2004, no replies) |
|---|
|
I have tried asking this in Outlook questions but no response so can anyone help? I have a field on an Access form that is a hyperlink. I am passing that field through to an outlook as I create a new contact but the web address is appearing twice in the outlook web page address field and looks like this http://www.test.co.uk#http://www.test.co.uk# Any idea how I can stop this happening? ... (more) |
| ScreenUpdating (by Damien McBain on 26 May 2004, 2 replies) |
|---|
|
Application.ScreenUpdating = False ...before running an "ugly" subroutine (one that makes the screen change a lot). ... (more) |
| vbMsgBoxHelpButton (by Techsupport on 26 May 2004, no replies) |
|---|
|
Hello, all...How do I set the properties for the Help button on this msgbox? thanks ... (more) |
| Exporting to Excel to link to Powerpoint (by =?Utf-8?B?U01hYw==?= on 26 May 2004, no replies) |
|---|
|
I have exported query data using the macro Output to into Excel, data came out great - now I did Paste Link from that Excel data into a chart in PowerPoint it paste all the data but also inserts a column at the begining which throws my whole chart off. I deleted the column but when I update the Excel spreadsheet with new Access data the column pops back in - I don't know what the glitch is. Paste Link data from an Excel spreadsheet I made and works fine. Any help is greatly appreciated! S ... (more) |
| Average without zeroes (by =?Utf-8?B?WW9nZ3lzdHlsZQ==?= on 26 May 2004, 2 replies) |
|---|
|
I have a form with several option groups on it. The option values assigned to each are 0,1,2,3,4 and 5. Each option group asks a question where the user will respond with 1-very low rating, 2-low rating, 3-ok rating, 4-good rating, 5-best rating or 0-N/A. I have a report that averages these values. However, I don't want to include the 0 value for the N/A responses. Is there anyway to average the responses from an option group without including the zeroes? Can I convert to Null values? Or am I attempting the impossible? ... (more) |
| <ALL> in Combox Box? (by =?Utf-8?B?Sm9l?= on 26 May 2004, 4 replies) |
|---|
|
I have a combo box which is a parameter to my report. Is it possible to put <ALL> in the drop list for user to select? Thanks ... (more) |
| Distinct query not producing distinct results (by KarenM on 26 May 2004, 1 reply) |
|---|
|
Greetings. A2K, Win2K I have a simple enough query, based on another query. When I run it, ... (more) |
| Text field with 255 (by =?Utf-8?B?UGV0ZXI=?= on 26 May 2004, 3 replies) |
|---|
| The max of a text field is 255 bytes long. How many charaters that it can hold? How it holds several A4 paper full of words? I want to use a text field to hold people's resumes which would be 5 to 10 pages. How can it be done? On my form it is a text control, what happens if the typing has hit the max 255? Appreciate some experience sharing. Thanks. ... (more) |
| Setting Link Tables Path (by Nick on 26 May 2004, 1 reply) |
|---|
|
Hi, I'm currently having two mdb files with one contains all the tables and the other contains the link tables to the first mdb. Whenever I ... (more) |
| freezing header rows (by =?Utf-8?B?amFuZQ==?= on 26 May 2004, 4 replies) |
|---|
| how do i freeze the header rows on a spreadsheet??? ... (more) |
| Saving Calculated Fields (by =?Utf-8?B?Q2hyaXM=?= on 26 May 2004, 1 reply) |
|---|
| Is there any way to save a calculated field on a form to the database. Just wondering ... (more) |
| Report Templates (by =?Utf-8?B?S2FyZW4gVG9kZA==?= on 26 May 2004, 1 reply) |
|---|
|
I've tried to find a thread addressing this problem and didn't see one, but forgive me if it's an incredibly dumb question and I just somehow missed the answer. =) I am trying to create a "template" report so that the field layouts will always be the same size, font, location, etc. I am building a database for Access-phobics and am using the switchboard to build and run very simple reports. (I.e. "Click here for a report sorted on Project Manager. Click here for a report sorted on Project Name) Thus, the fields appearing in the report will always be the same, and I'd like the layout to remain consistent. ... (more) |
| Updating a field in another table (by =?Utf-8?B?V2VuZHk=?= on 26 May 2004, 4 replies) |
|---|
|
Good afternoon, I have a database that tracks accounting functions for my department. I have figures out alot of things but I can't figure out this answer, so any help would be appreciated. I have 3 tables for various types of invoices-Driveway permit, utioity permit and OS/Ow permits. I have one table for payments. ... (more) |
| Default forms from imported MS project file (by =?Utf-8?B?QyBGb3Jhbg==?= on 26 May 2004, 2 replies) |
|---|
|
I have exported an MS Project 2002 plan to an access database. I open the access database and see the project plan data in the apporpriate tables. My requirement is to have more than one person modify the tasks, assignments, resources etc. Has anybody ever heard of default forms being created in Access as a result of the export of the MS Project plan (i.e. after the export you would see some ready-to-use forms in Access to update the exported tables)? Or do I need to create an application to allow multi-user access? ... (more) |
| Uninstallation of Access 2003 Packaged Application (by =?Utf-8?B?Ti4gQ290dG9u?= on 26 May 2004, no replies) |
|---|
|
When uninstalling a packaged application, I am always prompted for the original .msi CD. There are options in the setup.ini for caching the installation files - which I would presume eliminates the need for the original installation media? ... (more) |
| Parsing Data (by =?Utf-8?B?VG9ueQ==?= on 26 May 2004, 3 replies) |
|---|
|
Good Afternoon! Order Number :5202518 Delivery No : 483385 Line No : 22 ... (more) |
| =?Utf-8?Q?Mise_=C3=A0_jour_d'une_table_d'une_au?= (by =?Utf-8?B?c2FtYXI=?= on 26 May 2004, no replies) |
|---|
|
JE cherche à acceder à une autre base access à partir d'une base access pour mettre à jour une table je ne veux pas utiliser de tables attachées, Je suis bloquée ... (more) |
| Can't create MDE file with Word Mail Merge (by =?Utf-8?B?emFrbWFu?= on 26 May 2004, 2 replies) |
|---|
|
I'm am trying to create an MDE file. It gives an error message that MDE file can't be created. In the code, we are using Word's Mail Merge and believe this is the cause of the problem. I did compile clean the VBA code. Any suggestions? Zak the man ... (more) |
| Adding Search to a MS Access Data Access Web Page (by RC- on 26 May 2004, 1 reply) |
|---|
|
Hi all, I'm hoping that there is a way to add search capabilities to a MS Access Data Access page. I have a page created that will allow the user to add/remove records but what I really need is a way to search the database ... (more) |
| help: archives? (by G. Sahakian on 26 May 2004, 1 reply) |
|---|
|
Subject: help: archives? hello, this is probably not the right place but I cannot see where to ask; would ... (more) |
| Limit Number of records in a Subform (by Nick1966 on 26 May 2004, 1 reply) |
|---|
|
Hi I have a Main Form that displays the number of products received on any particular order. The details of which are then entered into a subform. Is ... (more) |
| Clearing old files from New File menu (by bomantas on 26 May 2004, 1 reply) |
|---|
|
Does anyone know how to clear old, non-existent, files from appearing in the "New File" menu on the right hand side of the screen when opening up access or selecting to create a new file? ... (more) |
| Office XP Developer (by hin on 26 May 2004, 1 reply) |
|---|
|
Hi all, Title: OffWH Message: Automation error. Library not registered. ... (more) |
| Calendar object (by Art Vandaley on 26 May 2004, 3 replies) |
|---|
|
Hi, I would like a text box object to be updated automaticaly by MS Calendar object whenever I click a date. Normally it is being updated after using TAB ... (more) |
| Programatically access the label making wizard (by Andy Levy on 26 May 2004, 2 replies) |
|---|
|
Hi Is it possible to programatically access Access's label making wizard ? ... (more) |
| syntax in database access (by budieko on 26 May 2004, 1 reply) |
|---|
|
Where can I get help for syntax used in modifiying database objects ? (ie: create table, insert into etc) I'm used to program in VFP and tend to use access ... (more) |
| Loading a form automatically when Access starts (by George Papadopoulos on 26 May 2004, 3 replies) |
|---|
|
Hello everybody I have built a small database with VBA support under Access 2000. The application is almost complete and I would now like to have a form opened ... (more) |
| Problem with birthdate calculation. (by Rusty on 26 May 2004, 1 reply) |
|---|
|
I took a existing database and chanded the birthdate and age feild to automatically calculate the age with ControlSource propeperty in the form view. Now the age doesnt show up in the Table view. ... (more) |
| Help wanted, distributing Access 2000 (by Bob on 26 May 2004, 1 reply) |
|---|
|
Help wanted Does anyone know of any books out there that addresses the problems of marketing an Access Database program with front/back end arrangement. ... (more) |
| Calculating age problems (by Rusty on 26 May 2004, 2 replies) |
|---|
|
I need help ! I took a existing database with a birthdate feild and a age feild. In the design form view I used controlsource property for the age text ... (more) |
| Usenet Archive Index | first | prev | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | next | last |