Search results

thanks ted but one list box isnt based on the results of the previous one it is just multiple filters to gain a list of item records

hey guys i have a cross tab report that atm i only have being filtered by a listbox from one table basically what i need to do is be able to filter the same report by 1 or more tables i.e there are 4 tables to choose from which are department, subgroup, group and supplier which means i want to...

all sorted boys and girls

yeah pbaldy sorry that was where it was blowing up thanks for your help

thanks, pbaldy just took a sample off the net and edited still trying to figure stuff out as i go so what where those lines to do?

hey everyone when i run the following code for a report i get the error message run time error 2465 cant find the field line12 referred to in your expression any help would be great Regards Jason Private Sub Report_Open(Cancel As Integer) DoCmd.Maximize Dim i As Integer For i = 0 To 7...

hey guys not sure if this is the right area to post this question so my apologies if it should be under somewhere else. I am trying to right my first vba code for a database. What im trying to do is i want to be able to base my reports off various filters being chosen from different list boxes...

This databse is just one that the client made themseleves hell it is only 1 table and what happnes is when some1 runs a filter on the table it comes up with this error the prob is all other machines have been switched off at this time so it is not like any1 else is using the databse.

I am receiving the following message when a customer tries to query a record any suggestion would be grateful 'the microsoft jet database stopped the procedure because you and another user are attempting to change the same data at the same time. Jason

In my database I have a query which calculates number of days missed for a delivery the next step I need to take is to find if any of these occur over a two month period and split the period in to days for each seperate month. For example a customer may have stopped from 28-12-01 to 3-1-02 which...

Pat: thank you very much i think i have it now

Pat: I understand that I need a where clause in my query but I don't know how to write the vba code that is needed for such a query

I am trying to create a report based on a form for a invoice statement which I have got working no worries. The problem is I would like to be able to print many customer invoices at the same time to do this I have created a list box could combo1 which has the customer's address in it. I would...

Hi I know this is a really easy question I am just having a mind block at the moment so I was wondering if someone could remind me on how to have a text box updated each time I change a combo box on the same form The e.g being if I change the address through a pop-list how do I make it change...

Raskew: Thanks I am still in developing queries and forms for other parts of the database I just knew that this is something I would have problems with as I have done no V.B or really any sorts of programming before. So thanks for your help and this is meant for every1 who has given me advice...

Rasekew: I do fully understand they are two seperate issues, however if i create a module to calculate days the paper is received in a given period surely i can also calculate the days the paper is not received for with only having to change a few fields.

I have a given start date and end date for each billing period which is entered through a form. As for what days papers are received I want to be able to create a module that calculates number of days stopped in a period for each customer if they ask for their paper to stop being delivered for...

Hi I am currently writing a database to calculate customer's bills for a newspaper delivery service and I have two problems which I feel probably could be solved in the same module. This is that I need to calculate a different price for saturdays then weekdays and also not inlcude any sundays...

I know this has probably been asked 1000s of time but why when I select a list box then extended multi select and use these selected values to create a report do i get nothing. If someone could please help me i would be really grateful. The form name is frmcustomerlist the listbox is combo26 if...

jwindon yeah done it works fine I knew it would I just thought that surely if it is in the same directory as the database it should pick it up as it did the first time before I moved it. Oh well just have to change it if I move it again.