| Discussion Groups Index | first | prev | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | next | last |
| Getting rid of " in a field in a table (by =?Utf-8?B?Qm9nZ2E=?= on 22 May 2004, 3 replies) |
|---|
|
I am importing Excel data into an Access table. When the teacher name text field is imported into Access, it puts "" at the beginning and end of the teacher's name. I have other text fields being imported & it doesn't do that to those fields; only the teacher name field. I want to write a macro that would clean up that field so that the "" will be deleted. Or I want to use the Find/Replace feature. However, when I go to find/replace I don't know how to tell it to just delete it rather than try to replace it with something. Any ideas? ... (more) |
| Can anyone suggest a good numerica encryption logarithm? (by =?Utf-8?B?RGF2ZQ==?= on 22 May 2004, 1 reply) |
|---|
| I have a numeric field and want to encrypt before storing in the table. Can anyone suggest a good loarithm? ... (more) |
| Access & PDA's (by Adam Ward on 22 May 2004, 1 reply) |
|---|
|
I want to be able to collect data on my PDA and then sync it with Access on my PC. I know this can be done but I dont know how is there any resource that will help me. ... (more) |
| Elapsed time (by Bee on 22 May 2004, 2 replies) |
|---|
|
My problem is this: I want to keep a record of the time required to perform certain functions under varying conditions. So I want Access to accept and display time as minutes and seconds only. No matter what I try Access ... (more) |
| Development Tracking (2nd post) (by Paula on 22 May 2004, 2 replies) |
|---|
|
I am to developing an application in Access 2003. I am looking for an easy, simple, way to track and record the changes, versions, etc. that is made during this development. Can somone recommend a form, process or ... (more) |
| Buy earlier version of Access (by Paul on 22 May 2004, 3 replies) |
|---|
|
I run on Windows ME, no problems with it, no intentions to upgrade. I have Office 2000 Standard, but now I want to add Access. I think I need 2000 version, but 2002 might work? ... (more) |
| Error in Loading DLL (by John Reichard on 22 May 2004, 25 replies) |
|---|
|
I hope this is the correct newsgroup to post my problem. I have a front-end Access 97 database that I am trying to convert to a .mde file. When I try to save it as a .mde file, I get the following error: "Error in Loading DLL". ... (more) |
| Parameter value when running query (by =?Utf-8?B?Unlhbg==?= on 22 May 2004, 1 reply) |
|---|
| Hello I created a query from one of my tables and I had five colums in my table. So in my query I calculated the sum of each column in the table. I also added in an extra field in my query that was suppose to add together the sum of each column so I could get a total of each column. when I run the query it ask for the parameter value for each column. What is going on. my expression for the last field looks like this--- Expr1: [SumOfJulia]+[SumOfAshley]+[SumOfMegan]+[SumOfTiffany]---- Thanks for any help. Sorry if this is basic but I am just starting to learn access and databases. I am actually a beginning web designer but I am much better at that. Again Thanks. Ryan ... (more) |
| who modified this record? (by =?Utf-8?B?R2luYSBTdGFycg==?= on 22 May 2004, 3 replies) |
|---|
|
I'm developing a database that will have several field users inputting data that feeds into several tables of my database. I plan to give each of these users a unique ID log-in, and would like to find a way to track which records they have modified (and when). I've got the and-when answered from reading other posts in this newsgroup, but would someone please let me know how to add the "who modified me last" field into my tables, and have it get the information from the log-in? If I can figure get this going, I might be able to salvage what is left of the weekend! Yikes!! ... (more) |
| step by step tutorial to publish database online (by Tal on 22 May 2004, 2 replies) |
|---|
|
I've tried to get help with this before but without success so far I have a database that needs to be accessible to a few people through a website interface. The plan is to store the database on one of our office ... (more) |
| Re: Modifing Cells- Increasing numbers in a table (by Allen Browne on 22 May 2004, no replies) |
|---|
|
1. Create a query into your table. 2. Change it to an Update query (Update on Query menu). Access adds an Update row to the grid. ... (more) |
| Access runtime 2000 with Office 2003 pro (by TrueBlue on 22 May 2004, 1 reply) |
|---|
|
I have a 3rd party app which requires Access 2000 runtime. I already have the full version of Access 2003 installed - do I still need to install the runtime? ... (more) |
| Excluding Data? (by Jamie Allison on 22 May 2004, 3 replies) |
|---|
|
Hi Forum I have a little problem in a Microsoft Access 2000 database i have. ... (more) |
| Puzz...runtime error, ACC2002 (by =?Utf-8?B?RGVyZWs=?= on 22 May 2004, 3 replies) |
|---|
|
I have a 2002 mdb that opens fine on all pc's running ACC2003 and all ACC2002 units except for one. I have installed the office suite twice and when I try to open the DB as a user I don't get the switchboard. If I close out and open the DB up in design view and then try to view the switch baord form I get the following error: Runtime error '-2147024769 (8007007f)': Method 'connection' of object '_currentProject' Failed. Now this error only occurs on the one pc, and if I run it from any other acc2002 or 2003 installation there are no issues. Not sure what could be caussing the issue on this pc, could it be a missing module? Thanks ... (more) |
| Query problem (by =?Utf-8?B?Tmlja2lvcw==?= on 22 May 2004, 1 reply) |
|---|
| I'm trying to create a query to extract details of an admission for a hospital. The query is meant to extract all the details that belong to an indiviual admission number. This includes things like patient number and name etc (field values that only occur once in the admission - the patient only has one name). The only problem i'm having is that an admission can have more than one diagnosis code (unique to the diagnosed illness). A diagnosis occurs in order of rank (the primary ranked diagnosis results can result in having a secondary diagnosis e.g the flu, causing sickness). However, i only want to extract the primary diagnosis code in the query and ignore the secondary and tertiary etc etc. Can this be done??? ... (more) |
| Error message using Hyperlinks in Access 2003 (by =?Utf-8?B?VGV6YmFy?= on 22 May 2004, 5 replies) |
|---|
|
Can someone PLEASE help me?? !! I have a hyperlink for each record in my database that opens a related Word document. ... (more) |
| posting results from a query on a web page (by =?Utf-8?B?TGluZGE=?= on 22 May 2004, no replies) |
|---|
| Hello, In my database I have recently created a database query where I have 4 individual column sums and 1 column that has the total of all 4 together. On my page I would like to be able to create a sentence that would be similar to something like this. Total votes for Tiffany _ (where "_" would be the total from the first column. I would do that for each row and then finally. Total votes submitted _ (the total of all 4 columns in my database. Thanks for any help or suggestions you may have. ... (more) |
| Retrieving a sting in a query (by =?Utf-8?B?QWNjZXNzbWFu?= on 22 May 2004, 6 replies) |
|---|
|
I've noticed someone else had a similar problem to me when trying to retrieve the first part of a postcode. I have two types of postode: AB1 2CD and AB10 2CD. So far by putting the following in as a query: Left([InputString], InStr([InputString], " ") - 1) i have managed to get the postcode AB1 to appear correctly (without a space, which is how i want it) but the word #Error comes up on all the postcode AB10. Looking at the expression, it looks fine to me. Can anybody see where i'm going wrong? Thanks ... (more) |
| Making form/report with a fixed no. of lines and variable no. or records (by Chris on 22 May 2004, 5 replies) |
|---|
|
I realy need your help for the following problem. I need to display some data in a tabelar mode in a report or form, using the data from a temporary table having at most 7 records. The printable report(form) must have exactly 7 lines, leaving empty the ones for which ... (more) |
| Accessing text box value (by John on 22 May 2004, 1 reply) |
|---|
|
Hi I am trying to access the value of a textbox in its 'on change' event as follows; ... (more) |
| Using Listbox selection values in query??? (by WOLFE on 22 May 2004, no replies) |
|---|
|
I am trying to use a list box to select what values should be used in a query. The list box contains about 20 items, and is set so the user can select multiple items. After selecting the items they wish to view, I would like to run a query that will only return records with the selected item on ... (more) |
| third page on form only showing one series of records (by S.Hoitinga on 22 May 2004, no replies) |
|---|
|
HI, I encountered a very strange problem in access 2000 and I don't know how to fix this. ... (more) |
| Can write but can't read from subform (by blue room on 22 May 2004, 1 reply) |
|---|
|
I have a form with a subform. The subform's record source is a query, which I have bound to the controls on it. Problem is, when I enter data into the subform, the data gets written to the table, but when I navigate back one record and then forward one record in the main form, I don't see the records ... (more) |
| Any help would be appreciated. (by Always Learning on 23 May 2004, 10 replies) |
|---|
|
Hi Guys, This is my first posting here. Could you please help me with this. ... (more) |
| Closing form (by John on 23 May 2004, 2 replies) |
|---|
|
Hi Is it possible to close a form through code from within itself without using the form name? I just worry that form name can change and the code will stop ... (more) |
| don't read... just an test (by cyberpoof on 23 May 2004, 1 reply) |
|---|
| is it working? ... (more) |
| Color problems (by Sylvia on 23 May 2004, 1 reply) |
|---|
|
I am running Office 2003 with Access 2003, on a Win XP system. When I boot this computer up, there is a color component missing. My desktop shows full color. The color is there on some web pages and partial color on ... (more) |
| MS Access Oject Usage Frequency (by Chris Holmes on 23 May 2004, 1 reply) |
|---|
|
Does anyone know a way to monitor the frequency of use for MS Access Ojects. Is there program code that I can develop or an Add In that I can buy to monitor the frequency of an objects use. ... (more) |
| Change text of 1 word in a text box (by Scott on 23 May 2004, 1 reply) |
|---|
|
Is there any way how to update one word in a text box to another. ? For example, I want to change the word "Reside" in a text box to the word "Resides", so that every "Reside" will become "Resides" but it will not ... (more) |
| Access 2000 on XP (by ndennis on 23 May 2004, 11 replies) |
|---|
|
Since installing Access 2000 on WinXP my application will not close without bringing up the error message to send to Microsoft. I don't know what the problem is that was sent. The same application still works on my laptop with ... (more) |
| COMPARE THE TWO TABLES (by Rick on 23 May 2004, 2 replies) |
|---|
|
PLEASE HELP!!! I HAVE TWO TABLES WITH THE SAME FIELDS, BUT TWO DIFFERENT SOURCES. ONE IS MY BROTHER'S ADDRESS BOOK AND ONE IS MY ... (more) |
| Font Changing in Report (by =?Utf-8?B?YmRlaG5pbmc=?= on 23 May 2004, 6 replies) |
|---|
|
If I have the following switch as part of a text box, is there any way to assign different color font for each item in "". For example Red for Waive Service Call, Green for Pending, etc.? =Switch([Waive Service Call],"Waived",[Cancel Service Call],"Canceled",[Rescheduled Service Month],"Rescheduled",[Date Written Report Sent] Is Not Null,"Completed",Not IsNull([Date Written Report Sent]),"Completed",True,"Pending") ... (more) |
| Select in .OPEN (by =?Utf-8?B?SmVzc2ll?= on 23 May 2004, 16 replies) |
|---|
|
Can anyone help me with this piece of code? The run-time error "-2147217904" saying that No value given for one or more required parameters. rst2.Open _ "SELECT * FROM tblWarehouseProduct " & _ ... (more) |
| command button (by =?Utf-8?B?TWlrZQ==?= on 23 May 2004, 5 replies) |
|---|
|
How do I make a command button place a time/date stamp in a text box each time I click it? I have the command button placed next to a text box, but I can't seem to make it do what I want it to do. Can anyone help. ... (more) |
| user define defined names (by =?Utf-8?B?Z3JvYg==?= on 23 May 2004, no replies) |
|---|
| I have a [perhaps stupid] question, and would really appreciate any input; How would Access handle the feature of end users [of the application we planning to develop] defined field labels [selected from a master template, provided by us, or defined by the end user] and allocaton of number of fields as result of selection of fields? Is this doable in Access? ... (more) |
| Microsoft Site has W32/Sdbot worm !!!! (by DazedConfused on 23 May 2004, 1 reply) |
|---|
|
I have talked with MS techs 2 times. I was in the process of updating to SP4 for Windows 2000 and McAfee warned of the W32/Sdbot.worm.gen.g Virus. It has a total of 4 or 5 infected files in thier download. As expected my update failed. I talked with MS this morning and they were ... (more) |
| Resetting database menubars (by =?Utf-8?B?U2lhbjc2Nw==?= on 23 May 2004, 1 reply) |
|---|
| I've come across a little problem when i set up the toolbars on display when my database starts up. Now i can't seem to reset them - how do i do this considering i no longer have the view and tools options on the main menubar. ... (more) |
| Switchboard questions (by =?Utf-8?B?Qm9i?= on 23 May 2004, 1 reply) |
|---|
|
Can i use a switchboard to access a query? Also, i have one main switchboard that allows me to open up two more switchboards - one which opens up forms and another which opens uses a macro. Is there any way i can place a piece of text on one of the switchboards without it apperaing on the other 2? ... (more) |
| sql syntax for subform combo (by =?Utf-8?B?dG9tcw==?= on 23 May 2004, 3 replies) |
|---|
|
Hi, I'm having some rookie difficulty trying to write an event procedure for a subform(orderdetails subform) combo box (cbodescription). I want it to get it's criteria from a combo(cbosubcategory) on the mainform(orders1). I keep getting errors saying basically that Access can't interpret the statement. ... (more) |
| Updating the link in a Linked Table. (by =?Utf-8?B?S2xpbGxlc3RvbA==?= on 23 May 2004, 4 replies) |
|---|
|
Macro Name: Autoexec Condition: ... (more) |
| Creating a macro (by =?Utf-8?B?V2FzcA==?= on 23 May 2004, 1 reply) |
|---|
|
I'm having a little trouble creating a macro to open a form. Currently i have a main switchboard that allows the user to open each form in edit mode by clicking on the relevent button. I would also like to for the user to be able to open each form in read only mode using a button on the switchboard as well. After much thinking i really don't know where to begin. Also, once i can open each form in both read-only and normal(edit) modes i'd like to be able to create a little warning to let the user know he/she can edit a form whenever a form is opened in the normal mode. Any help with this would be much appreciated, Thanks. ... (more) |
| Outlook express (by geary graham on 23 May 2004, 4 replies) |
|---|
|
How do I set up outlook express to receive from comcast.net? Smtp.comcast.net? ... (more) |
| Query sorting (by =?Utf-8?B?Tmlja2lvcw==?= on 23 May 2004, 1 reply) |
|---|
| I have a query that outputs the following columns in left to right order: Paitent number, sex, postcode, admission date, discharge date, admission method code, discharge code and daignosis. How can i sort the data retrieved by the query by disharge date and then by admission date (remebering that the admission date is the cloumn left of the discharge date)? ... (more) |
| Function FindFirst (by Paul on 23 May 2004, 11 replies) |
|---|
|
Run time error 3251, Operation is not support for this type of object. There is the code: Private Sub Command30_Click() ... (more) |
| Removing unnecessary references (by Silvester on 23 May 2004, 6 replies) |
|---|
|
Is there any way to check if there are unnecessary references being used for a mdb ? eg: if a reference is made to MS-Calendar control mscal.ocx but it is never really used during the running of the mdb ? ... (more) |
| windows upgrades?? (by Kim Hickman on 23 May 2004, 1 reply) |
|---|
|
Each time I turn on the computer, it tells me that my windows upgrades are ready to install. I install them then the next time I go into the computer, the same upgrades are ready to install. What happened to the initial upgrade installation and why do I continually have to install the same ... (more) |
| database corrupted (by sankar on 23 May 2004, 1 reply) |
|---|
|
i have database in lan. more than one user can have access with their own objects. hence same objects can not be allowed to update the same time.but sometimes it gets corrupted.let me know the reason for that. is it possibility to support the multiuser environment.please reply ... (more) |
| Saving A2000 split mdb in A97 format (by Silvester on 23 May 2004, 6 replies) |
|---|
|
I have an A2000 app split into FE mde & backend mdb. There is a great deal of custom programming including custom menubars, etc. Would I lose functionality if I save the fe/be to A97 format to cater to A97 ... (more) |
| Checking if outlook is installed and sending email immediately (by Silvester on 23 May 2004, 1 reply) |
|---|
|
I use outlook automation to prepare emails from Access. Dim oApp As Outlook.Application Dim objNewMail As Outlook.MailItem ... (more) |
| Password reminder (by Martyn Williams on 23 May 2004, 1 reply) |
|---|
|
Hi, Does anyone know how to switch on the password reminder in IE6 os Millennium ... (more) |
| Report & previous records... (by Teo\(I\) on 24 May 2004, 1 reply) |
|---|
|
example: +1 =1 +3 =4 ... (more) |
| Jetcomp for XP (by Ramesh on 24 May 2004, 2 replies) |
|---|
|
Hi, Does Jetcomp.exe utility work for database in Access XP? Any other utility to compact for XP? ... (more) |
| internet explorer error (by natalie on 24 May 2004, no replies) |
|---|
|
Hi, I keep getting an error message when opening Internet Explorer. IE has encountered a problem and has to close. Why is this happening? ... (more) |
| Appointment schedule - with a twist (by =?Utf-8?B?S2F0aGVyaW5l?= on 24 May 2004, 5 replies) |
|---|
|
I'm trying to attempt really hard at the moment...I have been asked to create a database that schedules appointments. The database is for a major research study in which participants have time periods between each visit and the study runs over 5 years. They also have 7 days either side of the set date in which they can attend their visit. The users want a program that calculates 3 months in advance the visit dates and creates an appointment record for each visit with the date and time of the appointment. However, they must be able to adjust this record if the participant can't attend the appointment on that day. I'm not really worrying with calculating the visits in advance and creating records yet but I am trying to figure out how to check that the user hasn't scheduled an appointment on a day that the place isn't open - this is the twist...not only do I need to cut out weekends, but also whichever day is entered as a day the place is closed...in other words, the place may be closed every wednesday and weekdays - how can I cut these days out as potential appointment dates. I have a drop down calendar from which they can pick or type in a date for an appointment but I need to prevent them from selecting a weekend date/public holiday/day when the place is closed. As this program is going to be used by a number of different studies...the day that the place is closed on, can vary. Weekends are always out but it may be in Study A that Wednesday is the closed day or in Study B that Friday is the closed day. ... (more) |
| Updating Data in A View (by Randy on 24 May 2004, no replies) |
|---|
|
I qork on an Access 2K front end to a SQL Server 2k database. I have a customer that has over 6000 records in a series of tables that he wants to update one field (which exists for all rows) but wants to do it easier then the form which we already have for it. ... (more) |
| OLE Server or Active X prob (by KRISH on 24 May 2004, no replies) |
|---|
|
Hi! My os is Win 2000. Office is 2000 prof. Whenever I open my access it is giving error saying OLE Server or ActiveX controls can not start, start it manually. The same is ... (more) |
| Switchboard (by Dazza on 24 May 2004, 1 reply) |
|---|
|
Hi, I'm not sure if this is the appropriate forum but I have a switchboard that has two levels. I have an input form that I'd like to add a control button that would take the user to the second level of the switchoard not ... (more) |
| Accessing Data on Table (by Brett on 24 May 2004, 1 reply) |
|---|
|
Hi I have Access 2003 and my information does not appear in table when entered via a form....Some data will appear ... (more) |
| Find button not working on Subform (by anonymous on 24 May 2004, 1 reply) |
|---|
|
Please, I put a find command button on my form, but it wont find anything in the subform i have! It wont bring up records that I know exist ... (more) |
| Help me restore deleted records! (by tsmith@hpbs.org on 24 May 2004, 1 reply) |
|---|
|
The database was not backed up. Deleted all records in error. Can I get them back? Thanks. ... (more) |
| Discussion Groups Index | first | prev | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | next | last |