Thread 25 of 25 | Thread Starter | | |  jseidel | Reading Paradox tables from Access 2007I 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.,
|
 9892 Hits | |
Thread 24 of 25 | Thread Starter | | |  Patricia R. Turner | access vrs paradoxNot 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 |
 4221 Hits | |
Thread 23 of 25 | Thread Starter | | |  David H. Thornton Sr | Dialing from Access 2003I 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. 14 replies. Last post: |  Matt.b | {Too Long!} |
|
 4026 Hits | |
Thread 22 of 25 | Thread Starter | | |  KCRABBE | splitting contents of one field into several fieldI 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 13 replies. Last post: |  kcrabbe | 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 |
|
 6087 Hits | |
Thread 21 of 25 | Thread Starter | | |  gsempcb | Populating ComboBox...(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.
|
 6849 Hits | |
Thread 20 of 25 | Thread Starter | | |  craigh | Help with DAO problems{Too Long!} 12 replies. Last post: |  craigh | FIXED., , I had to remove the single quotes. |
|
 2355 Hits | |
Thread 19 of 25 | Thread Starter | | |  mike d | New Memeber - Multi Selections in an Query from a I am a Power User and have been using Access since 96 HOWEVER I have never learned VB and I think that might be the problem here., , I know how to set the MULTI SELECT in the list box property, am I using extended,, , There my question is this:, , 1) Can I have a user select more than one element on the list box and have that link to a query WITHOUT using VB? , , Any function I can use within Access?, , Please help, if I need VB knowledge then at least I know I did all I can., , I have gotten very far with this tool and I love it, I am sure I might be able to decifer a VB module with alittle help but I really need this to work, so a user can pick say 2 dates and the query automatically runs for those two dates only., , I just learned how to set Parameter Queries from this Forum, thank you., , I know, I do not know VB, anyone have a good suggestion how a Power User can get started?, , Thanks 12 replies. Last post: |  kpalmer | {Too Long!} |
|
 2442 Hits | |
Thread 18 of 25 | Thread Starter | | |  Occie | Requery a combo boxI have a combo box on a form which allows a user to choose which institution they want. Then they can hit a command button to run a macro. This macro runs a query which pulls specific data for the chosen institution. , , Everything works fine. What I want is for the combo box to be reset or be clear when the user closes the query., , I have tried putting Me!cmboInstitution.Requery in the After Update event of the combo box. Does't do anything., , Any tips would be great. P.S. I don't know any VB. 10 replies. Last post: |  Occie | Kal,, , Finally figured out the error message and now the code you helped me with works. Thanks |
|
 3267 Hits | |
Thread 17 of 25 | Thread Starter | | |  chemistwendy | Getting fields with zero values to not print and nI have tried creating a macro that checks for zero values and then sets the visible property to false and I have also tried letting the macro set the width property to 0 inches but both ways the fields still seem to take up space even though they can not be seen. I need to bring the report to less pages if these fields are zero. Help!!! 9 replies. Last post: |  Scott | {Too Long!} |
|
 2165 Hits | |
Thread 16 of 25 | Thread Starter | | |  char_li | NewbieHello everyone. I have just been recruited to write an order tracking db for my company. I am looking for resources to that end., , This is a check to see how much traffic is on this board to see if this is a valid resource. Could a regular give me some information as to how quickly questions get answered and if all questions get answered? , , I hope I have found 'the place'., , Thanks all,, , char li 7 replies. Last post: |  char_li | {Too Long!} |
|
 2298 Hits | |
Thread 15 of 25 | Thread Starter | | |  blkphtm | combox box displayIs 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 7 replies. Last post: |  jdschram | {Too Long!} |
|
 8505 Hits | |
Thread 14 of 25 | Thread Starter | | |  kris0214 | question on subformsI have a field set in a subform (datasheet view) upon double clicking to open up the subform for user friendly entry (thanks for last post, it worked) and now Im wondering how to make the data entered update immediately without having to close form and come back in for it to appear in the datasheet view???? 7 replies. Last post: |  jdschram | {Too Long!} |
|
 2891 Hits | |
Thread 13 of 25 | Thread Starter | | |  Steve_Ignorant | Append query troubleI have been trying to build an append query, all seems fine until I run the query, then I get an error message stating that 10 rows have not been updated., I have no idea what is wrong but i suspect my relationships are the problem., The file can be viewed here:, http://homepage.ntlworld.com/charlie_chuck/Rental.zip , , I will try to outline as clearly as possible what I am trying to achieve in this query., My goal is to append 10 records from the column W_Rent from the tblProperty_List to the column Amount in the tblRent., As I said earler all my efforts have failed., If anyone can troubleshoot this issue for me I would be really grateful., , Steve 7 replies. Last post: |  Steve_Ignorant | Finally, I got it to work. Appreciate the input. |
|
 2126 Hits | |
Thread 12 of 25 | Thread Starter | | |  Rainier | Field LinksI have two tables, one has a primary key and a date, the other has job information. what script can i use to link the date field with the primary key within the same table? when i type in the date in the date field form the primary key autonumber does not correspond to the date, it creates another record. , Please help.... 7 replies. Last post: |  kpalmer | {Too Long!} |
|
 2375 Hits | |
