|
PUtting an Access database in the References list
I've manually added an Access database to my References collection.
I've got a file called "books1.mdb". I selected it using the Browse button
on the Refernces dialog box.
I now have "books1" in my list of Refernces, and I've checked it.
The location is "C:\MyDocs\SML\Data"
So, now how do I reference it, so I can get to the collection of modules in
it?
I've tried various combinatio...
|
7 |
11/13/2008 3:39:16 AM |
|
|
Update query using Count
Using Access 2003 (11.8204.8221) SP3 in XP Pro
I have a table in which I want to capture summary counts from another table.
I can write a select query and use the count function and get the results I
want. In order to write those results to my summary table, though, I need an
Update query, which does not have the Count function available.
SQL of Select query which provides the result...
|
5 |
11/13/2008 1:13:58 AM |
|
|
DAO "edit" method for a recordset is no longer found
I just converted an Access 2003 app to Access 2007 format. Now when I try to
compile the VBA code, the compiler croaks on the DAO recordset "edit" method.
This code worked fine under Access 2003. All my same references are in
place.
Any help will be much appreciated....
|
4 |
11/13/2008 12:57:07 AM |
|
|
How to use DLOOKUP with the Like * Functions
I have a form with a command button, when chosen goes to vba code. Within
this code I have a InputBox asking the user for a Employee name with a string
variable named 'SearchString'. I want to take that expression and 'Dlookup'
to a table, with the LIKE function, where the 'SearchString' does not have to
be the full text of the fieldname 'Employee'
I get a syntax error while writing ...
|
3 |
11/13/2008 12:53:01 AM |
|
|
Why aren't there Application Events for Access?
Can someone explain to my why MS hasn't add Events for the Application object
(Startup, Exit, etc.) just like the other Office apps? How many times have we
seen a poster asking about running code at Startup or when the Application
shuts down?...
|
4 |
11/13/2008 12:00:01 AM |
|
|
Creating and running a module to Refresh data in subforms
Hello -
I have a main form with a series of tabs in a tab control.
The data I am managing is for a manufacturing work flow, so most of the data
is in one table which has many fields.
I have organized the view of the data in the tab controls, using sub forms
in each tab.
Some of the fields in a sub form are based on values or calculations against
fields on another sub form. Most...
|
6 |
11/12/2008 10:47:27 PM |
|
|
"you entered an expression that has an invalid reference..."
Soooo, I just deployed a update to our fe. After doing so, I've made a few
changes for the next update.
In doing so, I've gained a new error, that seems to be coming from nowhere.
The changes I've made are to other forms, not the on that now has an error.
When I try to open the form in question, I get the following error:
"You entered an expression that has an invalid reference to the...
|
2 |
11/12/2008 9:36:12 PM |
|
|
Print only one page
Hi everybody!
What code to I have to write when I want to print a page from my report
without the print dialog box to come up?
Let’s say I only want page 2 to 2 should print I want to make a button and
when that button is pressed ONLY page 2 of 2 will print
...
|
2 |
11/12/2008 8:53:55 PM |
|
|
On Close event error
Hi,
I am having a problem with some code I wrote for a form. This seems to
be a 2 part problem.
The first part is that when the form it runs a query to populate the fields
on the form. If there are no records meeting the criteria the form doesn't
populate and you just see the grey background. This in itself is not a
problem as there are situations when there are going to be no ...
|
3 |
11/12/2008 8:26:04 PM |
|
|
ODBC - code
Hi:
I am getting some info from an Oracle db, through ODBC; so, when the user
clicks a button the ODBC comes up with ODBCname, user, passowrd. The user ID
and psw are the same for every user.
Can you please tell me how can I do this within a code; for example when the
db opens?/to connect and refresh automatically?
Thanks,
Dan
...
|
3 |
11/12/2008 7:58:01 PM |
|
|
Programming Pivot Tables in Access 2007
I've created several solutions in Access XP/2003 where I created a
programatically configurable Pivot Table on a form. This code does not
appear to work (natively) in Access 2007. Based on research I have done, the
Office Web Components library was retired with Office 2007.
I understand that I can still obtain the old OWC dll and add it to my
references list to re-gain this functio...
|
1 |
11/12/2008 7:53:01 PM |
|
|
Refresh the data in dropdown combo box
First some back ground about what I’m doing:
Using Access 2002, I have a form1 that looks at records in one table.
Form1 has a dropdown combo box that “Finds a record on my form based on the
value I selected in my combo box†.
The text boxes on form1 are all “Locked†= Yes, so the record can’t be
changed.
The dropdown combo box is not locked, so it allows me to select from the ...
|
8 |
11/12/2008 6:45:30 PM |
|
|
Getting Excel Range Data and Saving as a String
Hello,
I have a spreadsheet embedded on a form (works great) but I am trying to
find out if it is possible to save the contents of a range inside the Excel
container to a string so I can save it to a memo field in my database.
When I use the code below it just seems to be a single blank string...
[CODE]
Dim entireReceiptText As String
xlsReceiptContainer.ActiveWorkbook.Worksheets("...
|
2 |
11/12/2008 6:21:01 PM |
|
|
Get deleted primary keys
Hi,
Is it possible to do the following:
1) I have a members table. It has member ID column as primary keys. It has
1000 members. Some members has been deleted, so our table has some slots in
the member ID sequence. I would like to create a report containing the
deleted members ID (the ones that do not exist anymore).
Had tried it using querys, macros and VBA, but dosen´t had succe...
|
7 |
11/12/2008 5:07:02 PM |
|
|
Data Type Mismatch - String versus Long
Hello,
I am trying to build a WHERE clause with numeric criteria and storing it as
string criteria, but I am getting the Data Type Mismatch error when I open
the DAO recordset. I have two list boxes on the form: a left list box and a
right list box with 'Move One' and 'Move All' command buttons between them.
The code for the 'Move All' command button is (assuming there are two list
it...
|
4 |
11/12/2008 3:34:15 PM |
|
|
Status meter not moving until sub ends
Hi,
I've installed (via VBA) a status meter. The meter appears at the beginning
of the execution but does not increment until either I break the code or the
end of execution. Using Access 2003.
Code sample:
SysCmd acSysCmdInitMeter, "Processing", 5000
lngCount = 0
Do While tblname.EOF=False
....process stuff...
lngCount = lngCount + 1
SysCmd acSysCmdUpdateMeter, lngCoun...
|
8 |
11/12/2008 1:59:51 PM |
|
|
pulling information from access
Hi. Thanks in advance for your help.
Say I have a table with fields called 'CO#' 'PAYDATE' 'PAYMENT#' 'AMOUNT'.
The 'PAYMENT#' field is the payment number, is very important, and it typed
in not autonumber (on purpose).
So for each 'CO#' (each company) there are many payments, each numbered and
dated.
I want to pull a report for any company ('CO#') that has less than 26
p...
|
8 |
11/12/2008 1:09:44 PM |
|
|
PLease HElp - Date and TIme syntax in Query
Sorry but I dont understand what I am Missing here and have been searching
for the last 2 days
I have a simple query to create a record set.
SELECT tbl_Daily.* FROM tbl_Daily WHERE (((tbl_Daily.DateTime)=#11/8/2008
2:13:0#))
This syntax works fine and returns me 2 rows as expected
however when I try to use this from within a Form and substitute the date
for a value displayed wi...
|
3 |
11/12/2008 10:24:02 AM |
|
|
How to obtain Share name.
I use the Printer object to determine the Printer Name (DeviceName property)
but how to I get its share name?
--
Regards
Tom...
|
1 |
11/12/2008 2:36:07 AM |
|
|
Convert Excel vba to Access
Background: I have to evaluate over 500 stocks on a monthly basis to
determine the market-to-cost adjustment. Part of the process is to compare
the current market price to the previous six month high.
The following 2 subs go to Yahoo Finance and pulls 6 pieces of information:
symbol, date, open, high, low, close based on the date range I enter.
However, it is limited by the 256 colum...
|
4 |
11/12/2008 1:49:01 AM |
|
|
Assistance required with query
Hi,
I'd like to combine the two queries below into one (just to eliminate the
number of queries I have).
The query 'Qry_Group_Vendor_Name' consists of:
SELECT tbl_Comm_Data.VENDOR_NAME AS Vendor, tbl_Comm_Data.DEPT_NO AS Dept
FROM tbl_Comm_Data GROUP BY tbl_Comm_Data.VENDOR_NAME, tbl_Comm_Data.DEPT_NO;
It produces a list of unique) vendor names by department.
I then want to produc...
|
2 |
11/12/2008 12:03:24 AM |
|
|
Module Data Storage
I'm trying to create a multiselect listbox and be able to store what data is
selected. I'm using the example almost directly from the Help file:
Sub AllSelectedData()
Dim frm As Form, ctl As Control
Dim varItm As Variant, intI As Integer
Set frm = Forms!Form1
Set ctl = frm!lstProd
For Each varItm In ctl.ItemsSelected
For intI = 0 To ctl.ColumnCount - 1
...
|
3 |
11/11/2008 8:26:43 PM |
|
|
Emails
Hi,
I use the code that from Daniel Pineault's answer for another user since I
think that it fit to my case.
Application.FollowHyperlink "mailto://" & Me.EmailControlName.
Where EmailControlName is the name of the control on my form that contains a
valid e-mail address to use as the TO: field in the e-mail message.
It works fine with one address like Loitran@yahoo.com. Would you pl...
|
6 |
11/11/2008 7:25:03 PM |
|
|
Run code on application close
How can I run code when my Access application close.
I don't think there is an AutoClose macro in access.
Thanks for any help with this.
...
|
2 |
11/11/2008 7:14:22 PM |
|
|
Refreshing subforms in tab control
Hello -
I have a main form with a 7 tabs in a tab control.
The data I am managing is for a manufacturing work flow, so most of the data
is in one table with many fields as the work flow is linear.
I have organized the view of the data in the tab controls, using sub forms
in each tab
eg
Job details
Quote Prep
Quote Summary
Quote
PO
Requisition
etc
Some of the fields in a ...
|
6 |
11/11/2008 6:59:06 PM |