Search results

Something like this? http://allenbrowne.com/func-concat.html

Welcome to AWF rykid6! Considering that you're new you probably don't know how things work around here. What happens is if a question asked by another poster isn't entirely related to the original post, you would create a new thread describing your problem. Have a go at doing that but in the...

I can still see a quote there GaryPanic. For a numeric field it should be: "AccountNo = " & rsEmail.Fields(0) But since you're exporting to pdf, you don't necessarily need to open the report beforehand. As an alternative, you can set the filter property of the report in its Open event. The...

If you upload the db with the type of data you just explained and tell me steps to reproduce the problem, I'll take a look. Workarounds should be a last resort.

In a database (which Access is), you need as many tables as is necessary in order to fulfil all normalisation rules. What you currently have is a flat file structure, the same as what you see in Excel and this sort of structure fails in Access.

Did you use that particular db or you copied and pasted the code? If it's the latter, upload that db and I'll take a look.

As a side note, the fact that you're using a so-called Master table with the DISTINCT predicate would indicate that your table isn't normalised. Are you familiar with this term?

You stated ... meaning the db the suggestions in the db that I uploaded earlier didn't work. So I'm asking that you upload a db with the suggested changes that doesn't work.

No it didn't :D Actually MS VBA for Applications Extensibility 5.3 is used for coding the VBA Editor itself. For example, if you want to add/remove code to/from a module/class programmatically, it's that library that you use to do just that. But I agree with GinaWhipp, there are possibly some...

Just need to clarify, because the objective has changed, do you now want to check the Date Created property instead of the Date Modified property? If all you want to check for is newly created files then you can do that via FileSystemObject. If it's the latter, then my suggestion in my last post...

You mean like you have it in your first post? It's much easier to do it in a report where you set the Hide Duplicates property of the textbox to Yes. In a query, you'll need to get the Min() value of Column2 per Column1, e.g.: AA - AA01 AC - AC01 DE - DE01 ... those are the min values of...

Why don't you upload a db that doesn't work?

Ok. First thing you need to do is research a method of reading a file line by line. I suggest you look into the File System Object. Feel free to ask if you have any specific questions.

So basically you want the month totals to be based on the date ranges entered? I.e. if the user enters 6/1/2015 to 6/15/2015 you only want the totals between the 1st and the 15th of June? If that's the case then the record source (i.e. table/query) of the DSum() function needs to be raw values...

Does each message file always have a "FirstName:" line?

Create a SELECT query that joins both tables via the field you mentioned, go to SQL view and change the join to look like this: FROM table1 INNER JOIN table2 ON table2.Field LIKE table1.Field & "*"

How good is your VBA John?

Sounds like you're good with normalisation?

She needs to set you much harder tasks And don't worry, you can take all the glory That's quite a lot! I think a few years back you mentioned (or I hinted) that you were/should consolidate. Did you make any headway in this regard?

I would have expected all income to be positive(+) and all expense to be negative(-), but I'll go with what you currently have. 1. Drop a textbox in the footer section of the Income and Expense subforms, and enter the following in its Control Source: =Sum(IIF(Account="CL_CIBC_MC", [Amount]...