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

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

   ► MB LobbyMicrosoft Access Board   Print This     

Access VBA Programming Topic

Programming in Visual Basic for Access.

 

 Show:
New Activity New Threads Oldest Unanswered Most Active Most Read
  


25 Threads:

Add New ThreadRandom Thread

Thread 25 of 25
Thread Starter  

PS_1819
assignment help Oxford
A large team of assignment help Oxford experts, who are filled with skills, enthusiasm, talent and above all interest, expedite to write excellent quality assignment solutions. We have, therefore, created a pool of assignment writers Oxford, essay writers Oxford and assignment help Oxford experts who have gone through an intriguing training after three-stage recruitment process. These assignment help Oxford experts are trusted and reliable for serving authentic and plagiarism-free work. We do not encourage any freelancing or outsourcing in terms of catering assistance to the students, instead our academic team of assignment writers Oxford and essay writers Oxford take the responsibility of handling your task. 
13 months ago
1 Reply:

RobertJ.M
{Too Long!}
16 hours ago
New Stuff Since Your Last Visit
271
Hits

Thread 24 of 25
Thread Starter  

PS_2349
Verizon email technical customer support
{Too Long!}
27 hours ago
New Stuff Since Your Last Visit
6
Hits

Thread 23 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.,
8 years ago
31 replies. Last post:

John.S16
{Too Long!}
10 days ago
Nothing New Since Your Last Visit
5528
Hits

Thread 22 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.
14 years ago
4 replies. Last post:

petter.s
It was a very good post indeed. I thoroughly enjoyed reading it in my lunch time. Will surely come and visit this blog more often. Thanks for sharing.
 dissertation writing services
48 days ago
Nothing New Since Your Last Visit
3166
Hits

Thread 21 of 25
Thread Starter  

PS_2199
How to recover Corrupted Email Data ? EDB to PST
{Too Long!}
96 days ago
1 Reply:

Ralph.M
{Too Long!}
89 days ago
Nothing New Since Your Last Visit
46
Hits

Thread 20 of 25
Thread Starter  

PS_2174
What is the function of writing in the professiona
Once you're out of school you in fact won't be asked to write formal college essays. In any case the skills need to write an open college essay translate into different skills that are vital for professional growth in many work conditions. In many fields and callings faster or later, great writing and relational abilities turn into a need for boosting any further in the field. Nowadays they open up situations that won't be easy to get to workers who don't have these skills. You can try to check out this best essay writing service to have a right support for your writing related works.
114 days ago
Nothing New Since Your Last Visit
34
Hits

Thread 19 of 25
Thread Starter  

PS_572
HND course help student to build their Future.
Many students are doing nowadays HND Courses because they know after completing HND programming course they can achieve golden chance for their career. HND Course built your mind for higher education and provide the best platform which helps you to build your career bright.  Some of the student needs UK HND Assignments Help during their diploma course.
24 months ago
Nothing New Since Your Last Visit
527
Hits

Thread 18 of 25
Thread Starter  

PS_770
Learning never ends
There are many people in the world who want to learn more than more, I am also counted in these guys. I am working online for the top web designing companies in Pakistan and I have too much passion to learn new things in my profession and also out of my profession, actually I am very inspired with my school teacher, she told me that learning and teaching never end and I had promised with my teacher that I will learn more and more till the last day of my life.
21 months ago
Nothing New Since Your Last Visit
382
Hits

Thread 17 of 25
Thread Starter  

PS_518
Education
Now Officially Best Custom Online Essay Help and Affordable Essay Writing Services UK by essay help with expert writers. Essay Writing Help services offers 100% plagiarism free Online Essay Helping UK at cheap and affordable rates. , Affordable Online Essay Help UK - UKEssayPapers
24 months ago
Nothing New Since Your Last Visit
748
Hits

Thread 16 of 25
Thread Starter  

t
Missing Page Header in Subreports
Hey:, , I have a master report that contains independent subreports (that have no data relationship to the master report - the master report serves as a 'shell'). , , My problem is when the master report is previewed or printed, the page headers in the subreports do not appear. I'm baffled because while in design view, when I select the properties for a subreport's pageheader, the visible property is 'true', yet it does not show., , Anybody have this happen or know how to force the pageheader within a subreport to show?, , (How do I reference a subreport pageheader in using VBA from the master report code?), , Thanks!
17 years ago
4 replies. Last post:

william.a2
I don't know what you mean by the subreports appearing on one page, however in the event that professional writers open up the subreports in a seperate window and go to print review, they appear fitting in agreement size and introduction as the primary report.
24 months ago
Nothing New Since Your Last Visit
2116
Hits

Thread 15 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!
18 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.
24 months ago
Nothing New Since Your Last Visit
9287
Hits

Thread 14 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
12 years ago
Nothing New Since Your Last Visit
4253
Hits

Thread 13 of 25
Thread Starter  

ScottCybak
Sparatic Query Behaviour
{Too Long!}
18 years ago
Nothing New Since Your Last Visit
1366
Hits

Thread 12 of 25
Thread Starter  

Martin Gomez
Disable Print Screen Key
How to disable the Print Screen key in Microsoft Access
18 years ago
1 Reply:

