Search results

Specifically, you need to delimit the literal string representing your userid in the SQL statement. But ... I have some more comments on your code: - The .Text property is not really used as you are using it. To retreive a value that is shown in a text box, I would suggest the use of...

... By the way ... you can create many subform controls on a main form that use the same Form object as the Source Object... But I personally do not like to do that too often...

If you like that presentation style of the Tab Control that is fine, but I would suggest that you only use ONE sub-form control, just as Gemma suggested, but with a bit of a twist....Don't place the sub-form control IN a tab on the TabControl .. but place the sub-from control OVER the tab...

>> at which point the time (minus Indiana) << Just to confirm a thought previously posted ... Indiana now follows DST rules. Some of Indiana is on Central, some is on Eastern.

Ok ... a check box will return a value of True (-1), False (0), or if it is unbound and has the triple state property set to yes, then a Null can be returned as well (I recommend setting the Triple State property to no ... The DoCmd object acts upon the object with the focus, so if you use...

Also ... are you using and ADP or MDB ... plus (if using an MDB) .. is your data stored in a database other than Access/JET?

I do not beleive that your connection via ADO caused the issue you have experienced. If you were still able to open the database AFTER all this occurred, then that gives credibility to the conclusion that your ADO connection and SQL statements were probably not the culprit. Splitting the...

So ... is the data STORED as Text that is "QM00156"? ...

Hello Danmac ... Sorry to be so long on a reply! ... I have been busy of late, and I am just getting around to returning to AWF ... so ... in response to ... >> Could this possibly be an indicator I need to use your ADO version? << Yep ... you definately need the ADO version with an ADP...

I would probably go a route like this ... {Note: this is AIR CODE!!! ... also, I assumed all values were numeric, if they are not, then you will have to add single hashes around the text values} Dim frm As Form Dim db As DAO.Database Dim strSQL As String Dim x As Integer Dim y As Integer...

>> Would I be better off to shrink all these check boxes down to one Long << Nope ... you'd be better off normalizing your database. Which means you would have a child table that records the date and the status of the parent record, then in a query you can always get the latest status, plus...

Hello Mike ... It appears that your date format is dd/mm/yyyy .. which is fine .. is that a SYSTEM setting .. or has your field or datasheet view been told to format the date that way (ie: a Format property has been set to displaythe data in that format). If you are setting the filter in the...

Just some additional info to add to the fine advice you have already received ... ..... If you keep your empno as a TEXT field ... I assume you know the length you wish to have the value ... ie 6 characters (001234) or whatever. So ... when the data is input, it is important that you pad...

Any reason the Choose() wouldn't work? ... No need for VBA or a Table .. ??? ... just curious as I am thrilled a solution posted does the trick for you! ... but just wondering the advantage of the IIf() over the Choose() ...

In this case I would suggest the use of the Choose() function in conjuction with the Format() function ... Choose(Month([DATESENT]),"Janvier","Février","Mars","..etc..") & " " & Format([DATESENT], "d, yyyy")

There are a couple of options ... 1) While the file is in Excel, you can use Excels function named CLEAN(). 2) You can reference the Excel Object Library in the Access file and use CLEAN() again. In the VBA editor, use Tools > References, then click on the Excel Object Library, then create a...

Just a point of note ... Time() still sets the field with a date component, its just that the date component is 12/30/1899 ... ... It is my contention that having two fields to indicate a date and a time is not a good design practice and will eventually lead to issues that will require...

PMFJI ... As an FYI ... I beleive I have used something like this with succuss ... Instead of: Vacation Used is =frmVacationSumSubform.Form!SumOfHours Used something like: Vacation Used is =IIf(frmVacationSumSubform.Form.CurrentRecord = 0, 0, frmVacationSumSubform.Form!SumOfHours)

One thing to note about Date/Time fields ... you will ALWAYS have a date component and a time component. You see date/times are stored as a number (a Number/Double) to be exact. The unit of measure for that value is "Days". The value is the number of days aways from a base date. The base...

I would suggest to turn off the 'Name AutoCorrect' feature too. .... In addition here are some other tips .. - Set your recordsource of the form to a limiting or empty recordset, something like: SELECT * FROM SomeSource WHERE 1=0 Then modify your recordsource to a populated recordset in...