Thread 11 of 25 | Thread Starter | | |  Mr. Pickles | Count Number of dates w/holidays{Too Long!} 6 replies. Last post: |  Falcon | I'm trying to count the number of working days between two dates. I also need to take Holidays into consideration and not count them. |
|
 2147 Hits | |
Thread 10 of 25 | Thread Starter | | |  craigh | refer to object properties dynamically?how can I refer to object properties dynaically?, , for example, I want to do this:, , For i = 1 To numreturned, Me.i.Caption = result(0, (i - 1)), Next i, , there are buttons on a form named "1", "2", etc. I want to be able to dynamically set their caption values based on a recordset., , appreciate the help., , craig 6 replies. Last post: |  craigh | I'm working on a MAJOR project that is difficult to describe..., , basically, it will be a system that allows people to register for a "conference" (we call them festivals) and then schedules them into the festival based on certain criteria. It also allows for the administration of the festival, including hiring of judges, establishing locations, etc. We **might** be looking for someone who can complete the scheduling module of the project. |
|
 2270 Hits | |
Thread 9 of 25 | Thread Starter | | |  dannii22 | Input of data in reportsI have an access assignment to and I'm having trouble with one of the questions. , The question is as follows:, A report showing details of any given component. After input of the Component Code by the user, the system should be able to display data on this component. [end question], , I thought data entry was only possible in a form., , Does anyone have any ideas? Reply if you need more information. Thanks in advance : ) 6 replies. Last post: |  dannii22 | Thanks hraps for your help. It worked  |
|
 2055 Hits | |
Thread 8 of 25 | Thread Starter | | |  FranktheFrank | TimeStampHi,, , how can I create a automatically Timestamp in a Access table ???, Thanks, , Frank, , :) 6 replies. Last post: |  Jio.G | I agree with those special discussion. The self service portal of united states postal service department have the best result as the employees have got the best ever online presence and helped them a lot to improve their career.web posrtal at https://liteblueinfo.xyz/ have the best ever solution for them.
|
|
 2262 Hits | |
Thread 7 of 25 | Thread Starter | | |  Corporal Tunnel | How to link and replace data -Please help-I have a database with 7 fields. ID, Publisher, Title, Issue, Price, Checkout. In the checkout column I have html I copied from my online payment company. In the html is a place for title, issue, ID, and price. I have been manually typing in each piece of data for each box. I have 4000 books and have finished 180. Isn't there a way to have access take the data from the title field and place it into my html using some sort of tag??? I need it to grab the 4 pieces of info from the table and insert it into my html. I want to paste the same html into the entire checkout column and let access do the rest. This is simple right?? At my wits end. Thanks in advance. 6 replies. Last post: |  jdschram | hmm..paste error?, is this when you are physically pasting the HTML into the column the first time? before you are going to the form? This could be a problem if you are using text as the type for checkout...change it to Type MEMO..., , BTW..do you have MSNMessenger...it might be faster since we are both online right now... |
|
 2049 Hits | |
Thread 6 of 25 | Thread Starter | | |  Craig Goodman | Combo Box won't update with specified valueAs 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
|
 4393 Hits | |
Thread 5 of 25 | Thread Starter | | |  sjmoore | Corrupt mdb fileI 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.
|
 6503 Hits | |
Thread 4 of 25 | Thread Starter | | |  andyhud | Version Info in Access 97Does anyone know how to add version information to Access MDB files?, , By versio information I mean when the user right clicks and checks the file properties there should be a Version tab., , Any help gratefully received.. 5 replies. Last post: |  Dan | Ya your right about VB also haveing that ability. Those programs expose this functionalit by including a resource file compiled into the executable code, you can't do that with the Access executable. |
|
 2580 Hits | |
Thread 3 of 25 | Thread Starter | | |  blkphtm | Query containing matched valuesI have a table with a field, that is setup as a MEMO field. Information is entered seperated by a comma to represent more than one thing., , How can I create a query that will find a match of what I type in to look for., , Example: Field is for Serial Numbers: 001, 002, 003, etc is the data format in them. I want to just be able to search for say 003 and it would bring up that record. , , Daren |
 2162 Hits | |
Thread 2 of 25 | Thread Starter | | |  blkphtm | Excel and AccessHow about using excel to perform a vlookup or dlookup with the information in an access database table. Is that possible?, , Daren 5 replies. Last post: |  jdschram | {Too Long!} |
|
 2005 Hits | |
Thread 1 of 25 | Thread Starter | | |  terversa1 | Sharing Access Database between usersHi,, , I have a access database on my server..i have created a backend for the tables which is ok...but when i install the forms..etc..on each users PC..when 2 users try to access at the same time..it says that the data is in use ?? can anyone help ?? 5 replies. Last post: |  ScottCybak | I'd suggest you set it to "Lock Edited" and that you enable record level locking also. |
|
 2400 Hits | |
|