Search results for query: *

I work for a company that sales trailers with multiple depots and I want to be able to find the nearest depot from any ware in the country preferably by using post codes is there any way of doing this. Thanks

Resolved This is the way i came up with. Private Sub Re_Calc_Click() Forms!quote_header!Quote_Product!txt_Total_Price = _ Forms!quote_header!Purchesed_Items.Form!txt_Total_markup + _ Forms!quote_header!Labour.Form!txt_Labour_total Forms!quote_header!Quote_Product!txt_Unit_Price = _...

I am not quite sure of what you are saying please could some one expand.

I want to put the sum of two totals on different tab pages in the same tab control. How can I do so? Thanks

I have two sub forms on a header form. On one of the sub forms there are two sub total fields I need to put the total of these two fields into a total field on the other sub form. How can I do this? Thanks.

Hi I am having some problems with an after update event. I have created a front end with a text box called Amended By There are about 30 other fields the Amended By field picks up the user and the current date. When one of the other 30 fields are changed I want it to update the Amended By...

I have created a front end in access and I have multiple records I want to gather the total from every record and place the figure in a grand total field how do I do this.

I am trying to set the criteria for a report I want to link these on quote number this is the coding that I am using but I just get an error but I don’t now what is wrong with it. Dim strFilter As String strFilter = "quote_number =" & Forms!Quote_Header!Quote_Number

I have wrote a piece of coding that pulls the user ID and places this in a text box this is for a report (Quotation) This text box is in place of the signed by at the bottom of the screen. (This works fine). Now I have been asked to create more or less the same thing but this time it is a last...

I have created a popup that lets the end users select from a list of customized report formats. once they have selected the desired format they then click OK this previews the report from here I can't do anything with the print options on the print format screen until I close the Formats Form...

Thanks again i have done some testing and it is working fine now had a re-start and still working thanks

Sorry about this but the coding you gave me worked once and when I re-booted the computer it has just stopped working What should I do and also where should I be placing this code should i put it in a text box and if so when function should I place it under e.g. (on click) Sorry about this I...

thanks for the help that worked great you have saved me a lot of time and work there because i would have had to start again from last nights backup Thanks again

I have created an access front end and I made it so that when I loaded the access file up it ran from start up but when I was setting the options of what I could see on start up I un-ticked everything thinking I would just get the idea of what the user will see in run time without having to...

thanks for all the help i have got it working the coding tips were exalent thanks again

The company that i work for uses full first name and full second name for the loggin so what is your suggestion on the code ssVBAdev

I am currently creating a user front end for an estimating system that creates standard quotes. On the bottom of every quote that is created there is a signed by.[COLOR=red] I am looking to pick up the name of who ever is logged in on the machine is this possible. If so I am open for any...

I am currently creating a user front end for an estimating system that creates standard quotes. On the bottom of every quote that is created there is a signed by.[COLOR=blue]I am looking to pick up the name of who ever is logged in on the machine is this possible. If so I am open for any...

I am currently writing a piece of code that will let the end users pick from a list of business documents to preview, however there are going to be a lot of documents so I was thinking of using a combo box and a button that accepts. This is ware I have the problem I can't pick out the values of...

I have written a piece of code that prints a form using the standard Microsoft print Dialogue box but I can only get it to print the currant form. I want it to print out a report that comes from a drop down menu witch contains 10 or more custom print formats. I need to do this thought the...