Search results

Are the parent and child field properties in the subform object set? Is the criteria of the subform correct? It sounds to me like they could be saving, but the criteria of the recordset of the subform when it next opens means they are not displayed.

I don't see why the space would cause a problem. If you debug.print / msgbox strMain is it the whole string or does it end after the name like the email body does?

Will it work on an open file though, rather than providing the location of the file to open? I guess if GetObject (as opposed to CreateObject) accepts the location of a spreadsheet it must work, otherwise why would it accept a location.

A google search found this in another forum thread: Set xlApp = GetObject(, "Excel.Application") It's not something I've used but it looks like it trys to get an open spreadsheet (taken from here: http://www.tek-tips.com/viewthread.cfm?qid=90756&page=1) Equally, you could easily kill and...

The left & visible properties can do it, but as above it won't be simple as you will need to calculate new left values based on which controls are visible and which order they are in. And moving / hiding a single control will mean the left properties of all other controls will have to be...

When viewing the query builder there is an icon on the toolbar at the top of the Access window which is a red exclamation mark (the colour may differ in other versions of Access) which allows you to change it from a select query to an action query. In this case you want an update query. This...

:edit: Misread the OP. :edit2: Check the /cmd switch: /cmd Parameter: value to be returned by Application.Command function Specifies that what follows on the command line is the value that will be returned by the Command function. This option must be the last option on the command line...

I don't think you can remotely close someone elses connection to a spreadsheet via VBA. If it's closing a copy which you have open on your own PC then you may be able to find a way to close it.

I don't really use Excel, but try this: Left(A1,Len(A1)-6) That should start at the left-most character and return all the characters except the last 6 (as it's based on length it will work no matter how many characters are in A1).

An episodes table is fine, it's like an invoice table in that it has data for that specific interaction. But if you record data which isn't patient data and isn't episode data (like medical history, meds issued, etc) I'd put them in their own table, linked to the patients table (I imagine the...

Then change the query, instead of 2 fields ([Forename],[Surname]) have 1 field ([Forename] & " " & [Surname]).

You should be able to self-certify it using MS Office's SelfCert.exe, that's what I did.

If you can calculate the number of working days once & save it somewhere like a temp table or a hidden control then you can use that saved value for the other 49,999 records too. In fact, that sounds like a good idea. Call a function once to get the number of working days which should be...

To confirm, you use outlook, you pasted the provided code into outlook, you certified the code in outlook and when opening outlook you click the "enable macros" option? Also, I assume your email account isn't blocked from sending .accdb files (I know that with my one I have to zip .mdb files...

I suspect that's the field name, all 3 have the prefix "Invoice Amount - "

I don't think Date() should be surrounded by 's. I also thought RunCode could only run functions within their own modules, interesting to see you are using it on a sub.

Sounds like the data would be better split into 2 tables in a one to many relationship - 1 person to multiple meds (I assume that's what this is). That way you could easily return a list of the meds which apply to a specific peron.

[Total Invoiced]=nz([Invoice Amount - Deposit],0)+nz([Invoice Amount - Balance],0)+nz([Invoice Amount - Extras bar Amt],0) Changes are highlighted in red. The second part of nz is what the function should replace a null value with, I assume you want it replaced with zero in your sum.

A DLookUp for each day you check on each record you check. Perhaps you should use a recordset instead (Example function in the final post here: http://www.access-programmers.co.uk/forums/showthread.php?t=118886), I think opening a single recordset and using .findifrst should be quicker than...

Glad it's working. :)