Anonymous
Plese revive this valuable thread--- Prilette
6 years ago
Nothing New Since Your Last Visit
3164
Hits

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

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

Thread 10 of 25
Thread Starter  

Daryl Myers
Update text box field only on current row
I have an Access form set to continuous forms. I have an unbound text box on the detail row. When I set the text box to a value for that row, it is updated for all rows. Is there a way to change the value of a text box on only one specific row?
17 years ago
1 Reply:

giorgio_rovelli
Not if it's unbound, you need to bind it to a field in the form's recordsource
9 years ago
Nothing New Since Your Last Visit
3334
Hits

Thread 9 of 25
Thread Starter  

Michael
Paradox to Access, Please Help
I am in the process of switching to Access 2002, I cannot for the life of me find out how to get Access to automatically fill in other fields when key field is entered into "many side" table. Paradox did this so easily by checking the "Applicable fields" in table lookup, but find no such command in Access, any help appreciated, Thanks.
18 years ago
1 Reply:

mprestwood
For anyone is interested in a comparison of Paradox ObjectPAL and Microsoft Access VBA:
  • Paradox ObjectPAL and MS Access VBA Language Reference Guide
  • 9 years ago
    Nothing New Since Your Last Visit
    2077
    Hits

    Thread 8 of 25
    Thread Starter  

    Jon
    Setting Table paths
    Hi,, , I am fairly new to Access programming. My background is in Paradox. I have to write an application however in Access that is going to be multi-user. I have already learned that I need to split the database., , My question is this: In Paradox we define 'aliases' to reference table paths so that I don't need to know in advance where the tables will reside as long as I set the alias for those tables on startup to poin to their location., , How do I do that in Access? Since I may not know a drive letter or even and UNC path when I begin - how do I reference the tables?, , Any help appreciated., , Jon
    14 years ago
    1 Reply:

    ric_shumack
    {Too Long!}
    10 years ago
    Nothing New Since Your Last Visit
    3126
    Hits

    Thread 7 of 25
    Thread Starter  

    SteveL13
    How get calculated field value on a form to write
    I have a form which is bound to a table. On this form I have a calculated field. The calculation is the sum of two other field values. How can I get the value of the calculated field to write to a specific field in the table?
    16 years ago
    1 Reply:

    mprestwood
    Answering for completeness... Don't do that with a calculated field. At least, it's much easier using an event such as changeValue or another event.
    10 years ago
    Nothing New Since Your Last Visit
    2714
    Hits

    Thread 6 of 25
    Thread Starter  

    hassan_sani
    Starting MS Access
    Is it posible to start Access without the access startup showing? how can this be accomplished.
    11 years ago
    Nothing New Since Your Last Visit
    2989
    Hits

    Thread 5 of 25
    Thread Starter  

    jrabinaw
    Help with Lookup Boxes & Coding
    {Too Long!}
    11 years ago
    1 Reply:

    Dan
    {Too Long!}
    11 years ago
    Nothing New Since Your Last Visit
    2704
    Hits

    Thread 4 of 25
    Thread Starter  

    mathmg
    Seeking advice on table layout
    {Too Long!}
    11 years ago
    1 Reply:

    Dan
    It sounds like you have it right.  Since the checklist can have multiple subsections which may or may not be the same you should break them into seperate tables.  You may want to consider an additional field if the order of the subsections in the checklist has any importance.
    11 years ago
    Nothing New Since Your Last Visit
    2629
    Hits

    Thread 3 of 25
    Thread Starter  

    SDL20
    Is this possible?
    Here's what I'm trying to do, and I'd like to know if it's possible., , There is a form in an Outlook email that I will be getting frequently. In each form there are about 20 fields. Each of these emails is in a seperate folder. Is it possible to extract the data from the fields in the form in the email to populate my database. The difficult part is that each form is randomly placed in the senders email., , Does anyone know if this is possible?
    13 years ago
    1 Reply:

    mprestwood
    Yes, this is definately possible. The easiest solution is to use VS.Net. You would start by downloading the MS Office development kit or find an Office developer. We have a few in our family of developers so we can help if you wish to take the outsourcing approach.
    12 years ago
    Nothing New Since Your Last Visit
    2660
    Hits

    Thread 2 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?
    12 years ago
    1 Reply:

    mprestwood
    {Too Long!}
    12 years ago
    Nothing New Since Your Last Visit
    7152
    Hits

    Thread 1 of 25
    Thread Starter  

    DSW05
    Simple Copying Macro
    I have created a macro in Ms Access that selects certain rows and columns. Next I need the macro to copy the selected so I can use a simple past function. Simple right? NO! Banging Head On Wall I can't find a command in Access to copy! In every other Office program this command is "selection.copy", but not in Access. Please help; it is something I desperately need for my job. Worried
    15 years ago
    1 Reply:

    Don G
    Consider using a query to select the data you want.  Then make it an Append or  Make-Table query to create a temporary table or copy (append) your data into another table. 
    12 years ago
    Nothing New Since Your Last Visit
    2715
    Hits

    New Thread

    Follow PrestwoodBoards on: 


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