Search results

Hi all, I've spent a while now trying to find an answer to my problem but so far no luck. I have a database which once a month someone clicks a button to pull info in from an excel document. My problem is if the excel document is on our server and the vba path points to it there I get the...

Hi all, before I start I want to say I've searched through the forums for an answer but I must be using the wrong search criteria as I can't find what I'm after. So, my problem is I have a set of data which my end users want to view and then apply several filter variations to. There is 4...

Hi all Sorry if this has been answered elsewhere but I can't find the answer anywhere. I have the code below to open a pop-up form from within a form but whenever the code runs I get Run-time Error 13, Type Mismatch. Both the EnquiryCatergory and TenderRef fields are text fields as are the...

Hi all, Having spent much of yesterday afternoon searching the forums (probably with the wrong questions) I'm stilll wondering if it is possible to do the following. Within our work's database there is a field for a project number (input mask 00>L000C;0;*) which I need to filter down according...

Hi all, I am using the below expression in my query to caluculate the finish time. Finish: DateAdd("h",[workedhours],[StartTime]) I know this is not the best way to do what I want and that it would be a lot easier to have a start time a finish time and then work out the hours between the two...

Hi all. I have been tasked with answering the following for a database that was done by someone who has since left the company and I am approaching it from new. From what I can see, there are is a Start Date 1 End Date 1, SD2 ED2, SD3 ED3 which people use to assign blocks of days for which...

Hi all. I would like to know if anybody knows, if it's possible to add the number of hours worked, say 9.5, to a start time, say 07:30, to generate a finish time, in this example 17:00. This seems a strange question as the response I'll probably get will be, why not have hours worked...

Hi all, I've searched thorough these forums and can find bits that look like they can help me but have not been able to get my head around them. I been asked to create a list of reports within my database with a tick box next to them which people can use to identify as wanting to print and...

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...

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...

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...

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...

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...

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...

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...