Search results

This works - kinda. It stops importing duplicates, but it wont import the data with "Master Project" in either I amended it to see if it would make a difference also - but it hasnt UPDATE ProjectsLinked LEFT JOIN ProjectsTable ON ProjectsLinked.NAME = ProjectsTable.NAME SET ProjectsTable.NAME...

Hi guys, I have a query which looks up a table and appends any additions which arent in the table. The problem is its importing duplicates can anyone tell me how I do an "if doesnt exist" on a column please? My sql is below: INSERT INTO ProjectsTable ( NAME, REFERENCE, NAME2 ) SELECT...

I edited it after realisng it didnt attach properly - the link should work fine? Cheers

Hi, Im using Access 2007 its the ActiveX control I mean, heres a picture of it and as you can see the days are really pale. Hmm image wouldnt display so heres the link http://imgur.com/5lq7B Thanks

Im using the MSComCtl2.DTPicker.2 date picker and when you go to select a date you can hardly read the days they are grey with a white background so they kind of blend in. Is there a way to change this or would I change the date picker? If so how? Thanks

Simple when you know how - thanks worked a treat :)

Hi - yep me again!! Im trying to do 2 things - learn some VBA and get my query to output to the report and close the query in the background. I can get the first bit going but it continues to leave the query open my code is: Private Sub ReprintTimeSheet_Click() DoCmd.OpenQuery...

You little ripper!!! its sorted - converted the date/time function which was set to Format() and is now DateValue() and she works like a trooper!!! Thanks!!! You got a double thumby thanks!!! :)

Excuse my ignorance but when you say drop the time part (which is the one which I think makes sense as I dont need the time value) how do I do this? Do you mean at the table? Or at the point of it being added? Or something else? Thanks

Ah right - no, I understood what Gemma meant with regards to midnight being the cutoff for the between dates but I didnt actually get the date part thing working. Could you check my context please as I have looked on the MS guide and what ever I try doesnt work =datepart(Between...

I did yes... Its not something with the form it must be with the data as it was happening from the query. As mentioned previously its got to be to do with the date and time within the table as any selection I make it takes off the end date (due to the 00:00 midnight thingy I guess???)

Hi, Yep its a Date/Time field and its in short date format. Its just the last date which isnt coming back - if there was a problem with the format you would think nothing would be returned? Heres the sql for that query: SELECT TimesheetTable.sUser, TimesheetTable.Activity...

Firstly thanks for not shooting me down when I asked the question instead of trying it first - I did infact try it was just about to apologise when you replied. So, Im right back where I started. I have my form which now has the text boxes prompting for 2 dates - but the results still miss...

Ahh ok I get it, thats why it wasnt working. I thought it was because it was asking for between dates - hence why the 6th wasnt showing as it wasnt between. So I am going down the form route, I guess I need to apply some code to my button to query the dates. Can I use the above example...

Ive tried the Between method but that doesnt work for example if I put between 02/01/2012 and 06/01/2012 then all I get is 02-05, no 06. If I then try the same again with +1 at the end it still doesnt work it says the expression is typed incorrectly or is too complex to be evaluated. I didnt...

Hi, Im guessing I would would need a select statement to get specific data but how do I get a prompt to ask the user what date ranges they want? Thanks

I already looked through that before posting. The problem with that example is that its not a prompt it specifies the criteria. The "working week" which I am trying to find will always have a different starting value but I would always want the following 4 days (5 in total) from the point...

Hi, Im trying to create a query which will allow the user to print a weeks report. My current method prompts for between but that doesnt work as the user would have to put a day either side to get the desired result. What I was thinking was prompt for a begining date and then add on 5 which...

Went for the yes no in the end as I already captured datestamps within the table so I could always query that if needs be. I seem to be having problems with my reports - but I better post that in the correct section :) Thanks again

I didnt get it to start with as I thought the same query would do both tasks but then I realised it needed the additional update query - she's working like a horse now. Thanks!!