Search results

  1. A

    roundup or down to the nearest half is it possible?

    Check out: Int Round Fix http://www.599cd.com/tips/access/round-int-fix/
  2. A

    date values in query criteria

    Jeff, Beetle answered your WHERE clause question before. Since you want the month of October you use the Month function which takes a date and returns the Month so your Date Field is DOB so 'Month([DOB])', you wish it to be October which is the 10th month so your WHERE clause is WHERE...
  3. A

    date values in query criteria

    You might prefer the term 'Query Builder'
  4. A

    Cannot pass date from form to query

    Could it be the way access treats dates and the <= issue because of the time portion of it? Are you wanting them to match that exact day from the combo?
  5. A

    Cannot pass date from form to query

    I presume the field is set to date/time in the table/query you are searching in? Is the list you are creating the combo from in a separate table with a field type of date/time too?
  6. A

    Cannot pass date from form to query

    Try "#" & [Forms]![Formname]![controlname] & "#" You mention a combobox, what is its datasource? Does it have more than one column? You might need to use .column(#) property where # is column number, so then it uses that value as the criteria i.e. [Forms]![Formname]![controlname].column(#)...
  7. A

    Cannot pass date from form to query

    You need to wrap dates in # date # in Access
  8. A

    Mark a Thread as "Solved"

    Is this a possibility?? http://vbulletin-mods.co.uk/forum/4-x-x-addons/1740-mark-threads-solved.html
  9. A

    Crosstab Queries - Year wise query in Sequence without Skipping Years having no Data!

    Check out http://allenbrowne.com/ser-67.html You need to set the column properties shown about half way down the article. In query design view, show the Properties box (View menu.) Locate the Column Headings property. (If you don't see it, you are looking at the properties of a field instead...
  10. A

    double click

    So if you double click on on line in the listbox is it saying clientname? Even if you change it to clientname your criteria would be clientname=clientname which would be wrong You need the msgbox to say RecordID=1 etc Can you just open the Query that the listbox is based from and see what...
  11. A

    double click

    If you rem out the DoCmd and add msgbox stLinkCriteria what does it return?
  12. A

    double click

    The first column in the searchbox listbox needs to return a number since your criteria is asking to match [RecordID]= 'said number' Do you have another form in your database called "newform" that contains a Field called RecordID? What did the msgbox return?
  13. A

    double click

    What is the source of your listbox? Does it have the first field as RecordID? You could msgbox the value to see what it says depending on which row you double click.
  14. A

    Search Box in form

    Has the name of the Search textbox been changed to match the name you are using in the Query? When Access pops up asking for a parameter it's because it can't find the one you are passing it, usually due to the spelling.
  15. A

    Using table property in query

    Just create an update query
  16. A

    Access 2007 - Sum() Function Against Query

    Glad to see you got it working
  17. A

    Using table property in query

    Yeah just create an extra field (date created) in that table and set its default property as Now() so any records created will have it's created date attached, then add that field as a form header/footer and format as mmm yyyy and it'll take it from the query which you could filter with specific...
  18. A

    Search Box in form

    Here's a mini tutorial that might be helpful http://599cd.com/tips/access/multi-field-search-form-like/
  19. A

    Using table property in query

    You could use some vba Sub GetDateLastModified() Dim oFS As Object Dim strFilename As String 'Put your filename here strFilename = "c:\temp\find files.xls" 'This creates an instance of the MS Scripting Runtime FileSystemObject class Set oFS =...
  20. A

    Using table property in query

    So are you downloading say a csv file from a site which you are then importing into a db? Or is this a linked table from another data source?
Back
Top Bottom