Microsoft Access Most Active Threads

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.,

Posted to MB Topic: Access VBA Programming

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

Posted to MB Topic: Access News / Other

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

Posted to MB Topic: MS Access Interactive

(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.

Posted to MB Topic: MS Access Interactive

{Too Long!}

Posted to MB Topic: Access VBA Programming

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

Posted to MB Topic: MS Access Interactive

I 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.

Posted to MB Topic: MS Access Interactive

I 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!!!

Posted to MB Topic: MS Access Interactive

Hello 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

Posted to MB Topic: MS Access Interactive

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

Posted to MB Topic: MS Access Interactive

I 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????

Posted to MB Topic: MS Access Interactive

I 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

Posted to MB Topic: MS Access Interactive

I 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....

Posted to MB Topic: Access VBA Programming

{Too Long!}

Posted to MB Topic: Access VBA Programming

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

Posted to MB Topic: Access VBA Programming

I 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 : )

Posted to MB Topic: MS Access Interactive

Hi,, , how can I create a automatically Timestamp in a Access table ???, Thanks, , Frank, , :)

Posted to MB Topic: MS Access Interactive

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.

Posted to MB Topic: MS Access Interactive

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

Posted to MB Topic: Access VBA Programming

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.

Posted to MB Topic: Access VBA Programming

Does 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..

Posted to MB Topic: Access News / Other

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.

Posted to MB Topic: Access VBA Programming

I 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

Posted to MB Topic: MS Access Interactive

How about using excel to perform a vlookup or dlookup with the information in an access database table. Is that possible?, , Daren

Posted to MB Topic: MS Access Interactive

Hi,, , 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 ??

Posted to MB Topic: MS Access Interactive