Posts by chrisxs5

Re: Saving an Workbook/File as a Cell Text

Does the workbook already have the same name as the cell?

I have a form with many tabs the form is a member database. on one of the tabs the members children are stored. They have there own table and are set as a subdata sheet. The tab has their form on it. A form in a form. The kids are filtered to the parents. Have J Smith selected and only his kids appeared. I was asked to put a listbox to select the kids easier. But I cant get it to see the same filter. So instead of seeing J Smiths 3 kids I see all 250 kids in the table. The form will only show the 3 kids but the listbox has them all. Any ideas, thoughts, macros or suggestions? Thanks!

Re: creating an access report

Do a help search for "Insert an existing unbound object on a form or report".
I think that topic should help you get started.

Re: Parameter Msg After Form Criteria

Solved!

I had several sorts from before I set up the filter that asked for the values as well and one for a value I deleted. Erased those three and added updated sorting and it all works great.

Re: Parameter Msg After Form Criteria

So now I have done it. I saw the spaces as you pointed out and decided to remove all spaces to make it easier, I also tweaked some other things and not sure what I tweaked. But now it throws up the form then gives me the parameter question instantly. I am starting to become very confused.

Created a fairly simple database for Sunday School attendance.
Created a report with a criteria. The form I created works just fine but after the form I get parameter questions having to answer the same question twice. Any help

I didnt get any replys on the other one so I figured I would ask in a new thread.

How can I set an OLE Object (Bitmap) with a default picture in a table?

Re: capturing open, close, and exit events

AN add-in was my next suggestion. Put the open in the add-in as well.

Re: capturing open, close, and exit events

When I paste your msg into the thisworkbook page it runs just fine. Why dont you past the msg after the could that logs the open. That way when you see the message you know the log worked as well.

Re: capturing open, close, and exit events

Sounds like it would be better if you date stamped a cell versus giving yourself a message. Do you want a continuing log or just to know the last time you logged in? Also, will this be for all workbooks, sheets you open or just certain workbooks?

Re: capturing open, close, and exit events

Just curious why you need to do this?

Re: Images linked with Databases?

Cool, I am glad I did a search before asking. This is exactly what I was looking for. But let me extend the question just a bit.

How would I set up a default picture(Like a picture that says unavailable)?

Re: No Data Macro

The command is called from the reports property setting.

The 'On No data' event, calls macro "NoData".

Which is on located on a macros page with this settings:
Macro Name = No Data
Condition =
Action = MsgBox
Comment =

Message = Message
Beep = Yes
Type = None
Title = No Data

Re: Email cell information

There are several post that give you examples and code for exactly what your looking for on the forum. Try a search and look for similair titles and that should get you started.

Re: Error Message upon compacting

The following I found in the help files.

Troubleshoot compacting an Access database or Access project
A Microsoft Access database or Microsoft Access project will not compact for any of the following reasons:

You don't have enough storage space on your disk for both the original and compacted versions of the Access database or Access project. Delete any unneeded files and try again.

You don't have both Open/Run and Open Exclusive permissions for the Access database. If you don't own this database, contact its owner to find out whether you can be given these permissions. If you own this database, you need to update your permissions.

Another user has the Access database or Access project open.

The Access database or Access project is located on a read-only network share, or its file attribute is set to Read Only.

My No data macro runs twice. I dont see a loop or anything else wrong. The macro is in the macros page, not vba. Any ideas?

Re: Email Cell Contents

View the last post of this thread

Re: Filter with form

Of course I will. My apoligize for not posting it on my last post.

The message comes from your macro page. I forgot to name one of the macros. So when the report runs through all of them it sees one with no name and gives the message, but still sees all of the rest and thats why it allowed my filter to still work.

The solution to why the filter wasnt working is a very obvious one. The source was set to the wrong record. The criteria I wrote worked fine.

:guitar:

Re: Filter with form

Solved!

Re: Filter with form

OK, so I kept working with it and I can get it to filter correctly. But I still get the message. So how can get it to go away?