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 Read Threads

  


25 Threads:


Thread 25 of 25
Thread Starter  

KCRABBE
Subtracting records
{Too Long!}
Posted to MB Topic: MS Access Interactive
16 years ago
1 Reply:

kcrabbe
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
16 years ago
Nothing New Since Your Last Visit
16931
Hits

Thread 24 of 25
Thread Starter  

kirsten
query count
i need to total the amount of duplicate records in my database. I know this should be easy but i can't figure it out!
Posted to MB Topic: Access VBA Programming
19 years ago
3 replies. Last post:

Brook.K
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.
32 months ago
Nothing New Since Your Last Visit
9682
Hits

Thread 23 of 25
Thread Starter  

Lindy
Access Toolbars
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
Posted to MB Topic: MS Access Interactive
19 years ago
1 Reply:

char_li
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.
19 years ago
Nothing New Since Your Last Visit
9557
Hits

Thread 22 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 21 of 25
Thread Starter  

TheJoe
How to parse a text file with VBA?
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?
Posted to MB Topic: Access VBA Programming
19 years ago
2 replies. Last post:

bprestwo
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.
19 years ago
Nothing New Since Your Last Visit
8216
Hits

Thread 20 of 25
Thread Starter  

Don G
Replacing quotes with VBA in Access
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 withBig Grin!. 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?
Posted to MB Topic: Access VBA Programming
13 years ago
1 Reply:

mprestwood
{Too Long!}
13 years ago
Nothing New Since Your Last Visit
7226
Hits

Thread 19 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
88 replies. Last post:

henry.r3
{Too Long!}
10 days ago
Nothing New Since Your Last Visit
6815
Hits

Thread 18 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 17 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
6330
Hits

Thread 16 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 15 of 25
Thread Starter  

access_wanna_be
There are several tables with that name. Please sp
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.
Posted to MB Topic: Access VBA Programming
18 years ago
3 replies. Last post:

jdschram
[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
18 years ago
Nothing New Since Your Last Visit
5935
Hits

Thread 14 of 25
Thread Starter  

Daniel Fought
Preventing locking, concurrency and speed problems
{Too Long!}
Posted to MB Topic: MS Access Interactive
18 years ago
4 replies. Last post:

Dan
--------------------------------------------------------------------------------, 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.
18 years ago
Nothing New Since Your Last Visit
5716
Hits

Thread 13 of 25
Thread Starter  

lucasLondon
Full Outer Join in Access
{Too Long!}
Posted to MB Topic: MS Access Interactive
13 years ago
1 Reply:

Dan
{Too Long!}
13 years ago
Nothing New Since Your Last Visit
5184
Hits

Thread 12 of 25
Thread Starter  

rdavidson
recover damaged file...MSysDb
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
Posted to MB Topic: MS Access Interactive
18 years ago
2 replies. Last post:

Anonymous
--- sajo
8 years ago
Nothing New Since Your Last Visit
4781
Hits

Thread 11 of 25
Thread Starter  

virtualj
Database design - looking for opinions
{Too Long!}
Posted to MB Topic: Access VBA Programming
18 years ago
2 replies. Last post:

virtualj
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!
18 years ago
Nothing New Since Your Last Visit
4533
Hits

Thread 10 of 25
Thread Starter  

reebok_tennis
How to insert a picture to the form with VBA code?
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
Posted to MB Topic: Access VBA Programming
18 years ago
1 Reply:

dynamictiger
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
4423
Hits

Thread 9 of 25
Thread Starter  

mrs179
Form with dependent combo boxes (beginner)
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.,
Posted to MB Topic: MS Access Interactive
12 years ago
1 Reply:

dmichael
{Too Long!}
10 years ago
Nothing New Since Your Last Visit
4346
Hits

Thread 8 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
4327
Hits

Thread 7 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
4152
Hits

Thread 6 of 25
Thread Starter  

Ammar
Setting the value list in a list box based on the
{Too Long!}
Posted to MB Topic: Access VBA Programming
16 years ago
Nothing New Since Your Last Visit
4061
Hits

Thread 5 of 25
Thread Starter  

lludlow
Secure Database
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
Posted to MB Topic: MS Access Interactive
19 years ago
2 replies. Last post:

dmichael
{Too Long!}
10 years ago
Nothing New Since Your Last Visit
4033
Hits

Thread 4 of 25
Thread Starter  

jman009
I need Security!!! *info required*
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.
Posted to MB Topic: Access News / Other
16 years ago
Nothing New Since Your Last Visit
3954
Hits

Thread 3 of 25
Thread Starter  

gsempcb
Stuck, in Access 2003...
{Too Long!}
Posted to MB Topic: MS Access Interactive
12 years ago
3 replies. Last post:

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

Thread 2 of 25
Thread Starter  

ierax
query expression for multiple selection?
what should i put in the criteria of my parametrized query so that it works for multiple selections?, , in the form page i have the tag ,
1 Reply:

ScottCybak
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.
19 years ago
Nothing New Since Your Last Visit
3871
Hits

Thread 1 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.
39 days ago
Nothing New Since Your Last Visit
3827
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]