Search results

If as I said some specific 'rules' were imposed, then a non conforming post could be sent to the 'post bucket'...

Unfortunately, this exception is not widely known and how to post is not consulted. A possible solution would be to set up a package for new users ex: computer OS, Access version, zip of the db, etc. That would save lots of posts asking again and again the same requests...

Wrong forum, Jazz. This one is for Access apps...

Why is the main menu closed when you run the report? If it has to be closed, save the app state in a public var stored in a utility module then use this var to initialize your reports ( report open event ). If not, use forms!MainMenu!LabelName to initialize your reports.

jdraw: he doesn't have enough posts! Pantheon: just post 4 dummies so that you reach 10 posts... then you will be allowed attachments.

vbaInet: 1 - Modules: replace does the job in a single pass. 2 - Queries: I have a functions that transfers query text to a module and another one that move them back to the QueryDefs - simple to locate Date() and replace it... 3 - RowSource and ControlSource: there is no reasons to use...

It doesn't work because your db design is wrong. I only have 40 years experience in programming so I might be wrong. Nonetheless, I recommend that you go back to my schema AND READ CAREFULLY the explanations of each step. Since I see no form for data manipulation, I am afraid your leaving...

Here is a mini tutorial. I did it because there are flaws in your description that needs to be specified. Unfortunately its Word365: hope you can read it...

Date manipulation in filters is no joke! Attached, there is an exemple with a little bug: using MY Office365.A2013 (the plague on it), I cannot pass the DateFrom, DateTo to the report.

Of course, you will not have to change the page footer... But let's think about it: any date in modules can be change using one replace. Am I mistaken in thinking that finally, it's mostly queries that need to be adjusted?

Hi! Instead of going into those fancy businesses, you could create a Public ReportDate as date in a utilities module then replace all Date() with ReportDate. In the Open event of the main menu, set ReportDate to Date(). Last, create a form that sets the ReportDate to whatever you want...

Here is a more general solution to your question: str = "coco rico, " ' Why not... I = InStrRev(str, ",") ' Here is the trick: locate the comma from right to left str = Mid(str, 1, I - 1) ' Typical transfer...

Ah voilà!!! Now that you need is clear, a possibility could be a 3 page form (raw materials, labour and packaging). Product def. posted in the form header, with pages in the detail section...

How can we answer your question? We have no idea about your DB structure, queries and forms... Please make available a version of your app.

Why don't you use DoCmd.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile) Much simpler isn't it???

With Access every thing is possible... except a secure application. Attached is my solution to your issue (for recipes only). Hey! you forgot the Units table: 2 what? kilos, pounds, tons??? Good day, JLCantara

A screenshot of your DB relations would help. I may have a solution but I need to know your DB structure...

WildManUK: can you attach a screenshot of your form? Is your combo in a subform? If it is 'linked' to main form, why don't you initialize it when you select a record?

Here is a very complex issue hiding behind a cute smile: a distributed, user friendly, application in a context that as no IT team... 1 - DO NOT UPGRADE to Office365.A2013: I did it 3 months ago and I regret it to tears: A2013 is a piece of shit. With A2013, all the things your talking about...

Hi Nokia! Just realized today that last app was totally rotten!!! I was probably watching hockey and zipped the wrong version... This one is (or is it?) a final one... Sorry, JLC.