Search results

I have been trying to get an answer for this for sometime now with no success any help would be much appreciated. I have tried to solve this with Northwind Database but also with no success. This is what i have: Query with the following fields date, customer, collect from town, delivery...

i am trying to create a form with a left hand frame on ite where i will create a few button commands it will basically be like having a header but vertical on the left hand side of pane any suggestions thanks

is there a way of accessing my database online i.e. i am trying to upload my database online so my customer can access it and enter job / order requests online then the iformation would be sent to us in some form

i am trying to creat an application using access that i can transfer / use on a smart phone using windows mobile any suggestions!!1 thanks simon

I am trying to create an expression of some sort to find values in my postcode file my postcode file consists of postcode like this AB43 3WJ AB1 1RU etc... etc i am trying to when results shown for AB* then i want something where i can put "SCOTLAND" in the all AB* county fields

i have a query that calls all postcodes beginning with AB what i then have is a form that shows these results i want something like a button that when clicked will replace current values in county to "scotland" maybe something like this: If me.county is not like "SCOTLAND" Then me.counuty...

can you give me some idea on this as i am fairly new to this and have never used the dmax funtion thanks

i have a table of invoice numbers and i have a form with a field for invoice numbers what i want to do is get the last or highest invoice number last used from the invoice table by default help!!! many thanks

thanks pbaldy this worked a treat simon

i would like to see this at the bottom of my report 8ft Tables = 3 6ft Tables = 1 10ft Tables = 1

I have a report that will show 3 different text values on a report as below 1st delivery is an 8ft 2nd delivery is an 8ft 3rd delivery is an 6ft 4th delivery is an 10ft What i want is an expression of somesort to count 8ft so this would look like this at the bottom of my report 8ft...

just a simple invoice number like 6543 and then 6544 etc etc... sorry to sound thick but how and where would i use selectmax

thanks george i take a look

this is just one i picked from my list

Any body interested in a cd i have with all uk postcode address down to street level example: HU1 1NP Returns High Street, Hull BA11 4AA = The Butts, Frome The database is all of the UK inc street, town and county This has been really useful tool for my database PM Me

Hi all, is there any possibility of hiding the fact during startup procedure that this is not an access program i.e. hide all toolbars menu button etc... thanks guys

I am thinking of creating a new project as i have always had problems with invoice numbers so if anybody can help me in the right direction this would be much appreciated. first of all i must state that the invoices are monthly so there are say 20 records for one customer and say 15 for...

tried nothing happening just getting a lot of error message unless i am doing something wrong

sorry about private message set focus doesnt seem to do what i need when i enter a postcode and the results exist then i want to goto another field if there are no result then i want to just carry on with tab order

sorry there isnt basically if i open a report and the postcode field is like AB** then the surcharge field would be 6.00 i think it a bit like if postcode is like ab** then surcharge = 6.00 and if postcode is like KY** then me.surcharge=12.00