Im using a colour picker to change the colour of a text box on click. I need to store the colour in the text box. At the moment it changes the colour of the text box in every record. How can I overcome this? Thanks!
I've been updating the look of some of my db's and am trying to access the new style colour picker per Office 2007/10.
Up to now I have been using
Private Declare Function ChooseColorAPI Lib "comdlg32.dll" Alias "ChooseColorA" (pCHOOSECOLOR As ChooseColor) As Long
which displays the pre 2007 style.
I've looked all over the web but cannot find anything relating to the current style (other than using it from the ribbon or control properties), so not sure if I should be looking for a different function or a change to the ChooseColor type values.
All db's are running 32bit access and at the moment 32bit OS but will no doubt have OS upgrades to 64bit soon.
I've been trying to get a datepicker working in Access, unfortunately Access doesn't really seem to support it very well. I suppose I could make my own if I had to.
I miss VB.NET. VB.NET had built in date functions that allowed you to do a lot of things with dates. VB 6.0 has hardly any such functionality.
What I'd like to do though, is to be able to figure out which day of the week any given date is on. I don't want to write code like that myself, it feels like it would be too much work. Does anyone know of any code that would help out with a solution like this?
I want to let the user to select the date and time by showing a control/screen fot this. I used the MS access control: Microsoft Date and Time Picker Control 6.0. however, this doesnt show the date properly. Is there any Fully Free software that I can use to show a screen to allow the user to pick the date and time?
It would be nice to have a date picker, to reduce input errors.
I'm trying to get a combo box datepicker to work from a popup form. I've looked at fontstuff's version (http://www.fontstuff.com/access/acctut13a.htm), but it has the date on the main form (as do the examples I've found using search).
I have to run two queries to get the data I need, and the best way is to have them called at the same time from a macro - hence the popup form. If I use a text box txt_Date formatted as a date box forms![GetDate]![txt_Date] works fine. How do I get the variabe txt_Date to accept the results of the three combo boxes as a single date value?
Here is what i need help with i have the basic lay out but i just need someone to help me figure out the rest of this. Attached is a sample database with what i am trying to do. if someone would be so kind to help me figure this out that would be great.
in access xp, there was a handy active x DTP. it doesn't seem to be available in access 2003. is calendar control 11 there only option here?? it really isn't as convenient as the DTP. maybe there's a way I can make the calendar control operate in a similar way to the DTP?? or maybe there is a DTP but its called another name in the active x list.
I am using the Date Time Picker in MS Access. When I transfer my database to another computer the control shows as a blank white box. I have already done regsvr32 to register the relevant ocx and ticked the Microsoft Windows Common Controls -2 6.0 (SP6) in the reference box. Is there any other way to repair this control without having to reinstall the whole thing.
Is it possible to change the format of a date picker, for instance once i have selected a date, its is visible as 09/11/2006, can this be edited to just the month and the year 11/2006.
I have a form with a date picker control. I am not able to set the default value of the picker to the current date. For example say If I set the default value to "Today", i.e 11 Oct, Even tomorrow it will retain the same value "11 Oct" and not "12 Oct". Is there any way that I can set the default value to current date?
I solved my last problem by not using the ActiveX date picker. Now the date picker which I am using is really good.
But my new problem is that my date picker has a format of dd/mm/yyyyy. Also the format in my database is the same. But when I try to store to store the date value through the querry, the format stored in the database is mm/dd/yyyy. I dont understand this cos I checked the the date picker passes the correct format. I am totally confused!!! (as always)
Does anyone know how to store the correct format in the database..?? This is my querry strSQL = "INSERT INTO projet (id,code_NOP,client,libelle_projet,id_clarity,tech nologie_projet,em,date_debut,date_fin,site_mandata ire,charge_totale,ca_total_vendu) values('" & txt_id.Value & "','" & txt_code_NOP.Value & "','" & txt_client.Value & "','" & txt_libelle_projet.Value & "','" & txt_id_clarity.Value & "','" & txt_technologie_projet.Value & "','" & txt_em.Value & "',#" & Format(txt_date_debut.Value, "dd/mm/yyyy") & "#,#" & Format(txt_date_fin.Value, "dd/mm/yyyy") & "#,'" & txt_site_mandataire.Value & "'," & txt_charge_totale.Value & "," & txt_ca_total_vendu.Value & ");"
I am operating in MS Access 2007 and unfortunately have to stick with the "out of the box" controls. I have data entries of notes in my database for "most workdays" - but not holidays or weekends. I want to allow the user to be able to edit notes for "most workdays" - but not let them pick a day to edit that doesn't have notes - by selecting them from a calendar date picker. Essentially, I want to gray-out/lock the non-workdays from editing.Is there a smart enough Active X or other control as a Date Picker that uses the results of a query to show valid/invalid dates?
I have a form (Access 2007) that requires user to enter a date.
Using the standard date field (short date format) with the date picker works fine however some users prefer to enter the date via the keyboard (some prefer the date picker).
If I set an input mask (to facilitate keyboard entry) for the text box then the date picker disappears.
Is there any way to apply the date picker and the input mask to the control to accommodate all users?
I changed this text box format to General Date but I do not have the date picker icon when I click on the text box. I also noticed that for this text box in the property sheet, it does not even have the date picker option listed. I am trying to do this in a report header.
I have a parameter query that requires the user to input a start date and end date into dialog boxes generated by the query. My question is: it possible to have a date picker control actually on the dialog boxes when they show for a date to be entered, or is this only possible when using a form with text boxes to generate the dates for start and end dates?
This isn't the standard problem with DTPickers & Tab to which I've found lots of references!
I have a form with a Tab control, each page of which has a subform on it. There are several MS Date & Time Picker (6.0) controls on each tab. My problem is this: whenever you change tab when one of these DTPickers has the focus, you then can't type text (into a text or combo box, for instance) on the new tab until you have been into and out of another DTPicker control! (The KeyPress etc events do get triggered though). Once you've selected a DTPicker, you can then select another control and type text in OK.
The forms/controls aren't bound if that's relevant. It may be that the problem is caused by moving between subforms rather than between tabs.
Has anyone else had trouble with this? Is it a bug or expected behaviour (though I can't see why it would be)?
And most importantly, how can I get around it? Hope someone can help.
disable the data picker for every field on every form in my application - without doing it the long winded way of manually turning it off for every field?
Is there some kind of Time picker function , i can see the date picker however i am using a booking system and have a field named 'time of booking' and i need something that can dump the exact system/online time into the field.