I have a table that contains 12 fields in the format of playerXXCode (where XX is a value from 1 to 12).
I want to loop through a recordset and populate a temporary table with the player codes. (Transpose the data)
The problem is I want to do it like this:
Note:
rsOld = Original Table
rsNew =...
I have an Access 97 MDE database that I have distributed with the runtime files using ODE. My application works on most computers with the exception of 4. I seem to be getting an error when I'm using one particular table in a CreateQueryDef recordset.
The funny thing is that the date (which...
I've just built an Athlon 1000mhz system on a jetway 663ASPro Mobo. Everything worked on first boot,went through POST screen and tried booting from Hard Disk. Because the H/D hadn't been prepared the system halted - I turned it off. When I eventually found a boot disk, I started the PC again...
I have an AMD Duron 600Mhz computer with a gigabyte GA-7iXE4 motherboard, 64 MB SDram PC100 Dimm, CD Rom, Harddrive. My problem is my computer refuses to turn on sometimes. It seems to work, keyboard lights, CD Rom lights and then nothing. The reset button works but it does'nt set the...
When a database is opened for the first time I want to be able to write a new global constant variable to a module. If after a time no one uses the database I want to remove this variable. I want the whole process to be VBA and linked to a startup form.<br>
<br>
Is this possile?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.