Search results

Hi Stopher, You pass rs as an arguement but then later use Set rs - so why did you need to pass it? I have now removed the rs arguement. You've used ind in the On Load. But you increment it in the Sub. Have you made this a public variable? Ind is a public variable. If you debug.print...

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...

The data is imported from a text file, which already contains the courier. The courier cost is static and will not be changing.

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...

Thanks for all your held, i ended up resolving it with VBA using the following code Sub RandomMovie() Dim db As DAO.Database Dim tdf As DAO.TableDef Dim fld As DAO.Field Dim rst As DAO.Recordset Dim strSQL As String Dim strTableName As String strSQL = "SELECT...

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...

What i did to solve this was Create a new table - CustomerAddress which held the ClientCode and PostCode. I created a relationship between my CustomerOrder and Address tables using the ClientCode. I then created a query that shows the orders and postcode which i called GetPostcode Next i...

Thanks Galaxiom What i did to solve this was Create a new table - CustomerAddress which held the ClientCode and PostCode. I created a relationship between my CustomerOrder and Address tables using the ClientCode. I then created a query that shows the orders and postcode which i called...

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...

no that hasnt worked, when level 2 loads the score box reads 0, i think that i somehow need to get points2 to refer back to level1 but am unsure how

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...

Its not having another workbook open, we have had every other spreadsheet on the users desktop closed and made sure that all other users were out of this spreadsheet but its the same error appearing

yeah there is definately a worksheet called 'Background". The spreadsheet is on a server so everyone accesses the same spreadsheet, so i cant understand why it's not working for this one user.

That worked brilliantly thanks

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