Search results for query: *

Hi, Is it possible to have just one copy of a distributed form that users can access and submit responses through? I ask as this is what I've done with the 'distributed' pdf on a local server. I tested it and although the respondants are indicated in the 'new' section of Tracker I can't...

Apologies, Yes I have an open date field. Currently my only parameter returns the date range that I'm interested in (in this particular case a period of 24 months) but creating one such as you suggest won't be a problem. Thanks to you both, I'll go and give it a try.

Thanks Ian, I've tried that and that's not giving me what I need. The summary counts only those records in each month. I need a summary count of those records opened in the month with a closed date (or null) after that month.

Good afternoon, Am using CRXI and am trying to construct a report that identifies how many records were 'open' at a particular historical point in time. I.e. I have 6500 records each with a separate closed date, I need my report to say x number of cases were open in this particular month. I...

1-Have sorted that by cut and pasting a select formula from another report into this one. 2-I have 2 date fields on a simple report - 'Acknowledgment' & 'Closed'. I'd like the user to be able to select which field they are basing the date range record select on. Thanks.

Good afternoon, I would've posted these seperately but as they are quite closely connected and on the same project it seemed a bit pointless. 1st question: I have created a very simple report and want to filter the records based on a range parameter. I've created the parameter but it's not...

Hi Trevor, Have just tried your method. Got as far as about to open the front end and received the following message from Access: "The Visual Basic for Applications project in the database is corrupt." I think that pretty much answers the question of what's wrong with the database then?

Sorry I wasn't clear. You're right of course. I was working in the non-MDE copy of the front-end. It's behaving the same way as the MDE.

A quick update before I call it a night. I've checked the properties of each of the buttons and they are all of the DoCmd.OpenForm "Thisform" type. About as simple as a button can get, so the issue has to be with the form that they're opening, yes? |-( Why did i have to go and look at this on...

Thanks for your assistance. I've split the database and have created an MDE for the front end but am running into some problems. Firstly, the appearance of some of the forms has changed. Specifically the background colour of some of the buttons has changed from brown to white. Not a major...

Really, it's that simple? I had visions of this being a bit of a nightmare to do. Many thanks!

Thanks for your comments. Yes it's definitely set to compact on close as it's noticeable when you're the last user out. As for your second point. Yes we do. :-( Don't blame me - I didn't build it! Thanks for your help. P.S. Now I need to decide whether I report this to my manager (and end up...

Good morning, Am using an Access 2003 database that has had this issue for some time. Basically it is creating copies of itself, seemingly at random. The database is, imaginatively, titled Access Request Database but the copies are all named db1, db2, db3 and so. If the copies are deleted...

It's funny how you can get so wrapped up you can't see the wood for the sql's! Many thanks MajP. Works like a charm.

Good morning everyone. The title of this thread almost says it all. What I need to add is that I only want the form to cancel opening if the filter value passed from form A does not exist and the user hasn't clicked the 'Add New Case' button on Form A. What is happening at the minute is my...

I tried both. With the expression just nothing happened but the code (after a very small tweak) works like an absolute charm. Many thanks AceMan I'll raise a glass for you tonight for finishing my week off on a Hi(Lite)! Thanks, Secregeek

Tbl_SentDept.ID is numeric. Here's what I have done so far. If it looks amateur it's because I am! :-) Function MissingInfo(StrID) Dim dbs As dao.Database Dim RsMiss As dao.Recordset Dim MissCnt As Boolean Set dbs = CurrentDb Set RsMiss =...

Hi AceMan, Here's the sql as requested: SELECT Tbl_SentDept.ID, Count(Tbl_SentDept.ID) AS CountofID FROM Tbl_SentDept WHERE (((Tbl_SentDept.Department) Is Not Null) AND ((Tbl_SentDept.SendDate) Is Null)) OR (((Tbl_SentDept.Department) Is Not Null) AND ((Tbl_SentDept.DeptDeadDate) Is Null))...

I have the query table LEFT joined in the RecordSource of the form and I would have expected this to make the info available for reference elsewhere in the form. You seem to be saying that this isn't the case?

After some significant tweaking I now have the query counting the number of missing details and my conditional formatting expression is: [Qry_MissingMemoDetails].[CountofID]>0 I'm not getting any errors with this but it certainly isn't doing what I exppect either. I changed it to...