Why do my questions never get answered?

[Guest]

I have asked questions several times PLEASE HELP ME!!!

I have created a form and on the form i have a button that brings up a report and exports it to a file. When I click the button i created it asks me to which type of format I would like to output to display in. I was wondering if i could skip that step and have it automatically export to Excell? Thanks in advance. -RRyan

also how do i make a subform inactive when there is no information in the form that it is attaced to. The "Gap Refrence Code" is the field that ties them together. IF the Gap Refrence Code is the users initials and not a number then i would like it to beinactive

 

[Frank]

I can try and answer your first question...in
the "TransferSpreadsheet" Action in your Macro (or
module), you can choose the format to save the spreadsheet
in. Either Lotus format, or Excel format.
(DoCmd.TransferSpreadsheet acExport,...)

After the acExport, it asks you to choose what format you
want to save the exported file in)

Hope this helps.

-----Original Message-----
I have asked questions several times PLEASE HELP ME!!!

I have created a form and on the form i have a button

that brings up a report and exports it to a file. When I
click the button i created it asks me to which type of
format I would like to output to display in. I was
wondering if i could skip that step and have it
automatically export to Excell? Thanks in advance. -RRyan

also how do i make a subform inactive when there is no

information in the form that it is attaced to. The "Gap
Refrence Code" is the field that ties them together. IF
the Gap Refrence Code is the users initials and not a
number then i would like it to beinactive

 

[Joshua A. Booker]

RRyan,

I answered your first question in another group.

Second Question:
If Me![Gap Reference Code] = InputBox ("Please enter your initials") Then
ME!SubformName.Enabled = False
End If
Where Subformname is the name of the SUbform control on the main form.

HTH,
Josh

I have asked questions several times PLEASE HELP ME!!!

I have created a form and on the form i have a button that brings up a

report and exports it to a file. When I click the button i created it asks
me to which type of format I would like to output to display in. I was
wondering if i could skip that step and have it automatically export to
Excell? Thanks in advance. -RRyan

also how do i make a subform inactive when there is no information in the

form that it is attaced to. The "Gap Refrence Code" is the field that ties
them together. IF the Gap Refrence Code is the users initials and not a
number then i would like it to beinactive

 

[Guest]

Josh.. Where do i Place this code? Do i Place it in the form or the subform and in which part.

If Me![Gap Reference Code] = InputBox ("Please enter your initials") Then
ME!SubformName.Enabled = False
End If
Where Subformname is the name of the SUbform control on the main form.

HTH,
Josh

I have asked questions several times PLEASE HELP ME!!!

report and exports it to a file. When I click the button i created it asks
me to which type of format I would like to output to display in. I was
wondering if i could skip that step and have it automatically export to
Excell? Thanks in advance. -RRyanform that it is attaced to. The "Gap Refrence Code" is the field that ties
them together. IF the Gap Refrence Code is the users initials and not a
number then i would like it to beinactive

 

[Scott McDaniel]

Don't think anyone here owes you an answer ... people help when they can and
not necessarily according to your schedule. If your problem is critical and
you require an answer immediately, MS (and many of the regular posters here)
will be happy to provide this support for a fee.

If your question isn't answered in a day or two, repost it. Also, make sure
you post to appropriate groups (not to say that you didn't, but I'm often
amazed at the people who post table design questions to the Forms group).
Make sure you include the necessary information (Access version, code you
have tried, any specifics you think necessary for a clear understanding,
etc) and be patient.

I have asked questions several times PLEASE HELP ME!!!

I have created a form and on the form i have a button that brings up a

report and exports it to a file. When I click the button i created it asks
me to which type of format I would like to output to display in. I was
wondering if i could skip that step and have it automatically export to
Excell? Thanks in advance. -RRyan

also how do i make a subform inactive when there is no information in the

form that it is attaced to. The "Gap Refrence Code" is the field that ties
them together. IF the Gap Refrence Code is the users initials and not a
number then i would like it to beinactive

 

[Joshua A. Booker]

Ryan,

Where you place the code depends on the event after which you would like to
enable/disable your subform. Because you want to do this depending on a
field value which could change when the current record changes, you may want
to use the OnCurrent Event of the main form. OnCurrent runs every time you
move to a new record so you should find another way to get the user initials
besides inpubox. Do you have their initials in the data?
Perhaps you could prompt for their initials when the form opens. Thisi is
what the main form CBF should look like:
.............................................................................
............................
Option Compare Database
Option Explicit

Public stUserInit as String

Private Sub Form_Open(Cancel As Integer)

stUserInit = InputBox("Please Enter Your Initials.")

End Sub


Private Sub Form_Current()

If Me![Gap Reference Code] = stUserInit Then
Me!SubformName.Enabled = True
Else
Me!SubformName.Enabled = False
End If

End Sub
.............................................................................
........................................
Where SubformName is the name of the subform control on the main form.

Josh

Josh.. Where do i Place this code? Do i Place it in the form or the subform and in which part.

If Me![Gap Reference Code] = InputBox ("Please enter your initials") Then
ME!SubformName.Enabled = False
End If
Where Subformname is the name of the SUbform control on the main form.

HTH,
Josh

I have asked questions several times PLEASE HELP ME!!!

up a
report and exports it to a file. When I click the button i created it asks
me to which type of format I would like to output to display in. I was
wondering if i could skip that step and have it automatically export to
Excell? Thanks in advance. -RRyan in the
form that it is attaced to. The "Gap Refrence Code" is the field that ties
them together. IF the Gap Refrence Code is the users initials and not a
number then i would like it to beinactive