Search results

Apologies took a week off!! Yeah will look at that but it's a few disparate bits of info. They are actually related but database design is poor so they're not easy to get. I think I might look at running a few queries and write to a temp file and use that for the report.

OK but on the sub report will I have to do as Gasman suggested by opening a recordset and storing data in appropriate fields. If so then why do I need a subreport? Is it because I can't have an unbound report if that's the right terminology.

OK thanks but DB Guy has mentioned sub reports again so will dig deeper

No will come from same place. Obviously may have changed as it's a year to date report but will always come from same place.

Having had a quick read I don't think so. Sub reports seemed to be related to the report itself. I basically want to be able to run x unrelated query. query1 through queryx The data already I want appears on other reports. The user basically wants to extract 1 piece of data from several...

My user wants a report with (unrelated ish) data on it. The unrelated bit comes mainly because of the old design of the database and the fact it's not quite a relational model. I can run several queries to get the data he wants. But how can I then get it onto the report. So I want field 1 from...

OK I've got this to work. Whether or not I've transgressed any unwritten things you shouldn't do but... Before I start this form works using a combo box to select new items but the user wants a bulk update. I create a temp table in a pop up form which the user can select which records he wants...

Not always possible to share. I have to usually cut it down to the form and that takes time I don't have at the moment! I'll have to do some rework. It's no big deal just thought I could get away without doing it!

I know but the form already exists and there's a lot of validation in there that may be messy to move. The same form is also going to be used to add extra items in as well. I was hoping to add each item to the form and (maybe naive thinking this) the before and after updates would get processed...

I played around with this and found although my table wasn't actually appearing down the left hand side it was actually there! So now I have a temporary table that the user can tick what items he wants and he can change the number as well. When he closes the form where he does this I want to...

OK being a bit thick here. I thought the form timer event ran the timer event after a defined number of milliseconds. How does that help and what do I put in the time event. Or are you suggesting that after creating the table I somehow "wait" fora number of seconds before code continues? Again...

using select into.. strTable = "itempricegroupTEMP" 'Delete the table if it exists DoCmd.DeleteObject acTable, strTable strSQL = "Select ID, [price group id], [item id], description, sortreference, units, cost, gross, disc INTO " & strTable & " FROM itempricegroup " & _ "Where...

OK I'm getting stuck here. I've set up a mock form where I create a temporary table with selected data (only use certain fields and also have a filter) from another table. I do this in the open event. I try and make this the record set using Set db = CurrentDb Set rs =...

This is what I had in mind but using the original table which would screw up if more than one user was creating an invoice at the same time. In that scenario when temp tables are created are they specific to the user and won't interfere with another user doing the same at same time?

So I create a temp table with the details of the tariff group display that and then copy the selected items to the order?

Not sure you're sure of what I want! There are a set of tariff groups that contain anywhere between 10 and 90 entries. Each customer has a tariff group assigned to him. A tariff group can have more than 1 customer. All the tariff groups are held on one table. There is a default number of each...

Also....the items are split into different tariffs for different customers. Each tariff set has a number of items. The tariff sets are held on one table. I've just set up a quick listbox to play around with. I did this using form design and adding a list box onto the form and going through the...

I've started to look at this but not sure if will meet what I want to do. The user will select a number of items. Looks like this is fairly easy to do with the multi select list box. The other thing he'll want to to do is add a number in as well. Now I know he can go and do that after but his...

Excellent thank you

Never used one but looks like pbaldy has pointed me in the right direction. Thanks