Search results

I have a form with 4 check boxes on it which when ticked put a tick in the corresponding field on a report. I only want one tick to be allowed for each record. I see this can be done by creating an option group box but when I put my check boxes in the group box they do not allow me to check...

Have managed to: Create a form with command buttons Have the command buttons open the form, document (hyperlink), or report asked for Now want to have the original form with the command button disappear and only the form or report show on the screen. What is the best way to accomplish this? Can...

Here is the code I used Private Sub cmdWord1_Click() Dim WordDoc As String Dim oApp As Object 'Path to the word document WordDoc = "c:\test.doc" If Dir(WordDoc) = "" Then MsgBox "Not here" Else 'Create an instance of MS Word Set...

not that complicated I thought you could possibly translate into more understandable language the Transform.... statement so that I could see a little more clearly what it is that I have done that works.

How do can I open a word document from a command button. It does not want to see my file location and keeps telling me there is no document. Just looking for a simple on click procedure that will open word and then open a file.

That works Can you translate the SQL to me. I am not that familiar with it but I was able to get it to work in my DB. The one thing I noticed is that when you run the query it puts a row at the start that is all X's for all fields across, save and except the first column. How can I omit this...

Cross tab query Well the query went well and the report does show the fields left to right, however a cross tab query (which I used first) seems to be for numeric field values and my values in the field are not numeric. The end result is my report shows my field values as column headers and...

Never done a cross tab anything this will be a new experience :rolleyes:

color of command button My command buttons seem to work okay but they are all the standard grey color. How can I change the color?????? :o

Picture? How would I post a picture? That sounds like a great idea to get my point across. But basically it looks like this Field Field entry1 Field entry 2 Fiedl entry 3 I want the report to look like this: Field Field entry 1 Field entry 2 Field entry 3 Does that...

Set to no on vertical The property in the report text box is set "no" to vertical. When I change this to "yes" it does not do the job. It still puts the field entries each on a seperate line but just changes the direction so you can not read them.

checking what you ask :eek: Do not know will check and report back.

Still asking for input :) Please take a moment to shed some light on this subject, or at least point me in the right direction where to find the information on this subject. Thanks everyone!

I have a report that has a link to a table with a field called results. When the results field appears on screen (or prints out) it reports the contents of the field vertically on the page. Like: Result 1 Result 2 Result 3 I would like the results to show horizontally across the page in one...

I have a report that has a link to a table with a field called results. When the results field appears on screen (or prints out) it reports the contents of the field vertically on the page. I would like the results to show horizontally across the page in one line. Is there a special code that I...

Works like a charm, thanks, now I just have to get the message going and it will be complete.

:o I am creating forms and when I open them they look great but always open at the first record. I would like them to open at the add new record with a pop up giving that message for a few seconds when the form opens. Is this possible and if so how do I do it? Thanks