Search results

My suggestion; 1.Make one unbound form 2.Place two txt boxes on the form. Maybe you could name them something simple like Start & end. 3.Add calendar controls (Buttons) on the form or reference a calendar from the txt boxes double click event so double clicking the boxes gets the calendar to...

I use the following to give alternating backcolors in the Detail section of a Report. Placed in the Detail/OnPrint section of many of my reports; Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) If Detail.BackColor = 16777215 Then Detail.BackColor = 15263976 Else...

I'm a bit tired of the buttons I have been using both default MS and my custom ones. I'd like to find some more interesting versions that I can use and have been searching on google etc but the options are limited. Does anyone have any favourite links I can follow?

Fellow Access users, I'm interested to know what you think about Listboxes v a combo. I don't use lists because combo's seem to look better. When do you use a list and not a combo? How knows I might start using them. Just seeking opinions.

Another way is to use buttons to launch your reports. Create your reports so they use the date range(s) on your unbound form then add a button for each report to your unbound form. It's very fast but not as nice as the combo method if you have heaps of reports.

I found that calendar yesterday and it looks nice and easy to use. I just tested my db with that calendar as follows; 1. I got my db to give a compile error if I made an Event Proceedure and edited the proceedure in VB using the code supplied. The code should be simply typed into the event...

Yes RuralGuy summed it up so if you want colour you need to make your own buttons. It's not too hard and everything you need to know is in this Forum. After that you can do a google search for buttons and come up with some cool versions. The only caveat is that if you get into custom buttons you...

I haven't seen the calendar you are trying to import but you might have missed a Module which is needed to get the calendar working. Look in the Modules section for something like ajb or bascalendar. if you can't get it going you could search the sample databases on this Forum for...

Hi OSB I've been using two calendars for ages which you "dug up". The first was one which selects date by double clicking on the actual date & the other is a smallish model with a red circle around the current date and uses a button to select. Both work everywhere I have put them and are very...

I'm not exactly sure what problem you are having but I'm thinking it might be that your Form, from which you launch a report or reports, is maxed after viewing a report which has been maxed. I used to have that problem but it disappeared when I set my report and form Auto Resize format...

I have used the following in an unbound text box in a report; =Sum(Abs([mycheckboxfield])) MartijnAn did you put Rich's suggestion in the Report footer or page footer? In the report footer it will add up all the true's and if you create a footer based on one of your fields it will add up the...

Do you want the user to be able to choose the addresses they wish to print on a label or labels? If you have a small number of addresses you could use a check box on your entry form then sort your report query based on the checkbox. I only have a small db with a low number of records so that's...

RV Thanks for your reply. If I exclude all the "used" chemicals that is still only half of what I need to exclude as each drum of chemical has one purchase record and one used record. I would be left with chemicals which have been purchased and some of these will have been used, my report would...

I have a report used for chemical use which has the following fields in each record; ChemicalName ADateField BatchNumber ExpiryDate Volume Purchased (checkbox) Used (checkbox) Each time a drum of chemical is purchased the name, two dates, batch number, volume & a tick in the "Purchased" check...

I have been thinking about using some excel data in access. Reading the access help I noticed that it is possible to copy & paste data into access, is this a good way to go? Does excel data import easily and work ok in access?

Thanks RG. That is good news then. Can you suggest an edit which will allow me to update a second field?

This is the NotInList I have been using for some time (below). it works well but only updates one field. I need to update two fields now, City and ZipCode. Can I add data to two fields each time the notinlist is envoked? On Error GoTo Err_ErrorHandler Const Message1 = " Is Not In The...

I have a Contacts DB and at the moment I enter Cities/Towns and Post (zip) codes separately. I now want to set it up so I can select a city or town and have the appropriate post code fill it's own field without my intervention. Is this a case of cascading combo's or can I just bind a post code...

I liked what we had.

I would like to thank those who keep this Forum running. There is so much valuable information posted here and without it I would be at a loss. Every time someone posts a question, an answer or a piece of code it adds to the data. Thanks again.