Search results

To save anyone the headache make sure to use Int function in every section or it wont work properly. Like so... Newname:Format(Int([YourFieldName]/3600),"00") & ":" & Format(Int(([YourFieldName]-(Int([YourFieldName]/3600)*3600))/60),"00") & ":" & Format((([YourFieldName] Mod 60)),"00")

Just to let you know it worked for me. Thanks for link.

Thanks theDBguy I'll have another look out there; it's like raking muck tbh. But the knowledge it can be done makes me more resolute.

Anybody? Even if only to tell me it can't be done....

Double clicking the accdb file will open the file. Surely that works?

Hi Good People of AWF So about 8 years ago I wrote this fabulous (I think) application for a client who then decided he didn't want it (long story) so it lay in folder untouched gathering dust. Anyways, the bit you've been waiting for, I've been asked for exactly that db and when I tried to...

Thank you for your reply will try to implement and see how we get on. Will I be able to use this dynamically? Or will I have to type the switch query for each Area in the database? Thank you

I have a listbox on a form which displays properties(realty) that match the CityID of the property applicant. I also have an areaID within the city. I want to create a query which will return all property in the city the applicant is interested in but will order by the properties which match...

Hi, That was the entire query. I deleted original qry segment by segment to trap the part that was causing the problem. You are right I didnt need to use it - just wouldve saved time rewriting a specific query for this form. Using Access BE. Thanks for comments - was driving me mad more than...

Hi All, Opening a form with filter ([ContactID] IN (SELECT ContactID FROM tblBuisnessAddress WHERE tblBuisnessAddress.postcode LIKE 'w1*')) takes a crazy amount of time. (60 sec for 450 records and a few minutes for 1000's). BUT... ([ContactID] IN (SELECT ContactID FROM tblBuisnessAddress...

Hi, I have a search form which allows to search for various criteria such as postcode. The code for building the filter is as follows: varWhere = (varWhere + " AND ") & _ "([ContactID] IN (SELECT ContactID FROM tblBusinessAddress " & _ "WHERE...

Thanks Paul you are a genius. This was actually the data source of my form listbox so you can multiselect students and the added students would jump to another listbox of added students. You have saved me from a suicide pact with my computer. Thanks a mill:):):)

Hi Thanks for replying I don't know if I'm making myself clear. I have created the following query. SELECT tblStudents.* FROM tblStudents LEFT JOIN jtblStudentSession ON tblStudents.[fldStudentID] = jtblStudentSession.[fldStudentID] WHERE (((jtblStudentSession.fldStudentID) Is Null Or...

Hi, In the format tab of your combo proprties set your bound column width to zero. Alternatively you could change the order of your columns in the query and amend the bound column accordingly. hope thats some help Mike

Hi I am having real difficulty here. I have tblStudents (StudentID, Name etc.) and jtblStudentSession (SessionID, StudentID). Can someone please advise how I would query which Students are not registered for Session x. The unmatched records part is simple, what I cant work out is if how to...

Hi I have a continuous form which displays contact names and addresses, and a search box to filter records. Once the required records are displayed I would like to use a cmd button to send the records to MS Word. Can anyone tell me please how could i reference the form recordsource in the SQL...

If one would do it this way round i.e. update each table separately, how would you reference the OrderDetails to the new order? Basically; how would the tblOrderDetails know which order it related to? Unless you added a new PK for repeat orders......?

Thank you for your help guys. Seems straightforward (but then it always does ;) Will try implemeting......... Mike

Hi I have in my sales database tblOrders and tblOrderDetails. In tblOrders there is an option to flag this order to be repeated yearly until further notice. The trigger will be a button to generate this years repeat orders. Please can someone advise the ideal way to create these new...

I'm no expert, but as long as the subform is linked correctly through Master and Child Field properties it should display the related records in the subform as soon as you go to a new record in the main form. Have you tried going to a new record manually, does it still not update the subform...