Search results

Hi all, Just looking for a bit of advice really. I'm building my dad a database for his garage so he can store customers details, MOT test details, job details. Where I'm getting confused is displaying this information in a form. Basically, I want there to be one form that shows (without...

Hi all, I've looked through the previous posts here but can't find what I'm looking for (probably because I can't think of how to phrase it). Basically I've got a text box that allows for entry of the item cost, then a text box called Quantity and another text box that calculates the total cost...

Hi all, I've searched the forums but can't seem to find anything similar. I work for social services and we have a database that stores information on children who may need services from adults when they reach 18. What I need to do is create a query (so that a report can be run) that will show...

Hi all, I've got a form in my database that enables you to print or view reports, which I inherited. There is a list box that is automatically populated with all of the reports listed in the Reports tab of the database window. The list box row source says the following: SELECT msysobjects.Name...

Hi all, I have a frmUserLoginScreen that opens frmMainSelectionScreen, which has 4 command buttons on it. Dependant on user level, some of the command buttons are disabled. I have four user groups, manager, admin, IT and guest. When the guest logs on, the frmMainSelectionScreen only has one...

Hi all, Thanks to a AWF member last week, I have managed to advance a lot further with the login screen I need but have hit a brick wall. Below is the code I was given and at present, the code opens up the same form which is fine, but I need the form that opens to enable the delete client...

Hi all, I'm having a problem trying to get some code to work that a member of this forum helped me with some years ago. Basically I have a form with a combobox that is used to select the user name and a textbox for the password to be entered. There are two different types of user, manager and...

Hello all, I've been asked to set up a basic database to store information on clients that will need to receive a service from us when they reach 18 years old. I have set up the table but am not sure on how to write the query. I need the query to create a report that will list all of the...

Hi all, I have tried searching for other relevant posts but have not found anything. I have a form that gives the user the option of opening up 3 different forms (bit like a switchboard). When a form is selected to open, upon opening, the main selection form is visible behind the opened...

Hi all, I have a database that contains records for all of our clients. One of the fields relates to service type received. The main table that holds all the records has many duplicates, as some clients have more than one service. I have created separate tables and append queries to filter out...

Hi guys, I have been given a table that was produced in Excel that I have imported into Access, it is a list of service users that have received an assessment from us. There are 11 different assessments and not all users have had one of each. For example, one user has 4 different assessments...

Hi, I have been given the task of producing a feasibility study on the benefits of building a separate (secure) database on Access or having the software developers build an add-on to our existing system. I was wondering if any body could help me with some of the pro's and con's for each...

Hiya, I am trying to create a form that can be used as the user level logon screen. The form has been designed with an option group for selecting the type of user and then a text box for the password to be entered in, followed by a continue button. Once the user has selected their type and...

Hi, At the bottom of each of my reports I have a text box that displays the total number of records within the report. What I am trying to do is create a new report that will show the values from each of these text boxes, basically producing a summary sheet. Is this possible?

Hiya, I'm having a bit of trouble showing the totals at the bottom of a report. I have tried setting the control source to =Count(*) but the message in the text box displays #Error Doe's anybody know what I'm doing wrong? Any help would be greatly appreciated. Thanks

Hiya, I have a number of reports that provide specific information relating to the queries they are based on, as well as a sum in a text box to calculate the number of records within the report. Basically I am wanting to take the outcome of the sums on all reports and then produce one report...

Hello, There is probably a really simple answer to this, but my mind has gone totally blank. Basically I am trying to create a query that will count all of the records in a form that match the criteria I want. For instance, out of 100 children registered, I want to find out the number that are...