Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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