Recent content by TheFoxy

Hey, I'm making a small DB for storing book details. I have one table, books, and I've made a simple form to lookup books and edit their records. The idea is to enter criteria in the row of text boxes at the top, and have the subform bring up any records that match. The form is unbound, with...

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"...

Hey, I've got 3 tables, and a form for entering new records to table 1. I want to take the number entered for one of the fields on that form away from the number stored in a specific record in table 2. The three tables are linked (1 to 3 by an ID number, and 3 to 2 by a keyfield) so there will...

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.