Search results

Sorry I get what you are trying to do now (Duh) When you said VB I thought you were trying to connect to your database from VB. I take it you mean VBA. Look in the General forum for a 'Mailing List'post by Expublish. It might give you some help.

Mmm. I see what I can come up with. Perhaps Bukhix might have some ideas.... He's pretty cool with email. [This message has been edited by Nero (edited 04-17-2002).]

You need to use ADO method. In your references you need to tick the 'Active X Data Objects' library You can then use the ADODC control to access your database. You need to use some code like this on the Form Load event: Private Sub Form_Load() Dim rs As ADODB.Recordset Dim cn As...

What you need is a field to store the value in that you select from the combo box for the record. When you create the combo box the wizard prompts you to enter a location to store the value for the selected record. You need to point it to a holding field in your table on which the form was...

Runtime will let the user add records run queries etc(depending on the permissions that you set)but it won't let you make design changes ( I think!!) What I meant by just viewing is that the way I explained above lets you use your database but you would have to set everything up manually. If you...

If you want to just view your databases on a machine without Access installed. Browse the developer CD. ODETools\V9\AccessRT Double click on the setup exe. This will install the runtime files. You need to then make sure the shortcut to your database points to the runtime files to run. i.e...

Problem Solved. Thanks anyway.

Mitch, I have written the code below to try and solve my problem but it is not working.It is updating all the records in the table and not the ones specified by 'Holder'. I think need the If statement inside the loop but I keep getting errors when I do this. I would be very grateful for any...

Hi Mitch, Basically the first form is like an inventory that will amongst other things show the status for a selected tool. On the second form a user chooses a product from a combo box and on a subform displays all the tools required to make the product.What I am trying to do is if a user...

Hi, Does your software have the option of exporting this data as a .dbf file or is it just .txt only? If there is a way of changing the format to .dbf then I have some code I will share with you that wull solve your problem.

Hi, I have a form in which a user will enter data for a tool and the product that the tool will produce. On another form I have a combo box which contols a subform so that when the user chooses a product from the list the sub from shows all the tools required for the process(a bit like a...

Jack, Thanks for your reply I will give it a go.

Hi, This problem seems simple but I cannot get my head around it. I have created my own auto number routine which works fine(the reason I did this is because I was fed up of not being able to reset the inbuilt autonumber when you delete a record).When a new record is created I want to be able to...

Thanks for your help Pat. Problem solved!!

Thanks Pat, That has done it. The only problem I have now is that these 4 tables are deleted once the query has run.The next day 4 more tables are imported and the process continues.Once the tables have been deleted the relationship cuts. Is there a way of automatically restablishing the...

Hi, I posted a topic a few days ago but I didn't explain it very well. The problem is that I have a query based on 4 tables. Each table has 14 records. When the query is run I would expect it to show the data I need in 14 records in the query.Instead it is showing 38016 records in the query. Can...

Hi, I am currently working an a database that was originally developed by someone else. It is a bit of a complicated process but I'll explain the best I can. Data is exported to an export folder from a third party program once a day.In the database there is a macro constantly running waiting for...