I.T. Discussion Community!
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

October Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access Board   Print This    All Groups  

Microsoft Access Most Active Threads

  


25 Threads:


Thread 25 of 25
Thread Starter  

jseidel
Reading Paradox tables from Access 2007
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
8 years ago
30 replies. Last post:

Stacy.W2
This is an incredible article. I am pretty much pleased with your work. Thanks a lot for sharing., mcafee activate
33 days ago
Nothing New Since Your Last Visit
4610
Hits

Thread 24 of 25
Thread Starter  

Patricia R. Turner
access vrs paradox
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
18 years ago
17 replies. Last post:

brian p kim
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
4072
Hits

Thread 23 of 25
Thread Starter  

KCRABBE
splitting contents of one field into several field
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
15 years ago
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
15 years ago
Nothing New Since Your Last Visit
5919
Hits

Thread 22 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.
Posted to MB Topic: MS Access Interactive
11 years ago
13 replies. Last post:

nashwannabe7
{Too Long!}
11 years ago
Nothing New Since Your Last Visit
6696
Hits

Thread 21 of 25
Thread Starter  

craigh
Help with DAO problems
{Too Long!}
Posted to MB Topic: Access VBA Programming
18 years ago
12 replies. Last post:

craigh
FIXED., , I had to remove the single quotes.
18 years ago
Nothing New Since Your Last Visit
2276
Hits

Thread 20 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
Posted to MB Topic: MS Access Interactive
17 years ago
12 replies. Last post:

kpalmer
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2311
Hits

Thread 19 of 25
Thread Starter  

Occie
Requery a combo box
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
17 years ago
10 replies. Last post:

Occie
Kal,, , Finally figured out the error message and now the code you helped me with works. Thanks
17 years ago
Nothing New Since Your Last Visit
3121
Hits

Thread 18 of 25
Thread Starter  

chemistwendy
Getting fields with zero values to not print and n
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
18 years ago
9 replies. Last post:

Scott
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2082
Hits

Thread 17 of 25
Thread Starter  

char_li
Newbie
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
18 years ago
7 replies. Last post:

char_li
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2181
Hits

Thread 16 of 25
Thread Starter  

blkphtm
combox box display
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
17 years ago
7 replies. Last post:

jdschram
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
8411
Hits

Thread 15 of 25
Thread Starter  

kris0214
question on subforms
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
17 years ago
7 replies. Last post:

jdschram
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2779
Hits

Thread 14 of 25
Thread Starter  

Steve_Ignorant
Append query trouble
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
16 years ago
7 replies. Last post:

Steve_Ignorant
Finally, I got it to work. Appreciate the input.
16 years ago
Nothing New Since Your Last Visit
2049
Hits

Thread 13 of 25
Thread Starter  

Rainier
Field Links
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
17 years ago
7 replies. Last post:

kpalmer
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
2274
Hits

Thread 12 of 25
Thread Starter  

Mr. Pickles
Count Number of dates w/holidays
{Too Long!}
Posted to MB Topic: Access VBA Programming
17 years ago
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.
17 years ago
Nothing New Since Your Last Visit
2046
Hits

Thread 11 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
Posted to MB Topic: Access VBA Programming
18 years ago
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.
18 years ago
Nothing New Since Your Last Visit
2157
Hits

Thread 10 of 25
Thread Starter  

dannii22
Input of data in reports
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
17 years ago
6 replies. Last post:

dannii22
Thanks hraps for your help. It worked Big Grin!
17 years ago
Nothing New Since Your Last Visit
1895
Hits

Thread 9 of 25
Thread Starter  

FranktheFrank
TimeStamp
Hi,, , how can I create a automatically Timestamp in a Access table ???, Thanks, , Frank, , :)
Posted to MB Topic: MS Access Interactive
17 years ago
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.
11 months ago
Nothing New Since Your Last Visit
1962
Hits

Thread 8 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.
Posted to MB Topic: MS Access Interactive
17 years ago
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...
17 years ago
Nothing New Since Your Last Visit
1929
Hits

Thread 7 of 25
Thread Starter  

Craig Goodman
Combo Box won't update with specified value
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
12 years ago
Nothing New Since Your Last Visit
4240
Hits

Thread 6 of 25
Thread Starter  

sjmoore
Corrupt mdb file
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
11 years ago
5 replies. Last post:

Anonymous
{Too Long!}
8 years ago
Nothing New Since Your Last Visit
5517
Hits

Thread 5 of 25
Thread Starter  

andyhud
Version Info in Access 97
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
18 years ago
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.
18 years ago
Nothing New Since Your Last Visit
2464
Hits

Thread 4 of 25
Thread Starter  

blkphtm
Query containing matched values
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
17 years ago
5 replies. Last post:

jdschram
not a prob
17 years ago
Nothing New Since Your Last Visit
2087
Hits

Thread 3 of 25
Thread Starter  

blkphtm
Excel and Access
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
17 years ago
5 replies. Last post:

jdschram
{Too Long!}
17 years ago
Nothing New Since Your Last Visit
1923
Hits

Thread 2 of 25
Thread Starter  

terversa1
Sharing Access Database between users
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
18 years ago
5 replies. Last post:

ScottCybak
I'd suggest you set it to "Lock Edited" and that you enable record level locking also.
18 years ago
Nothing New Since Your Last Visit
2298
Hits

Thread 1 of 25
Thread Starter  

KMerker
UNION on 2 Tables
{Too Long!}
Posted to MB Topic: MS Access Interactive
18 years ago
5 replies. Last post:

KMerker
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2288
Hits

Follow PrestwoodBoards on: 


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech