Search results

This wont create the relationships between the tables, but you can export all the tables themselves using this method: DoCmd.TransferDatabase acExport, "Microsoft Access", _ "C:\DataBaseToExportTo.mdb", _ acTable, _ "SourceTableName", _ "DestinationTableName" So use this code...

You want to reference the subform from the contols name on the main form, and NOT what the subform is actually called. Basically what this means is that on your main form you should have a subform control. Use that subform control's name to reference the subform. So heres what you want: SELECT...

Hmm, dont know any any real good books that you can use to learn. I was sorta chucked into the deep end when I started my job. My boss just said 'do this' and so I learnt access. Talk about a crash course. :rolleyes: Check here first: Recommended Reading Thread and also here: Recommended...

Check that you have the reference for the data objects in your project. Do this by going into the VB code, then go Tools -> References Then check that Microsoft DAO 3.6 Object Library is selected. If it isnt, scroll down the list and find it. That should fix the problem. And to learn VB search...

If your also curious, you can use the ordinary click event as well, as long as you do this little bit of code: private sub mytree_click() dim oTree as treeview, mNode as node set otree = me!mytree.object set mNode = otree.selectedItem() 'now mNode is the node I can use...

Inside the combo box is an event called On NotInList. You'll need to write some VB code here to get what you want to work. Try what I write below, that should help you. Note that the LimitToList property must be set to true for the above event to occur. (Also note that if limittolist is true...

In the control properties there are 2 fields, Enabled and Locked. Setting Locked = true is enough so that the user cant edit any data in that field. Setting Enabled = false means that the user cannot set the focus into that box. Set locked = true and enabled = false will give you the...

Heres one way to do this: All you have to do is place an afterupdate event in the first box where the code reads as follows: (Note that I refer to 'fieldin' as the field where you type the number, and 'fieldout' as the <IMG SRC="%%URLofImages%%/8659.jpg" BORDER=0> textbox) Dim NumberToAdd As...

The approached you use it one of the simplest and probably one of the best. Unless you have very specific needs using one query/sub form with 2 sub forms is fine. Jason

Just a quick notification to you guys that I posted a sample database that uses an ActiveX treeview control in the Sample Databases section. I noticed a few people want to use treeview controls, but documentation is quite thin unless you search real hard. Hopefully this will help you guys a...

Just a quick question to see if any of you code gurus out there can solve this problem. The code Ive written simply opens up a recordset from a parameter query, but unfortunatly the code chucks a Data type conversion error whenever I run it. The code is listed below: Dim rstA As Recordset Dim...

Just a quick problem that I discovered with some Access 2000 vb code Im trying to write. The situation is thus: A form lists models with their respective parts in a subform. The subform is to be filtered using some command buttons (easily done). I noticed however through testing that the filters...

I followed the linked article, and it was perfect for my problem. My form now works great again! Thanks for the help. Ta Jason

Really weird #Delete error As of late my large database that I have written has started to recieve errors. Before last week though, it worked nicely, and its only been in the last couple of days when everythings begun to go banana shaped. A quick bit of info; the Database is split to front/back...

Thanks for the reply. Ill go and give tham a shot. Ta Jason

Just 2 quick questions. Firstly: I have been asked by my employer to make the default value of a text box on a new record the value from a previous record. In this case, I use continuous forms as the display, and the records record an employee's leave. So the form runs like this; on the left is...

I managed to fix the error. For those wondering, it was simply caused by a invalid field name (TextStockRemaining). This was caused by a wrong version of the report being imported from another database. Strange that it said '|' as invalid as opposed to 'TextStockRemaining'. Ah well...

Okay, this ranks pretty high on my strange'o'meter. Firstly, the report in question simply prints out a report listing all outstanding orders (with their duedate and misc. details. The report used to work fine, then recently, every time I open the form it chucks an error. Run Time Error '2465'...

Thanks for the quick reply Mile-O-Phile. I read the thread you posted and unfortunately, my Backend is already Access97. However, I just tried something else that sped up the speed considerably. I have an attendance record that is calculated on the fly from a subform and displayed on the front...

I was wondering if anyone else had a large performance drop in their databases when upgrading from Access 97 to 2000. The problem with mine is that I have a lot of code and stuff running in a particular form (it gathers an employee's details) and because there was quite a bit of information to...