Search results

Thanks David i can now get my date to save to the second table. It does throw up an odd issue though. If the day of the month is 10 or greater then it saves it correctly as dd/mm/yyyy if however the day number is 9 or less it saves it as mm/dd/yyyy I have checked all of my regional...

Sorry I am not making myself clear - I do appologise. I dont know how to write the time into the record on JANE as its not linked to the form I have open.

Thats fine on FRED but on JANE how do I find the correct record using the WRNumber from FRED and add the time stamp to that record. Sorry to sound so dim but I think I am :(

Ok this is probably childsplay to most of you. I currently have a form that I use to enter data to a table called FRED. On this form I have a buttom that sets the date and time value on the table called FRED to the current date and time using NOW(). That works fine. Now at the same time...

thanks guys, I have now managed to pull a simple text value out. I have altered the field I want to pull out to try and pull back a hyperlink. When I put the results into a textbox on the form it has a # at the start and end and is no longer a hyper link. Any suggestions?

JANR - thanks for the pointer, I had already found that link and couldnt get my ehad around it so asking you all was my last resort. DCrake - I have renamed the table so no spaces or special characters and have (I thought) altered the code correctly now, but I still get error 2001. My code...

Ok I have this code to (try to) pull some info out of a table depending on the value in my current form. I am just using the message box as a quick way to display my results for the moment. varx = DLookup("[Folder Location]", "[TABLE - WR & WBS Codes]", "Criteria = '" & Forms![ZZZZZ test...

can you give me a clue how to do the dlookup as I have fried my brain now with repeatedly trying and i need some expert guidance :D

I have a form [FORM - ENTER DATA] which I use to enter data about orders. This is stored in [TABLE - Enter Data]. As each entry is created it uses a combo box to pull an order number from a table called [TABLE - WR & WBS Codes] but stores this in [TABLE - ENTER Data]. [TABLE - WR & WBS...

Cheers Pat, that sorted it.

Thanks for such a great answer, that sorted my problem out 100% :D

If say I enter a date into a text box on the form how would I get that value into the criteria on the query ?

This is most helpful - thanks. Taking it a step further how could I run a report of a query but instead of typing the start and end dates, use a calendar on a form for thew user to select start and end dates?

how did you create the data in the Total Time Used column This may point us in the direction to help shwo you an answer :)

Hi I have created a query that produces exactly what I want and from that I then run a report. This is great until I then want to group the report by date. The table that the info comes from has the date created by the now() command so its in the dd/mm/yyyy hh:mm:ss If I group on the date...

Hi sorry for being a newbie and asking dumb questions but i have done my best to trawl the site using the search features but it turned up nothing. Anyway.....I am trying to impport data into access and append it all to one table. Currently the data is in MHTML format (dont shout at me yet -...