Search results

Are you actually printing the report? The CanGrow property does not effect a print preview.

You can not set focus on tblUserName, because it does not exist. You will have to create it yourself. I realize that this makes for some double entry, but I find the benefits make it worthwhile in your case.

What I usually do in this case, is that I have a table called tblUserProfile that has the information for all of the users of the database (including their username, and group). When the database is opened, have a hidden form open that check the CURRENTUSER contant to find out who has just...

You can tell who is logged in by using the CURRENTUSER constant. You can then write some code on the OnOpen event: if currentuser="YourUserName" then me.yourcontrol.visible=true else me.yourcontrol.visible=false end if

Just a thought, but you are using SQL as a variable. Is that a reserved word? Try a different variable.

You will have to experiment with your workgroups until you find the correct one to use with your backend. Try to retrace your steps when you created it. Did you set up security on the back end? If so, what workgroup were you using at the time? Once you have successfully logged into the back...

I would assume that your [SelectPT] and [SelectDate] controls are unbound. That means that they will retain their values when you return from the report to the criteria form. If you would like to force them to re-enter a date after selecting a new patient, you could clear the [SelectDate] box...

If you are entering data in a form, you must leave a record before it will save to a table. It sounds like your report is triggered from your entry form, so you should either leave the last record, or save the last record entered just before you run the report. You can save the record using...

Have you tried creating a new, blank database, and then importing all of your objects into it? I find that it is usually one of the system files that has corrupted to cause this problem. Creating a new DB will re-create all of the system files.

Go to "Help", and look up the "RecordSetClone Property". This should get you on the right track.

I have some date functions that I have created that adjust for weekends and holidays. It is currently set for American holidays, but it can easily edited for any country. The functions are: PrevWorkday: Returns the previous workday. NextWorkday: Returns the next workday. AddWorkdays: Provide a...

You may still have a system object that is corrupt. If I am understanding you correctly, it sounds like you just made a copy of the database and called it Temp.mdb. What you want to do, is to create a brand new, empty database. Import all of the objects (including links) to the new database...

I have used both Office97 and Office2000 on Windows XP Pro with no problems at all......

This type of corruption is usually caused by a bad shutdown of the database. The corrupt file is quite often a system file that is created when the database is created. There are two things that I would try: Create a new, blank database, and import all of your objects into it. (This will...

Why would you be putting this code into a recordset? If you want to populate a combo box, just enter the code into the record source property of the combo box.

The suggestion from 3699wat will change your date format across the board. Since many of the dates that you have entered do require the full date format, this will not work for you.

Just use the code exactly as it appears (including brackets). The only thing you need to change is "YourFieldName". I could not tell what your field name was from your post, so you will have to fill it in where ever your see "YourFieldName".

Try creating a new, blank database. Import all of the objects from the original (including links). Compile and compact the new database. I have had a great deal of success with this method. Make sure all of your users realize that they must shut the database down properly (no right clicks on...

You could use a particular, and impossible date to flag the TBD (example #12/31/9999#). Your record source would then be: =iif([YourDateField]=#12/31/9999#,"TBD",[YourDateField]) As for the partial date that you are being supplied, you could just use the 1st of the month, and maybe and a...

If you are running a report, you can use the "On No Data" event to trigger your message box.