Search results

Not the most elegant, but you could nest IIF statements... like... Assuming table 'tblDates' and 3 date fields, 'Date1', 'Date2', and 'Date3'. Query could be: SELECT tblDates.Date1 AS D1 , tblDates.Date2 AS D2 , tblDates.Date3 AS D3 , IIf([D1]>[D2] And [D2]>[D3],[D1],IIf([D2]>[D3] And...

Any help here? http://www.dbforums.com/t1072368.html :confused:

If you will always have an empty table that you import to, this function will work. If not, you will need to modify it to account for the records already in the table. Function ImportData() On Error GoTo ImportData_Err Dim db As DAO.Database Dim rst As DAO.Recordset Dim intCount As Integer...

Just a shot in the dark.... try If IsNull(Attachment.LpOleObject) Then

How can you hide a table? Right-click the table in the database window, click properties, and check the 'Hidden' box. Table will be hidden. To show again, click on Tools, Options, View, and click the Hidden Object check box. :p :p :p

Do you execute this code before you actually save the record? If so, try moving the code to follow the code that actually saves the record. Just a thought.

I'm not sure that your pseudo-code matches your description. You want anyone in the steward field, and if that steward is a contact, then it cannot be null? If so, Try this: SELECT tblMembers.Steward , tblMembers.Activist FROM tblMembers WHERE (((tblMembers.Steward)="Steward")) OR...

A simple update query should work fine. Just update the date field with today's date using the same criteria that you used in the first query. By the way, I assume that each time you run your e-mail query, you have fresh data in your table. If not, wouldn't you be sending old data along with...

Like this? SELECT tblFields.Fld1 , tblFields.Fld2 , tblFields.Row , tblFields.Fld3 FROM tblFields WHERE (((tblFields.Fld1) In (SELECT [Fld1] FROM [tblFields] As Tmp GROUP BY [Fld1],[Fld2] HAVING Count(*)>1 And [Fld2] = [tblFields].[Fld2]))) ORDER BY tblFields.Fld1...

Glad it's working for you... good luck!

This seems to work for me. [caution - not thoroughly tested] Query: SELECT Table1.Team , Table1.[Team Number] , Rand([Team Number]) AS Expr1 FROM Table1; Function: Function Rand(intInput) As Integer Randomize Rand = Int((99 * Rnd) + 1) End Function HTH :D

Open the main form with a filter or OpenArgs, and the sub-form will be linked [presumably] to the first record related to the record in your main form. HTH :)

You do not normally insert files into Access forms.. rather into tables. Something like: INSERT INTO tblValuesNew ( [Value] ) SELECT tblValues.Value FROM tblValues; HTH :)

SetWarnings Action see help file

I agree that you should compact and repair, but I do not believe that the files themselves will shrink appreciably. I am not aware of any advantage to store them within the database.

Yes. No. No problems, really, but I found that it really depends on how many developers will have access to your project. If it is just you, and you do not need to document your version history, then really no need for it, just keep regular backups per standard procedures [offisite, etc.] :D

I suggest that you do not put them in there to begin with, that way no size issue. Standard db design suggests that you store the images outside of the db and only store the path to the file. Here is one way: http://www.jamiessoftware.tk/articles/handlingimages.html Also, check the MS site...

The paramenter for tblDeed_CorrectionNo: CorrectionNo in your query is 0. The report doesn't like that. :o

Here is my simple table [tblValues]. Value Dave Pete, Ron, Sam John, Ralph, Susan, Robin My query: SELECT GetPart([Value],",",1) AS Expr1 FROM tblValues; Results in an error message #5 'Invalid procedure call or argument.' [this comes up twice in processing this query] Resulting data 3...

Thank you, I will look at that to see if it will help, but I should have made clear that we will not always be assured that the delimiter will be a comma.