| News Index | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next | last |
| Re: Link table in code doesn't "take" (by Joe Fallon on 5 May 2004, 1 reply) |
|---|
|
I use this procedure to re-create links to SQL Server. ==================================================== http://www.mvps.org/access/tables/tbl0009.htm ... (more) |
| Re: transaction not working (by Wayne Morgan on 5 May 2004, no replies) |
|---|
|
In addition to Allen's recommendations, you have a typo here (CLIENTS and client), no "s" on the second one. ... (more) |
| Date fields in an ASCII delimited file (by David Howlett on 5 May 2004, 1 reply) |
|---|
|
I am exporting a table to an ASCII delimited file. All my date/time fields export with a time stamp (i.e. 5/4/2004 03:04). I want the ASCII file to contain only the date without quotes (5/4/2004). ... (more) |
| Re: ldb (by Ron Hinds on 5 May 2004, no replies) |
|---|
|
"Denise" <anonymous@discussions.microsoft.com> wrote in message news:89bd01c4328f$2e8e3400$a301280a@phx.gbl... ... (more) |
| Database Closing (by Rebecca on 5 May 2004, 7 replies) |
|---|
|
My database is closing on me without saving the changes I make to a query. For example, I go to the query, make the changes, hit the ! to run the query, get the results I wanted, click the X to close the query, and it closes my whole database!!!! So when I open the database again, I go to the ... (more) |
| Re: Undefined Function ... in Expression (by Brendan Reynolds on 5 May 2004, 1 reply) |
|---|
|
Most certainly you could adapt them in Access - if you were using Access! :-) But when you use a VB6 front end and an MDB database, you're not actually using Access - you're using the Jet database engine. ... (more) |
| Hello (by Randy Charles Morin on 05 May 2004, no replies) |
|---|
| Goodbye ... (more) |
| Menubar different for different users (by =?Utf-8?B?Sm9uYXRoYW4gQw==?= on 5 May 2004, no replies) |
|---|
|
I have a database used by about twenty people. I have created a menubar that I want to force all of the users to use. The problem is that the menubar shows up differently on different machines. I have gone into Tools:Startup and set the global menu to the one I want, but it still has no effect. Also, I have fixed the menubar to include a menu item in the MDB, but when I make it an MDE the menubar does not include that menu item. ... (more) |
| resetting form (by =?Utf-8?B?UkFXTEVZ?= on 5 May 2004, 4 replies) |
|---|
|
When entering info into a form and clicking for the next form, the cursor stays where it left off in the previous form. Is there anyway to have it reset to the top field? Thanks! ... (more) |
| RE: Can't open Access 2000 database (by =?Utf-8?B?QmlsbCBUaG9tcHNvbg==?= on 5 May 2004, no replies) |
|---|
|
Chad I am having the same problem. Try opening Access and then open the file from the File menu-Go to Microsofts knowledge base and look up article 815283 ... (more) |
| VBA code to run an append and a delete query (by SusanR on 5 May 2004, 1 reply) |
|---|
|
I have a process that has a print button. What I want to do is..when the print button is pressed run my query called appendtohistory, sending it the needed criteria, to copy that record to a history table and then run my ... (more) |
| Digital Certificate (by Randy on 5 May 2004, 1 reply) |
|---|
|
I develop in Access 2000, and most of my customers use 2000 or XP. Last weekend one of my customers got Access 2003. How do I attach our digital certificate to my Access 2K program so it will quit bugging my customer about the Macros, VB code and Queries that I have coded? ... (more) |
| RE: Access error message (by =?Utf-8?B?bmlra2k=?= on 5 May 2004, no replies) |
|---|
|
Wayne and Damien, I am so grateful for the help you provided. The database was recovered intact. Thank you for taking the time to guide me through this. nikki ... (more) |
| linking to a picture (gif) on the web (by =?Utf-8?B?Ymph?= on 5 May 2004, 1 reply) |
|---|
|
can you link to a picture on the web, so that if the website is updated, the pic in your Word file updates? thx ... (more) |
| Re: Access crash!! (by on 05 May 2004, no replies) |
|---|
|
I am compacting it 3 times a day because the front-end database size increases from size 5MB to 55 MB. But that is another problem I will work on later. ... (more) |
| User authentication (by =?Utf-8?B?UGFuZ28=?= on 5 May 2004, 2 replies) |
|---|
|
I am in a domained network and i have put an access 97 db on a network drive, I would like to have people login using actually their network credentials, like username and password. How cai i do that? ... (more) |
| Identifying the selected option on a Switchboard for later use (by =?Utf-8?B?THlu?= on 5 May 2004, no replies) |
|---|
|
I have three Switchboards containing a MAIN Menu, and ENTRY Menu and an EDIT Menu. Before I enter further data I first of all open a form to enter the patient ID to check that the patient exists, then depending on what option was selected, say the option to enter a follow-up, I would then wish to open the form for entering follow-up data, or if it was an Adverse Event I would wish to open that form. I therefore need to be able to determine the currently selected option on the current Switchboard. Any suggestions on how I do this? Thanks ... (more) |
| Autonumbering-Assigning a team number (by =?Utf-8?B?Sm9obiBCb3phcnRo?= on 5 May 2004, no replies) |
|---|
|
I have a long list of participants that I want to assign a team number between 1-16. I have a field "Team Number" that I would like to be able to go through my table and do an update query to assign consecutive team numbers. Does Access have a function that will allow you to do this? Thanks, John B. ... (more) |
| Re: REF :- CURRENCY HEADING £ (by Allen Browne on 5 May 2004, no replies) |
|---|
|
Access is *supposed* to follow the Currency setting the user has defined in the Windows Control Panel (under Regional Settings), but it does not work as you would expect. ... (more) |
| Re: transaction not working (by Allen Browne on 5 May 2004, 1 reply) |
|---|
|
1. Set a Database variable *after* you open the transaction in your workspace. 2. Use dbFailOnError so you hear about any issues. ... (more) |
| Re: Access2002 crashes while changing from query design to SQL (by Allen Browne on 5 May 2004, 2 replies) |
|---|
|
Okay, next thing is to verify that you have at least Service Pack for Access 2002 (the Help | About screen will show "Access 2002 SP2" if you do). Just as importantly, check you have SP 8 for JET 4. ... (more) |
| Changing editing behavior of form fields (by EHPorter on 5 May 2004, 2 replies) |
|---|
|
When tabbing around the fields in a form, the normal behavior of Access seems to be to "highlight" the contents of the field when tabbing into it. Thus, any keypress will replace the contents of the highlighted field. ... (more) |
| delete table (by Michael Magg on 5 May 2004, 1 reply) |
|---|
|
Hello! I wanna import a table with a makro, but a table with this name already exists. So the imported table (f. i. "table") is saved as "table1". How can ... (more) |
| Show/Hide Subform...fidsgal (by fidsgal on 5 May 2004, 1 reply) |
|---|
|
I have a main form and a subform that are linked. On the main form, I have several check boxes with text. My goal: As a user clicks on a check box, I want the form associated with that text (subform) to "pop up". The user may check as many as needed, likewise the same number ... (more) |
| Re: =Min(DateField), =Max(DateField) (by =?Utf-8?B?Sk1vcnJlbGw=?= on 5 May 2004, 10 replies) |
|---|
| Hello again and thanks for all your assistance in this. Below is what I use to load the sql statement. ... (more) |
| Functions (by =?Utf-8?B?Q3ludGhpYSBT?= on 5 May 2004, 3 replies) |
|---|
|
Does anyone know of an easy way to switch words in a field? For example, a field has John Smith - on 2000 records we need to put Smith first so it can be sorted. I would be most grateful for any ideas. ... (more) |
| Count Expression (by Tru Dixon on 5 May 2004, 1 reply) |
|---|
|
I am having a difficult time trying to create a calculated control on a report to Count a specific text value in a field for example I am trying to Count the =Count(IIf([AppNeighborhood] = 'Allegheny County')). Why ... (more) |
| Access Database - moving text to another line (by mediapressint on 5 May 2004, 4 replies) |
|---|
|
Hello, I'm in a pinch. I created a database of names, address, phone numbers etc. However, as I compiled the ... (more) |
| Re: ldb (by Marty on 5 May 2004, no replies) |
|---|
|
Thanks, I'll try the administrator approach as logging out and leaving it overnight (which has worked in the past) didn't work this time. ... (more) |
| THANKX WAYNE MORGAN (by tru.dik@comcast.net on 5 May 2004, no replies) |
|---|
|
I really appreciated the help with (It worked) Count Expression. ... (more) |
| unlock VBE project (by HJC on 5 May 2004, no replies) |
|---|
|
I am using Access 2003 - on a form that I have created, when I try to change it, I now get message that I cannot change it because it is locked - says "unlock VBE project" - I never locked it and would like to get rid of ... (more) |
| Use Dlookup() on report text box (by Scott on 5 May 2004, 2 replies) |
|---|
|
I have a text box on my report which I want the RecordSource of it to point to a quary where a certain field in the query matches a certain field in the record source of the report, both fields are Numeric, indexed; ... (more) |
| day of the week (by ian on 5 May 2004, 3 replies) |
|---|
|
can somebody tell me the expressin to put into a query so I get the day of the week (mon, tues, etc..) from a date field. ... (more) |
| Graphs Management trhru Forms (by Cesar Ortiz-Lopes on 5 May 2004, no replies) |
|---|
|
I need a little help: - I have a Graph created thru a form. The graph data comes from a query/table with two colunms: dept and counter by ... (more) |
| Access 2000 Losing Connection to SQL Server (by Jay2k on 5 May 2004, no replies) |
|---|
|
Hello Everyone, I am having an interesting problem with our database. We are running an Access 2000 front-end with a SQL Server ... (more) |
| How to Check Who Logged into Shared Dbs (198755) (by Denise Ottie on 5 May 2004, 2 replies) |
|---|
|
Any tips to coding and running module, called ShowUsers, found in MS Knowledge Base Article 198755? ... (more) |
| "Property value is too large" error message (by Ana on 5 May 2004, 2 replies) |
|---|
|
Hi there, I've been creating a table and now all of a sudden i can't save new changes. I get "Property value is too large". ... (more) |
| Re: ERROR MESSGE (by anonymous on 5 May 2004, no replies) |
|---|
|
Cannot open with shift key held down. anotheruser record, look for State by User..." ... (more) |
| Access Accounting Systems (by Nick Demars on 5 May 2004, 2 replies) |
|---|
|
I am looking for an inexpensive Microsoft Access based accounting system that can be cutomized for different industries. Are there any suggestions? ... (more) |
| Access 2003 Hotfix 837003 (by Que Gatlin on 5 May 2004, 2 replies) |
|---|
|
Can anyone tell me where I can obtain the HotFix for Access 2003 - 837003 -- it is the one to fix the Post SP3 problem with importing text files. I was able to locate the KB article 837003, but it does not provide a ... (more) |
| Looking for MVP in Houston (by Hugh Horton on 5 May 2004, 10 replies) |
|---|
|
My boss has authorized me to contract for some help on an Access programming project but he requires that they be local, ie in Houston. (He doesn't believe in the internet) ... (more) |
| How to setup Startup options to keep table updatable (by jj on 5 May 2004, 1 reply) |
|---|
|
Hi, experts, I try to configure the Startup options for an Access.adp. But it locks my table update capability, no matter how I ... (more) |
| Installing Access97 on Windows XP After installing Office XP (by florence on 5 May 2004, 1 reply) |
|---|
|
I just bought a new Win XP Pro PC with Office XP Small Biz already installed. I need Access. I have an Office97 Pro CD that came with my old PC. Can I install JUST Access97? And will it cause problems to any existing ... (more) |
| access 2002 hyperlinks search and replace not updating target (by richard walton on 5 May 2004, 1 reply) |
|---|
|
Since upgrade to XP and Access 2002, hyperlinks are not working as before in Access. Old established table of hyperlinks work just fine in search and replace in order to update new date for displayed link, and target. But, ... (more) |
| Error message when looking at data (by Angela on 5 May 2004, 2 replies) |
|---|
|
I am getting an error, "Error accessing file. Network connection may have been lost." When I click "OK" it then shows me some visual basic code. This is occurring when I open a form and then try to look at different ... (more) |
| 3 Questions (by Chris Sergent on 5 May 2004, no replies) |
|---|
|
1. For Microsoft Office 2000 Developer, is there a way to add spell check on the runtime software, and if so how? 2. I just recently received MS XP Pro Operating System. I ... (more) |
| Bar Code Readers (by Steve on 5 May 2004, 5 replies) |
|---|
|
Can anyone suggest a good barcode reader and software that is best compatible with Access? I would assume Access is a good database for bar codes. Am I correct? ... (more) |
| access unlock protection (by Dr. C on 5 May 2004, no replies) |
|---|
|
Just tried deleting form again and I get message "this visual basic for applications-project has been protected with a password." I did not enter a password - how can I delete this form? ... (more) |
| Access 2000 for small business (by Sheila on 5 May 2004, 1 reply) |
|---|
|
Access 97 was upgraded using the above software. The computer crashed and had to be reformatted now I cannot use Access 2000. I get an error 'Can't find the database you specified, or you didn't specify a database at all.' ... (more) |
| MENSAJE DE ERROR EN INFORMES (by EDMUNDO DOMINGUEZ on 5 May 2004, no replies) |
|---|
|
Tengo un informe el cual integra varios campos basados en=20 una consulta. Pero al parecer no puedo usar muchos Campos,=20 ya que al solicitar la vista previa del informe, se=20 despliega el siguiente mensaje de error: "DEMASIADOS=20 ... (more) |
| Report Criteria (by Scott on 5 May 2004, 1 reply) |
|---|
|
I have a database where I manage membership for a organization, there are 2 tables in there, 1 called Membership_Records which contains the info for each family who enrolls in the membership, and the second ... (more) |
| ANY IDEAS? (DLOOKUP is killing me) (by Austin Gelbard on 5 May 2004, 2 replies) |
|---|
|
I am trying to use the DLOOKUP function as part of a SELECT function to build a list for use as a ROW SOURCE to create a pull down menu for data entry in a table. (wow that sounds like a lot). ... (more) |
| Access Can't find file error message (by Bill Thompson on 5 May 2004, 1 reply) |
|---|
|
I get this error message "Cannot Find the File <Filepath\Filename.mdb> (or One of Its Components)." Error Message While Opening .MDB File from Windows Explorer ... (more) |
| Auto Number or any method (by suzie on 5 May 2004, 1 reply) |
|---|
|
I have created form using Frontpage and database is Access. When the user enter data from the form, i want database to generate id in sequence format. In that case I need to set the id to autonumber. ... (more) |
| VB Script Debugger - Access 2003 (by peter on 5 May 2004, no replies) |
|---|
|
I upgraded from Access 2002 to Access 2003. Since performing the upgrade, the Script Debugger will not allow me to debug a Data Access Page. When you start to debug, an IE window opens, but it is blank. It appears ... (more) |
| Re: MoveLast on TableDef Recordset (by =?Utf-8?B?RWQgQg==?= on 5 May 2004, no replies) |
|---|
|
I changed the code to do as you suggested and that is working also. Thanks, Ed ... (more) |
| Dropdown Box in a Report (by =?Utf-8?B?bG5pYg==?= on 5 May 2004, 3 replies) |
|---|
|
Here's what I'm trying to do: I have a small Access database. Records equal individual shipments with unique invoice numbers. Fields (apart from identifying ones) are yes/no checkboxes to indicate particular problems with the shipment. Shipments often have more than one problem, therefore, option boxes/toggles or drop-downs can't be used. ... (more) |
| Dividing two fields in a Query (by RichK on 05 May 2004, no replies) |
|---|
|
Hello All! Newbie here looking for some help. ... (more) |
| Dividing two number in a query...HELP (by RichK on 05 May 2004, 3 replies) |
|---|
|
I have a query that returns 2 values that are sums. I need to divide these two numbers and show the results in the query. ... (more) |
| form settings (by =?Utf-8?B?UkFXTEVZ?= on 5 May 2004, 1 reply) |
|---|
|
I have a number field setup in a table as "Double" with "1" for the number of decimals (only way I found for decimals to show up). When entering the data into a form, however, the decimal doesn't show up. Anyone have any ideas on what I'm doing wrong? Thanks! ... (more) |
| News Index | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next | last |