Search results

hi thanks for the reply at first I didn't understand your suggestion but yes I can see how that would help will give it a go this week thanks again

I have been tasked with converting a series of excel sheets into an access database to allow multi user entry the main table will have a product name - desc in image below - and some fields that are required for all records but also a raft of other fields that only certain records will...

So I just did a re-link between my back end and front end, closed the form corresponding to the multi value field table, re-opened it, and now it works :)

Hi hoping someone can point me in the right direction before I pull out all my hair ! Until recently I didn't realise that access 2007 and above could do multi-value combo box fields I have got it working in table view however when I select multiple values in form view and click OK...

hi thanks for reply I think I am on SP2 but will check below is the xml I got from the web <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> <ribbon startFromScratch="true"> <tabs> <tab id="MyReport" label="Report Print and View Options">...

I want every report to have an Export to Excel option in my 2010 runtime apps I have created USysRibbons table and copied sample XML code from the web in The ribbon will show but specifically <button idMso="ExportExcel" size="large"/> does not seem to show ?? Is that because it is...

hi yes field1 is just the staff id ( numeric ) now getting "data type mismatch in criteria expression" assume it is the min(field3) as field3 is a text field bet you wish you hadn't replied now :)

Hi sorry for delay in replying it is access sql so I have changed it to Like "*+" I have also replaced my stripped out field "clock" with the original "field3" however I am now getting syntax error. Can't see how TimeValue will work on the string field3 when it has . and + in it ?? new...

Hi my new sql is as follows:- SELECT DISTINCT Clockings2.field1, Clockings2.field2, TimeValue(Format([clock],"Short Time")) AS StartTime, TimeValue(Format(Replace((SELECT First(clock) FROM Clockings2 as Tmp WHERE field1=Clockings2.field1 and field2=Clockings2.field2 and...

thanks CJ for the reply your questions.... time came in as 19.18 I have used text functions to work out the position of the period/full stop and then created a field called "clock" with format of short time the examples were for 1 person - clockings for 11th and 12th shown no order I...

I have been tasked with importing data from a clocking on system to analyse worked hours. There is no option to amend the format of the export which is not great surname forename Field2 Field3 xxx xxx 11/06/2013 19.18 xxx xxx 11/06/2013 5.37+ xxx xxx 12/06/2013 5.41+ xxx xxx 12/06/2013 19.21...

Many thanks to both Bobs :D got there with this DoCmd.ApplyFilter , "[next contact] Between " & Format(Date - 1, "\#mm\/dd\/yyyy\#") & " And " & Format(Date, "\#mm\/dd\/yyyy\#") it didnt like Me.Filteron ? funny how i had to change from date , date+1 to date-1 and date oh well...

Hi tried that and get syntax error ( missing operator ) in query expression '[next contact]>=#21/09/2012# and <#22/09/2012#' strange that it doesnt return an error without the <

thanks for the suggestion shouldnt there be a < in there somewhere ?? I assume you are trying to do a between statement ? anyway it does return 2 records but strangely one is less than today 28/07/12 and 1 is after today 29/09/12 ? :(

nope - still get no records returned thanks for the suggestion though

this is driving me nuts ! I have a form based on quite a complicated query I have a button to filter the results to show only records where next contact date = todays date ( next contact is a calculated field ) the button has code DoCmd.ApplyFilter , "[next contact]=" & Date i have...

Hi In an Access continuous form detail section how can you display progress of orders graphically Each order has to go through five stages the query will calculate for each stage whether the order has completed that stage ( based on dates in and out of each department ) I want the form...

thanks got it working using a form with subforms rather than reports found that reports in access 2010 can have an On Timer event procedure but not access 2003

help ! I have designed a database for a sales team to record orders taken etc they currently have a whiteboard where they mark up orders taken for each day - they want to replace this with a large monitor and display the info automatically from the database. I have created 2 crosstab...

can handle simple access programming but I am not a programmer as such access 2003 database - i have a hyperlink field on a form with a button next to it which saves the user doing right-click edit hyperlink problem is that it defaults to the folder that the database is stored is there a...