Search results

Thanks for the reply... I find using the security aspect of Access (workgroup, users, etc) totally overwhelming so have gone for a custom log in form with startup code to prevent access from casual users (hiding all design views along with shift key disabled, etc)......still haven't worked a...

Hi guys, I've seen different log in forms and tips on multi-user use but can't seem to find info on the following... We have 6 people at work and I'd like to assign which user updated a form or created a new record...this would be particularly useful on the sales part of the database to track...

Thanks for the reply Guus... Took your advice and re-designed the form - with 53 skills and counting I realised listboxes were not the way to go and the hideous make table, append routines were so cumbersome they are now a thing of the past... So (with your advice) - I now use one Job...

Candidate Skills Database Thanks for getting back to me... As requested, please find the attached db for you to have a look at... Many thanks in advance dazza61

Hi there, The recruitment database I have designed for work is okay in the main except for where I need to filter candidates depending on their skill sets. What I need to be able to do is filter candidates that possess ALL skills selected in a multiselect listbox... Table structure runs as...

Thanks for the reply Rich - been away a while hence my delay... I totally agree with the present message box as it covers if the printer screws up (out of ink, paper jam, etc)...but I'm still stuck... I pull all unprinted timesheets (using a query) into a report/subreport combo that you can...

Hi guys, I have a report with a subreport... One of the fields in the subreport is a boolean field called 'Printed' I've tried setting this field to 'True' in the OnPrint and On Format events of the detail section (which is where the 'Printed' field is placed) but I keep getting an Error 2448...

Listbox problem... Managed to sort my problem by making a temp table, appending necessary records and filtering /bit of VBA to get the desired result. Now I can choose any position/job role and find candidates who match ALL the skills criteria that are attributed to them. I also managed to get...

Listbox query problem Any takers on this one - ? I'm just really stuck at filtering records from 2 listboxes where the second listbox is set to multi-select... Many thanks in advance dazza61

Hi guys, I'm working on a company recruitment database. I've stripped out where my problem is and attached the relevant file/tables/queries, etc... I have a form with 2 listboxes (left and right) that are used to select various combinations of employees depending on job role and skill types...

Hi there, Been struggling with this simple thing for days now... If I move through a listbox by using the keyboard (NOT the mouse) to display the seletced record in a 'detailed' form I get the previous record that was selected in the listbox displayed in the detailed form instead of the newly...

Thanks for the reply Peter :) Your soooo right about the consistency. My example of text was an ideal example, but some users enter the date without a year (e.g. 25/10) and sometimes the date is entered in various formats (e.g. 25.10, 25-10-06). Then some may insert a new line (or more) after...

Hi guys, Hope this hasn't been covered before... We use Outlook and an application I've designed in Access at my place of work for Contact Management. We do quite a few imports and exports between both apps, some built in and some VBA coded I'm wondering how to go about the following: In...

Paul's snippet I got lost with at first but then I stumbled on new things and used it for something else LOL - Nice one and thank you :-) John - Nice example and bang on! - Tweaked it to suit my needs so that it had the same effect all within the same form - Many thanks :-) dazza61

Thank you for the reply John... :-) I understand the using the query for the combo, it's the second bit you mentioned that I'm struggling with i.e. about the excluding records that have already been selected...if I use a <> operator in a query it excludes ALL records before they've been...

Hi guys, I've tried searching all the threads for an answer to my problem and I can't seem to find it.... Ok I know this should be simple... I know to use Distinct and DistinctRow to only show unique records in a combobox but all I want to do is that once a selection is chosen in the combobox...

Hi guys, I've tried searching all the threads for an answer to my problem and I can't seem to find it.... Ok I know this should be simple... I know to use Distinct and DistinctRow to only show unique records in a combobox but all I want to do is that once a selection is chosen in the combobox...

Public Sub Loo() Dim intYes As Integer Dim varStr As String Do Until varStr = "strLocalStoreStopsSellingToiletPaper" DoCmd.OpenForm "ThereOnceWasAPersonFromEaling", acPreview, _ "qryWhoTriedTo______" WhereCondition: "[QuiltedBeatsAllAndFeelsComfyToo]=" & intYes varStr="WeRanOutHonest"...

Hi Shadow:-) Nice code!! - Converted all my forms and used snapshots for my reports (as you suggested though I had to fiddle with the code a lil coz I was using a custom filter routine for my reports)... Couple of questions though... Would it be possible to modify the code to hide the access...

Hi there, Having read many posts here regarding normalization, table designs with a view to avoiding duplication of data, avoiding storing of calculated contols into a field in a table (duplication as well as danger of keeping data updated, etc) - I would like to clarify something... I've...