Hello all,
Please help with this:
On opening my database, I have a switchboard that opens up.
How do also run a report automatically just after the switchboard screen opens. To make the switchboard open when I click on my database, I went to tools..> startup. But I don't know how to run a report automatically after that.
Thanks for your help!
I have a database that has been functioning very well for nearly a year. Suddenly today, as I attempt to open a report (very complex report takes about 2 minutes to render), the database closes before displaying the report. I have moved the db from the server to my desktop and the same problem happens. It does not matter if I try to execute the report from the switchboard or from the Report Object List.
DB is 344,940KB. I have larger db's that work fine.
I don't know where to look for a way to stop this from happening. Nothing was done to the form design between the last time it worked properly, and today.
Any thoughts are welcome.
Thanks,
George
I have just noticed when I open one of my forms . the database window becomes inactive and I cannot open another , form , report etc.
View 2 Replies View RelatedI have a report based on a query that has data for many dates. At the moment I have put a specific date in the criteria of the query so that I could build the report format. So it now displays all the data for the date i have in the criteria section. I will need to run this report several times per week so the specified date (and corresponding data in the report) will need to be changed to a new date when I open the report i.e. when I open my report I want to show data in the report only for a specified date.
Can I create a date parameter box open up when I open the report? Can I create a form with a button that when I click will open the report displaying data for that date? What would be the best way?I also need to display the specified date on the report.
I have a form with 7 List boxes linked to 7 Query's which in turn are linked to a table. Each list box if for a particular trade.
I am trying to select a person or persons from each List box and then have them sent to a report. I have Code to do one list box, but do not know how to link all boxes with code to a 'Open report' button.
The code I am using is as follows:-
Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim strWhere As String
Dim ctl As Control
Dim varItem As Variant
'make sure a selection has been made
[code]....
i have a database that runs updates from within itself.what i need is, this database to then open a another database run a update query, then close it.
View 4 Replies View RelatedHello friends,
I would like to add a cmdbutton on a form to view a report.
This report should also include the last modified data of my form. Is it possible to see the data without closing the form?
Or perhaps there is a solution like close the form and open the report (it will use the field SSN as PK) of the last modified (or viewed) recordset?
Any help or code will be appreciated.
Thank you.
I have an Access 2003 database that has a report which prints to the default printer.
We recently replaced the printer and now we cannot open the report in either design or preview.
How can I resolve this problem??
Many Thanks,
DL
This keeps happening to me. I am tired of importing from a backup and making modifications. My report won't open in any view. I double click on it in the db window, and nothing happens. It does the same when I try to open in design view. Have any of you ever had this proble,? What should I do?
KellyJo
Seasons Greetings to all.. I hope you didnt put on too much weight.
The fog at Heathrow ensured I had a very stressful Christmas.. but thankfully it has gone for now.
i have a question regarding choosing a report to open based on a combo list..
i have a field called jobtype..
this field will always have either
"CASH" or "ACCT"
i have 3 separate report designs.. 1 design for cash jobs, 1 design for acct jobs, and 1 deisgn for both jobs.
i want a form that will allow my user to choose which report to look at..
lets call it form1.. i want to place a combo on my form (combo1) that has the values..
CASH
ACCT
BOTH
i realise that in my report query source.. i can use the following as the jobtype criteria
[Forms]![form1]![combo1]..
Question
I need the combo to realise that if the CASH value is selected.. it should open the CASH report..
if the ACCT value is selected.. it should open the ACCOUNT report..
and finally if BOTH is selected then open the BOTH report..
how can i do this?
I have several reports that open from a Form. All but one of the reports have menu bars on them...one report does not. I've looked at just about everything and I can't figure out what's causing that. Actually, I really don't need the Menu bar on the Reports, so I would like to remove the others.
I've attached a copy of a cut-down version of the file so that you can see what I mean. The file will open up to the Reports. There are two reports listed. The "New Releases" does not have a Menu Bar and is what I want. The "All Movies" has the Menu Bar which I want removed. Can anyone tell me why one has it and the other does not?
Thanks!
I have a list box which contains different types of log entries. Each different log entry type has a different report that goes with it.What I want to do is select an entry in the list box, and click on print, email, pdf or view report buttons, and the appropriate happens, selecting the associated report for the log type automatically.I have a table with the logtype in it, and against that I have a DefaultReport field, which contains the name of the report that needs to be opened for that logtype.
I am getting the correct name for the report no problem at all, I have made sure that the name is right by going to rename report and copy and pasting it.When it goes to open the report I get an error message - Run-Time error 3071, the expression is typed incorrectly or is to complex to be evaluated.I have a debug line running to make sure I am pulling back the correct report name and I am.I have tried putting the dlookup where the report name would normally go in the docmd.openreport and I have also tried using ReportToView as a String and putting that in the docmd.openreport, but to no joy.
I have tried it with and without " around the report name and still no joy, either in the table or by concatenating the dlookup with Chr(34) at either end of it, then it comes up saying the report cannot be found.
I created a simple form that has a dropdown of all the reports that a user can select. I am using the following command;
DoCmd.OpenReport "rpt_Roadshow2", acPreview, , "RoadShow.RSID = SelectSymbol.Column(0)"
Where SelectSymbol is the name of the ComboBox and Column(0) is the first column of that data field. When I run it I get
Run Time Error 3085
Undefined Function 'SelectSymbol.Column" in expression.
Good morning All,
I have a form with a command button to open a report ( based on a query ) for the currently displayed record. here is the code I have used:
Private Sub CS_notes_Click()
On Error GoTo Err_CS_notes_Click
Dim stDocName As String
stDocName = "InternalSNwithRMAprodMASData"
DoCmd.OpenReport stDocName, acPreview, , "TLAUnit = " & Me.UnitSN & "'"
Exit_CS_notes_Click:
Exit Sub
Err_CS_notes_Click:
MsgBox Err.Description
Resume Exit_CS_notes_Click
End Sub
I believe this came from this forum sometime. When the button is clicked I receive the error:
"Syntax error (missing operator) in query expression '(TLAUnit = 26712B')'
TLAUnit is the report field, UnitSN is the form field.
Any help with the error?
Thanks
Kevin
I hae a button on my form to open a report. However, I get all the records in the database when I only want to see the report with the current record from the form on it. How do I narrow my report?
View 9 Replies View RelatedI have a form with three combo boxes and am looking to open a report based on the choices they make. After each combo box is selected a query is run that makes a table based on their choice. I want to be able to use the appropriate table, without having to set it each time. The data displayed is going to be the same on the report just different data. Any help would be greatly appreciated.
Thanks
Bobby
hi...
firstly, i created some report based on query. then in my form i create list and combox to list down all primary key that had in query..
what i want to do is open report, based on criteria that i selected from combobox or list box...
i create both cbo and list box to compare which 1 is better... but both not working. i mean it works but not show the data as i want to. it open / list all data at report..
i use this code but nothing happen :
for listbox;
StCriteria = "[ID]=" & "'" & ListCustomer.Column(0) & "'"
DoCmd.OpenReport "Invoice Print", acPreview, , StrCriteria
and Cbo;
StrCriteria = "[ID]=" & Me.[cboCustomer]
DoCmd.OpenReport "Invoice Print", acPreview, , StrCriteria
plz help me..i dunno what to do.. :confused:
it works but not correct
I need to create a form that will open up to a report. the form is going to have two options.
one option will open up a report that will show all candidates submitted
the other option will open the same report but only show the candidates that have not recieved a no from the employer.
does anyone know what type of coding will need to go into this and how to go about it.
any help would be greatly appreciated.
I'm having a little trouble getting this accomplished. I can instruct access to print the report, however I just want to be able to view the report after I select a button. I will attach a picture so you can see what I have thus far. I do have an older version of this and it works flawlessly and as far as I can tell everything is a carbon copy of the working version.
View 9 Replies View RelatedI am trying to filter a subreport on open.
In my report I have a field called "Packages" and my subreport consists of a table, one of the columns is "Packages" so I want to use the value that I have in "Packages" to filter for only those items in the sub report.
Is this possible?
I need the following report to open with date parameters. I have the following code, but it doesn't quite work.
When an item is chosen from Modl (a list box) a box pops up asking for LowPop, then another for Start Year and then another for End Year.
Those last two aren't doing what they should. They should restrice the [Date] field to between the years entered as start and end. I would like to put it in the "OpenReport" line, but don't think that's going to work.
Code:
Private Sub Command27_Click()
Dim varItm As Variant
Dim ModelWhere As String
Dim strQuery
Dim LowPop As String
Dim SDate As Date
[Code] .....
What is the best place to have opendatabase statement ? Currently I have opendatabase in all of my forms. I dont have any modules in my application. I am new to access programming. Is module really necessary in an application?
If I can put the opendatabase statement in one place, it will be easier for me to change the database name and path, if I have to..I dont know how to do it.
Can anyone help..I hope this one should easy for many of you people.
Thanks very much.
Hi,
I've run across a couple issues with our database. The most immediate issue is that I have been unable to open the database on any networked (or non-networked) computer. Me and a assistant typically enter data into this database from two seperate computers. She works on a wireless networked computer with the file on my computers hard drive. I work directly with the file. My computer is wired to the router. (in case that information helps)
We keep getting errors about "cannot access remote computer" and such, they seem to occur when she's entering data and I have the database open, then close Access. It will often give her the error and not allow her to save the record.
But just today she entered something, I closed my database window, then reopened it and I could not get in. All network computers rebooted, and still cannot get into the file. I can enter the password and then it goes to just a blank area (like when your first open access with no database). Older backup versions of the database still work, so it doesn't seem like an Access error. I also noticed that the little "LockFile"s are not being created (I ever faked one just to try it out and it deleted it after i entered the database password)
I can't repair, or convert or anything, it just asks for the password, I give it...and then nothing.
I'm very lost. Thanks for any help.
I have one database and I want the ability to click on a button and open up another database. Can I do that?
View 1 Replies View RelatedI can't open my database...
It was open yesterday and after a power failure computer turned off...
2day I can't open it...
Messege box says something like ---database was open--- not properly closed--- etc. etc. and can't perform auto repair...
I tried to import the objects in other database but can't do that as well...
Is there any way to repair the database???
Thanx and regards,,
MPB
I have problem once each day when I open Access for the first time. I get an error message "Microsoft Access has encountered a problem and needs to close. We are sorry for the inconvenience.". It asks for a file name and insists on compacting (I think) and saving the database. I go through this several times saving it under a diferent name each time until I get the warning "Security warning Some active content has been disabled. Click for details." with a button to disable it.
View 13 Replies View Related