Search results

Great thanks, apologies though as I dont think I mentioned previously. The export is triggered from the Private Sub ExportCSV_Click() so wouldnt I need the click to append a tick to the Exported column so they wouldnt get exported again? Thanks

Hi peeps!! Im not entirely sure how to achieve this, I would like to setup an export which exports only newly added records from a table to a csv. Currently I have an export (based on a query) which exports everything. Would I need to create some sort of flag which indicates a record has...

Thanks, worked a treat. :)

Hi All, Im trying to create a generic query which will pull data from a table based on the logged in user. I have a module which pulls in the windows username but cant seem to get the query to work - it just pulls in all data from that table. If I use the criteria which is assigned to that...

But Im not getting prompts??? Its complaining about parenthesis :s

Do you mean not putting enough information? If thats it then ok, Im trying to create the discussed output of a minimum date from a set of data. I have tried using the expression builder to build my code as below =Min ( [TimesheetTableTemp]![Task Date] ) But it says that the expression you...

Im trying to use the expression builder to do this with no avail. Any chance of a hand please. Im clicking (for now)....=Min ( [TimesheetTableTemp]![Task Date] ) shouldnt that show me the minimum date in the column? Thanks and apologies for being a thicko :(

A user completes a form based on 5 days. What I would like to output is the first date in the 5 days and the last day in the 5 days so I get the week begining and the week ending.

Legend - worked a treat thanks. The same report has start date and an end date, I dont suppose you know how I output that to 2 text boxes do you? Thanks again :)

I seem to be making a right lash up of this, the previous post I deleted as it wasnt relevant. So the problem with this is. If I have a text box which should display which week number the task date field is referring to as per this code =DatePart("ww",[TimesheetTableTemp]![Task Date]) Access...

I get an error when i try this - the code is =DatePart("ww",[TimesheetTableTemp]![Task Date]) Thanks

Apologies - I have infact sorted it. The problem was that the fields I referred to werent correct and so the reoprt was populating another users data rather than starting blank and then populating the current users data. I've still got my Access "L" plates on :)

Hi all.. Im trying to calculate a week number of a submitted report. Im guessing the way to go about this as I capture the date the user is referring to I can calculate which week number that date falls in? my question is how do I do it? I tried =Format([TimesheetTableTemp]![Task Date],"ww")...

Afternoon... Im trying to create a base\template report which users will use to print thier forms with. The problem being the report doesnt seem to clear down the results so it starts with a fresh copy of the report. Is it something I am doing incorrectly? Thanks

Hey, Thanks for the replies, I managed to do it using DoCmd.OpenQuery "ImportNewProjectsQuery" Thanks again :)

Hi all... I have a query which checks a table to see if there are any new additions to it (the table is a linked table). Can anyone please tell me how I get the query to run on startup of the database? Does it require some VBA? Thanks

I thought I did in one of my earlier posts? The data from the spreadsheet populates a combo box in which a user makes thier selection. Once selected along with other inputs they then submit the form selctions to a table.

Currently I have a combo box which lists projects, to start with I just have a table. But the finished product needs the table to be updated from a spreadsheet, which occasionally gets exported from a different application and will be imported to Access. Im trying to work out the best dynamic...

Im not too sure if this is achievable but thought I would ask the question. Is it possible to link a new table to the spreadsheet so the data within that table is always up to date then some how (maybe using a select type query??) import whats different between the 2 tables based on the criteria...

Is it possible to specify criteria on this? So I would only import the data which contains say "live data" in the "current status" column? Or would I import all the data then filter out what I want people to see within the combo box?