I have written a query that limits the number of records returned. I would like to allow the end user to determine what they want that number to be? If for example they want the top 20 or 10...
I have at least three Event Types (60, 60070 and 65) associated with a patient leaving the department. A given pt could have any, or all valued in a single record, discrete date/timefields ...
I have a table with columns named Title1, Title2, Title3, Title4 etc.
I am building a For loop to access them and add them to a collection like this
Dim keyCollection As New Collec...
When I run the code below it works perfectly but only opens a New Record. I'd like the user to be able to see all of the records (to help them see what to put there and avoid silly duplicatio...
Hi,
This is my first question so hopefully I provide everyone with enough info. I have a database developed in Access 2000. It works fine when the users have Access 2000 or 2003 on their co...
make sub form within a form read only if security level is not met
MS Access 2003 - I am developing a database that I use to invoice customers and would like to automatically generate emails with invoices based on shipped field and date. Is it possible to do...
I have a database, created in ms sql server management studio express, that is maintained in access 2003. I have the following columns: LoanNumber, LoanAmount, LoanTerm, LoanDate, InterestRat...
Hi all, trust you well.
I have a table (Product) that has a related table holding (Items). There are many items for one product.
I want to know if there is a way that i can create a dupl...
I have a form that my consultants use for contact management. On the form I have a sub form that is used to log each contact with the client. I have added a new command button called "Left Me...
I created a macro in ms access 2002 and I'm trying to import a spreadsheet with 4 columns from excel 2002 into a table with the same columns and data types. If I use File, Import everything w...
I have a very simple form that I enter temperatures for a range of dates. The fields are Date, High, and Low. The record source is a table called tbl_HighLow. For this particular tables fun...
I submitted a string of code below: it is supposed to search my table ("StudentName") for all records where the field "NumberStudents" is null and StudentName = "Tom". I can not get the "Null"...
Hello,
I have created an Access database application that takes about a minute to load. That database consists of 84,000 companies and 265,000 contacts. Currently, the record source of my ...
I have an Access 2003 db form. In the form i have the follwoing to send an email to a receipt after a from is filled out.
Private Sub SendMail_Click()
Dim strTo As String
strTo ...
Hello,
I have 2 command buttons, Red & Green. The Red one turns a rectangle's backcolor property to red, and the green button turns the same rectangle's backcolor property to green. That pa...
I have a field in a form that has data that almost matches data in a table except for a few characters at the end of the string on the form data.
Is there a way I can replace the data on th...
I'm pretty new to Access 2007 & VBA and I've been hunting around the help files and my Access 2007 Bible. I haven't found any info on whether or not the Data Collection Wizard in Access 2007 ...
Hi,
I'm trying to open a Word Doc from a list box. It begins to open the file and then stops with a Runtime 5174 Error, which says "This file could not be found (c:\//program%20files/conta...
Can someone help me with a way to create a button on an Access form that checks the display size of an image on the form?
Hi all,
The following question shouldn't be so hard. I want to automaticly print the webpage that i requested with the code below and then close it again.Tthe file loaded in the webpage can...
Can anyone help me to write three functions in vba access in order to extract the name like the examples below into last name, first name and MI?
the format of the name is "First Name", "MI...
I have created a database for tracking medical visits to a first aid center on a project site. The database has a few tables that are linked to make the database more user friendly because it...
I have a spreadsheet which consists of a pivot table only. I want the data out of the pivot table, so I drill to details, delete the pivot table sheet entirely and save the book with just one ...
I would like to update some of my forms to have a more professional look. Currently, I have command buttons on the form to perform tasks like saving the record, printing the record and openin...
