Search results

Hi I have writen what i thought was a simple query to filter down service records. I have a Calculated field DueDate:[LastServiceDate]+([ServiceInterval]*7) this has the criteria Between[Week Commencing Monday dd/mm/yy] And Date("d",+6,[Week Commencing Monday dd/mm/yy]) I was happy to start...

I want to enter a date and have it display results between the specified date and 6 days later. I have tried criteria Between [From] And ([From]+6) it works for numbers but not for dates anyone got any ideas?

I am trying to create a macro which when runs syncronises the design master with the replica set (or the other way around). When I use the RunCommand SyncroniseNow it starts to work but then crashes. Can anyone get this to work?.

Now this is probably staring me right in the face but... I have an orders form (Usual stuff main = clients, sub = orders, subsub = products,{all query based}) on the main i have created a combo that finds a company name from the records in the table, this works fine however whenever i add new...

I have an ordering system which uses a form with 2 subforms for the order (Client / Order / Products Requires), after this order has been taken it is passed on to the stock control department. Due to the nature of the product it can be stored in many locations. The location ref number needs to...

When you create a command button to open another form based on related items. Is it possible to have more than one set of related items i.e. Name = Name & Size = Size ? Thanks in advance Alex

I have been asked to make a report print using a dot matrix printer but i have no experience with these what so ever. Does anyone have any tips or things i should look out for before i choose one to buy. Thanks for your Help Alex

Hello Is it possible to open a form and have it displayed in a blank form filter, instead of opening the form and then clicking the icon for form filter. If not does anyone know how to display the form filter button inside the form instead of being on the toolbar of access (it does not seem to...

why does it say Object variable or With block variable not set whenever i try to select a picture to go onto the background of my subform? Alex

I have turned off the standard navigation buttons so i can produce my own custom nav. bar out of command buttons. The problem i have is that when you turn the nav. buttons off you have no way of scrolling through results from a form filter. The number of records within the form is also no longer...

I need the all of my dates to be entered in the format . dd/mm/yyyy, and be displayed in Medium date format. However whenever i set the date format to Medium i can only enter the day in mm-dd-yyyy format. Is it possible to change this. (I have tried to use an input mask of dd-mm-yyyy but it...

I have a text box which is bound to an underlying table. I used code written in vba to make this box fill from the data of one in a subform within the main. The answer is shown correctly in the text box and correctly updates the underlying table but only after you click in the text box and then...

I have also created a sales order page which is used to record all the information from the order. It is in the format of Main Form - Client Details (Address & Delivery Address etc.) Subform1 - Orders (Invoice Number, sales person etc.) Subform2 - Order Details (Ind. product details i.e...

I have created a text box on a form which sums a contract value from the values in a subform. It all works correctly and me the right answer. However i need this figure to be then stored in the underlying table for use in related queiries and forms. Is this possible? Please Help Alex

I have the problem of needing to hide a text box if it contains no value but appear if the control source equation creates a value to put in it. How would i go about doing this. Thanks Alex

Hello again my friends more problems i am afraid. Is it possible to have a yes/no type switch in my main order form which when changed will alter the type of equation used in the subform datasheet. If this is possible how do i go about doing it?. Thanks for all your help Alex

I need to create a section which ammends underlying stock levels in my product table when and order is placed in my order form. I am currently using a Main form (client details) and 2 subforms (orders & order details) as my order form. Is this possible or am i asking too much from access...

Hi, I have just started writing with ms access and i have come up against a couple of probs, Firstly, how do you total a column in a subform? i.e. all the line totals added together to produce a grand total. Secondly, i know it is possible to use a combo box to lookup a row of results from a...