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 TouchToneTommy 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: Pampers
  • Content: Threads
  • Order by date
  1. Pampers

    subquery? max?

    Hi everyone, Looking for a query that select the following: id date number 1 12-11-2011 3 2 12-11-2011 5 from this dataset: id date number 1 11-11-2011 2 1 12-11-2011 3 2 11-11-2011 4 2 12-11-2011 5 ... Can't figure it out Regards Peter. Pampers [afro] Keeping it simple can be complicated
  2. Pampers

    transfertext error when filename holds .

    Hi everybody, I am trying to read a file into a table using transfertext command. But if the file name holds '.' before the file extension, Access cannot the find the file (error 3011). My code is: DoCmd.TransferText acImportDelim, "specArtImp_SchapKaart", "tblArtImpLocalTemp"...
  3. Pampers

    Hooking Up A CHM-help file with Ms Access (2007)

    Hi Everyone, I created a little help-system through microsofts 'html help workshop', that produces a chm-file. You can hook this file up with an Ms Access application through f.e. the forms HelpFile-property (path to the file) and the HelpContextID-property (points to a specific topic within the...
  4. Pampers

    execute some js after page_load event

    Hi everyone, I have webpage (apartmentdetail.aspx) with a site.master (asp.net). After the page (with a formview for databinding) loads I want some js to be executed. It will set an html-image source (src) to that of the first loaded image. Here is the code for the controls. <img...
  5. Pampers

    problem passing an asp.net control to my js-function

    Hi everyone, I wrote some JS. I have an asp-imagebutton (within a formview)and js-function. On mouseover of the button the function will be called and it will get the src from the imagebutton. All works ok. But how could I pass the control dynamically into the function and then take its src...
  6. Pampers

    import excel sheet into table

    Hi everyone, In Access (2007) you have the option to import an excel sheet into a new table manually (with a wizard). How can you automate this process? I can not append the sheet to an existing table since the sheet various in format (more or less columns with different column headers) Pampers...
  7. Pampers

    hyperlink problem

    Hi everyone, I am trying to create a hyperlink. But is not working (it will point to a website withing my website). Say the website url is: www.test.com. It requests this: Requested URL: /ASPNET_MasterPages_Tutorial_01_VB/www.test.com and I want: http://www.test.com Here is my code. w...
  8. Pampers

    dynamic field refering in recordset

    Hi everybody, I have a non normalised set of data, where months of the year are field names, like [01-00], [02-00], meaning januari 2000, februari 2000. I want put these dates in a table as data. So i want to step through these field names and write them to a table. But i dont know how i can...
  9. Pampers

    Delete/Modify Field Property

    Hi Everyone, Question about a Field Property. I can create a Field Property (see code), but how can I modify or delete an existing property?? Dim tdf As TableDef Dim curDatabase As Object Dim fld As Object Dim prp As DAO.Property 'Get a reference to the current database Set curDatabase =...
  10. Pampers

    Change Field Order in Table by Code

    Hi Everyone, I have a little form with a button to modify/create tables and field in a back end of database. I have some code to add a field to a table. That works fine except that it adds this new field always on the bottom. Can I influence were the field is placed within the field-collection...
  11. Pampers

    SELECT * FROM IN-problem

    Hi everyone, I'm trying to execute (in vba-code) a query from another database then where the code is running. Can't get it to work. Error message is that it cannot find the object. strQuery = "SELECT * FROM qryContainerMovesEDI " & _ "IN \\Svr-file01\data\Shared\AAASeaTrade\Seatrade_be.mdb"...
  12. Pampers

    datagrid with hyperlink

    Hi everyone, I have a datagrid with a DataGridTableStyle. Like to add a column that holds hyperlinks... How can I achieve this. Pampers [afro] Keeping it simple can be complicated
  13. Pampers

    creating or copying a shortcut to the desktop of an .mdb

    Hi everyone, I'm trying to create (or copy) a shortcut to the desktop-folder of access-application. Can't get it done. Any suggestions? Pampers [afro] Keeping it simple can be complicated
  14. Pampers

    position controls on report by code

    Hi Everyone, I try to position the (text) controls on the report by code. Something Like: On format() Me.Consignee.Top = 4 Me.StreetName.Top = 5 etc... Is there a way to do that? Pampers [afro] Keeping it simple can be complicated
  15. Pampers

    how refer to 'nothing' in a query

    Hi everyone, Not sure if it can be done, but I have a criterium in my query which refers to a form-checkbox (chkBox). All is well, the criterium can be True or False and the query runs ok. But what can I do to ignore the criterium completely so the query returns True and False values. Tried this...
  16. Pampers

    WillContinue Property

    Hi Everyone, I want to show a label-control (lblContinue) in report-page-footer (or somewhere else) if the detail-section will continue on the next page. How can I use the WillContinue-property of the detail-section to accomplish this? Pampers [afro] Keeping it simple can be complicated
  17. Pampers

    Blank rows in combobox

    Hi Everyone, I've got a strange issue. I have a combobox populated through a query. All is well. Except for one machine, where the rows of the combo show as blank rows. The data is there, but it looks like a white font on a white background...??? Users don't have the option to change fonts or...
  18. Pampers

    create vba by mouse click/dynamically

    Hi everyone, I was wondering how you could write vba code dynamically, say by clicking a button. What I want to achieve is to add some mousemove-events vba for a form. Pampers [afro] Keeping it simple can be complicated
  19. Pampers

    Set next highest number in nvchar-field

    Hi Everyone, I have a table Customer with an AccountNumber field (nvchar20). The user can set this 'number' by itself. But if the user leaves it blank I want Sql server fill it up with the next highest numeric value in the column. AccountNumber (nvarchar(20) -------------- 000001 ABC9123 000002...
  20. Pampers

    set specific columns in a datagridview

    Hi everyone, I executed a stored procedure to fill a datatable (function 1). Then I bind the table to a datagrid that shows on a form (function 2). All is ok... But how can I limit the amount of columns in the datagridview. Not is showing all the fields the sp retrieves. Say I just want to see...

Part and Inventory Search

Back
Top