Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dafyddg
  • Content: Threads
  • Order by date
  1. dafyddg

    Passing parameters between MVP views

    Hi all, Seemigly simple question but can't satisfy myself with the correct answer. Two MVP based views. On one view you click on an item in a list. Click a button and then the details of that item are displayed in another view. My question is how does the summary view pass through the state to...
  2. dafyddg

    Problem with the TextBox.AppendText method

    Hi, I'm using a TextBox to provide output from a process that a utility i'm writing runs. Now i thought this would be a simple case of calling the AppendText method each time a new message was ready to disply. But no. For the first 1000 or so message all it fine, but then after a certain point...
  3. dafyddg

    Argument Exception when using Image.FromStream(MemoryStream)

    I've got a method that i use to convert a byte array into a System.Drawing.Image. The code looks like this: private Image ConvertByteArrayToImage(byte[] bytes) { Image image = new Image(); using (MemoryStream ms = new MemoryStream(bytes, true)) { ms.Write(bytes, 0, bytes.Length)...
  4. dafyddg

    Regular expressions problem

    Hi, I'm not sure if this is the right forum to be posting this in, if not could you please point me in the right direction. Basically i'm having trouble with layered data and header. (i'm probably using the wrong reminology here as i'm a bit of a noobe in this area). Below is a simplifcation...
  5. dafyddg

    Quick question about workgroup files

    Hi, If i create a workgroup file for a data base and then move both the database file and the workgroup file to another computer, will the database still work? I think it will but can't test it at the moment. Its just that i remember seeing somewhere about registry keys being created when the...
  6. dafyddg

    Force new Report for every 9 records

    Hi, Is there anyway that you can force Access to print another report every 9 records? I have page header, invoice id header and a detail section with associated footers at the bottom too. For every 9 elements in the detail section i want to print the invoice id header section again. I can't...
  7. dafyddg

    Problem with the ' character is SQL INSERT statment

    Hi all, Having a rather silly problem with SQL insert in access Basically i build an SQL insert statment as a string and one the values i put into it is a string e.g. Dim test as string Dim SQL as string test = "Hello" SQL = "INSERT INTO Testtabel([Astring]) VALUES('" & test & "') This...
  8. dafyddg

    Problems with rounding up currency

    Hi, I've written an SQL query thats designed to increase all the values in a field by a specified percentage. This is the SET part of the query SET Rates.[Unit Cost] = Rates.[Unit Cost] * " & actualrate Unit Cost field is set to Curreny with 2 decimal places and actual rate is a number such...
  9. dafyddg

    Certain elements not printing in the detail section

    Hi, I can't figure out if this is a problem with my printer or a problem with access. I have lines in the detail section of a report that don't print and yet some that do. I'm using horizontal lines to make the separation of elements clearer so that i have one horizontal line the width of the...
  10. dafyddg

    Tab switches active window, why?

    Hi, This isn't a big problem jsut an annoyance. Sometimes when i'm working with the VB editor the tab key no longer works as the tab key but task switches windows instead. I don't know what i do to make this happen so i have no idea how to turn it off. I assume i pressed a key by accident but...
  11. dafyddg

    Method for sizing dialog boxes to the size you want

    Hi, I've had headaches trying to get dialog boxes to size to what i want them too. Trying to make a dialog symetrical so that both margins of it are the same width. Well here is something stumbled upon recently. Turn of the rulers. I never use them and i've never heard of anybody who does...
  12. dafyddg

    Getting the number of records on a form - Recordcount?

    Hi, I'm trying to get at the number of records in a form. I'm currently using the code: records = Me.RecordSource.RecordCount but i get the error message invalid qualifier in reference to the '.RecordSource' part of the code. The form has its record source set by another bit of code to and...
  13. dafyddg

    Referencing a field in a Subform

    Hi, I've got some SQL which i use to populate a list box which is in a subform. The list box has the following SQL as its row source: SELECT Contracts.ContractID, Contracts.Description, Providers.[Provider Name], Contracts.ClientID FROM Providers INNER JOIN (Clients INNER JOIN Contracts ON...
  14. dafyddg

    Updating a list box within a subform

    Hi, I have a main form called AddEditClients with a subform called AddEditClients. The subform has its row source set to a table called clients. The Main form has a list box that shows a list of all the clients and when a user clicks on a client the sub for is updated to show the details of...
  15. dafyddg

    Modifying the start menu

    Hi, Does anybody know of a way i can add my own folders to the windows XP start menu on the right hand side i.e. the bit where 'My Computer', 'My Music', My Network Places' is. I know i can turn the ones that are there on and off or change them between lists and link but i want to add my own...
  16. dafyddg

    Acess locking up with strange error

    Hi, I've been suffering with this for a while but i've finally had enough of it now. If i try and save my project when there are more than 2 access forms that need changing (basically when it tries to save two access forms at the same time) it fails to do so and locks up. I get a warning...
  17. dafyddg

    Selecting only records with indentical values in a field

    Hi, I have a table full of payments which are all uniqe. I want to be able to run a query that will return the sum of two values in a number of records with the same value in a paticular field. So: the table payments has the following fields: PaymentID (autonumber and primary key) Subtotal...
  18. dafyddg

    Sizing forms, how do you do it?

    Is there a way of accuratley sizing forms off the grid? Currently i have to drag out the detail section of the form to the size i want then match up the edges of the actual window to the edfe of the detail. This seems to work but is there a more scientific was of doing things? Why can't i just...
  19. dafyddg

    Running code ONLY when a report is printed

    Hi, I need to run code each time a report is printed to basically update the status of the invoice represented by the report. I used the OnPage event of the report for this but found that this code runs when the report is both printed and previewed. I want my code to run only when the Report...
  20. dafyddg

    Lines and boxes not coming out in the printed version

    This is a rather bizare problem i have a report based on a Query that basically is an invoice. My problem is that although i have put various boxes and lines on the report they do not come up on a printout. Only the text/pictues and date print out. The lines and boxes show up on the print...

Part and Inventory Search

Back
Top