pks00
Last Activity: Apr 9 '09, 05:45 AM
Joined: Oct 26 '06
Location:
-
there is vb.net code here http://www.codeproject.com/KB/vb/Pow..._in_VBNET.aspx which you could possibly adapt. Key thing here is the imports used. Given this you can do the equivalent in C++.net -
try pressing the shift key and keeping it pressed then opening your db
u may need to do this a number of timesLeave a comment:
-
Wotcha Aj, its cos u got OR in there instead of AND.
Try changing it to that and see what happensLeave a comment:
-
The controlsource should be set to the fieldname thats in your table. That way u ensure that textbox is bounded to that field. Any changes u make then are reflected in that textbox.
Now I assume you want this for new records, have a default date of Now()
You can do this one of two ways
in table design, u can set the default value to be Now() so that way no coding is required
or you can set the Default...Leave a comment:
-
Have u got the latest MDAC installed?
read this LinkLeave a comment:
-
Do you mean you want to go to the last record displayed in the subform?
You could try this from the mainform - use the afterupdate event of your combobox to do this as u want this to happen when u make a change
Me.<<nameofmysu bform>>.SetFocu s
DoCmd.GotoRecor d , , acLastLeave a comment:
-
You could always create your own popup form, make it look like a message box. Ensure its set as popup and modal.
That way you can change colour and font style to your hearts content :)Leave a comment:
-
u open the db to run some code. this code, is it reopening same db?Leave a comment:
-
Can u create columns in your xls file then import it but specify it has columnsLeave a comment:
-
I would think that using WinInet would be the best approach
Note its great for small files, I dont think its that great for large files
http://msdn.microsoft.com/archive/en...asp?frame=true
search google and u should find examples...Leave a comment:
-
is that database already opened when u run this bit of code?Leave a comment:
-
I prefer the use of vba because u want to validate both start and end dates - thats if both are entered by the user.
Its possible for someone to enter a end date then a start date
eg
...Code:private sub ProjectStartDate_BeforeUpdate(Cancel as integer) Cancel = ValidateDate end sub private sub ProjectEndDate_BeforeUpdate(Cancel as integer) Cancel = ValidateDate end subLeave a comment:
-
Access dont do stored procedures else that would of been good.
Only way I can think of is u write the vbscript to open up the database, setup a querydefs object and extract the SQL. Then u use this sql in your ado recordsetsLeave a comment:
-
Do you mean you want the records in your table sorted in that order?
Why would u want to do that, u simply need to write a query as already shown and that is it.Leave a comment:
-
Ok, I did it on the understanding that u wanted it disabled when u had your default value of 0. To me it wasnt quite clear that u wanted it disabled when nothing was selected.
Did u know already to use the Keypress function and also to use the .Text property and not .Value?Leave a comment:
-
I left it as variant just in case invalid string is passed i.e. something that isnt a date or doesnt have a space....Leave a comment:
-
DMAX is used to determine the maximum value of the specified field in the specified table. Third parameter is optional, u can specify some criteria.
Its just a quick way of getting max value. In access, if u hiliite DMAX then do F1, u will get more info
i.e. taken from help page
You can use the DMin and DMax functions to determine the minimum and maximum values in a specified set of records (a domain). Use...Leave a comment:
-
You get that error if the database is already open
Close all instances of the db then try running your codeLeave a comment:
-
Looks like you have hit a limit and there isnt much you can do except rethink your solution http://support.microsoft.com/kb/187342Leave a comment:
-
Looks like u got some work to do in reorganising your DB
http://support.microsoft.com/kb/289686...Leave a comment:
No activity results to display
Leave a comment: