Search results

its a table and query list which is why it's particularly bothering - deleting the first item from the actual table!? - although it keeps the ID number the same. I cant find anything similar happening anywhere else on the internet!?

My list box is behaving very strangely... I am just learning about the multiple selection tool and found a snippet of coding on the Microsoft website that works a treat http://support.microsoft.com/kb/827423 I can't quite see how or why but when I even select an item on the list, close the...

I'm trying to create an interactive report where the user can position the address textfields using up, down, left, right buttons and text boxes. I have already hit the brick wall in finding that reports aren't really interactive however I did manage to manipulate the Top and Left properties...

I don't know where to begin or what to even call this method. Basically I know the wizard is quite good at finding similar records searching for duplicates but it doesn't give you many options afterwards except delete or ignore. i basically want a list table object to be populated with...

My client has just told me that he would prefer the database I am working on to be able to be accessible from the 2 different branches. At first I was going to create 2 completely separate databases with date fields so I knew which was new information so I could combine the databases for...

I have found 2 useful snippets of code: acCmdLinkedTableManager acCmdImportAttachAccess The first one actually runs the wizard to link tables. The second one runs the wizard to re-link tables. these are all very good, but there are 2 main issues. 1) It will run everytime the database is...

dim tbl as Dao.TableDef for each tbl in currentdb.tabledefs tbl.connect = ";database=" & \\Network\Main Files\Documents\database_be.aacdb tbl.refreshlink next tbl This is the code i have used. I understand how it works but it just throws the error as I mentioned before. And websites talking...

Thankyou, I think I'm onto something. I tried that tabledefs method and kept getting error #3219, saying the tbl.connect function is invalid?? Everywhere else on the internet has an extremely long winded play around with tbl.connect. What am I doing wrong??

right :S so which part of that is the name of the table?? and when would this vba be triggered??

Yes the computers will have runtime, not the full version of access. It is important the users cannot edit the database design. My issue is that none of the computers on the network have the full version of access for that reason, only my computer which is not part of the network (and where the...

I have created a databse system with a back end tables to make it network freindly. But it doesn't link the tables relative to the database but instead gives them a new pathway. This is troublesome if I want to put the system on a computer network without access, it wont link. Is there a way to...

I found the answer. The command "Application.ExportXML" has everything I need to do and customise my export. There are extra properties such as the path for the schema too. But running the code twice, but with the second one adding a date format to the end seems to do the trick. If course, I...

Look up database normalising for college level ICT. It tells you all about relationships. Access prefers 1:1 or 1:many for data to flow. For example 1 teacher can have many pupils, but 1 pupil can have many teachers (Many:Many relationship). So to normalise this you would create an...

Is there not a manual way to create an "export to XML" tool? at the moment I'm using the wizard, which is all very well but it's extremely limited. Things like customising the path to export the XML can't be done!? I am designing a system for a computer network with no access on it and it...

Basically, I need to amend data when I print a form the "date last printed" is updated. I cant figure out where to begin or imagine how its done as I'm used to amending data 1 record at a time, but printing address labels for example include 3,000+ records which all need to be changed to update...

I discovered its not only the first time, its every time, and the only way to solve it is to open it in design view and run VB in the background??

I have made and completed a small database tool and split it front end and back end to place it on the network. My issue is the programme first begins with errors, like asking me for ID numbers and stuff, but once you cancel, close the database down and reload it, it's fine, everything works...

Well at the moment, I am using the simple code: Private Sub XML_Click() DoCmd.RunSavedImportExport (Yelloows) End Sub It runs the saved export, and asks if I want to replace the existing XML file.

I have created a tool to export data into an xml file. This xml file is then loaded in flash for various tools. I was wandering if there was a way to automatically rename the xml (say tag on date and time to the end of the file name) before exporting the xml file - in one click of the button...

Autonumber is obviously used as a primary key in most cases, but I'm thinking of a future proof version of my application, I already have 6,000 fields and I'm told Autonumber only has room for 4 bytes of data... isn't that 9,999? What happens after 9,999? and also how high can it count? (i.e...