Search results

Hi Ken Thanks for all your input I will look at this a little longer. If anyone else knows more please reply thanks

Hi the response from msysobjects is: Connect DSN=winone;Driver=C:\dbisam\odbc\stdsrc\ver3\lib\dbodbc\dbodbc.dll; ConnectionType=Local;RemoteType=LAN;RemoteHostName=; RemoteIPAddress=129.0.0.1;RemotePort=13005;RemoteService=; RemoteReadAhead=50;MRUDatabase1=Memory...

Hi Ken coppied and used that however. The tables from my external programme are not mdb files and cause a problem when I load them. If i use file>get external data and link tables then I can access the informatiion. using the code you gave me I was able to find the file with a fileio routine I...

Hi Thanks for quick response. I can not keep these records in one table as the programme was not written by me and I have no control over what happens. These tables are created by a piece of third party software.

sorry if thi9s is the wrong place but I thought I would try somewhere. I would like to create links to table trough an odbc link. whta I have is an estimation programme that creates 4 tables in a directory/folder each time you create a new estimate I have an odbc link that points to the given...

I really don't know why I am using the tmp table except that it keeps the exisitng records as they were. An order may be issued to one or more people for the same bit of work and so thought it would be easier to keep track this way?

Hi This may seem a really dumb question but I just can not get my head around the best way of solving it. I have two tables orders and orders_tmp the table orders is created form the orders_tmp table. The order is created by a single field createorder (yes/no)from the order_tmp table. I run an...

Hi Ray Thanks I did try that and it did not work. I did a search on the forum after the post and found the answer I was looking for from another post. and came with a sample db, Thanks all

Hi I am try ing to create a query that sorts records in a table based on a filed on a form in order to produce a report. I have a field on a form called customer in my query for the report I want to sort customers in my table by their name if given on the form or to show all records if not...

I am creating a booking system that allows three different departments in our company to invite up to two guests to an event. I have created a single form called event which lets me select the three departments. on this form there are three sub forms linked to the departments. These sub forms...

Wow that worked. Thanks for the help Paul

Hi all can someone help me with this one? I have written the following code but I can not get it to work. fname = pname & "_" & ia & "_" & onmae & ".doc" Set fs = application.FileSearch With fs .LookIn = application.CurrentProject.Path & "\database files\letter"...

Thanks Guys Have been playing and this was just what I wanted. Paul

Hi Im after a function that takes a string and finds only the file name. So form a variable strpath = "c:\MYDOCS\DATA\THISFILE.TXT" i would like just the file name thisfile.txt thanks for any help with this PAul

Please ignore this post as I found that you change the cycle mode of the form. Form properties cycle: Current record

HI I have a form which collects names and adress fields. If a user enters thye required details and then tabs to the next field this is fine until they accidently tab on the last field only to be taken to a new record. How can I stop the last tab going to a new record and instead loop back...

Hi Guys Thanks for response. I was more looking at ways to intergrate this with outlook calendar. I know there will be a lot of resiastance to this but with the ever increasing demand on Health and Safety in the work place it gives us a good excuse for fire regulations.

Hi all I have been asked to build an in out office notice board that will keep track of all employees in the building. we use windows server 2k and I would like to record in/out in an access / sql database. Any one know how I could go about this. Thank Paul

thanks Bob even with shrink set to yes I get the two pages. I had to move fields down my report to get them on a second page and to make the report look respective. is there a way to only print page one

Hi Hope someone can help on this. I have created areport that is spread over two pages. which works really well. This report is for tracking damge to our fleet vehicles. on the report a have a basic check list of all items in vehicles this is on page one. now on Page two I have an image and...