Search results

Seems like its just doing a filter before it gets to your record with ID# specified. So, the query pulls all data from the database source, then you input a value (ID#), and then that record gets filtered. If you design your forms this way, it's not uncommon to see a record that shouldn't be...

Found it: CurrentProject.AllReports...

Is there a way to refer to a report as an object so that I can refer to a particular property of that report? For instance, I have a form and several buttons that call the same report (with different filtering). I would like to use the ServerFilter option to set a filter to be executed at the...

If you would like to essentially filter out those items that have no value for 'specialised subject', then you would want to create a query that only selects those records that have a value for 'specialized subject': SELECT * FROM tableName WHERE [Specialized Subject] <> null (Granted that you...

remove first dummy record Why not take the information in the first 'dummy' record and simply place it as text on the form?

Lucy, Ok. I believe i understand what you are trying to ask now. So you have a table with the following fields: Ordered (type "yes/no") "Project Stage" (type text) "Sales Stage" (type text) On a side note, if you do not have a Primary key, I would go ahead and create one for this table. You...

Although I'm not in a place to test this out, can I send this function an equivalent WHERE clause? For instance: SQL statement to count the number of rows that have the 'Value' field set to 'True': SELECT COUNT(*) WHERE Value="True" In a report, is the following syntax valid for the control...

I'm not sure as to what else you could do. Did you import this data from an Excel spreadsheet by chance? If you had in-cell carriage returns in the spreadsheet,you may need to go through the data in your tables and determine if there are ASCII characters (black boxes that represent carriage...

Rob, I'm not sure if the basing the report on the query will work as I need to execute the count function on the same table, but many times with different WHERE clause statements. As for the pass through, I was thinking of maybe using a View stored on the server to actually perform the...

Hello, Is there a way to use the COUNT functions of SQL in an Access report? For instance, I can create a report which has it's record source set to a table in SQL Server. However, I would like to use the COUNT function and assign a text box (or boxes) the return value. I have not been able to...

Lucy, I'm not quite sure I understand your question fully, but I'll give it a try. So you have two column titles (or headers of columns): 'Ordered' and 'Forecast'. In addition, you have in a table somewhere a value for 'Project Status' and this value can be either 'ordered' or 'not ordered'...

I had a similar problem and changing the 'Can Grow' and 'Can Shrink' property values on the report to "Yes" solved the problem. It was actually the 'Can Shrink' property that fixed the problem (I really don't understand that one). Nishant

HTH, Sorry, I removed the other post from Modules & VBA. I wasn't sure which forum this thread would go under and failed to remove it from the other board. thanks, Nishant

Here's the odd thing. In my OnLoad, I have one statement: DoCmd.Maximize. I commented it out, still get the same macro errors. Here's the other thing, I sent this Access project file to another computer and it works fine. No errors upon opening like I am receiving right now. Very odd indeed. I...

I do not have an autoexec macro. I actually have no macros in this project what so ever (so it claims by going to Tools > Macros in the Visual Basic editor). Thank you, Nishant

Could someone shed light as to why the following occurs upon opening my Access project (SQL Server as the backend): Error received: "Module not found." If I try to save the project, but then I receive an error message that tells me it cannot find a report (which doesn't exist anymore). In...

I have an Access form that authenticates with SQL Server. The user would log in with a user/pass on startup. Is it then possible to change the connection login information as the Access form is running (it will be triggered) so that I can specify a new username and password? Would this mean...

Hello, I have a many-to-many relationship between two tables, which has a join table. Would it be possible to do the following: Take a user selected primary key from a list (or combo control) control (we'll call it key-A) from the first table, query the join table with key-A and find all...

Hi All, Does Refresh on a subform perform a Requery as well as part of the refresh command? Or does a requery need to be called seperate for a subform? Thanks, Nishant

makes absolute sense. thanks!