Search results

If your dates are in column A, then you could place the following formula in, say, cell B3: =A3-A2 You will then have to set the format for cell B3 to 'number' and set the decimal places to zero. This will give you the number of days between each row. To calculate the number of crates in...

If I was to have collection/deliveries in column A, and the quantity in column B. I would have a running total in colum C that contains the following formulae: =IF(A1="delivery",C1+B2,C1-B2) Paul

I think you mean you want the button on the screen, but you don't want it on your printout. Right click the command button, go to properties, select the Categorised tab, and change PrintObject to False. I hope that is what your looking for.

It works!! :)) Thank you ever so much for your help. This has been a good learning experience for me and now the users won't be able to select the wrong fields again!

I think its exactly what I want. My code (in a module) is as follows: Function ResultFilter() Dim str_SQL As String Dim ResultType As Integer ResultType = DCount("[TestResult]", "[TR 1st pass]", "[TestResult] = '1st Pass' Or [TestResult] = '1st Fail'") If ResultType > 0 Then str_SQL...

Thanks Alc, I have used DCount in a module and I believe I'm half way there. Next step, I need some code to do this: 1) If DCount returns 0, I need the list box (on the form) to display one set of fields. 2) If DCount returns >=1, I need a different set of fields in the list box. I could...

I am able to create list / combo boxes in a form where the fields displayed in the box (for the users to select) will depend on (1) what has been entered in other fields on the form and (2) results from other queries/look up tables. I'm happy with all of this. Where I'm stuck is that I am now...

thats good then, I wondered if something was wrong. Thanks :)

In my main table (in the back end), I have about 11 thousand records (with 19 columns) and when I first created the table I left most of the field sizes at the default value (255). However I have now reduced many of them, some to just 5, but the file size after running the compact and repair...

1) Make a form with a drop down menu, where you can select a person. 2) On the query, go to design view, and in the criteria field under the person, right click and select build. Then in the new menu, double click 'forms' to open it, navigate to the form that selects the person (as in step...

I think it depends on what type of info is held in the clipboard. I have seen the Enhanced Metafile (and many others) before when I have tried to paste other file types. But with the 'print screen' type, it only seems to give 2 options when you use paste special.

I don't get that option either and I'm using Word 2003. But I do use the paste special and experiement to find the best option for file size and quality images. Thanks.

THANK YOU!! The crop tool does the job really well. Unfortunately the company I work for doesn't allow us to download and install anything.

Surprising I've been unable to find any info on this. I am writing a user manual for my database and I'd like to 'copy' various forms and stuff to the clipboard, and then paste them into Word. The trouble is, when I use ALT-Print Screen, it copies the whole Access display (everything I can...

Actually, I just tried something like this on my own database. Add the total textbox to your form as normal. Then add a command button that has the following code: total=[month1]+[month2]+[month3] This will update the total value in the textbox. When you save the record your table will be...

Yes I just edited what I said to correct that.

Providing the fields in the table are set to currency. You can add a textbox on your form and type in the 'default value' (in properties > data) the following =[month1]+[month2]+[month3]

Hi, I was wondering if anyone might know if such a database would work over 2 sites. Specs are roughly as follows: 1) Database located on network in Harlow, Essex, that our Scotland site has access to. 1) No more than about 5 users on at any one time. 2) Main table will have 600 rows of data...

What you have looks correct, if its not working you might need to provide more info. If you want it a month earlier you can do this: DateAdd ("m", 11, [Hire Date])

I think I have this under control now. I am running a query to get the Max date, unit and SN. Then I am running a new query that matches the Max Date, SN and Unit (from first query) against the original query and table. I set the location filter to "Harlow" and bingo! As the date is...