Search results

I would create a table to store the excluded job nos and join the tables using the job no.then run a query searching for unmatched data. No need to add any criteria just add the excluded jobno to your table If the jobno appears in your new table then it wont appear in your query then design a...

is it possible to add a field to your jobs table say "ExcludeJob" data type yes/no, then you could use 1 query to return all jobs who's "ExcludeJob" =false You could design a popup form to allow you to edit the "ExcludeJob" field from your main form and set 1 or all records to whatever you need

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) Dim NoOfDays As Single if isnull(me![Time In Days]) then NoOfDays=0 ' or any other value you may want to give it else NoOfDays = Me![Time in Days] end if Select Case NoOfDays Case 1 To 10 Me![Time in Days].ForeColor =...

Would running a query with owners permission solve your problem?

your data type FAMILY ID,needs to a number,at the moment you are trying to compare a number(autonumber) with a text value-even though your FAMILY ID may well be numeric,access looks at it as data type text

I may have misunderstood the question Pat I took the question to mean to update the table once-that is transfer the data,but i guess common sense says why would you do that

Take a look at this attatchment

try using the on print event for the report header to set the title me.txtTitle = MyReportTitle i got the same as you (blank title) but when i used the on print event the title showed

not that i know of Perhaps some one else in this forum may have a better answer for you

Tim I dont want to be a pain,but could i ask you another question In access when you create a table,for any text fields access sets the deafult of allow zero length to no.I assume there is a good reason. I havent had a problem with that up until i linked to a db that a vb app used for data...

this will only "Lock down access" to the average user If you go to tools,select startup, there you can select what form to show on start up,whether to show database window etc if you want to stop the right click etc set the forms shortcut menu property to no However this wont stop any one...

Sorry Laurie i mis read your question You could create a public variable to hold your value Public MyreportTitle As String then on the form that opens the report MyReportTitle =me.TxtReportTitle docmd.openreport YourReportname Reports![reportName]![titlename]=MyReportTitle That may do...

is the title on the report a text box? If it is why not set its control source to = Forms![frmReportHiRise]![txtReportTitle]

you could try to loop through each control on the form,locking everything except combo boxes, rather than using allow edits for the form.

Thanks Tim It is comforting to Know That there are professionals such as your self and all the others who use this forum , who are willing to share their knowledge and experience I only learnt how to use the internet last november and have learnt an enormous amount from forums such as this one...

Thanks Tim Yeah there are sure a lot of possibilities and this partivular user thinks its a simple task,His mind cant grasp that the human mind has all these powers of what may occur built in The computer Has not!!!,It has to be told(programmed) I have set it up so that if a user leaves a...

Tim I have tested at home on a network between 2 pcs and i thought what i had done was sufficient,as if my daughter selects the same job as me a split second later she gets the message that another user has selected that job and so it refreshes her screen to reflect the true state of the data...

not knowing exactly what your table set ups are i will try to help if your query contains the fields ,field state and, field city and the combo boxes are based on 1.cb1 table states 2.table citys then in your query the criteria would be field state criteria=forms![formname]![cb1] field state...

in the reports record source click to build a query include the two fields that you want to set criteria on and set the criteria as before field1 =forms![yourformname]![cb1] field2 =forms![yourformname]![cb2]

Thanks Tim ,i will take your advice and learn more about access locking strategies Pat I Will try to explain what the Owner of The business wants 1. he wants to have 3 users on 3 pcs to be able to allocate jobs to 3 different delivery runs,or maybe more in the future...