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

August 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  

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!
16 years ago
2 replies. Last post:

Jay.M
Check the field you want to count and enter "calc count all"
5 days ago
Nothing New Since Your Last Visit
422
Hits

Thread 24 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
10 years ago
Nothing New Since Your Last Visit
3620
Hits

Thread 23 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!
15 years ago
Nothing New Since Your Last Visit
1075
Hits

Thread 22 of 25
Thread Starter  

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

Thread 21 of 25
Thread Starter  

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

Anonymous
Plese revive this valuable thread--- Prilette
53 months ago
Nothing New Since Your Last Visit
2578
Hits

Thread 20 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.,
6 years ago
Nothing New Since Your Last Visit
2202
Hits

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

Anonymous
{Too Long!}
6 years ago
Nothing New Since Your Last Visit
4846
Hits

Thread 18 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?
15 years ago
1 Reply:

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

Thread 17 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.
16 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
  • 7 years ago
    Nothing New Since Your Last Visit
    1569
    Hits

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

    ric_shumack
    {Too Long!}
    8 years ago
    Nothing New Since Your Last Visit
    2434
    Hits

    Thread 15 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?
    14 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.
    8 years ago
    Nothing New Since Your Last Visit
    2105
    Hits

    Thread 14 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.
    9 years ago
    Nothing New Since Your Last Visit
    2590
    Hits

    Thread 13 of 25
    Thread Starter  

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

    Dan
    {Too Long!}
    9 years ago
    Nothing New Since Your Last Visit
    2221
    Hits

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

    alan.l
    Have you tried MAPI?
    9 years ago
    Nothing New Since Your Last Visit
    2340
    Hits

    Thread 11 of 25
    Thread Starter  

    mathmg
    Seeking advice on table layout
    {Too Long!}
    9 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.
    9 years ago
    Nothing New Since Your Last Visit
    2075
    Hits

    Thread 10 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?
    11 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.
    10 years ago
    Nothing New Since Your Last Visit
    2216
    Hits

    Thread 9 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?
    10 years ago
    1 Reply:

    mprestwood
    {Too Long!}
    10 years ago
    Nothing New Since Your Last Visit
    6410
    Hits

    Thread 8 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
    13 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. 
    10 years ago
    Nothing New Since Your Last Visit
    2195
    Hits

    Thread 7 of 25
    Thread Starter  

    jdoody
    Passing Value From One Query to Another
    Hi all! I'm new to this site, which I just happened to stumble upon. I have a question that is probably easy for a seasoned Access user. I have created a series of queries and have linked them in order to create a report consisting of current and prior year budget to actual totals. I am wondering how to pass values between queries - for example, user enters "6" - for month 6 - in query 1, how do I access this "6" as input for query 2?
    15 years ago
    1 Reply:

    Don G
    Your first query becomes input for your second query.  Just drag and drop the field from the first query to your new query design.  It works like a charm.  When you execute the 2nd query, it automatically updates results from the 1st query for its input.  Hope this helps.
    10 years ago
    Nothing New Since Your Last Visit
    2243
    Hits

    Thread 6 of 25
    Thread Starter  

    lerry1989
    Adding data from VB into Access
    I am writing a program with VB. It is connected to Microsoft Access so the user can add member details to the form and when they press save, the details are stored in the Database but I also need to create reports so the user can calculate their monthly takings. Does anyone have a basic way of doing this that I can easily adapt?, , Thanks
    10 years ago
    1 Reply:

    Don G
    Use a query to calculate the takings and either combine the query with your member table to provide a summary of info or feed the query to a report.  Reports are prettier and can provide details as well as totals, but queries are quicker if you just need totals.
    10 years ago
    Nothing New Since Your Last Visit
    2266
    Hits

    Thread 5 of 25
    Thread Starter  

    gurunath
    Message Boards
    Can U please send me the different msgboards which we will use in ms access
    14 years ago
    1 Reply:

    adamlum
    There are various messageboard software packages out there that use Access as a back end, one that I have had success with can be found here http://www.webwizguide.com/web_wiz_forums/default.asp Hope that helps! 
    10 years ago
    Nothing New Since Your Last Visit
    2221
    Hits

    Thread 4 of 25
    Thread Starter  

    Lisa Bush
    Need help with BYPASSKEY
    Hello everyone., , Is there a way to set the BYPASSKEY (shift) to false for users who sign into a database but allow it to be used for myself who is the administrator of the database? I don't want people who have some knowledge of Microsoft Access to be able to use the SHIFT key. There is highly sensitive information in this database that I have created., , Thanks so much for any help.
    12 years ago
    1 Reply:

    adamlum
    Answered this question in another post, here's the link: http://www.prestwoodboards.com/ASPSuite/eBoard/Thread.asp?MBID=11222 
    10 years ago
    Nothing New Since Your Last Visit
    2267
    Hits

    Thread 3 of 25
    Thread Starter  

    Lisa Bush
    Need Microsoft Access help
    Hello everyone., , Is there a way to set the BYPASSKEY (shift) to false for users who sign into a database but allow it to be used for myself who is the administrator of the database? I don't want people who have some knowledge of Microsoft Access to be able to use the SHIFT key. There is highly sensitive information in this database that I have created., , Thanks so much for any help.
    12 years ago
    1 Reply:

    adamlum
    Don't want to plagiarize, nor type a bunch of code, but an exact solution can be found here: http://www.databasedev.co.uk/disable_shift_bypass.html  Hope this helps! 
    10 years ago
    Nothing New Since Your Last Visit
    2793
    Hits

    Thread 2 of 25
    Thread Starter  

    earthenfairie
    AutoFill Union Query
    I would like my order form to fill in all corresponding data after the part number has been entered into the Part No field. I have a custom parts table and a standard parts table. I have created a union query to combine these tables into one list. I just can't figure out what to do next. How do I get the form to search for the Part No and fill in any corresponding data? Please help..., , Thanks for your time....
    13 years ago
    Nothing New Since Your Last Visit
    1530
    Hits

    Thread 1 of 25
    Thread Starter  

    earthenfairie
    Command Button Coding Help
    I've been using this code for a command button to open a new form. It has worked consistently until this last form I created. I get an error message that says "OpenForm action was canceled" when I click the button. Please help. I need this button to work, as this will be the only place in which this particular form will be accessible., , Code Following....thanks for any help., , Private Sub Production_Details_Click(), On Error GoTo Err_Production_Details_Click, , Dim stDocName As String, Dim stLinkCriteria As String, , stDocName = "Production Details", , stLinkCriteria = "[Customer Orders.Pick No]=" & "'" & Me![Pick No] & "'", DoCmd.OpenForm stDocName, , , stLinkCriteria, , Exit_Production_Details_Click:, Exit Sub, , Err_Production_Details_Click:, MsgBox Err.Description, Resume Exit_Production_Details_Click, , End Sub
    13 years ago
    Nothing New Since Your Last Visit
    1272
    Hits

    New Thread
    -
       Contact Us!
     
    PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

    2,043 People Online Now!!  
    Sign In to see who's online now!  Not a member? Join now. It's free!
    Show more stats...


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