Search results

try usingFor Each control In Forms![frmMain]![childHigh].controls Debug.Print control.Tag Next conrol

try a query like this by using two sub queries in which you do the restrictions. SELECT T0.YourSortedField FROM [SELECT TOP 10 T1.YourSortedField FROM [SELECT TOP 20 T2.YourSortedField FROM YourTable AS T2 ORDER BY T2.YourSortedField]. AS T1 ORDER BY...

you can find a method on Allen Bowne's Site Return to the same record next time form is opened

this should work, assuming your table name is DefectSELECT Code , Sum(Qty) AS SumOfQty FROM Defect GROUP BY Code ORDER BY Code

In the Tools menu under Macro you can find an item called Convert Macros to Visual Basic. In the property tab of your button select the Event register and scroll down to the On Click event. Make sure the the contents is [Event Procedure]. Then click on the right side of the item on the ellipsis...

Hi George, try Forms![frmMain]![childHigh].Form.Controls from frmMain you can shortly write Me![childHigh].Form.Controls

Possibly that is what you want.

once the table exists use an update query instead of the maketable query.

here is a query which might give you a clue on how to use aggregate functions. I you only want the summary you can take out on of the subqueries.SELECT G.YR , G.Genre , (SELECT Count(*) FROM tblGenre WHERE Genre=G.Genre) AS GCnt , (SELECT Count(*) FROM tblGenre WHERE...

Use the Nz function on the fields which may contain Null values. i.e. ...+Nz(vv)+Nz(dv)+...

Hi, i assume Fornatian's first suggest (+-0.5). Maybe you have to correct these rows inside the query. It gave me 6819 tuples as result. I leave empty fields inside, which can by changed with the Format property inside the query. It seems to be not so bad having the data inside a table for...

put this code i.e. behind a Click Event of a button and adjust the names.DoCmd.OpenReport "YourReport", acViewPreview, , "[YourItemFieldInReport]='" & Me.YourDropDown & "'"If your filter depends on a numerical value remove the single quotes.

I think you need a third table with at least two fields as foreign keys refering to the previous described tables. With this constellation it is possible that one wish can be expressed by more than one client without having redundant data. It is a matter of taste how to implement this Structure...

here is an other suggestion.If Not IsNull(DLookup("User", "USER_LOG", "User='" & Me!YourDropDown & "'")) Then Beep MsgBox Me!YourDropDown & " is already connected.", vbOKOnly, "Login Fault!" Else dbs.Execute ... End If

the date should be formatted either as Format(Me!txtDate,"\#mm\/dd\/yyyy\#") or Format(Me!txtDate,"\#yyyy\-mm\-dd\#"). Another workaround is converting it to a double size number. I.e.: DoCmd.ApplyFilter , "CDbl(dteDate)=" & CDbl(Me!txtDate)

dbs.Execute does not return any value. What you can do is using the option dbSeeChanges with dbs.Execute which will raise an error if another user tries changing the data you're just writing.

I think that is what you're looking forSELECT C.Office , C.CallDate , C.StartTime , C.FinishTime , (SELECT Count(*) FROM tblCalls WHERE Office=C.Office AND StartTime BETWEEN C.StartTime AND C.FinishTime)-1 AS CntOfOtherCalls FROM tblCalls AS C

As you can see, there is a select query sitting inside the main query. Normally you would expect there (in the FROM clause) a table or query name. For addressing the fields given back as results of the subquery you need an alias name. I kept it short and used the arbitrary name Q. Though if you...

put all calculation formulars together into your desired field. Discount Rate: [Weekly Rate]-[Weekly Rate]*0.15

Well it takes a while, but I think I got itSELECT AC.AgeCause , Count(Q.Cause) AS CountOfCause FROM Age_Cause AS AC LEFT JOIN (SELECT AR.Cause , AR.ReviewDate FROM AgeReview AS AR WHERE AR.ReviewDate=[Enter Review Date]) AS Q ON AC.AgeCause = Q.Cause GROUP BY...