Recent content by LEE hepworth

Hi all Have a database on the backend. Front end has a password which are linked to this backend. Have disabled the shift key for the back end and all short cut keys. just wanted to know if adding a password to the back end would this prevent access from the fron end or would they get asked for...

Query Hi what i have is a query with a field called Payment Method. In this field there is DD and Q What I want is to produce a new field in this query only and if the Payment Method is dd prodce Direct debit in the New Field and if Q produce Q ta

What I want to do is if a field in a query Payment_Method is say dd produce another field to produce the result direct debit and if its Q in Payment_Method produce Q in the New field. I have linked the query to a table and once this is up and running I will copy it to Excel. But all I want is...

Hi all Need some help using Access 97 and what I want to do is on a form have a command button and using the on Click export all the records from the query called All Sales into a present excel sheet called Sales without any headers. Using The transferSpreadsheet Method, Where AM I GOING Wrong...

Displaying records Hi All What I have are two tables, One called Employees and the other called sales with a one to many ie one employee can have many sales The problem is say one of the employees has no Sales they are not displayed in the query. What I want is all the employees displayed...

Hi All Wonder if you can help What I have is Sales Database run in Access 97. I search on Sales in the Access Query But say we have 10 Sales reps and only 7 have sales the query will only show those seven. Is there anyway that the query can show the three that did not have any sales with the...

Back end Hi Have tried that but when I goto save the new fields are not saved

Hi all Using Access 97. Have a table on the Backend containing data that is being updated most of the time. Want i want is to add some fields to this but because its on the back end it will not let me. Can you tell me in easy terms how i would get into the design in the back end in order to do...

Hi All What I need is to restict different queries to say 40 entries and the other 32 entries but if this cannot be done I can resrict them all to 40 .Just need to know how. I'm using MS access 97 In English say you run a query, that will pull all the records. What I want is to run a query in...

Thanks for your help

Date Thanks but I'm bit confused All I want by the above statement is to take the Sales from Monday to Saturday and include these dates ( Mon, sat). So I will run a query called Last Week which will look for sales with these dates, just last week.

Hi Just need some confirmation. Using a query to find amount of sales between two dates. The start of the week starts on Monday and needs to include the sales for that day and finishes on Saturday and include that day. Sunday there are no sales. Is the below correct Between...

Back End Thanks for your advice. What I've done is at start up hidden the window and also used a lock in order to stop the user using the shift key

Back ends... Have a bit of a prob. Have built a database using MS access 97 have a front end and back end. But in the front end there are tables which are linked to a back end which is a separate database for example called BE which only contains the tables. Have tried using the security...

Just a quick one.... Have a Sales Id which is unique , but can I reset this... Also how many records can we add in a table many thanks