Search results

Hello, I am trying to create a treeview for users to easily manouver, there are several different levels to the treeview, Meetings Issues Risks I can populate the meetings level of the treeview with the list of meetings within the department however when i try to populate the Issues...

Hello, I have a problem that i need some help solving. I have a table called tblCourierCosts, the table consists of the following fields: Date Run Boxes CourierCost What i need to do is for each Run, add the number of boxes and then perform a calculation to work out the cost and place...

Hello, I know i can create a query that displays the records with a minimum figure but how can i get my query to show all records but the ones with the minimum figure. My Query has the following fields Run PayrollName Output Timestamp Boxes as an example, run 1 may have three payrolls...

I have a table called 'MovieDatabase' which lists all of my movies, i am trying to create a query that when run selects a random film from the list. The query i have set up does select a different movie each time i run it but the problem is after i close the database down. When i re-open the...

Hello, I have a query called Orders which has the following fields: ClientCode PayrollName Frequency Output TimeStamp Date Count PostCode RunNo There can be several entries for each RunNo. I have another query called BoxesDespatched which contains ClientCode RunNo Boxes What i need to...

Hello, I have a table of our customer orders which contains the following fields: Client Code Client Name Output Date Count Post Code (Ascending) Run No. Different clients share the same post code so what i would like to do is on each date, every client that shares the same postcode should be...

Hello, I have a table of our customer orders which contains the following fields: Client Code Client Name Output Date Count Post Code (Ascending) Run No. Different clients share the same post code so what i would like to do is on each date, every client that shares the same postcode should...

hello, I am trying to set up a form so that when the back button is clicked, a specidic field in my databse is checked to see if it is true or false, if it is false i want to remove the text from another field. Any Idea's how i can do this. My table is called "MovieDatabase" My Yes/No...

Hello, I am in the process of making a game and i am trying to code the scoring system, the game has several levels so i am trying to take the score from level 1 and have it continue to increase on level 2 on level 1 i have set points1 as integer i am struggling to get the score to move onto...

Hello, I have a spreadsheet that imports data from another spreadsheet. The user can then print off a control sheet using this data. In the most part the code works fine most users can use the spreadsheet issue free, however there is one user who keeps having problems, every time they run...

hello, I am trying to run a report that only shows records that have a checked flag, is it possible? Thanks in advance

hello, I have created a form that uses a subform to display the results of a query. the subform query shows the entrants name and a flag, i would like to populate certain cells in excel with the fields of the record that has a checked flag. Is this possible? Many Thanks

hello, I am trying to create a form that uses a subform to display the reults of a query, my problem is that i have 5 queries for the user to choose from. Is there any way that i can use the one form and populate the subform with the users chosen query or do i need to create a form for each...

Hello, I am trying to create a form that loads up text boxes with a number taken from a query. the code i am using is Dim stDocName As String stDocName = "Total Pages by Printer" DoCmd.OpenQuery stDocName, acNormal, acEdit Which opens my query. I then have to enter a date is...

Hello, Is there any way that i can code a macro or module in access to run an excel macro that formats data and saves it as an htm file and then import the htm file into access? Thanks in advance

Hello, I am trying to create a label on my database menu that shows when the data was last updated. I am trying to read the date from Print end time in the table Print Data. The data is sorted ascending using the Print end time field. I have tried a query to show the last record however...

I am running delete and append queries but when i run them i'm asked to click yes, no or cancel, is there anyway i can bypass this and have automatically select yes? The code i am using is Dim stDocName As String stDocName = "AppendDups" DoCmd.OpenQuery stDocName, acNormal, acEdit...

Hello, I have a form that performs a calculation, i am trying to add the data in the text boxes into a table. I have managed to get the data into the table however one of the text boxes contains a percentage and once entered in the table rounds up to the nearest whole number, i have tried to...

Can anyone help me, I am trying to create a form with 2 text boxes on, i want to enter an id into the first text box, click a button and have a different field from the record appear in the second text box. Any help would be much appreciated. Many Thanks

Hi, I am trying to calculate the total number of mail pieces between two records. The number of records may vary between the two ID's. I am trying to create a query that when run will ask me to type in a starting ID number then ask me to enter an End ID number then want it to show me the...