Search results

I agree with you and like I said what I've been asked to do does seem backwards. I'm not one to argue and try to give what the user wants so again although I agree with your method, if you know a way to filter/search/find a record in the main form based on criteria in the subform, any...

Hi all, hopefully someone will be able to give me a straight answer to this one even if its as simple as yes or no, however if its yes I hope you could explain how. :) My question is: Is there a way to have a subform filter or go to a corresponding record in the main form. Subform is linked...

Thanks for the reply but it wasn't really what I was thinking of. What I remember was a form which showed all the information that is set up when the workgroup file is created through the Access security wizard. This information could then be changed or added to via the form rather then going...

Hi all. Once upon a time I stumbled upon an example form or selection or forms that I merged that allowed the admin user to add and modify user accounts that were set up using the User-Level Security wizard. The form showed the user accounts and group there each were in both of which could be...

Sounds like a good idea, will give it a go. Cheers

Hi all. After having spent pretty much all of this morning searching for a solution though numerous posts, I am still lost. I have been given a database that I was told was created in 2000 but it is updated in 2003. The problem I've got is there are users on 2000 and 2003 which means any...

I can see the file but when i double click to open it nothing happens. No error messages simply nothing. However, it will open if it is open via the Open file option within Access. Sounds strange I know

As the thread title suggests, my problem is that I have a database that will not open via the mapped drive. There are other databases stored on this drive that open fine so it is only the one database that is causing me a headache. Any suggestions as to why only this one database would be...

Using VBA is fine by me. Can see where your going with the suggestion, however how would I change the code so that it runs on whatever is entered into a text box

Hi all. Having searched on here and found many examples for search forms, I still can't find one that will do what i'm after. What i'm trying to do is have my user enter some search criteria which will show associated results for materials and the codes assigned to them. This was easier...

Hi all. Here is my problem. Within my form I have a subform and about 20 records. Each record has 10 tick box with it which are tick by the user if the criteria on the main form is required. What I am trying to do is have a tick box on the main form for each criteria that if ticked will update...

Hi all. Here's my problem. In my form I have an unbound text box call AO which will show a figure based on what tick boxes are selected. The code runs on the On Current event of the form. The code used is This works fine. However, I have since been asked to show this form as a report which...

Hi all. Having searched around I cannot seem to find what i'm after. I have a database which i hope to give users the option to run an append query which will copy certain pieces of information form one weeks to a another week. Originally I thought about w/c + 7 which would give me a new...

Yeah it helps. Makes sense to do it that way. Cheers.

Hi all. I am having some problems with some users, not allowing the database enough time to compact and repair before they switch off their PC or laptop. Although they have been told many times about the function needing time many are just impatient. This has resulted in various db1, db2 etc...

Hi all. I have tried searches on here and via google but can't find a difinitive answer to my question. What i would like to do is create a custom help file that will run when the user requests it. I know there is a property option to set a custom help file within a form but i am unsure of the...

Hi all, i'm having a rather annoying problem. When I view my report I have 2 sets of conditional formatting that run, one that changes the back colours of certain fileds when the criteria is meet, and the second, the text colour of certain fields, both of which work fine when previewing the...

I have tried both methods and can't get it to work. What am I doing wrong. I have a text box with the Date() expression in it then Date() + 1 for tuesday, Date() + 2 for wednesday etc and then within each text box set the format for them to dddd so that they show Monday, Tuesday etc instead of...

Hi all. Within my report, is there a way to highlight the date fields that would be either a saturday or sunday in grey for example so that weekdays are shown more clearly. Note that I have already set the date fields to read Mon, Tues, Wed etc but for some people using my database this doesn't...

Hi thanks for responding. problem is sorted now. thanks though