Search results for query: *

Hi I have converted a word document to '.pdf' using Adobe Acrobat Proffessional v6. We would like to have the file expire after a timeframe and in effect making it unable to be opened. This would achieve quality control and prevent old information from being accessed. Any advice would be...

Thank you

Hi I have converted a word document to '.pdf' using Adobe Acrobat Proffessional v6. We would like to have the file expire after a timeframe and in effect making it unable to be opened. This would achieve quality control and prevent old information from being accessed. Any advice would be...

Hi ken Please disregard the last post. I have worked it out using List0.Hyperlink.Follow which works fine for the a doubleclick event. Can I call up a search dialog box to select a specific drive where multiple cdrom drives exist? Cheers

Hi Ken Thank you again, the hyperlink seems to be the way to go. I would prefer to display the data in a listbox however it seems that the hyperlink doesnt work from the listbox. I bound the colomn containing the hyperlink so can you help with the click event code or is there a better way? Cheers

Thanks Ken My appologies Our employees use notice books containing a unique reference for each notice issued. The data is then entered into the database using the unique reference of the notice as the ID. The paper copies are then stored in archived binders and put away. To ease the process of...

Hi all Cant really find too much on this subject. I want to be able to open and view a pdf file of the users choice from a list box. The location of the files would most likely be on a network drive or cd. The specific file reference will be stored within a table. My question is how to...

Hi Ken and r937, You are not going to beleive this but i feel quite embarrassed. My query was working fine right from word go, because the date feilds on the form were blank it returned no records because it was looking for blank feilds ((obviously)). I have constructed a work around to ensure...

Hi Ken, I am not using code in this instant. I have created the query in the design veiw window and assigned criteria from there. All the 'Like' criteria work fine. The 'Between' dates criteria causes the problem. I did try to write the criteria using your solution in the SQL veiw window but it...

I have created a query with multiple feilds and assigned wildcard criteria linked to my form to each feild. The following is an eg. LIKE "*" & [forms]![formname]![formfeild] & "*" this works fine when the query is run. I have created a form with the intention of the user...

Hi all, The keyword search is down for maintenance so here goes. I have created a query with multiple feilds and assigned wildcard criteria to each feild. The following is an eg. LIKE "*" & [forms]![formname]![formfeild] & "*" this works fine when the query is run. I have...

Hi all, Your suggestion Fran made me take a closer look at the FAQ and follow process more precisely. I realised that I didnt follow the last point of creating a new database and importing all tables etc to remove the open/run properties. I think the most important point is to remove all...

Hi all, Well well!! I cannot beleive this but the security has failed again. It was all working fine, the database was placed on a network and only those with access and permissions could open it. I tested it on a number of occassions and from different computers and I thought it was a winner...

Ensure the list box has got focus and then use the arrow keys on the keyboard

Follow jeremy's advice. I had a similar problem and found that you need to create the worgroup first before running the security wizard. Read the FAQ in jeremy thread above.

Jeremy, I followed the procedure in the FAQ and thank you it worked. I originally created the database and then applied the security wizard to create the workgroup file instead of creating the workgroup first. This obviously isnt the way to do it and I still dont fully understand why it doesnt...

hi all, I have just read all the messages in this post and i think you have all lost the context of the original question that was asked. I have exactly the same problem. The database security features work fine on a single pc that the database was created on. I have put the database and the...

Hi, You will need to ensure you have set the relationship between all 3 tables before continuing. The easiest way would be to create a query under the queries tab. Press the new button on the right and its up to you but it might be easier to select the simple query wizard. Select each table and...

Hi, Thanks for that, I didnt realise I had used the date syntax. Big day and started to get frustrated. Thanks for the tips. Cheers :-)

Hi, I am trying to create an sql with to criteria. 1. being the region and 2. between dates. strNotChartCount = "SELECT * FROM tblnotice WHERE Region = #" & strRegion & "# and IssuedDate BETWEEN #" & strStartDate & "# AND #" & strEndDate & "#" The syntax...