Search results

There was certainly a time when he was often called a war criminal for the reasons mentioned in the post above, so it was probably a genuine effort to arrest him on those charges! I think these days Blair is just the butt of poor leadership jokes, but then pretty much all UK leaders suffer the...

There is Autoformat. You can save the format of your old forms as an autoformat pattern then apply it to the new ones and they hopefully will magically become at least close to what you want. Need to enable the autoformat button in the quick access toolbar I believe.

To save reformatting every time, you could create an autoformat with the sizes changed. Just to did once, then go to Autoformat and save this is as a starting point. Then whenever you make another form, you can use that menu again to apply those format changes right away. Note: I think that...

It will depend on this. The data for the sheet needs to actually have all the parameters you'll be looking for obviously. A compile error means there is a mistake in the way the code is written, rather than a mistake with the concepts used. So it is probably just a apostrophe in the wrong place...

Ah yes I was assuming you were using VBA! So are you changing the filters manually then? The whole process could be automated in VBA, but it's not a beginner-level task. So is it the case that you just need to close the report in between manual exports?

Sounds exactly like a case of this to me. Or perhaps someone really is just trying to clever by deleting things from the backend! Hopefully you have some form of backup from which you can get the records back.

I don't understand why you can't just the use datedif or datediff functions in their regular forms, so have lines like: Days = DateDiff("d",[CheckIn],[CheckOut]) in Access and Days = DATEDIF(A1,B1,"D") in Excel. Both give the the number of days stayed in total. Works for months and weeks too...

Try this line: DoCmd.Close acReport, "ReportTitle" Should just close the report entirely.

Does it just come up with no results? If so then it might be looking for a postcode that literally has a star in it. I looked it up and putting: & "*'" instead of & "'" at the end of your filter strings is the proper way to do it. I'm fairly sure you can do this regardless of where or how the...

I think you can just edit the & "'" at the end of the filter strings to: & "*'" And that will do it. Although actually I'm struggling to remember if that's right, so perhaps just try it out, and if it doesn't work try: & * & "'" instead.

Ah right, in this case I think it is just being applied incorrectly. Have you literally just written that IF statement into a box on the form? If you haven't already got something scanning the internet table for IDs, I'm afraid you'll need to actually write a program to do it and set it to run...

1) Yes you can add a wildcard. You probably want "*" in this case, since it just means anything. So if you looked for M16* if should return everything with M16 as the beginning go the postcode. 2) I don't see why you want to create your own system for this when there is a built in one? Assuming...

Probably because the lookup is actually holding the ID of the record you are looking up, which is a number. If you have set it all up right it will still be the text that appears when actually viewing the data, but since the first column in the lookup field is technically the ID of the foreign...

An if statement should work in principle. What you posted: IF[CustomerID]=([InternetTBL]![CustomerID], Yes,No) won't work as it is not set up correctly. Try: IF([CustomerID]=[InternetTBL]![CustomerID], Yes,No) I just moved the bracket from after the = to before the if, which is where it should...

No problem, glad to help! Yes the same principle can be used for any combination of any number of criteria. I use it all the time for setting up complicated filters with loads of different inputs. As long as you make sure that all criteria after the first one have the 'and' in them, and are...

As far as I know, the only way to do with is have a macro that opens the report 50 times but with different criteria so that in effect, you are opening each page one by one. Every time you open these one-page reports you export them to PDF, then close them, change the record source of the report...

You can edit the heading properties of the excel file in your macro. You can see it being done in the code here. http://www.dbforums.com/microsoft-access/1661928-access-vba-write-excel-header-footer.html

I have seen a similar problem before, but it was solved in a different way: The business just agreed that if they were buying stock in at different prices, in order to avoid a database nightmare, they would just use a weighted average stock price in all their calculations. Having a single...

Is the problem still caused by input dates being null? I don't think the code you have posted actually protects against them. E.g. is Me.PhysicalExpires is null, the date diff will give the number of days between now and the default 'zero date' which is in 1900. Probably not what you want...

The issue is that your are overwriting the filter when you apply it on the status. Instead you want to build on top of this. So instead of lines like: Me.Form.Filter = "[Status] = '" & _ Replace(Me.cboStatus.Text, "'", "''") & "'" Use: Me.Form.Filter = Me.Form.Filter &...