Search results

oh sorry, I know the solution already sorry, I figure out the solution already: use a update query as posted and update to : CDate(Mid([TextDate],5,6) & " " & Right([TextDate],4) & " " & Mid([TextDate],12,8)) thanks a lot anyway :)

How to update this text field into date field ? I'm import a CSV file which has the date in this format Tue Jul 12 12:32:35 2005, ..., .... Tue Jul 19 09:36:05 2005, ..., .... as the import wizard cannot recogize the field and fail to convert it into Date/Time, I import it as a Text field...

seems that conditional formating is very nice in Access2000+ , BUT how can I define a conditional format with more than 3 conditions ??? In fact, I have six colors for the user to select in a combobox , any idea ? Thanks :o

thanks a lot !! what a secret :eek:

:eek: oh !! the requery finally works (I had a wrong syntax of reference maybe). But the problem of knowing if a form is opening or not remains Help plzzzz :confused:

:confused: I'm having multiple forms working at the same time. All the forms contain a combobox to select "client" (limited to list). The idea is there's another form to manage the client information. However, I have no idea how to update all the combobox in other forms when I updated the...

OH ..... so simple :eek: i spent a whole night on it !!!!! anyway, is there any method i could know the current record offset ?

i'm deleting some records in subform after a combobox selection in mainform. However, after Me.requery (in the mainform combobox afterupdate), the mainform always go to the first record !!!! HOW could i go back to the CURRENT record in MAINFORM ???

i'm deleting some records in subform after a combobox selection in mainform. However, after Me.requery (in the mainform combobox afterupdate), the mainform always go to the first record !!!! HOW could i go back to the CURRENT record in MAINFORM ???

oh thanks! your answer helps building up my basic concepts :)

what's "FYI controls" ??? anyway, i found that DSum() should be used instead of action query in my case.

yes, great idea thanks :)

oh !!!! so clever and tricky !!!!! :eek: thanks :)

yes , it's not associated .... or , SHOULD I associate it ? and HOW to associate it ? i just wanna put the ONLY one result from the query into a textbox (which is bound) .... i feel so poor about how stupid am i :(

:confused: hello, I have created a summary query to calculate a "total" , the query is giving only ONE number (i.e. a table with only 1 row and 1 column) .... but , HOW could I get that value and put it into a textbox ????

hello, I have created a summary query to calculate a "total" , the query is giving only ONE number (i.e. a table with only 1 row and 1 column) .... but , HOW could I get that value and put it into a textbox ???? :confused:

thanks for your answer ;) in fact, i had a wrong design (trying to use an unbound textbox in a form to manage numeric fields across tables) . The problem was solved by creating the form on a query such that all the numeric fields are included and bound in the form Thanks again :)

oh ... that means , if i set the Decimal places , the .Value of a textbox will become numeric but not text ?

could you be nice enough to tell me which properties ? i can't find anything like "type"

thanks a lot :)