Search results

Mike, If you have Access 97 or later, you can use the "Optional" keywork in the declaration of parameters in a function/subroutine. See Help for more details. RichM

See Help for the "DateAdd" function. That will let you add 1 day to the current date. Also see Help for "DatePart". I think you will need to use DateAdd to advance to the next date. Then you will need to set a Date variable to Year, Month, Day, Hours, Minutes, Seconds. RichM

Dim strPath As String RichM

Sara, Yes, you have tblContracts and tblSteps and tblContractSteps. For tblSteps, I'm thinking about some sort of "template" table based on contract type. This is a permanent table. In this table you would have a non-unique key of ContractType and many records for each ContractType. Each...

Sara, 1) It sounds like different contracts have different steps/dates based on some kind of contract "type". Right ? If yes, then you might want a table of standard steps/dates. The primary key would be ContractType and StepID. 2) In tblContracts, does each and every contract have a value for...

Jon, Basically, you make 2 queries. Query 1 will Select duplicates. Query 2 will include Query 1 and delete the result. RichM

<< I'm rethinking this whole thing now because it's sounding too darn complicated for what it's intended for.... >> Amen. BTW, the "Access Developer's Handbook" has a section on custom autonumbers. You might find it helpful. RichM

Oh all right then. So it sounds like you want to present 2 lists to the users; inpatient numbers and outpatient numbers. Right ? So we can visualize a form with a yes/no control and a listbox. When the user toggles the yes/no control, you would like to rebuild a list of patient numbers. Then...

It's probably possible but why do it ? Do you expect all the users of this app to say "Aha, this number begins with 5 so this person is an inpatient" ? Just add a field that indicates inpatient/outpatient status. RichM

you wrote << ElseIf lngConut > 0 Then >> Did you actually copy and paste code into your message. If yes you should try "Option Explicit". Conut <> Count RichM

Or use "property" procedures; you can set a value in a form and get it in other forms, queries, modules, etc. Simpler and cleaner. RichM

Shep, If queries were in the back end, then how would you use a query from a front end ? Queries, forms, modules, etc should be in the front end. RichM

Kevin, DLookup won't help you flush a bunch of toilets (I couldn't resist :)) It sounds like you need to know if there is at least one toilet and what all the toilets are. For that use a RecordSet. Make a string that is the equivalent SQL statement to the DLookup parameters. Check the number...

jmriddic wrote << I had put in a separate module to begin with . Needed to include it in the module with the startup form. >> No, that's not true. You can put the API declarations and Functions in a separate module. Just remember to call the functions from the Open and Close events of your...

Thanks ghudson and mrabrams. I have been looking for a Win32 version of this API call. I also converted and tried it with Access 2000 and it works just fine. RichM

You might find some information in the various "Access Developer's Handbook" versions. The publisher is Sybex and the authors are Litwin, Getz, and others. I have the Access 97 version and it does have a section about Access as both client and server. However, DDE is dead technology. Access 97...

If you are using MS Access data tables, there is no reason to convert DAO to ADO. If it hurts, don't do it. RichM

I don't follow all your process requirements, but that's OK. In general you can create a Recordset from the result of an SQL statement. Then you can use all rows and fields in the Recordset for additional processes. But first I would rethink the requirements. Writing a lot of code to...

Doc, Whatever the use or source of "temp" tables, I still don't see any upside for storing temp tables in the FE (versus storing temp tables in a private MDB) All the apps I make are network-only. Nothing is permanently stored on the user desktop except private work MDBs. Of course the best...

Doc, Sounds like things I have done, but I don't know about the "parent/child" aspect of your data. In some multi-user entry and update apps, I have created work tables on the user C: drive with code that runs in a start up module. A delete query cleans out the content of the work table when...