Search results for query: *

...and calls Me.subform.requery to re-run the query. Dim db As DAO.database Dim querymod As DAO.QueryDef Dim strSQL As String strSQL = "SELECT * FROM book WHERE " Set db = CurrentDb Set querymod = db.QueryDefs("qry_searchform_1") If Me.author <> "" Then strSQL = (strSQL & "book.author_id="...

No, and it doesn't seem like a good idea to me. I want the details of the Order items to show in the subform, which would need recordset code otherwise, and it would obviosuly require a whole load of coding to replicate the functions of the form when they are bound. The only option I can think...

That would work nicely for a plain form, but the problem is that the subform is where I need to do the calculation. I would want to calculate when the main form moves to the next page. But there is no way, as far as I can see, to communicate between the main form and subform. (I would need to...

I added in the reference, and used the dao prefix, and it worked. Thanks! :)

Do you have a Table or Query in your database named querytext?" Lol, no, that is a placeholder for the SQL I was using. :P "Do you have a variable in your project that is using a keyword? Such as: Dim database As String?" No. Thanks VBSlammer and RoyVidar, I'll try doing what you say. I'm...

I cannot understand what the problem with the following code is. It's from a function in a code module (Access 2000): Dim DB as Database Set DB = CurrentDB Dim TheRecords as Recordset 'No problems here I get "ERROR: User-defined type not defined" on the first line. EH?!? It doesn't appear...

Hey, I have a form Orders with a subform OrderItems. The Orders form is linked to the OrderItems subform by OrderID. The Orders form corresponds to an Orders table, and OrderItems form to an OrderItems table. (one to many join on OrderID). Each OrderItems record represents one item that can be...

The ASUS site is horrible, so I couldn't locate any updates. I did try disbaling boot virus protection in the BIOS yesterday. After this I could boot from a floppy! However, I just turned the computer on today to begin work and it now DOESN'T work again! >:(

Thanks for the help so far! :) Right, after some fiddling I've swapped the computer's floppy drive for an old LS-120 drive that was sitting in another one. This drive connects to the ATA interface, and shows up as 'LS-120' but it will also read/write to normal floppy disks and so masquerades as...

There is a version of DOS on the hard drive as it currently has Win98 installed on it.

While trying to boot DOS from a Win98 boot floppy disk, I encountered an annoying problem. After the BIOS checks the hardware and list IRQs it detects the floppy disk as it should, and there is a bit of activity from the floppy drive. It then stops and I get left with an unresponsive command...

Thanks, it works now! :D Never knew I had to use single quotes around text for criteria.

I've tried DLookup, but I get the following error: "Syntax error (missing operator) in query expression 'Serial = XCV5G' I don't know why I'm getting this error, since the DLookup above this worked perfectly. (NumberOf is an int, TheSerial is a string). NumberOf = DLookup("Num", "Items"...

...sure it's more than or equal to the number, and giving an error if it isn't) and I can alter the field with DoCmd.RunSQL, so I just need to: *Grab the Keyfield from table 3 by looking up the ID field from the form; *Grab the number field from the record in table 2 which has the same keyfield...

The top query is SubQuery 1, the one below it SubQuery2, the one below that SubQuery3, and the last one is the final query with all the required data in it.

...of the one before it and adds information from another table, so I end up with all the information I need in the last query. SELECT Services.* FROM Services WHERE (((Services.ServiceID)=[Please enter Service ID])); SELECT [SubQuery1].*, Items.* FROM [SubQuery1] INNER JOIN Items ON...

lol, that use of 'FROM' is something that I have not seen before. Could you give me an explanation so that I can set up this query?

Hey, I currently have a query with several sub-queries that each add data from a different table to the sub-query before them, to build up information from several tables in one query. I've had to do this because using more than 2 tables in a query gives me an 'ambiguous outer join' error. Is...

Your method works JonFer, thanks! :D

Ummm... how would I go about doing that? lol (I'm not a frequent Access user) :P