Search results

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...

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 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...

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"...

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

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 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

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...

Help please. I would like to be able to create a browse button that will allow the user to find a file that when they click ok on the browse window is assigns the file to a hyperlink . I have used the following code to open a dialog box which works fine and puts the file name in the hyperlink...

HI I am having a real mental block with this problem so can any one help. I am creating a driver database to keep track of approved drivers. I record any driving offence in a table called convictions. This is to track such items as speeding drink driving etc. What I want to do is look in the...

Hi is it possible to change a forms from single to continusos using vba an a control button. The forms starts a single form. The control button will say "all" and when the user clicks this button the form changes to a continuous form is this possible. Thanks for any help Paul

Hi I would be glad of a little help. I am creating a c ontracts database and need to keep trak of individual contractors figures. I set up a contractor and allow the system to only issue orders to a contractor if there monthly balance doe not exceed 1/3 of their total monthly turn over. My...

Hi I how can I find out if my form has any records or not. I have a form that gets its data from a query. If the conditions of the query are not met then no data is shown. However my exit button tries to calculate a value based on the recors shown if the condition was met. When the condition...

Hi I am struggling with this one. I have a combobox that uses the following row source SELECT [General Query1].[compinfo], [General Query1].[ID] FROM [General Query1] ORDER BY [compinfo]; I want the user to select one of the options which I then need to find out the comapny ane and also the...

Hi I am having real problems with this one. I Have a form with a sub form. The main form is set against a table called contracts. The subform data is from a table called Parts. The sub form is a continous form and holds a basic discription of all parts. against each part is a button which...

Hi I am creating an invoice database. In its simplist form I have three forms, which are tied to tables customers and invoices and as such form: 1) Contains Basic client information 2) Contains info on invoices. 3) contains info of invoices. the table are linked by a record id called [who]...

Hi Is it possible to open a second access database from a from. I.e I create an application menu in a master database and then from this I call smaller databases. for example I would have a master db called contracts this opens a menu form. From the menu I may select sub-contracts that...

HI I hope this is a simple one for someone. I have a combobox set as a lookup field in a table. where row source set to: "Sole Trader";"Partnership";"Private Ltd";"Public Ltd";"Other" on my form I have its default value set to sole trader what I would like to do is beable to show a new text...

Hi all I have a continous sub form and there are 4 fields however only one can be changed. I therefore would like to be able to go from record to record. I have used: docmd.gotorecord ,, acnext however this causes a problem when I reach the end of the table. How can I find out if there are...