Search results

Sorry a pandemic got in the way of this and I just commented the code out on the offending machine. However need to do it properly now and the above didn't work. Falls over on the "if me.Dirty" bit with error 2455

Thank you for all the replies. In the end I used a query using MSysObjects which has last modified date and has allowed me to suss it out!

Unfortunately I don't have that luxury but here's what I did. I think you've misunderstood about the date. The properties date is correct but you have to look at each in turn or run a report and plough through the report which is what I'm doing now. The bit that would have been good would be to...

....and if he isn't and I have to pick up the mess?

I want to know what the last set of objects to be updated are. I know I can display objects in order of last modified but the results are limited in that it appears to display those recently modified, those modified with 2 weeks and those older. Unfortunately the changes were made just before...

OK after investigating the weird issue I found that I'd commented the if me.dirty line and just closed the form!! I'll do that again!

I have just completed some very small enhancements to a small system. This was with access 2016. I have deployed the software to 2 machines. 1 is using either 2010 or 2016 access the other is , I think 2007. On the 2007 machine he is getting an error to a form that has not changed and worked...

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