Well, the brain freeze seems to be moving off . . . solved the problem with the help of Knowledge Base at Microsoft.com., , In case anyone else needs a reference: [URL=http://office.microsoft.com/en-us/assistance/HA010345581933.aspx]MS KB Article[/URL], , I would still like to hear any strategies that anyone might have to do this in an easier fashion . . .thanks, kc
I guess you may use the query that was shared on Prestwood forum. Somewhere about queries. Rovena Gilbert and Derreck Torr (essay writers from the stuff) commented on the process of calculating the whole amount.
I have an Access application that imports data from Paradox tables in an existing, external application (Timeslips by Sage). App was originally written in Access 2003 and I was able to link to several Paradox tables and read them successfully (no update is required). We upgraded to Access 2007 and the existing Paradox links work just fine but I have been unable to create new read-only links to more of the Timeslips' Paradox tables. The new Import wizard assumes a read-write link and then fails with the error:
"Unexpected error from external database driver (11010)."
Development is on a Windows7 64-bit machine and deployed to a WindowsXP machine (soon to be upgraded to Windows7). I've tried linking on both machines and NoGo.
I've also tried searching the web for code that could handle this but to no avail.
Any suggestions as to how I can accomplish this? Thanks very much.,
Good Evening everyone.. I am new too this board. But I have a few tough questions on Access, could you please help., , 1. Is there a way that you can get rid of the toolbars completely ? when you are viewing a form., , Lindy
Are you asking if you can view the form outside of access? ie, the Access toolbars?, , Or is this a project you are updating and the forms have toolbars in them?, , Not that I have put toolbars in my forms, and getting it all to work outside of Access (stand alone) is the last thing I will research., , I'm afraid all I can help you with here is clarifying the question.
Is it possible to make a combo box display more than one field from a different table when you select what you want, instead of just showing the first column of a table?, , Daren
Are there any code examples available somewhere where I could see some guidelines how to parse a delimited text file and change my database accordingly?
First reference the Microsoft Scripting Library in your code. Open the file using the TextStream functionality of the Scripting library. Then use the Split function to break the delimited records up into their elements.
I am downloading data from a web survey into a txt file that I then import into Access. Users are inserting "quotes" in their comment fields. I am cleaning up the comments in the txt file by reading them into variables and using the REPLACE function to remove jargon (e.g. &LF; is replaced with. That works fine, but I have tried to REPLACE the quotes with ^ or single quote but I can't get VBA to read the quotes. I have even used Chr(34) and it is not recognized. How do I REPLACE quotes in substrings?
(Hi, I am using Microsoft Access 2003)
Is it possible to populate a ComboBox with choices from more than one field?
I've got a couple of different tables, both having a "Department" field. One table has some departments, and the other table (Linked SharePoint table) has some different departments.
I've got a form with a ComboBox control where the user picks a department from the drop-down list, and right now it only pulls the departments from one of the tables (the non-SharePoint regular table). Is it possible I could give the ComboBox "Row Source" property to, in addition to pulling data from the one table, also adding the Department field from the SharePoint table, too? Just so it lists all departments from both tables.
Any help is appreciated, thanks.
I have an mdb file that appears to have some corruption. I have run the "compact and repair database" utility several times. This utility runs without reporting any problems. However, there are about 5 forms of about 60 in the mdb file that, when modified cause MSAccess to crash. I have also tried to start with a blank mdb file and cutting and pasting every form, table, query, report, from the old file to the new file and the same problem occurrs with the same forms.
I am desperately hoping for some advice from somebody to hopefully help me save all the code that I have done and not have to build it again to get rid of the problems (it would really be a pain).
Thanks in advance.
I have a table with several fields. Each field contains several options separated by a ;., , In other words, the information in a typical field would look like:, , xxxxxx;yyyyyy;aaaa, ccc;dddddddd;ff, , The last item does not have a ; at the end of the item., , Is there a simple way to split this one field into several fields?, , Thanks for your help., , KC
For anyone who has this problem . . . , , 1. export database into Excel, , 2. highlight the column you want to split, , 3. click on DATA, then TEXT TO COLUMNS, , 4. just follow the instructions, , 5. then import Excel spreadsheet into ACCESS, , It worked for me . . . thanks, again, to everyone who helped me to sort out the problem . . . maybe not the neatest solution but within my grasp . . . take care, KC
I am trying to link tables from an Oracle database using the link table wizard but I keep getting the message "There are several tables with that name. Please specify owner in the format 'owner.table'. (Error 3298)". I have linked tables many times before and never received this message. What can I do? HELP!!! Thx.
[URL=http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q117900&LN=EN-US&rnk=29&SD=gn&FR=1&qry=Please%20specify%20owner%20in&src=DHCS_MSPSS_gn_SRCH&SPR=MSALL&]http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q117900&LN=EN-US&rnk=29&SD=gn&FR=1&qry=Please%20specify%20owner%20in&src=DHCS_MSPSS_gn_SRCH&SPR=MSALL&[/URL] , , also has info...except the error number is 2030
--------------------------------------------------------------------------------, One more question. , , 1. When doing a query to a linked database on local machine linked to network file, will it still create network traffic? , No data editing made, only browsing.
I was working with my main .mdb file, and as luck would have it, Access up and crashed. This does happen every so often, as is true with most software including Microsoft products, but this was a very bad loss., , Upon trying to reopen the file and recover what I have since my last save, I get the following error message:, , The Microsoft Jet database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell its name and the path name correctly., , There was no object named MSysDb in my system, so I am assuming it is an Access feature. Other backups I have work just fine...only the file which crashed gives me this error., , It is possible to spend a day recovering lost work, but if there is anyway I could recover my lost file and sidestep this error message, I would be very appreciative., , ``allen
Thanks for your reply. I felt that option 2 was the best decision, but then I sometimes have a habit of making life more difficult than it needs to be. Thanks again,and I will follow you suggestion about linking the supplemental client data!
Dear all,, , I have made a form for my new database. I added a bound object frame. Now I want to insert picture to my form. I know how to insert it by right clicking the frame and then select "Insert Object...." on the pop up menu. This procedure seems to be inelegant, because I want my user to insert the pic just by clicking a button. , , I want to make a button, name it "Insert Picture" button, and just by clicking the button, Access will open Dialog Window, and I can select the file I want to insert to my form. The problem is, I just don't know how to make the VBA code for this button. , , Can anyone help me how to make the VBA code for this problem? Please let me know. Thank you for you kind attention. , , Regards,, , Ary
Hello-
Very much a beginner at Access here. I'm trying to create a form for data entry, and may have several questions, but let's start with this one:
I am entering data related to employee attendance at professional development sessions. There are six categories of sessions, and each category contains about 20-40 independent sessions.
For the first two steps of the data entry process, I would like to have two combo boxes: one in which the category is selected, and the second in which the exact session in question (sorted by data and course title) is selected. Of course, I would rather not have the second combo box contain over 200 sessions.
The question is thus: How do I make the contents of the second combo box dependent on those of the first, so that if a particular category is selected in the first, only the sessions in that category are displayed in the second?
Thanks in advance.,
As this is my first post to this board, I will try not to complicate this with unnecessary information.
I am trying to set a combo box to a specific value (the name of a loan) using VBA for when the form opens. The combo box is populated with Loan Names from an Access table. Currently, I am using the following code to set the list index property (I have used this with excel vba before and it worked):
Combo_LoanName.ListIndex = 3
The problem is that when the form opens the combo box list is populated but no item is selected. I have tried other variations of the code above but to no avail. Can anyone spot what I may be missing?
Thanks,
Craig
Not sure where to put this, but I am interested in whether the general groups feels there is more of a market out there for paradox apps or access apps. Keeping this short i won't go into my background, but I am thinking of making a career change, currently i am not in a development enviroment but am thinking of getting back into it. I have developed apps in both Paradox (my first development platform, and my first love) and Access. I am thinking of getting back into the field developing stand alone apps and I guess I need to pick one or the other to use, and i am wondering which would be the better choice as far as more marketable? , , I hope this post makes sense as I need to make a decision on wheter to purchase the Paradox Development edition or the Office Developer tools., , I would appreciate the groups comments, either on here or via email. Thanks
Can I set up a Secure Database where I have five users accessing a table. This table will have information about 12 divisions. Passwords are assigned to the five people whereby the password allows them to either edit or only view the data about the division., For example:, John can update info about division 1 and division 5 but he has only read-only rights to the rest of the divisions., , If anyone has any suggestions please help me., , Thanks
I have an Access 2003 Database and I need to be able to automatically dial phone numbers from a field I have in the form or table within the database (eg. Members work (field)) but when I press the command button the command is blank. any suggestions.
Hi, I'm doing a Uni report on the security features of Access., basically info on:, -related issues such as system and data access security, -user login facilities of access as well as machines etc, -performance considerations (info on access on a network), -Optimal number of users accessing files at one time if centralised etc, If you could help me out with this I'd be very grateful.
there is another post in this forum i just replied to:, [URL=http://205.158.230.147/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=29&t=000028]http://205.158.230.147/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic&f=29&t=000028[/URL] , , hopefully, this will set you on the right track.