Search results

I have searched for this and have not come up with an answer as yet. I have query that is accessed by entering criteria in a text box and then the user can click a button which will use the criteria entered in the query and then export it to an excel file. Is there any way i can get the option...

I have a database about when computers have been installed I have a form It has a drop down list with Januray through to December I want the user to select a month and a year and then click the command button and it will run a query displaying all the computers installed in the month of that...

Morning I Have done a search but have not found an answer I ran a delete query and specied fields to be deleted from certain records. Instead of deleting the field it trys to delete the entire record. Any ideas how i can get it to just delete fields and not the entire record.?

Database is an asset register. I have a table called assetcurrent It displays the asset and where it is, who its with and what it is. I want a button on the form which when clicked will move the record from the table assetcurrent into another table called asset history. Any ideas?

I have a database of assets. For example a computer will have an asset . This database will show the asset, where it is, what it is and who its with . It will display this on a form. When this asset gets given to someone else i want a button on the form which displays the assets current data...

Right i have a table which lists football players and what days they scored their goals. so its a total history for the season. so for example if tierry henry scores 32 goals he will have 32 different entries how can i run a query which will tell me when each player scored their most recent...

I have uploaded an example of my database As you can see there are two tables and two forms. What i want is for a user to view or enter data for a record on the first form. And then when they are done they click the button to open up form2. What i want to happen is for the company name/id from...

im running a query on a table which contains many entries for the same thing the many entries are different years finanical information for that project how can i get a query to display a projects total spending for its earliest year, and not display any other year for that project bare in mind...

Right I have created a report from a query which is created from my tables The report displays a project and the phases that project is in and what date the project reached that phase. So if one project has been through ten phases it displays it ten times with the date at which it reached...

Right I have a form which users will fill in There will be a date field they fill in in one text box and then next to will be "Financial Year" text box which I want to be autofilled depending on the date they enter. For example if they enter 01/01/05 then in the FY text box it will...

Right i have a project form which has a sub form of location One project can have many locations therefore it is nescarry to enter more than one location Problem is with the cascading combo boxes i have for country to region to sub region, is that you can enter one fine, but if you enter...

I have looked on the forums and cant quite find what im looking for so i wanted to ask you lot for help. I have a database i have created. It will be sent out to people to populate via a series of forms i have created. How can I lock it down so that: 1) you cant access any of the database...

I have a form with the text box "Project Name" I have used a command button placed next to the project name box which if clicked opens up a finance details form for the project name box. Problem is if that project does not have any finance details it still opens up the form but just comes up...

I have one form which is created from one table. I open the form and if i scroll with the mouse it doesnt move through records, it stays on the first record but amends the details for that record in the second box. any idea how i can set the scroll mouse function to browse through the records...

As you Can See I have attached just one form in my database. I have created a combo box with a value list of forms which are in my main database. And then put in command button to press to open the form you have selected in the value list. but alas i cant get the right code to be able to open...

Right I have followed one of the sample databases and modified it to create cascading combo boxes like i needed. Now all i need to do is use them in the context i need. Basically I have country, region and sub region. These cascade to each other in the form which has been created. If you...

I have a form, and when it opens it has focus on a box i dont want it to focus on How do i change which box it has focus on when it is opened?

I have a form ive created as part of my database used for data input. Someone opens the form , enters their project number, and then enters what country it is in, what region it is in, and what sub region it is in. They are all dropdown menus with the information coming from a table via a...

You know the scroll ball wheel thingy on your mouse inbetween the two mouse buttons. On a form i created if you scroll up and down on it it scrolls through the records on the form. Is there anyway i can stop this from happening?

I have created forms for inputting into my database. First of all a form opens with a choice of opening up another form displaying certain tables to input into. On the startup form there is also a text box for the user to type in text and then using a command button filter the next form with...