Search results

  1. dan-cat

    Lse

    Interesting that this university's relationship with Libya was considered acceptable until now. I guess the cost of bad headlines eventually outgrew the cost of refusing the lucrative grants.
  2. dan-cat

    Macro Navigation

    Can I quickly navigate to the "Macro Name" I want in a specific macro without having to manually scroll down the page looking for it? I'm using 2003
  3. dan-cat

    Happy Birthday Kraj

    Happy Birthday, Bud! If you ever read this, come back already :)
  4. dan-cat

    Opinions please...

    Ok my turn to ask for opinions... what do you think of this site. Blunt as you like as long as it's honest. I promise I won't get upset. :p link
  5. dan-cat

    Not inclined

    Man, I have done no work today. The sum of all my efforts today are several one-liners on this forum and writing down four things that I have to do tomorrow. Does anyone else get days where they just do not have the inclination to do what they should do on any other normal day? I've turned my...
  6. dan-cat

    Linking to SQL Server

    Strewth didn't think I was ever going to work with Access again, but I am, so here comes a table link question for you. Got an access xp FE linking to SQL server via a DSN file. All linked up fine, however the tables in access have been given a 'dbo_' prefix to the original table name in SQL...
  7. dan-cat

    United 93

    What are people'e reaction to this? http://www.united93movie.com/index.php Is it appropriate? Is it a piece of propoganda? Is it a suitable memorial or just another money-making device from the movie industry. What's your gut reaction to it?
  8. dan-cat

    Asp.net hoster

    Hi, Can anyone recommend a good windows hoster? I need .net 1.1 support, sql server 2000 and good customer support. My budget would be around $250 per year. Thanks
  9. dan-cat

    Opinions on Master/Child relationships

    Hi, We all know we're not supposed to duplicate data right? So was wondering how people deal with the deletion of Master records. For instance let's say I have 3 tables. tblSales tblSalesSub tblProducts tblSales - lists the sales summary - stuff like SaleId, SaleDate, SaleTotal tblSalesSub -...
  10. dan-cat

    stored vs calculated values

    Hello All, Ok I'm still a little rusty as to when and why you shouldn't store a value. Take, for example a db designed to process timesheets. Timesheet form details employee, rate of pay, total hours and total pay Timesheet continious sub-form details date, starttime, finishtime and total...
  11. dan-cat

    Drag over-sized form

    Hello, I have a form which is intentionally over-sized so the user has to use the scroll bars to view its entire contents. Does anyone know of a clever way to allow the user to click and drag on the form to simulate the use of the scroll bars. Much like what you can do in Acrobat reader...
  12. dan-cat

    Minimized api call

    Hello, Does anyone know whether there is an api call to use to determine whether a form is minimized? I have the one for maximized Private Declare Function IsZoomed Lib "User32" _ (ByVal hwnd As Long) As Long Thanks Awfully Dan:)
  13. dan-cat

    Defining controls to be enumerated

    Hello, When enumerating a set of controls within a collection - is it possible to define which controls are enumerated by their name. For example I want to enumerate all the controls within a tab page that start with the name thumb*. This is what I have done: Dim img As Control For Each img...
  14. dan-cat

    Looping through properties collection

    Hello, What I am trying to do is create a new field which has the exact same properties as another field in a different table. Here is what I have done: ' Declare variables Dim db As DAO.Database Dim prp As Property Dim tdf As TableDef Dim tdfNew As TableDef Dim fld As Field Dim fldNew As...
  15. dan-cat

    Refresh image box

    Hello, I'm updating the picture property of an image box with something like: Me.Image1.Picture = strPicturePathName That's all working fine - however everytime this happens a big progress bar appears on the screen saying 'Currently importing C:\MyPicture.jpg ........' Is there anyway of...
  16. dan-cat

    Querydef Trouble

    Hello, I'm trying to build my own querydef based on criteria on a form but I am having a slight problem with the SQL. The function reads like this: Function BuildSQLString(strSQL As String) As Boolean Dim strSelect As String Dim strFrom As String Dim strWhere As String strSelect = "s.* "...
  17. dan-cat

    Is Access Run-Time pants?

    I've just had a go at running a sample database in Access Run-time. The problems I came straight up with were: 1) Have to build your own custom menus 2) Couldn't preview a report 3) Couldn't call a common dialog box 4) Couldn't output a report to .rtf file. Does anyone agree that this is...
  18. dan-cat

    FileSearch Problems

    Hello, What I am trying to do is open a filedialog and with the file selected - check to see whether the file exists. ie. Whether the the user has typed a new file name or selected an old one. This is so I can warn the user that the file will be over-written. Here is what I have done Dim...
  19. dan-cat

    Carriage report in text box

    Hello, Is there anyway of forcing a carriage return in a textbox within a report? So instead of having say 6 seperate fields within the report to detail an address. ie [CompName],[Add1],[Add2],[Town],[County],[PostCode] - you could have one text-box within the report whose control source...
  20. dan-cat

    Enumerating field property values

    Ok, I've had my turkey sandwiches and mince pies and I still can't figure out what I am doing wrong with this DAO statement. All I am trying to do is list the values of each property for a given field. Why am I getting a type mismatch error with the prp variable? Public Sub Help() Dim db As...
Back
Top Bottom