I have a form that displays a photo for each student. This is done through
storing the path of the photo in a table and displaying the photo when on
current (ie)
me.imgName.picture=me.imgpath

In MS Access,
currentdb.execute "insert into [table1] ([Name],[ID],[Img]) values
('Amy',23,'C:\testscore.pdf')"
it cannot insert the file (ole object).

Hi gurus
I am using vb code to create a table and add fields. I need to set the
DecimalPlaces property of a field to a value. I cannot see how to do this as
it is not a "standard" attribute of the field object eg like

Is there a way to import into a table Scheduled Task Information like the
Schedule, Next Run Time, and Last Run Time from Scheduled Tasks?  Any
information is greatly appreciated!  Thanks.

I have a specific page that I want to go to within my website that I want to
activate from an Access commandbar, menubar. The below works just fine.
Dim ie As InternetExplorer
Set ie = New InternetExplorer

I have mdb file which i would like to enter to source safe.
On some of the forms and reports there are an arabic characters.
These characters are declered on my computer and not on the server where i
place the source safe.

Been a tough week for bugs. This code looks good but fails. Any insights
would be appreciated
Dim strQuote As String
Dim str As String

I have an error flag that I want to use on a form.
I want to set flag on through error checks done on different events
I am then checking for this flag when the form is closed, but it doesn't
reconize the value on set while in an event.

Hola a todos y gracias por vuestras respuestas
Tengo un formulario llamado Totales Diarios donde tengo un campo fecha, y un
subformulario donde calculo los movimientos diarios de los albaranes
dependiendo de la fecha que se introduzca en ese campo.

I'm trying to clear check boxes when I finish printing a report... any ideas?

I am new here, I have learned a lot from this forum and my thanks to all
repliers with thaeir great suggestions.
But I have a question, using office 2003:
I am writing a vba module in Access to create a word document with values

I would appreciate some help to do the following:  create a record set,
filter the record set and then with the filtered results, update a table.  I
can start the process, but get stuck.  Here is my attempt:
Dim db as DAO.Database

Im trying to run a make-table query via docmd.runsql  within en event
procedure.  I get a compile error on the SQL statement with the word "SELECT"
highlited.  I copied the SQL statement directly from the query.  I suspect
this is the problem.

Hello group,
I have written a VBA code which works fine on my machine and also I
tried it on a 2nd machine. However, now I have emailed to a user in a
different country and when he opens it. Nothing comes up!

I am trying to run a SQL query and apply the recordset to an unbound textbox.
I am doing this primarily because I want to run multiple queries on one form.
So far I have this down:
Set conn = CurrentProject.Connection