Search results

Hi Guys, I was wondering how I would send Yes/No fields to Word using bookmarks. I have implemented bookmarks on my word docs to connect to Access but my boss suggested I change some of the text fields to yes/no fields on my form. I know from doing some research that it would a 1 or a 0 I...

Hi, I need a little help. There is an article from the Microsoft KB site that shows how to send data to word from the current record on the form. I set that up and works pretty well when you have data in the field. There are some text and memo fields that will not be filled in on every record...

I tried the subreport but after I went through the wizard it gave me a blank section and I know I have a common field between the two. Any suggestions?

Hi, I was wondering if there was a way to print a report containg information from mutiple queries. Basically I want to do a report where I Enter a name in and get a lisitng broken down by drug type for each patient. The information by drug type for the patient is kept in 3 different queries...

Hi I tried doing that but it is now saying there is not a field name 40? I have synchronzied combo boxes on my form so the Value that gets stored in the table is the ID Number of the Fields not Text Portion. Here is what I have typed. DoCmd.Requery ([Response]) DoCmd.GoToControl (Response)...

Hi, I want a text box on my form to only be enabled when a certain value is selected from a drop down box that is located on the form. I would tried to place the code in the After_Update Event for the dropdown box to do this but I already have a Macro there that performs a different function...

Hi, I have been working on a database for a client and one of the database's main objectives was to calculate time intervals. I have been trying to find a solution to take into account when time rollovers to the next day. I thought had a solution when I looked at Article Q130514 from Microsoft...

Hi, I am wondering if anyone has developed a time interval function taking into account that the date is in seperate field. My problem is there is only date field and the upper time value can be from the next day. For instance the upper time could be 01:00 in the morning and the lower time...

Hi, is there a way I can sum time values together? I want to do a calculation to sum and avg time values in a query but I don't know how to proceed. thanks.

It is as follows originally: I am trying to modify a existing form so that if I enter a classification of an activity from one drop down box and I then select the activity dropdown box that it will display only those activities found under that classification. This information is being enter...