Search results

Sorry I miss-understood your question, but Iv solved it now, I found a post by Baldy with a link on how to "Open a second form to the record selected on the first form, but still include all records" a bit of code changes and it works for me :) Dim rs As Object 'open the new form...

15945 total records in table, the form gets its data from a query of the SQL table

Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmForm" stLinkCriteria = "[DrawingNo]=" & "'" & [Text0] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria Sorry shoun't of changed it.

Hi we have a database frontend/backend and am moving the backend to an SQL server. This seems to have stopped the next and previous button working on the form although the add new button still works. The form is opened to a specified record via and another form using this code Dim...

thanks but i need it to work in the query, I cant believe ACCESS finds this so hard

in the case of frank clarke, 1 would return all in list 4,4,5 & 6 4 would return just the 4s null will never happen nor will 10

Im still stumped on this :(

added .mdb file

heres a stripped down db

im working on one now ;)

Hi Ari thanks both only half work, first one works if the number is in list (priority field) but shows no records if its not a match. second show all records if the number is in the list and all records if its not. If the number is in the list, filter only for the number, if not, show the list.

when I try that the true part returns all records when theres a match very frustrating these queries

this returns no records. if [Forms]![frmTRinput]![Text103] is 2 and theres no 2 in the priority field. If [Forms]![frmTRinput]![Text103]=2 and theres no 2 in the priority field I want all records in the filed to show

HI I have this in the criteria of a query field name priority IIf([Forms]![frmTRinput]![Text103]=[priority],[forms]![frmtrinput]![text103],[priority]) [Forms]![frmTRinput]![Text103] will be any number 1-7 depending on user input. Priority is in a table and might have any combination of numbers...

If anyones got an answer for this, it would be nice.

On investigation it seems that MS Project 2007 can't open .accdb file, it can open a .mdb file though. Converting my database back to .mdb is not an option. I believe MS Project can open a .accdb via ODBC but I have no idea how to set up a data source for that. So it seems my best option is to...

How can I transfer a querys results to MS project via an on click event. At present I transfer to excel then link project to excel but there must be a better way.

Thanks changed code to use late binding, works a treat now.

The situation: We have a split Front end back end database which is used to raise Technical Requests on our design engineers, approx 30 users, some are management. I have created a method that uses MS Project so the managers can easily see via a Gantt chart what his team has on and how to plan...

just new records