Recent content by theconfusedbear

Hi You very clever people out there ... please help. I have two tables which I need to change stock levels. I have one table that has the stock levels as of now ... and another table that shows stock levels from yesterday. I need to produce a txt file so that it checks both stock levels and...

I have a contact database which I want to archive items - I have created a field called Archived and as a Yes/No field. So everytime a contact has been assigned a YES I want "Archived Contact" to flash so that its easy for people to see! Im sure its really easy ... but Im stupid! HELP...

trevor I really appreciate your efforts but its still removing the line. I have just done the first address line - I hit the button and the data disappears from the field. And doesnt reappear in the feepayers first address line .. Im sure that im annoying you enough but I would really...

Ok I have done that .... but it just wipes the address from the address and doesnt put anything into the feepayer address

One table with two address sets in the table - one for the client address fields and one for the feepayers address fields. 90% of the client addresses need to be copied to the feepayers address details. So all I want to do is have a button the form which appends the data from the clients...

I have done an update query and an append query ... which only creates a new record with only the feepayers details in it ... im really stuck

I have one table with the following address1 address1b address1c town county postcode AND feepayeraddress feepayeraddress2 feepayeraddress3 town county postcode. The question is users are filling in the address fields but want to hit a button on the form so that it copies the contacts...

Need help .... I have a database which has two sets of address fields in one table. One address set is for a client and one address set is for a feepayer. Are you able to create a button that copies the client address fields and populates the feepayer address fields (with the same data)???

You see thats why your clever!!! thank you!

How can you create a dropdown field with 20% through to 30% so that the prices increase by that amount?

Is this possible???? I have a field in my report called LeadSource which in the table holds one letter A, B ,C and so on. Can you set an expression to say when A appears show Apple or when B appears show Bear (just as an example). I have linked a decode table to the main data but its running...

thank you ....

This is driving me crazy, with my muppet knowledge! I have a report which has the following fields Application Count Hit And Miss Count Sale Count I am trying to do a percentage from Hit and Miss Count plus Sale Count / Application Count I put it in an expression on the report but it shows...

I have a table of around 100,000 records all with a unique contract ID. However there are several entries holding different information on each line but with the same contract number. How can I assign each contract number with its own ID for example contract number 12345 has 6 different...

Bless You! thanks