Recent content by alxj

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

This happens to me on a regular basis with my invoicing program all i can think is that access strugles with combo boxs. If anyone else has any suggestions i would be interested to try them. Alex

The only time i have ever seen this message appear is when you have a calculated field based on another calculated field. Try re-writing the formula for the tex box checking you are using the long locations for the fields.

Cheers DJBRUMMY you probably wont believe it but i got it to work 2 mins before your Post using exactly the same method. Many Thanks Anyway Alex

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 think that you are on slightly the wrong track. Go back to the basics. If you have a table with your clients in and a table for the orders to go into then relate the two tables together then use the form wizard to create a simple form with subform. Use the example northwind database to help you.

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 used the global variable method as specified and it works great. The only problem is i can only get it to work when it is taking the value from the main form if i ask it to take it from a subform it does not work, is it possible to do this?

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

thanks for your help mike i will get that paper costed up it could be a serious option. Alex

it is mainly because the report to be printed is a delivery reciept which has to be signed by the customer when the product is delivered and this is split into four parts (2 to the customer & 2 on file). I did suggest printing out the copies on a laser printer but the were not keen on the...

Yes it is for carbon copies so i will check that before i buy one. Thanks for all your help, speak to you all again soon Alex

erm you could try conditional formating that would change the results colour but i am not sure about value?

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