Microsoft Access / VBA Forum

Hello all, I have a form in Access XP that returns all printers intalled on the users system. The select which printer they want to print to and click a "Next" button. The button click event runs the code at the bottom of this page to open a number of reports, change the printer to the one the user specified, save and close, then print...

I am using Outlook Express as my newsgroup reader. Would anyone know why when I go to create a post to the newsgroup or read the existing posts and responses, it always opens to restored down? I have to maximize every time. Thanks, Carl

I work for an engineering firm that mostly performs structural inspections on cranes and lift equipment. Until now we have hand written field inspection reports, hand them in then entered into a database and formal report written in word. Is there any way to streamline this. Can there be a table with different components etc to enter into a...

Patients-physician-querry relational database with 2 tables, physicians and Clients, In the Client DB, there is a number that implies the physician, I can easily make a form where you put in the physicians number, but.. If I want the dropdown box to show the name of the physician I have to base it on the other table. (the physician table),...

I have main form who contains subform in datasheet. I want to disable (selecting one column and then Ctrl + C). I just want them to see results in datasheet but not to copy data form datasheet. Thanks in advance

Hello all, I am converting an Axs 2.0 application to a2k (I know A2K is not the most current version but Axs 2.0 support ended and A2K is supported in our company amd on every PC). The form is part of an access projcet (ADP) and runs against SQL Server 2000. I have an bound form in endless view which contains a header with a combobox....

Hi, I am making a web application in asp.net. I want to add a record in ms access using a button event. How to do it? ANY IDEAS ???

Hi Gang I have 2 tables and a field called part_id in each table. I want to get a list of the records that have the same part_id in both tables. Please help! Andy

I have a form that's based on a query. I'm trying to make the form only accept hours worked if there is a pay rate already entered in another form. If not the form will return a message box notifiying the user that there is no corresponding pay rate for the hours entered, then return the fields to null values. The problem is that my code...

I've a Dell with Windows 2000 and had installed Microsoft Office 2000 Premium and Professional. ACCESS 2000 was running just fine. I got an upgrade to ACCESS 2003 but didn't like how it was running and looked, so I uninstalled it, hoping to get back to ACCESS 2000. but now ACCESS 2000 won't run at all . when i try to open it it says,...

I need some help. Here is the problem. Table_1 (gl_Train_KeyIdeas) +----------------------+----------------+-------------------+---------------+ | KeyIdea_ID | Unit_ID | Group_ID | Title | +----------------------+----------------+-------------------+---------------+ | 1 | 1 | 27 ...

Hi all, I'm looking for examples of off-the-shelf business to business (b2b) access applications. The scope of my investigation is pretty broad so any examples would be of a great deal of help. Run-time applications would be super terrific but any will do. You can reach me at benben999 at excite.com (at means @ :) ). Thank you, Ben

I have a form which has a tick box control which has SendObject code to email a report. The code is Private Sub Loadtxt_Click() On Error GoTo Err_Handler DoCmd.SendObject acSendReport, "rptOnlineUpload", acFormatRTF, , , , "OnLineUpload", "Please upload this document to Online", True Exit_Handler: Exit Sub Err_Handler:

is it possible to take data values added in a report and insert it into a form?

I hope that someone will be able to help with this problem. It is probably an easy fix for mose of you so bear with me... I have 2 tables for this. One has item # and InventoryAmount. The other is daily production which has a linked field for the item #. The UsedAmount and item # are entered in the daily production each day. The amount...

Hi All, I have a database with a button that when it is click it sends an email to the client. This email button works without any problems in other computers. On Thursday we bought a new computer, and this particular button does not function on the new computer. I installed several version of Outlook from 2000 to 2003 and still doesn't...

Good day, I need to add security to my data base, looking at the log on name to the computer, i am sure this is possible. Could anybody help me with suggestions and how to implement it. Les Stout

Hi. I was wondering if there was anyone that could take a look at the specs for this database and help me through this? http://www.myelasticmind.com/databasespecs.pdf I don't know much about databases, I can't afford to hire a programmer, and I really need to get this done.

I'm fairly new to access and VB. I have a form which contains several text boxes and an insert record command button. The button is supposed to insert a new record into the database using the text fields, and then increment a text field by 1. The insert record part works fine, but I cannot seem to increment a text box by one. I'm sure theres a...

I have a main report which filters on popup entry for an ORDERID. Within report is a subform/report which has order details. When I run subreport by itself, details only print once, but when I run main report, details within subreport are printing twice. What might be causing the duplicate records? LOU

Using A2K. I've researched this newsgroup and can't find the answer to my question. As we all know, when a database is turned into a Design Master, another database is created called "Replica of {database name}". Can that replica then be moved (not copied but moved) to a laptop? A previous database developer set up a replica for a...

I am using Access 2003 and am having difficulty creating a subform that will save records associated with a particular parent record.... The error message I receive pertains to indexes, relationships, etc... Thanks!

I keep receiving the above error message in Microsoft Access 2003 when I open ANY database - including a completely empty test database (no forms, no macros, no tables). Can anyone suggest a solution? TIA

I am trying to have a button that launches a word mail merge document thats already linked to my database. when i hit the button, word opens with the file, but all the mail merge features are greyed out. what am i doing wrong? i am using office xp, and here is my code: Public Function LaunchMerge() On Error GoTo Err_LaunchMerge

The database I am working with contains a field with as many as 12 different values (09,10,11,12,13,14,15,16,17,18,19,20) My end user has requested that the number of times these 12 different values appear in the table be grouped in the following 8 groups (15 or 19), (13 or 17), (16 or 20), (14 or 18), (09), (11), (12), (10) That is, for...