Search results

Very General Question What version of Access do you use? And if you use Access 97, why do you choose to use that over that of Access 2000 or higher? I am curious to find out the reasons. As for me, I use Access 2003 all around.

Two points: 1. Defendant = FirstName & " " & MiddleName & " " & LastName If the record does not include a middle name, then the phrase will include an extra space between the first and the last names. Better would be: . Defendant = FirstName & " " & MiddleName & _ Iif (Len(MiddleName...

Perhaps: VariableName: ([Table1].[Field2]/[Table2].[Field2])

OK, sorry for the additional information. I didn't see that the problem of flickering was taken care of. I won't belabor the thread any longer, but I have tried different methods repainting, even going through a couple of API methods I had used in the past for similiar purposes. I still have...

From FreeTranslation.com: "I have have a simple WEB side in Access generated z. B SEITE1 there I a Dropdownlist where the values come of a table. The choice of the user should deliver condition into a SQL as a parameter, and the result of the SQL should written into a text field. I am create...

The solution to the flickering problem has little or nothing to do with the method of record count extraction. I have similar flickering problems with unattached labels and images on my tab pages themself. I am guessing you have Windows XP and Access 2002 or 2003, as the problem seems to be...

A date value is actually a double integer, formatted for date and time display. 12:00:00 is equivalent to zero. Using the Iif statement is common in such circumstances.

If you get a syntax error, you should be able to identify the place the error is happening. Try this: 1. In SQL view, try to open the query. 2. When the error occurs, click "OK" 3. Look at the query closely. Do you see anyplace on the query that is highlighted? Without reconstructing all...

I never use the Integer or Single values anymore. Not worth the hassle.

If the problem gets too hairy, and your company think it's worth it financially, you might go to this link. Database Repair This is the sponsor of the help forums, by the way.

SELECT qryTwo.fldEntityID FROM tblDetail INNER JOIN [SELECT tblEntityDetail.fldEntityID, tblEntityDetail.fldDetailID, tblEntityDetail.fldValue, tblEntityDetail.fldDate FROM tblEntityDetail INNER JOIN [SELECT tblEntityDetail.fldEntityID, tblEntityDetail.fldDetailID, Max(tblEntityDetail.fldDate)...

You have to use the same conditional formatting for each control you want formatted. You have to do each control separately. Just use the same expression in each control. By the way, you used the term "over a month old", not "over 30 days old" in your original request, that is why I used the...

I Got It! OK, I think you wanted a query to return a recordset of all records FROM Table1 that are NOT IN Table2, IF there are no ducuments currently in Table2 which contain document numbers starting with "15" or "17". Sorry, I had to read a litte more into it. Here is the query: . SELECT...

On the subform CONTROL on the main form, put your code in the On Enter event. Remove the code from the text box on the actual subform itself.

I would number the records on the underlying query (call the field RunCount), then refer to RunCount on the form. If you need to see a sample, check out the tutorial I wrote for subforms here.

Try using the Iif statement to determine the records to return. I rarely use the between statement myself, but I think you are getting a null value problem.

I don't fully understand. From what I see of the resulting recordset, you are returning all records from table 1 that is not present in Table 2. That much I got. Here is my query for that: SELECT Table1.DocID FROM Table1 WHERE (((Table1.DocID) Not In (SELECT DocID FROM Table2))); What I...

I'm sorry, I was away for a couple of months. I see you solved the issue with the subroutine and function difference. But I would not alter the function itself if I were you. Just loop through the array that is returned from the function to process your dates.

Using DLookup is not correct in this situation. It is only used to find a single record in a recordset without creating a recordset object. However, you will have to create an object to retrieve multiple records. Basically, your sequence will be: 1. Declare recordset object. 2. Set the...

In reading through andrewf10's post, I gathered that all he was looking for was the date of the following Monday (or Start Date) from a given Date (or Previous Date), if it wasn't already Monday. The interval variable was the number of days andrewf10 originally used in his attempt at the...