Search results

Well, it's been quite a while away from Access, but let's see if I can help. Question: why do you have to click a button first for the query params window to popup then supply the params? Why not put textboxes on the form where the params can be entered in directly? This way, code the button...

Well, with several nested sub queries, the whole thing is bound to run slow. Maybe u could create a sub that first creates a temp table, adds the relevant rows to it, then executes a simple select query to retrieve the data needed. HTH

Well I'm sure it's possible, for one. If u just want to know if there's any data at all in a given query u could maybe create a form with 15 textboxes. Connect each to a query with a Dlookup. For example, txtBox1 source =DLookup("Field1;"Query1"), txtBox2 source =DLookup("Field2;"Query2"), and...

Nothing beats experience! Thanks for the lesson DCrake!

The query should be first loaded into a control on a form before u can connect to its fields. So u can either create a form, with the query underlying it, then connect to a control on that form that retrieves the field in question, or u may put "Dlookup("Field1";"Query1") in text box 2. HTH

Well, u could try the following: add a button "btnReverse" to your form and put the following code behind it: Private Sub btnReverse_Click() Dim invertedNumber As String Dim bytCounter As Byte Dim leftDigits As String Dim allDigits As String leftDigits = "" bytCounter = 1 Do leftDigits =...

U mean pivot query? The Northwind sample DB has an example of a pivot query. Might help u get on the right track. HTH

Well I took a quick glance: 1. in the report query, replace tblOperatingTool.Description by tblMain.[Tools Input 1] 2. On the report change the source for Tools to Tools Input 1 3. Move the controls "Tools" and "Week Commencing" to the details section and delete their respective group...

How about doing an update query that updates the check mark field to True or "yes" and put a Not Null in the criteria line beneath the field that should have data in it. HTH

Try something like: UPDATE Table2 SET Table2.Contact_First_Name = DLookup("Contact_First_Name","Table1","Table1.Contact_Id=50") WHERE Table2.Contact_Id=5; HTH

How about adding a button on your form with this code behind it: Private Sub btnAdd_Click() Dim db As DAO.Database Dim rs As DAO.Recordset Set db = CurrentDb() Set rs = db.OpenRecordset("Dispute", DbOpenDynaset) rs.AddNew !Type = Me.Type !NAMC = Me.NAMC !PartNumber = Me.PartNumber...

U may try to set the expression to call the function (numbers to words) only after the report has loaded, for example in the Detail_Format Event: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me.NumberInWords = fNumbersToWords(Me.Total) End Sub HTH

Ok, do u already have a routine to automatically update your stock? In my DB's I normally do this by running a query on the total amount purchased of a given item, minus the total amount sold (or set apart) for that item. That way u're sure your stock is always up to date. What u sold, or set...

Does this actually work in DAO ?

Ok, so u want to put today's date in the notes field and "Schedule Changed, also in the notes field?

Well u could create an aggregate query with just personID and Requests and group by Count on Requests. Run a DMax query on Requests in this query. HTH

1. The Child/Master link between sub and main should be made thru FriendID, not MoivieID. 2. Remove tblBorrowers from the sub form's record source: it has nothing to do there. U should use tblLoans FriendID 3. To prevent re-lending, u could create an index in the loan table, combining...

Ok, I didn't mean any offence, just that you're problem needs to be explained a bit better in order to have someone try to help u. Regards,

Well, it actually looks more like old egyptian, as it is ;-)

Have u checked out Access Help on the subject?