Linking Sub-Forms
Fri, 12 Dec 2008 06:01:01 -0800
Currently I have a form and subform and they are linked and everything works
fine. What I would like to do is click a button that would change the Master
Field.
IE; Master Field, Key;Process1
Child Field, Key,Process
I would like to click a button that changes the Master Field to , Key;Process2
Anyone h ...
|
automating updates to an ole field from the contents of a Win fold
Fri, 12 Dec 2008 05:59:00 -0800
Our single-table database tracks student information. The table data updates
and appends via a macro (transfer text and a series of queries.) Pretty
simple so far...
My site head is asking for a new field that would contain a photo of each
student. He wants our guidance people to be able to save photos as j ...
|
Split a field into many
Fri, 12 Dec 2008 02:59:01 -0800
When I receive student testing data in CVS format, there is one field with
all of the student answers. For example, ABACCCDACADBBBAC.
How can I split that one field into one field per answer? ...
|
email pdf report Access 2003
Thu, 11 Dec 2008 18:34:11 -0800
Hi,
I have a pdf report that I create in Access 2003 and then use Outlook 2003
to email it. I would like to automate this. I'm not sure how to approach
this.
Thank you.
jbc ...
|
Use Conditional Formatting to Hide Error?
Thu, 11 Dec 2008 13:17:03 -0800
I have a field on a report that returns all the correct calculations, except
for two entrys. That entry will never return a real answer because it is 0/0
& the other is 0/7. I would like to use conditional formatting to shade the
cells so you do not see these errors on the Report. Can anyone help me do
th ...
|
Keep Word from updating on the screen while Access is in control
Thu, 11 Dec 2008 12:35:02 -0800
I am building a Word document from several Word documents (copy and paste),
then updating the created Word document with variable information from the
Access database. All this is being done from Access VBA. The problem I'm
having is that on my client's computer (OS is XP, Office is 2007) I have not
been a ...
|
Attachments with email from lotus
Thu, 11 Dec 2008 12:20:08 -0800
I am trying to send a report through Lotus Notes. Can I send it in
snp format or does it have to be pdf? I am using the following code but I
don't know how to reference an Access report? Do I have to export it first
and then send the email through the db? I know by EMBED code is wrong. I've
been trying t ...
|
|
|
Prevent screen updating during resize event
Thu, 11 Dec 2008 11:57:01 -0800
I resize a lot of controls in the form's resize event. Problem is the screen
flashes madly as the code runs and controls are resized. Is there a way to
turn off screen updating while the procedure runs? ...
|
Read an FTP Log File
Thu, 11 Dec 2008 19:53:43 GMT
I need to see if I can have Access open an FTP.log file as read only and then
pull in the data and parse it out into different fields. I have a couple of
problems.
I can't really write VBA code. (I can usually manipulate someone else's code,
though.)
The file is an appending file. Meaning, for every new ...
|
If prices equal then choose always choose Vendor A
Thu, 11 Dec 2008 09:00:01 -0800
For the same PID when two different VIDs have the same price, select VID A.
For example, for PID=1 both VID A and B have same price of $9.88 so would use
the record with VID=A. Same would apply for PID=8.
Before:
PID VID Price
1 A $9.88
1 B $9.88
2 B $7.87
3 A $2.79
4 A $4.89
5 A $ ...
|
