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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.