Search results

Thanks Sir Paul. When I grow up I truly want to be like you. I finally got it working in mine. I can hear you thinking...if he finally got it working then he must have found the trick.

Not out of the woods yet. I get a: run-time error "3021": No current record

Thanks for staying with me Paul.OK this should be good now.

1&2) Sorry, I just re-uploaded the database to open to the Main form (Departmental Purchasing Requisition). On it you should see the button: "Requisitions by Suppliers". 3)Do not worry about the linked tables, these came about when I "compacted and repaired" the database, and it then became...

OK pr2-eugin, This is the link. When I click on the "Requisitions by Supplier" button, it brings up the "Search Result" form which displays all the records of transactions done with the supplier that has the focus on the "Departmental Requisition Form". I now want to be able to doubleclick on...

It is not accepting that code in the where condition line.

Yes, I would like to try that, but somehow I am not able to access the DoCmd in my Macro. Been looking around in the various macros in the pull-down menus and can't find it again!!Whew!

I have a subform based on a query using data from various tables. I want to be able to doubleclick on a specific record in a field and have that record from that table displayed. Let me try to illustrate, I will write the Where Clause I have been using in my macro and put in red the code that I...

Hi, hope someone can help. I want to be able to point my where clause to a specific record in a field when I double click on the record. At present when I doubleClick it is defaulting to the Field but not the specefic record.

Thanks datAdraline, just did a search on the topic and that code helped me.

And therefore we are not in diagreement, because I am saying that the new results are "Switched" everytime a table/form is updated because the switching is done at the query and/or the report level. Anyway,thanks Pat. I will do some more research on using a FTP site.

Yes, but I have tried everything I know and so far I am not able to do anything external (via the internet) with objects in MS Access 2007. Could you enlighten us lesser ones please?:(

Yes but the Switch() was not used at the form level, it was used in the query which feeds from the updatable form. So everytime the form (whichever field) is updated, the query is automatically updated and then switched. Honestly, I have tested it over and over and it runs smoothly.

Thanks again Pat, I tried the Abs fn and it worked fine. However, using the Switch() in the querry still allowed me to update the form, and the changes were reflected in the report like how I wanted to. Still looking into how to limit the life of the database. The times opened would be good...

Yes Pat, good answers. For shutting down the database I was thinking about setting a macro to count the the times the database is opened and then shut it down when the amount of times opened has been met. Or setting the macro to some 24 hrs. count. I actually haven't looked into it as yet. For...

Thanks Pat, as I mentioned in the post before this that the "Switch() Function" actually solved my problem. However, I am going to look again at the Abs() Function. I also found myself two new challenges: 1. I want to be able to make my database run for say 30 days after which it will become...

Eureka!!! I got it, it is called the "Switch Function"

Or if I was able to convert the expression Expr3: [DietSelection]=1 to say If Expr1=1 then "Diabetic"

In other words I have this expression in a query: Expr3: [DietSelection]=1 This returns a value of True for the first row of the first column of a combo box. But how can I get the expression to return: 1.The third...

Trouble again! Now I want to print some labels. I now need to convert back the true values to the string names as displayed in the combo box. I have been fiddling around with some string expressions in the query and not able to do it. Help! Pat my friend are you there?