Search results

Changing dates within flash to be American mm/dd/yyy hh:mm:ss and having this stored in Access as UK date dd/mm/yyyy *due to windows locale settings. This SQL runs in MS access .... UPDATE UserOverallResults SET Results = 30 WHERE UserName = 'Rov' AND format(QuizDate,("mm/dd/yyyy...

Thanks for the reply. I amended my actionscript code and now the date is stored as "mm/dd/yyyy hh:mm:ss" which populates the DATE/TIME field (QuizDate) in the access database. TextDate is a string in actionscript which is used to successfully insert the QuizDate into the table as "mm/dd/yyyy...

Thanks for the reply, the spurious bit n bobs are due to the fact Im using Flash mx (not really the best language to use in conjuction with access!!) The extra back slashes are to print special characters like ". IM tempted to jsut save the date from the beginning in US date format. Then worry...

mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = 10 WHERE UserName = 'Rob' AND quizDate = #02/19/2008'") This works too, so it doesnt like the time section ... hmmmmm

I tried the code below and still get error: mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = 10 WHERE UserName = 'Rob' AND quizDate = format(#02/19/2008 12:03:32#,\"general date\")"); I can't believe it has no problems with the INSERT where textdate is a STRING in...

Thanks I was just looking into that !! mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = 10 WHERE UserName = 'Rob' AND quizDate > #02/19/2008#"); Works!!! But complains about ... mdm.Database.MSAccess.runQuery("UPDATE UserOverallResults SET Results = 10 WHERE UserName...

Greetings, I'm using flash mx and MDM zinc which i assume connects using the JET rather than ADO database engine. For the life of me cannot get a simple update to work due to the dates involved, lost count how many hours have gone by trying!!! Within access I can easily switch quotes and...

Thanks for the replys. I do only want to record who OWNS the Q&A (who created it). Though I also would like to know who UPDATED it, which currently I cant do. As far as recording the views, Im not interested in individuals I will write code to update the view count only if the user has...

Thanks for the reply. Well I read about another method and attempted to implement that. Ive captured a screenshot of my form. The problem is the USER must be able to search records by NAME and NOT ID. The combo box however is bound to the Module ID as the TWO subforms are based on the...

Thanks for the response. The link is to record which USER has added the Question and Answer. One FLAW Ive spotted already is it wont record who UPDATES the Q&A (only datestamp it) only the creator will be recorded. The reason I have implemented it fully, is I didnt mention Im using Access...

Greetings, I'm designing a simple FAQ system. The primary aims are as follows :- * Allow a choice of category to display Question and Answers * Allow a sequence to be provided to display Q&A's * Allow user to rate the advice * Record the number of times the Q&A viewed * Record the initial...

Greetings, Using the button wizzard I am able to create a combo box that searchs for records and display data. However I cannot add NEW values to the list, I cannot change the properties of the box to allow this. Is it possible to use a SINGLE combo box to allow a search facility and an ADD...

As the value is on the form cant I write it to the record uisng vba code (provide basic syntax/example)? Obvioulsy complication of writing it when the navigation button is pressed to move to the next record.

Hi Rich, I thought VBA was the way forward to write the value of the form into the table field. Can you expand on the use a query to retrieve the value? In the query the calculation is not bound to a table just the form value. Cheers Rob

Im sure this is a common problem, I had a nasty shock when I discovered that calcualted fields (from a query) in my subforms are NOT stored with the database though the control source is a table field they are not bound to a table. What are the most popular ways to solve this? Easier the better :)

I just needed to requery the subform !!!! I'm going to look at changing it to create a new record (with a whole new set of problems no doubt!)

Thanks for all the replies, I was doing some JSP work and now Ive come back to access. I had read there were issues using DoCmd.RunCommand acCmdRecords from the main form. Anyway the focus goes to the desired subform.control (I know this as Its the second textbox and not the first). If there...

Hmmm I may add a combo box to allow them select the type of edit mode. Why something so simple to go to the last record should be this complicated I will never know. I havent used Access for very long (collectiveily around a month), frustration!

Greetings, I have a main form. Upon filling in a combo box it then displays a subform (based on a query that uses values in the combo box on where clause) THe subform has the paramater Data Entry = 'No' as I want users to see all existing records and all additions/deletions and edits. However...

Greetings, Has anyone come across a problem where if you run a query via query design it retrieves results though if you run it through forms it retrieves 0 rows? I have a subform based on a query, when in the design mode of the form to ensure im using the correct query its runs without errors...