Recent content by JimmyK

You need to set the query to only update that particular record in the database. Something like: UPDATE tbl_Prj_Details SET tbl_Prj_Details.Archive = Yes where yourfieldname = 'whatever'

Hi all, We have developed a database at work and the printing of the report is defaulted to duplex printing. If I create a new database with nothing in it and go to print properties of a new report, it is fine and only does printing on one side. We initially thought the problem was that the...

Can you paste what your queries are?

Have you tried adding .value after xlWsERD.Cells(4, "K") to see if that solves the problem? If not, try removing the rst!Fund, etc and put in text to see if it writes to it.

In your table structure for the table you are drawing the data from you would set the two fields you require as the composite Primary Key. The combination of the two fields will not allow duplicates. eg., the fields are named: edate, etime you could set it so the PK is a combination of edate &...

Either Hold down the left-shift button when opening your database or try and press "F11" when in the database hopefully one or the other works

What does the error say?

Something like this in the form_load function ... Dim rstRecords As DAO.RecordSet Set rstRecords = CurrentDb.OpenRecordset("select count(*) from ImageTable") If rstRecords.Fields(0) = 0 Then MsgBox "There are no records" Else MsgBox "There is at least one record" End If

use autonumber as the field type. but then again you didn't really give too much specifics so maybe that's not what you want

Can you paste what your query is so people can get an idea of what could possibly be wrong?

Without knowing too much more about what your database has, and how it's structured, try someting like this: SELECT tblMusic.artist, tblMusic.album FROM tblMusic GROUP BY tblMusic.artist, tblMusic.album; That query will group information by the artist and the album

What better source than the horse's mouth? http://msdn.microsoft.com/vbasic/ As that contains all the reference material about Visual Basic and what you can and can't do, with examples, it should help with any technical queries.

Hi, I have included a very short example of a database that allows you to do what you want. What it does is: allows you to set the directory & filename you want to use export data to specific cells save & close the spreadsheet What I have it do is run excel invisibly whilst it is entering...

It is possible to do something like you want. I have done something similar at my work to retrieve email addresses (in bounced email reports) in an email folder. I will take a look at my code on Tuesday when I get back to work and see if it can help you out.

When you say this, do you mean you want have something like: PRIMARYKEY, FIELD1, FIELD2, FIELD3, FIELD4 and now you want to add another field, FIELD5, between FIELD2 & FIELD3? Create queries and sort by whatever you want.