Search results

Thank you This was a life saver. Simple, easy instructions that got the job done. Thank you so much. Sam :)

I have a really crazy question. I noticed that one of the Access sample databases (template for Service Calls) has the ability to create appointments for service techs. My question is can this appointment information be exported easily to Outlook. Reason for the Question: My company is...

I need help, in more ways than one. Anyway, here's the problem. I have a finished database (or so I thought) I went to install it at the customers PC and when I go there I started having trouble. I have resolved some of them by using an older version, but I still have one problem now...

Is there a way to find out what variable a combo box is sending to a query? I have a combo box on a form that is used as the critera for a query. When I type in the query the criteria, the query works great. When I use [forms]![frmPatByLocation]![Combo8] to put the criteria into the query...

Here is the SQL for the qryPatientToCalcAge: SELECT IIf(DatePart("m",[tblPatient]![DOB])=DatePart("m",Date()) And DatePart("d",[tblPatient]![DOB])=DatePart("d",Date()),CInt((DateDiff('d',[tblPatient]![DOB],Date())/365.25)),CInt((DateDiff('d',[tblPatient]![DOB],Date())/365.25)-0.5)) AS Age...

I have an almost complete database. Everything was working in test mode with test data. Now that I have put in real data there seems to be a problem with one of my queries/reports. I have to install this on the customer site next Tue so I'm out of my wits right now. I would appreciate anyone who...

Backup code Cosmos, I got the code from someone on tek-tips. I will post it below. If you send me your email I will send you the email I got so you can see the additional notes he gave me. sharon@entechcomputers.com ------- Option Compare Database Option Explicit Private Const FO_COPY =...

I have a code that will create a back up of my backend tables. The code creates a file name which includes the date and time the backup was created. My question is can I in this code add something that will put this date and time in a field in a table. I want to use this date and time field...

OK, That sort of works. What is happening now is that the text box says #Name even though I typed in a name for it. Also when it does set the focus to the text box, the box is at the bottom of my screen is there any way to make the text box go to the top of the screen?

If I create a very long form with several text boxes that list helpful information on the database, can I do the following: From other forms using a "Help" Command button open the very long form and hae the focus jump to the area of the very long form that I want. I tried using the following...