Microsoft Access / VBA Forum

I have created a supplier database the only problem is with creating the reports where on the print preview they print every order. I want it to just show the current order. So form the supplier form you can click on the report button and the report just show that unique order for the user.

I have a database that I need to restrict the ability to edit one field based on another. The two fields are DOS (date) and Amount (currency). I only want the users to be able to edit the Amount field if the DOS is =>now()-5. Does anyone have any suggestions? Thanks, Lisa

Access 2000. I have a table called tbl_main There are several fields in this table - two of which are called "Staff Name" and "Account Number". I created a form (frm_data) which is linked to the table tbl_main. In this form - the user would first type in the "Staff Name" (combo box format) and then tab/enter to the next field --> account...

I have a form of club members with a continuous subform on it showing boat details. I hold the boat length and beam (in meters) in a table. On the subform I also calculate and show the imperial equivalent length and beam. You can enter lengths in either the metric box when an AfterUpdate event shows the imperial eqivalent, or converseley you...

Hi, I have been struggling with this problem for two days. My development PC is running Windows XP/Office 97. The work stations are running Windows 2000/Office 97. In the past I have always compile the Access front end file in the developments PC before letting the staff copy the access file. Since two days ago, despite the access file is...

Hello everyone, I want to create an employee license plate database and need help with the best table design. I was thinking three tables: 1) tblEmployees EmployeeID EmployeeName

Is there any updates to this code since the book? Everything's working OK except for one particular form, it is big, 3 pages with a table control on each but it's not the only 3 page form in the db. All forms were originally designed at 640x480, this one form, if I have Access at 800x600 or less (or just main window sized to that size)...

Hi folks, Firstly, Happy New Year to all. I have some problems with query pls help.I have 4 tables namely Equipment,Safety1,Safety2,Safety3. some of the fileds in each table is shown below. equipment: requestorname,building,equipmentid(pk),WWID safety1:status,equipmentid safety2:requeststatus,equipmentid safety3:status3,equipmentid

Hi, I've put a subform onto a form. I want to be able to double click on an item in the subform and have the revelavent information to pop up in a new window. I think its something to do with linked child parent fields but I can't seem to get it to work. Any advice. Regards, Denis

Windows XP tips and tricks. Learn how to bypass very common windows problems, speed up your system and make it more reliable with useful tips and tricks.

Hi, I have a panel of data organised as follows: id1, 1990, 100 id1, 1991, 101 id1, 1992, 100 id1, 1993, 103 id2, 1990, 80 id2, 1991, 90

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