IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Access
Search Access Group:

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

Prestwood eMagazine

July 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
9 years ago
95 replies. Last post:

carlo.a
Norton Security Standard can protect only one system. Norton Security Deluxe can be used for up to 5 systems, and Norton Security Premium can protect up to 10 systems. To know more about them and their comparison you can visit the official site of Norton. https://nortonsetup-nortoncom.com
43 minutes ago
New Stuff Since Your Last Visit
6860
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
19 years ago
17 replies. Last post:

brian p kim
{Too Long!}
19 years ago
Nothing New Since Your Last Visit
4153
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
16 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
16 years ago
Nothing New Since Your Last Visit
6001
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
12 years ago
13 replies. Last post:

nashwannabe7
{Too Long!}
12 years ago
Nothing New Since Your Last Visit
6785
Hits

Thread 21 of 25
Thread Starter  

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

craigh
FIXED., , I had to remove the single quotes.
19 years ago
Nothing New Since Your Last Visit
2319
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
18 years ago
12 replies. Last post:

kpalmer
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2366
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
18 years ago
10 replies. Last post:

Occie
Kal,, , Finally figured out the error message and now the code you helped me with works. Thanks
18 years ago
Nothing New Since Your Last Visit
3189
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
19 years ago
9 replies. Last post:

Scott
{Too Long!}
19 years ago
Nothing New Since Your Last Visit
2120
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
19 years ago
7 replies. Last post:

char_li
{Too Long!}
19 years ago
Nothing New Since Your Last Visit
2233
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
18 years ago
7 replies. Last post:

jdschram
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
8456
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
18 years ago
7 replies. Last post:

jdschram
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2825
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
17 years ago
7 replies. Last post:

Steve_Ignorant
Finally, I got it to work. Appreciate the input.
17 years ago
Nothing New Since Your Last Visit
2084
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
18 years ago
7 replies. Last post:

kpalmer
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
2324
Hits

Thread 12 of 25
Thread Starter  

Mr. Pickles
Count Number of dates w/holidays
{Too Long!}
Posted to MB Topic: Access VBA Programming
18 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.
18 years ago
Nothing New Since Your Last Visit
2094
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
19 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.
19 years ago
Nothing New Since Your Last Visit
2230
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
18 years ago
6 replies. Last post:

dannii22
Thanks hraps for your help. It worked Big Grin!
18 years ago
Nothing New Since Your Last Visit
1962
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
18 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.
20 months ago
Nothing New Since Your Last Visit
2119
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
18 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...
18 years ago
Nothing New Since Your Last Visit
1987
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
13 years ago
Nothing New Since Your Last Visit
4328
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
12 years ago
5 replies. Last post:

Anonymous
{Too Long!}
9 years ago
Nothing New Since Your Last Visit
6335
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
19 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.
19 years ago
Nothing New Since Your Last Visit
2527
Hits

Thread 4 of 25
Thread Starter  

David H. Thornton Sr
Dialing from Access 2003
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
15 years ago
5 replies. Last post:

Alex.J2
Hello, I would like to thank you for sharing this interesting information. I appreciate reading it. I have never tried using these databases. Maybe I should try using when I will work on my custom dissertations review task.
42 days ago
Nothing New Since Your Last Visit
3829
Hits

Thread 3 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
18 years ago
5 replies. Last post:

jdschram
not a prob
18 years ago
Nothing New Since Your Last Visit
2130
Hits

Thread 2 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
18 years ago
5 replies. Last post:

jdschram
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
1966
Hits

Thread 1 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
19 years ago
5 replies. Last post:

ScottCybak
I'd suggest you set it to "Lock Edited" and that you enable record level locking also.
19 years ago
Nothing New Since Your Last Visit
2357
Hits
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]