Search results

No both master and sub form are set to popup no thanks

Hi Bob thanks for that was what I was looking for. The only problem I have with this is that it open the hyperlink in the background and not in the front. Paul

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

Paul Thanks again for all your help. I will give your way ago. The way I did it came from a previous forum and is a habbit that I will gladly forget. Paul

Well Paul thanks for that I am still not 100% about this but from what you said I came up with this: pen = DSum("Penpoints", "Convictions", "[driver] = " & "'" & Me![Name] & "'" & " And [dateoffence] > Date() - 1860 ") It seems to work. I will try the following for my other dilema. str2 =...

well Hi Paul Thanks for response. I still have not got my head around the use of quote mark in access I got the code to work with the following. pens = DSum("[penpoints]", "[convictions]", "[driver] = 'paul evans' And [dateoffence] > Date()- 1280 ") however I need to change 'paul evans' to...

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 guys my meaning of monthly turn over is based on a contractors yearly turn over / 12 this is the amount of money the contractor would see going into their bank in one year. so if a contractor yearly trn over was 120,000 then their montly turn over is estimated at 10,000 so for my...

calc of figures thanks for reply. There is no easy way I can break this up into smaller sections as my problem is looking at it as a whole. the small sections I can manage. I think what I am looking for is a way to constanly monitor one figure against another. inother word my max value of...

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

Thanks Allan That worked a treat.

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

Thanks very much for that. That was just what I wanted.

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

Ok so ita appears that access does not always save records in a logical order. This would explain why my record three is infact record five. So I think I need to use the docmd.findrecord command. only I am havng problems with this to. I use the following to open the newform stDocName =...

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

Boy that was quick. Just what I wanted. Thanks saved me hours.